Databases · Beginner → Expert
🗄️ Microsoft SQL Server Developer and DBA
Master T-SQL, schema design, transactions, indexing, security, backup, HA, automation, monitoring and performance tuning on SQL Server.
Course roadmap
Pass each module exam to unlock the next module.
Module 1 · Beginner
SQL Server Architecture, Editions and Tooling
Locked
Module 2 · Beginner
T-SQL Querying, Expressions and Data Types
Locked
Module 3 · Beginner
Joins, Aggregation, Window Functions and Set Logic
Locked
Module 4 · Beginner
Schema Design, Constraints and Normalization
Locked
Module 5 · Intermediate
Transactions, Isolation, Locking and Concurrency
Locked
Module 6 · Intermediate
Indexes, Statistics, Execution Plans and Query Tuning
Locked
Module 7 · Intermediate
Stored Procedures, Functions, Views and Triggers
Locked
Module 8 · Intermediate
Users, Logins, Roles, Permissions and Encryption
Locked
Module 9 · Advanced
Backup, Restore and Recovery Models
Locked
Module 10 · Advanced
SQL Server Agent, Jobs and Maintenance
Locked
Module 11 · Advanced
TempDB, Memory, Storage and Configuration
Locked
Module 12 · Advanced
Monitoring, Extended Events and Troubleshooting
Locked
Module 13 · Expert
High Availability, Always On and Disaster Recovery
Locked
Module 14 · Expert
Data Import, Export, Integration and Migration
Locked
Module 15 · Expert
Advanced T-SQL and Reporting Patterns
Locked
Module 16 · Expert
Expert Capstone: Operate a Production SQL Server
Locked
Certification gate
Final course exam
Pass mark: 80%. Time limit: 360 minutes. All module exams must be passed first.
Locked until modules are passed