Phase 08: Database Engineering

This is a self-paced learning repository. Follow the modules in the recommended order, but study and practise according to your own schedule.

The completed project is available on main. The starter branch provides a clean beginning.

What you will build

Inventory and Warehouse Management System

Recommended learning path

Module	Topic	Videos	Code reference
1	Relational Design, Keys and Constraints	Watch on YouTube	p08-module-01-relational-design-keys-and-constraints
2	Queries, Transactions, Concurrency and Locking	Watch on YouTube	p08-module-02-queries-transactions-concurrency-and-locking
3	Indexes, Query Plans, Privileges and Recovery	Watch on YouTube	p08-module-03-indexes-query-plans-privileges-and-recovery
4	Prisma, Migrations, Reconciliation and Release	Watch on YouTube	p08-module-04-prisma-migrations-reconciliation-and-release

Technology and engineering areas

• PostgreSQL
• SQL
• Prisma ORM
• Transactions
• Query analysis

Repository structure

modules/       ordered learning resources and practical labs
project/       completed reference on main; clean beginning on starter
assessment/    project requirements, review questions and rubric
docs/          supporting curriculum and engineering references
resources/     reusable templates and reference material

Video lessons

Watch lessons, demonstrations, debugging sessions and project walkthroughs on the Oliseyenum channel:

▶ https://www.youtube.com/@oliseyenumomodi

As individual videos are published, their direct links can be added to VIDEOS.md.

How to use this repository

git clone https://github.com/oliseyenumomodi/phase-08-database-engineering.git
cd phase-08-database-engineering
git switch starter

Move through the modules in order. Use module tags to inspect each reference point:

git tag
git checkout p08-module-01-relational-design-keys-and-constraints
git switch main

Project review

After completing the modules:

1. build the project from the starter branch;
2. run the supplied checks;
3. compare your decisions with main;
4. review the assessment requirements;
5. explain the architecture, trade-offs and limitations.

Author

Oliseyenum Omodi
Software Engineer • Builder • Instructor
Oliseyenum Studio • Powered by Illumination Gate

Build. Teach. Share.