Course Overview
This hands-on course covers everything needed to become a proficient MSSQL professional, from crafting complex Transact-SQL (T-SQL) queries to managing large, production-ready databases. Topics include performance tuning, indexing strategies, backup and recovery procedures, security implementation, and automation via SQL Server Agent.
You will learn the roles of a Database Administrator (DBA) and a senior Database Developer, ensuring you can manage and manipulate data efficiently.
Detailed Curriculum
Module 1: Foundational T-SQL
- SELECT, INSERT, UPDATE, DELETE statements
- JOIN operations (Inner, Outer, Cross) and Subqueries
- Stored Procedures, Functions, and Triggers
Module 2: Database Design and Architecture
- Normalization principles (1NF, 2NF, 3NF)
- Table and Index creation (Clustered and Non-Clustered)
- Views, Schemas, and Constraints
Module 3: Performance and Tuning
- Reading and interpreting Execution Plans
- Query optimization techniques (Hints, Rewriting inefficient queries)
- Database monitoring and troubleshooting locks/deadlocks
Module 4: Administration and Security
- Backup strategies (Full, Differential, Transaction Log) and Recovery Models
- User management, Roles, and Permissions
- High Availability concepts (Mirroring, Replication, Always On)