Programming Foundations
Advanced SQL
Write the queries analysts and ML engineers rely on: subqueries, CTEs, window functions, indexes and query tuning.
- Advanced
- About 12 hours
- 4 modules
- 14 lessons
- Free
This course is not released yet. We publish courses one at a time, each one complete. The full syllabus is below.
What you will learn
- Complex QueriesSubqueries, Common Table Expressions, CASE Expressions and more
- Window FunctionsOVER and PARTITION BY, Ranking Functions, Running Totals and more
- PerformanceHow Indexes Work, Reading a Query Plan, Transactions and more
- SQL for MLBuilding Feature Tables, Sampling and Splitting Data in SQL
Course syllabus
Not released yet · full syllabus below
- 1
Complex Queries
4 lessons- 1SubqueriesSoon
- 2Common Table ExpressionsSoon
- 3CASE ExpressionsSoon
- 4Set OperationsSoon
- 2
Window Functions
4 lessons- 5OVER and PARTITION BYSoon
- 6Ranking FunctionsSoon
- 7Running TotalsSoon
- 8LAG and LEADSoon
- 3
Performance
4 lessons- 9How Indexes WorkSoon
- 10Reading a Query PlanSoon
- 11TransactionsSoon
- 12Views and Materialised ViewsSoon
- 4
SQL for ML
2 lessons- 13Building Feature TablesSoon
- 14Sampling and Splitting Data in SQLSoon