MSSQL Server Hands-on Database Administration

$2750 200+ hours

This course content has been carefully design to take the students from an absolute beginner level to an expert SQL Server DBA, with a strong focus on hands on training. So, it enables the students to develop skills in the areas of:

1. SQL Server installation, Configuration and upgrade.
2. Database Design
3. Implementing High availability and disaster recovery solutions in SQL server (Always on availability groups, Traditional failover clustering, Log shipping, Replication, and database Mirroring, Database backup and restore)
4. Database Security (Always encrypted, Transparent database encryption, dynamic data masking, SQL server login, permissions and authentication.
5. Database Migration.
6. Performance tuning and monioring using both SQL server inbuilt and 3rd party tools.

Research, projects and group work are also core areas of this training, hence the students graduate as 21st century SQL Server DBAs, equipped with the latest technologies and ready to compete at the world stage.

If you are ready to learn how to harness Microsoft SQL Server to deliver mission-critical performance, gain faster insights on data, or drive your hybrid cloud strategy, you are in the right place. These learning opportunities can help you get started quickly - from product exploration to deep training and certification.

Get certified, and show the world that you are ready to take advantage of the breakthrough performance of Microsoft SQL Server to deliver faster data insights that drive business transformation.