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
Coursera Ad

40% Off Career-Building Certificates

Learn More → Corporate Finance Institute Ad

35% Off Finance Skills That Get You Hired - Code CFI35

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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 120 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.