This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.
Module 1: Install and Configure SQL Server with PowerShell
Lab: Configuring SQL Server with PowerShell
Module 2: Administering SQL Servers with PowerShell
Lab: Administering SQL Servers with PowerShell
Module 3: Maintaining SQL Server with PowerShell
Lab: Maintaining SQL Servers with PowerShell
This PowerShell for SQL Server Administrators 55069A Training course is ideal for anyone who works with the Windows network environment. However, this training can be much more beneficial for SQL Server Administrators.
Q: Is this course for server administrators?
A: No, not only server administrators, but for IT who want to or are willing to work as SQL Server Administrators in Windows. A learner enrolling in this course must have a minimum of one year of experience as a PowerShell administrator.
Q: What are the requirements for the 55069-A: PowerShell for SQL Server Administrators course?
A: The requirements for the 55069-A: PowerShell for SQL Server Administrators course are that the learners must have: experience working on Windows desktops or servers; experience working in a Windows domain environment; and experience in administering SQL Server Servers.
Q: What will you learn from the 55069-A: PowerShell for SQL Server Administrators course?
A: You will be able to learn, install, and configure SQL Server and all its components using PowerShell. Day-to-day SQL Server Administration with PowerShell and maintaining the SQL Server environment using PowerShell scripting and programming options
Q: What is PowerShell?
A: PowerShell has a set of commands known as cmdlets (pronounced command-lets). In addition to cmdlets, PowerShell allows you to run any command that is available on your system.