Log In
Join
for free
Log In
Join
for free
Back To Course Home
Practical Data Analysis with SQL
0% completed
Introduction
Introduction
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
Descriptive Statistics
Describing a Series
Describing a Categorical Series
Quiz: Descriptive Statistics
Grouping and Subtotals
Grouping
Conditional Aggregates
Subtotals
Quiz: Grouping and Subtotals
Running and Cumulative Aggregation
Aggregate Expressions
Window Frames
Next and Previous Rows
Ranking
Quiz: Running and Cumulative Aggregation
Interpolation
Comparing Missing Values
Back Filling and Forward Filling
Linear Interpolation
Quiz: Interpolation
Binning
Binning
Equal-height Binning
Equal-width Binning
Quiz: Binning
Conclusion
Conclusion
Quiz: Descriptive Statistics
Test yourself for descriptive statistics with SQL.
Get hands-on with 1200+ tech skills courses.
Start Free Trial