Mini Map
Search
⌘ K
Log In
Practical Data Analysis with SQL
0%
1.
Introduction
Introduction
2.
Basic SQL for Data Analysis
Anatomy of an SQL query
Common Table Expressions
Generating Data
Exercise: Generate a Date Dimension
Random Data
Sampling
Example: Train/Test Split with SQL
Quiz: Basic SQL for Data Analysis
3.
Descriptive Statistics
Describing a Series
Describing a Categorical Series
Quiz: Descriptive Statistics
4.
Grouping and Subtotals
Grouping
Conditional Aggregates
Subtotals
Quiz: Grouping and Subtotals
5.
Running and Cumulative Aggregation
Aggregate Expressions
Window Frames
Next and Previous Rows
Ranking
Quiz: Running and Cumulative Aggregation
6.
Interpolation
Comparing Missing Values
Back Filling and Forward Filling
Linear Interpolation
Quiz: Interpolation
7.
Binning
Binning
Equal-height Binning
Equal-width Binning
Quiz: Binning
8.
Conclusion
Conclusion
Home
/
Courses
/
Practical Data Analysis with SQL
Quiz: Descriptive Statistics
Test yourself for descriptive statistics with SQL.
We'll cover the following...