Course Curriculum

01

Introduction

Get set up with the working database and understand the data model used throughout the course.

02

Querying

Master the fundamentals of SELECT — filtering, sorting, aliasing, and conditional logic with WHERE, CASE, and more.

03

String Operators

Manipulate and transform text data using PostgreSQL's built-in string functions.

04

Aggregates

Summarize and group data with aggregate functions like COUNT, SUM, AVG, and HAVING clauses.

05

Joins

Combine rows from multiple tables using INNER JOIN, LEFT JOIN, UNION, and set operations.

06

Dates

Work with timestamps, timezones, intervals, and date arithmetic to handle time-based data.

07

JSON

Query and build JSON and JSONB columns — from selecting nested properties to aggregating structured data.

08

Arrays

Store, search, and transform array data types with unnesting, slicing, and aggregate functions.

09

Window Functions

Perform calculations across related rows without collapsing them — ranking, partitioning, and more.

10

Database Design

Design schemas from scratch — tables, constraints, keys, indexes, and relationships done right.

11

Advanced

Level up with CTEs, subqueries, transactions, CRUD operations, and powerful utility functions.

12

Conclusion

A recap of what you've learned and where to go next to keep growing your SQL skills.