BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL for Statistics Essential Training

via LinkedIn Learning

Go to class Write review

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

Reviews

4.6 rating at LinkedIn Learning based on 59 ratings

Start your review of SQL for Statistics Essential Training

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.