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: Basic SQL for Data Analysis
Test your knowledge about the basics of SQL.
We'll cover the following...