db-training

Mono repo of database training labs.

Labs

lab-1-modeling

Data modeling: schemas, tables, and ER diagrams.

• ER diagram (Mermaid Live)

lab-2-normalization-schema-implementation

Normalization and schema implementation using SQL Server.

Setup

1. Start the SQL Server container:

   docker compose up -d

   The server will be available on port 48370 with SA password Password!.

2. Connect to the database and run the scripts in order:

   • migrations/init.sql - creates the schema
   • migrations/seed.sql - populates the data

3. Run migrations/assert.sql to execute the assertion query.

lab-3

Relational vs. document design using MongoDB.

• Sample data: shop_smart.products.json - import via MongoDB Compass into products_nmummau
• Query examples: QueryExamples.md