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

Introduction to Databases
Meta via Coursera Intro to Relational Databases
Udacity Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera Web Application Development: Basic Concepts
University of New Mexico via Coursera