Intermediate · 3h 50m · lessons

PostgreSQL

Store, query, and relate real data — from SELECT to indexes and EXPLAIN.

Start course

What you'll learn

  • ✦Explain the relational model: tables, rows, columns, and keys
  • ✦Query data with SELECT, WHERE, ORDER BY, LIMIT, and aggregates
  • ✦Insert, update, and delete data safely inside transactions
  • ✦Connect tables using primary/foreign keys and JOINs
  • ✦Enforce integrity with constraints and understand normalization
  • ✦Make queries fast with indexes and read a query plan with EXPLAIN

Syllabus

Module 1
Meet PostgreSQL Free
Module 2
Reading data Locked
Module 3
Writing data safely Locked
Module 4
Relationships & joins Locked
Module 5
Making it fast Locked
Module 6
Beyond the basics Locked