🟦 📌 Module Intent

Database First (Starting Point 🔥)

🎯 What This Module Is About

This module is designed to build your foundation in real-world database thinking before using EF Core.

Instead of jumping directly into code, we start from the most important layer:

👉 The database itself

🧠 Core Learning Objective

By the end of this module, you will:

✔ Create a real database using SQL Server (SSMS 22)

✔ Understand how production databases are built using scripts
✔ Analyze a complete database schema (TrainingCenterDB)
✔ Understand why this design was chosen
✔ Learn how tables, constraints, and relationships work together
✔ Review the main relationship types:

• One-to-One
• One-to-Many
• Many-to-Many
• Optional relationships

🎯 Why This Module Matters

👉 Most beginners try to learn EF Core without understanding the database.

That leads to:

❌ confusion in relationships
❌ incorrect queries
❌ poor performance understanding

✅ This module fixes that

👉 We build your database understanding FIRST
👉 Then we build EF Core on top of it

🧩 What You Will Learn in This Module

🔹 1. Creating the Database

✔ How to use SSMS 22
✔ How to execute real SQL scripts
✔ How databases are created in real systems

🔹 2. Understanding the Schema

✔ Tables and their responsibilities
✔ Column design
✔ Data types and structure

🔹 3. Understanding Constraints

✔ Primary Keys
✔ Foreign Keys
✔ Unique constraints
✔ Check constraints
✔ Default values

🔹 4. Understanding Relationships (CRITICAL 🔥)

✔ One-to-One
✔ One-to-Many
✔ Many-to-Many
✔ Optional relationships

👉 These are the backbone of EF Core later.

🧠 Mindset Shift (VERY IMPORTANT 🔥)

Before this module:

❌ “Database is just tables”

After this module:

👉 “Database is a system of rules, relationships, and constraints that protects the data”

🎯 Final Intent

👉 This module prepares you to think like a database designer and understand real systems before writing a single EF Core query