Velamuvi AIAcademy
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. 1

    Complex Queries

    4 lessons
    1. 1SubqueriesSoon
    2. 2Common Table ExpressionsSoon
    3. 3CASE ExpressionsSoon
    4. 4Set OperationsSoon
  2. 2

    Window Functions

    4 lessons
    1. 5OVER and PARTITION BYSoon
    2. 6Ranking FunctionsSoon
    3. 7Running TotalsSoon
    4. 8LAG and LEADSoon
  3. 3

    Performance

    4 lessons
    1. 9How Indexes WorkSoon
    2. 10Reading a Query PlanSoon
    3. 11TransactionsSoon
    4. 12Views and Materialised ViewsSoon
  4. 4

    SQL for ML

    2 lessons
    1. 13Building Feature TablesSoon
    2. 14Sampling and Splitting Data in SQLSoon

Recommended next