55069: PowerShell for SQL Server Administrators Training in Conway
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
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.Â
  Â
Course Length: 2 Days
Course Tuition: $890 (US) |
Prerequisites |
|
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 To help you prepare for this class, review the following resources: Classroom Training: Course 10775A â?? Administering Microsoft SQL Server 2012 Databases |
Course Outline |
Module 1: Install and Configure SQL Server with PowerShell This module explains how to setup SQL Server components using PowerShell. Lessons – Module Objectives
Lab: Configuring SQL Server with PowerShell
After completing this module, students will be able to:
Module 2: Administering SQL Servers with PowerShell This module explains how to perform day-to-day administrative tasks on SQL Server Servers using PowerShell. Lessons – Module Objectives
Lab: Administering SQL Servers with PowerShell
After completing this module, students will be able to:
Module 3: Maintaining SQL Server with PowerShell This module explains how to perform maintenance tasks on SQL Servers using PowerShell. Lessons – Module Objectives
Lab: Maintaining SQL Servers with PowerShell
After completing this module, students will be able to:
|
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes