Microsoft SQL Server Hands-On Training
In-depth expertise in Microsoft SQL Server through a combination of theory and hands-on exercises, covering features, functionality, and best practices end to end.
About this course
The Microsoft SQL Server Hands-On Training course offers in-depth expertise in Microsoft SQL Server. Through a combination of theory and hands-on exercises, participants gain a deep understanding of SQL Server's features, functionality, and best practices.
The course pairs every concept with lab work, so you leave able to do the job rather than just describe it.
What you'll be able to do
- Confidently install and configure SQL Server environments
- Apply sound database design principles
- Harden databases and manage access properly
- Run dependable backup, restore, migration, and upgrade processes
- Diagnose and resolve performance bottlenecks
- Choose and implement the right high-availability approach
How the program is structured
Each phase builds on the last, pairing instruction with lab work so the concepts stick.
SQL Server installation and configuration
Stand up SQL Server correctly from the start, working through the installation options and configuration choices that shape everything afterwards.
Database design
Model and build databases that hold up in production, with the structures, constraints, and objects that keep data consistent.
Database security
Control access and protect data at rest and in motion using SQL Server's security features.
Database backup and restoration
Build backup strategies you can rely on, and practise the restores that prove them.
Database migration and upgrade
Move and upgrade databases between environments and versions with minimal disruption.
Performance tuning
Find and fix the bottlenecks, using SQL Server's built-in tooling alongside third-party utilities.
High availability and disaster recovery
Work through Always On Availability Groups, traditional failover clustering, log shipping, replication, and database mirroring.
Interested in Microsoft SQL Server Hands-On Training?
Get the schedule, pricing, and next start date — and tell us about your background so we can confirm it's the right fit.