Overview
-
Get Ben Sullins's 12 must-have SQL techniques for data science pros—engineers, DevOps, data miners, programmers, and other systems specialists.
Syllabus
-
Introduction
- Extract meaning from data
- What you should know before watching this course
- Using the exercise files
- Retrieve data using SQL
- Join tables
- Filter data
- Aggregate data
- Window functions
- Subqueries
- Rolling calculations
- Analyze employee data
- Date and time functions
- Common table expressions
- Year-over-year calculations
- Finding ranks
- Becoming a powerful data scientist
