IntermediateFull track availableDatabases

SQL & Databases

Relational database design, SQL queries, and optimization

13 atomsSpaced repetitionLearn at your own pace

What you'll learn

SELECT & FROM

Filtering with WHERE

Sorting with ORDER BY

LIMIT & OFFSET

DISTINCT

JOINs (INNER, LEFT, RIGHT)

Aggregates & GROUP BY

Subqueries & CASE WHEN

CREATE TABLE, UPDATE & DELETE

Window Functions (RANK, ROW_NUMBER)

Indexes & Performance

Python + SQL (psycopg2)