SQL Server & T-SQL Curriculum

Welcome to the SQL Server and Transact-SQL (T-SQL) curriculum. This section is structured like a university-level DBMS course, covering everything from relational design to advanced performance tuning and administration.

Curriculum Modules

1. DBMS Foundations: Intro to Databases and SQL Server Architecture.
2. Relational Design: ERD, Relational Schema, and Normalization.
3. SQL Basics & DQL: Basic querying and SQL Server data types.
4. DDL, DML & Constraints: Schema management and data manipulation.
5. Advanced Queries: Aggregations and set operations.
6. Joins & Subqueries: Complex relationships and CTEs.
7. T-SQL Programming: Procedures, Functions, and Triggers.
8. Performance Tuning: Indexing and Execution Plans.
9. Transactions & Concurrency: ACID, Isolation, and Locking.
10. Security & Administration: Security models and backup/restore.