COURSE INTENT
Understand it. Practice it. Put it to work.
Model application data and make sound choices about storage, queries, and change. The course brings concepts together with applied activities and projects so learners can connect what they know to meaningful work.
WHY THIS MATTERS AT WORK
Take more confidence into the next decision.
Model data around real requirements and make better-informed decisions about queries, changes, and performance.
IS THIS COURSE FOR YOU?
Who it is designed to help.
- Application developers
- Data and analytics practitioners
- Teams responsible for the quality of operational data
Before you begin
Basic technical familiarity is useful. Database concepts and PostgreSQL examples are introduced as the course progresses.
Learning experience
Relational modeling, queries, indexes, performance, migrations, and an applied database design project.
LEARNING OUTCOMES
- Translate requirements into data models.
- Write and improve relational queries.
- Reason about consistency, indexes, and migrations.
CURRICULUM PREVIEW
A route through the subject.
- 01Relational modeling
- 02Query design
- 03Indexes and performance
- 04Migrations and operational care
PROJECTS & PRACTICAL ACTIVITIES
Make the ideas tangible.
Schema critique
Query tuning lab
COMMON QUESTIONS
Before you begin.
Is a database required?+
The course introduces database concepts and uses PostgreSQL for hands-on examples.
NW
YOUR INSTRUCTOR
Njeri Wanjiku
Builds data products that help teams ask useful questions and make better-informed decisions.
View instructor profile