🗃️
SQL
SQL for Data Engineers
Joins, window functions, CTEs, stored procedures, indexes, transactions, MERGE, and every SQL concept you need.
15 in-depth tutorials
How SQL executes: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY — the real execution order.
02GROUP BY, HAVING & CASE WHEN
In-depth tutorial covering group by, having & case when.
In-depth tutorial covering subqueries & performance.
In-depth tutorial covering sql functions.
In-depth tutorial covering sql joins.
In-depth tutorial covering window functions.
In-depth tutorial covering ctes & subqueries.
In-depth tutorial covering ddl, dml, and constraints.
In-depth tutorial covering indexes and execution plans.
10Views, Temp Tables & Variables
Views, temp tables, table variables, and CTEs compared: scope, persistence, and performance.
11Stored Procedures & Triggers
In-depth tutorial covering stored procedures & triggers.
In-depth tutorial covering normalization & star schema.
In-depth tutorial covering union, pivot & dynamic sql.
In-depth tutorial covering transactions & acid.
15SQL Interview Practice (20 Qs)
In-depth tutorial covering sql interview practice (20 qs).