Course Curriculum

Module 1: Introduction to Databases

• What is a Database? Understanding how data is stored in the real world.

• Why MS SQL Server? Introduction to Relational Database Management Systems (RDBMS).

• The Role of a Database Developer: Career opportunities and real-world use cases.

Module 2: Setting Up Your Lab (Installation)

• Downloading SQL Server: Step-by-step guide to downloading the Express Edition (Free).

• Installing SSMS: Setting up SQL Server Management Studio (the tool you'll actually use).

• Connecting to the Server: Troubleshooting common login and connection issues.

Module 3: Your First Database

• Creating a Database: Using the GUI and the CREATE DATABASE command.

• Understanding Tables: Rows, columns, and data types (INT, VARCHAR, DATE).

• Managing Databases: How to Rename, Backup, and Drop (Delete) a database safely.

Module 4: Mastering DML Queries (The Core Skills)

• INSERT: Adding new records to your tables.

• SELECT: The art of retrieving data (Using WHERE, ORDER BY, and TOP).

• UPDATE: How to modify existing data without making mistakes.

• DELETE: Safely removing records (and the importance of the WHERE clause!).

Module 5: Hands-on Capstone Project

• Project: "Build a Student Management System."

• Create a database for a school, add student records, update their grades, and filter the list to find top performers.

🏆 What’s Included for the Student?

• ✅ Books: Step-by-step Guide of the installation and coding.

• ✅ Cheat Sheet: A downloadable PDF of common SQL commands.

• ✅ Practice Lab: A sample dataset to play with.

• ✅ Certificate of Completion: A Shrash Technology Digital Badge to share on LinkedIn.