This course guides learners on how to use PowerShell and SMO features to administer SQL Server. Students learn to maintain daily and scheduled maintenance works. The key focus is kept on Database Engine administration however, SSAS (Analysis Services) and SSIS (Integration Services) related exercises are also covered in the course.
This training is designed based on the objectives of the course variant 55069A.
The course is meant for SQL server admins working with Windows Network. The ideal candidate must have some real-world experience with SQL server administration using PowerShell.