SQL for Statistics Essential Training

Offered By: LinkedIn Learning

Tags

SQL Courses Statistics & Probability Courses Relational Databases Courses

Course Description

Overview

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

Taught by

Dan Sullivan

Related Courses

Accounting for Death in War: Separating Fact from Fiction
Royal Holloway, University of London via FutureLearn Advanced Machine Learning
The Open University via FutureLearn Advanced Statistics for Data Science
Johns Hopkins University via Coursera 農企業管理學 (Agribusiness Management)
National Taiwan University via Coursera AI & Machine Learning
Arizona State University via Coursera