Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading course

PostgreSQL: Uncharted

CoursesPostgreSQL

PostgreSQL

Start from what a database even is and end writing window functions, recursive queries, and full schemas in real PostgreSQL, right in your browser.

Easy to Intermediate to Hard
12 units
120 lessons

Follow the units in order, or explore any lesson that interests you.

Sign in to start

Course syllabus

12 units

1. Databases All Around You
See why applications need databases, read table structure, and run your first PostgreSQL queries.
10 lessonsStart here
Loading lessons…
2. Your First Queries
Filter cafe and library rows, combine conditions, sort results, and shape exactly what a report needs.
11 lessons
3. Shaping Values
Calculate new values, clean text, work with dates, and turn missing or conditional data into useful reports.
11 lessons
4. Counting and Summarizing
Turn detailed cafe and gym rows into counts, totals, averages, grouped reports, and filtered summaries.
10 lessons
5. Working Across Tables
Follow keys across normalized cafe tables with inner, outer, self, and junction-table joins.
11 lessons
6. Designing Schemas
Turn practical briefs into normalized table designs with keys, cardinalities, and junctions.
10 lessons
7. Building Tables
Create and evolve PostgreSQL tables with suitable types, constraints, primary keys, and foreign keys.
11 lessons
8. Changing Data
Insert, update, delete, return, upsert, and group related PostgreSQL changes into transactions.
10 lessons
9. Queries Inside Queries
Nest focused queries, test related sets, and combine compatible results into precise reports.
10 lessons
10. Readable Queries with CTEs
Name intermediate results, chain report stages, generate series, and traverse hierarchies.
9 lessons
11. Window Functions
Calculate context beside detail rows with partitions, ranks, offsets, and moving frames.
10 lessons
12. Views and the Capstone
Publish reusable query surfaces, read unfamiliar SQL, and deliver a complete month-in-review report.
7 lessons

120 lessons across 12 units. Start with any published unit.