Skip to content
Contact
Back to learning library

Phase 08 · Web systems

Database Engineering

Model reliable relational data, write analytical queries, control transactions and integrate an ORM responsibly.

Open repositoryWatch on YouTubeStarter branch

Company-level project

Inventory and Warehouse Management System

Begin from the starter branch, work through the modules and use the main branch as a completed reference after making a genuine attempt.

PostgreSQLSQLPrisma ORMTransactionsQuery Analysis
Open starter projectView completed referenceAssessment resources

Recommended sequence

Complete the modules at your own pace.

Every module links to the exact GitHub resource folder and its stable code-reference tag.

  1. 01

    Relational Design, Keys and Constraints

    Study the resources, complete the practical lab, validate the result and record any limitation.

    Code referencep08-module-01-relational-design-keys-and-constraints
    ResourcesVideo
  2. 02

    Queries, Transactions, Concurrency and Locking

    Study the resources, complete the practical lab, validate the result and record any limitation.

    Code referencep08-module-02-queries-transactions-concurrency-and-locking
    ResourcesVideo
  3. 03

    Indexes, Query Plans, Privileges and Recovery

    Study the resources, complete the practical lab, validate the result and record any limitation.

    Code referencep08-module-03-indexes-query-plans-privileges-and-recovery
    ResourcesVideo
  4. 04

    Prisma, Migrations, Reconciliation and Release

    Study the resources, complete the practical lab, validate the result and record any limitation.

    Code referencep08-module-04-prisma-migrations-reconciliation-and-release
    ResourcesVideo

Project review

Build first. Compare second. Explain every decision.

Build from starter
Run validation
Compare with main
Document limitations
Explain the architecture