This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.
If all the optional lab exercises are included, the class may need to be taught in three days instead of two.
This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.
Cui se adresează:
This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.
Job role: Developer
Competențe dobândite:
- Install and Configure SQL Server and all its components using PowerShell
- Manage day-to-day SQL Server Administration with PowerShell
- Maintain the SQL Server environment using PowerShell scripting and programming options
Cunoștințe prealabile:
Before attending this course, students must have:
- Experience working on Windows desktops or servers
- Experience working in a Windows domain environment
- Experience Administering SQL Server Servers
- Fundamental experience with PowerShell or Course 10961B – Automating Administration with Windows PowerShell
Prețul include:
Suportul de curs oficial Microsoft în format electronic și diplomă Microsoft, recunoscută internațional.
Discount de volum:
Se acordă discount-uri negociabile de volum. Solicită oferta specială pentru compania ta!
Model diplomă:
