Library › SQL & Databases
SQL-WB
SQL & Databases
Hands-on from page one — one sample database, every concept as runnable SQL, and the problems interviewers ask.
- 01SELECT, FROM & the Sample Database A — SQL Foundations
- 02Filtering Rows with WHERE A — SQL Foundations
- 03Aggregate Functions B — Aggregation
- 04GROUP BY & HAVING B — Aggregation
- 05Joins I: INNER & OUTER C — Joins & Subqueries
- 06Joins II: SELF, CROSS & Multi-Table C — Joins & Subqueries
- 07Subqueries C — Joins & Subqueries
- 08Set Operations: UNION, INTERSECT, EXCEPT C — Joins & Subqueries
- 09Window Functions D — Advanced Querying
- 10Common Table Expressions (CTEs) D — Advanced Querying
- 11CASE & Conditional Logic D — Advanced Querying
- 12String, Date & Numeric Functions D — Advanced Querying
- 13DDL: Creating & Altering Tables E — Data Definition & Management
- 14DML: INSERT, UPDATE, DELETE E — Data Definition & Management
- 15Views, Indexes & Performance E — Data Definition & Management
- 16Transactions & Concurrency in SQL E — Data Definition & Management
Open the interactive reader →
Same content with progress tracking and self-check drills.