PostgreSQL for Application Developers
Model data that will not fight you later, write queries the planner can execute well, and change a live schema without downtime.
Intermediate3h 34m4 modules16.7k students
What you'll learn
Model data with real constraints
Use types, keys, and constraints so the database refuses to store something invalid in the first place.
Write queries that express intent
Use joins, window functions, and CTEs to answer a question in one readable statement.
Make slow queries fast
Read a query plan, choose the right index, and know why the planner ignored the one you added.
Change a live schema safely
Run migrations on a busy table without taking a lock that stops the application.
Course Content
4 modules • 3h 34m
Your Progress
Not started