This repository contains my lab solutions and practical implementations for the Database Systems course, covering fundamental to advanced database concepts using SQL Server with teaching by Ramy Nagy.
The course is divided into 10 days of intensive database training:
| Day | Topics Covered |
|---|---|
| ① | DB Design, ERD, File vs DB systems, DB Life cycle |
| ② | DB Schema, SQL Basics, Database Creation |
| ③ | Normalization Techniques |
| ④ | Aggregate Functions, Grouping, Subqueries, EERD |
| ⑤ | DB Engine, Ranking Functions, T-SQL |
| ⑥ | DB Constraints, SQL Server DB Creation Rules |
| ⑦ | Variables, Control Flow (IF/WHILE), Functions |
| ⑧ | Views, Indexes, Merge & Pivot Tables |
| ⑨ | Stored Procedures, Triggers, XML Handling |
| ⑩ | Backup/Restore, Mirroring, Cursors, Jobs, SQL CLR |
- Microsoft SQL Server
- SQL Server Management Studio (SSMS)
- Transact-SQL (T-SQL)
- Visual Studio (for SQL CLR)
- Database Diagram Tools (ERD/EERD)