Author
Released
3/9/2018- Define variance and standard deviation.
- Calculate discrete percentiles.
- Calculate continuous percentiles.
- Analyze correlations.
- Explore linear models, such as linear regression.
Skill Level Intermediate
Duration
Views
- [Dan] Hi, I'm Dan Sullivan, and in this course, I'll be describing how to use SQL for statistics. We'll start by reviewing the basics of descriptive statistics, like sum, average and standard deviation. We'll cover how to use discrete and continuous percentiles to bucket data. We will explore ways to identify and understand relations between variables or columns within rows, as well as across rows. We'll also delve into more advanced functions for making predictions with linear regression.
So let's take a look at statistics in SQL.
Related Courses
-
Statistics Foundations: 1
with Eddie Davila2h 6m Beginner -
Statistics Foundations: 2
with Eddie Davila1h 56m Intermediate -
SQL Tips, Tricks, & Techniques
with Ben Sullins59m 23s Intermediate -
Advanced SQL for Data Scientists
with Dan Sullivan1h 24m Advanced
-
Introduction
-
Welcome34s
-
Exercise files32s
-
-
1. Basic Descriptive Statistics
-
Installing PostgreSQL2m 27s
-
Load data into PostgreSQL1m 36s
-
Basics: Sum and average3m 22s
-
-
2. Percentiles and Frequencies
-
Discrete percentiles6m 32s
-
Continuous percentiles2m 25s
-
3. Correlations and Ranks
-
ROW_NUMBER2m 2s
-
Mode1m 27s
-
4. Linear Models
-
Minimizing error1m 26s
-
Computing intercept2m 12s
-
Computing slope3m 24s
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome