PostgreSQL — Data Modelling, Queries and Guided Practice

Understand the data model, guarantees and typical workloads of PostgreSQL.

• Data model and storage approach
• Consistency and durability
• Typical workloads
• When to choose PostgreSQL

Run PostgreSQL locally and perform basic reads and writes.

• Local setup or a managed instance
• Clients and connection settings
• Basic reads and writes
• Inspecting data

Design schemas, keys or documents that fit the questions you need to answer.

• Schema or document design
• Keys, relationships and constraints
• Migrations and versioning
• Common modelling mistakes

Write queries or pipelines that answer real questions correctly.

• Filtering, joining or aggregating
• Transformations
• Correctness checks
• Using PostgreSQL from application code

Make reads and writes fast enough, and understand why they are slow.

• Indexes, partitions or caching
• Explain plans or profiling
• Batching and concurrency
• Cost awareness

Protect, back up and recover data.

• Access control
• Backup and restore
• Monitoring
• Privacy and retention

Design, load and operate a data layer that serves a defined use case.

• Requirements and model
• Loading and querying
• Performance checks
• Documentation

Consolidate trade-offs, scaling options and maintenance practices.

• Scaling options
• Upgrades and migrations
• Common failure modes
• Next steps