Web DevelopmentIntermediate
Database Design with PostgreSQL
Design schemas that scale, write efficient queries, and tune performance.
25 hoursDr. Sarah Chen4.8 (4,700 learners)
About this course
A comprehensive PostgreSQL course covering relational design, SQL, indexing, transactions, and query optimisation. You will learn to design normalised schemas, write complex queries using window functions and CTEs, use JSONB for semi-structured data, and diagnose slow queries with EXPLAIN ANALYZE.
Target audience: Backend developers, data engineers, developers building data-intensive applications
What you will learn
- PostgreSQL
- SQL
- Schema design
- Query optimisation
- Indexing
Course syllabus
10 modules · video + exercises
- 1Relational model: entities, attributes, and relationships
- 2Normalisation: 1NF through BCNF with practical examples
- 3PostgreSQL DDL: CREATE, ALTER, and constraints
- 4SQL in depth: JOINs, subqueries, aggregates, and window functions
- 5CTEs (WITH clauses) and recursive queries
- 6JSONB: storing and querying semi-structured data
- 7Indexes: B-tree, GIN, GiST, and partial indexes
- 8Transactions, isolation levels, and MVCC
- 9Query optimisation with EXPLAIN ANALYZE
- 10Replication, connection pooling with PgBouncer, and Neon basics
Prerequisites
- –Basic SQL knowledge helpful
Frequently asked questions
Does this course use a cloud database?
Exercises use a Neon (serverless PostgreSQL) instance provisioned automatically when you enrol — no setup required.
Ready to start Database Design with PostgreSQL?
Join 4,700+ learners already enrolled. Self-paced, certificate on completion.