Starting from writing T-SQL queries, the goal is to become a DBA who can install, back up, monitor and tune a production database. All labs run on a real SQL Server environment.
Program modules
- SQL & T-SQL fundamentals · 15 hours
- Programmable objects · 15 hours
- Installation & administration · 21 hours
- Backup & recovery · 21 hours
- Performance & monitoring · 18 hours
- High availability & security · 18 hours
Projects you will build
- A SQL Server environment installed and secured from scratch
- Automated backup & maintenance plan + restore drill
- Performance report analysing and speeding up slow queries
Who is it for?
- Aspiring database administrators (DBAs)
- Developers and sysadmins working with SQL Server
- People in reporting / data teams
This is a paid program and fees are collected at final registration. Why pre-register? A class only opens once it reaches at least 12 participants; pre-registration tells us when that happens, and nothing is charged at this stage.