SQL for Statistics Essential Training

Go to class

Write Review

Free Online Course: SQL for Statistics Essential Training provided by LinkedIn Learning is a comprehensive online course, which lasts for Less than 1 hour of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. SQL for Statistics Essential Training is taught by Dan Sullivan.

via LinkedIn Learning

Less than 1 hour of material

Self Paced

Learn how to use SQL for descriptive statistics: to summarize data sets, derive insights, and make predictions.

Syllabus

Introduction
- Welcome
- What you should know
- Exercise files
1. Basic Descriptive Statistics
- Installing PostgreSQL
- Load data into PostgreSQL
- Basics: Count, minimum, and maximum
- Basics: Sum and average
- Variance and standard deviation
2. Percentiles and Frequencies
- Introduction to percentiles
- Discrete percentiles
- Continuous percentiles
- Summary of percentiles
3. Correlations and Ranks
- Introduction to correlation
- Correlations between variables
- ROW_NUMBER
- Mode
- Summary of correlations
4. Linear Models
- Introduction to linear regression
- Minimizing error
- Computing intercept
- Computing slope
Conclusion
- Overview of SQL for statistics

0, based on 0 Course votes at GetYourEducation

4.6, based on 59 Course reviews at LinkedIn Learning

Start your review of SQL for Statistics Essential Training

Add review ->

Language

English
Certificate
Certificate Available
Date of Start
09th March, 2018
Price
Free Trial Available
Provider
LinkedIn Learning
Taught By

Dan Sullivan
Share this course

SQL for Statistics Essential Training

ANIMATIONs

Adobe Lightroom Classic Fundamentals

Build, Train, and Deploy ML Pipelines using BERT

English for Research Publication Purposes

English for Research Publication Purposes

Introduction to Bohemian Watercolor Techniques