Course duration
- 2 days
Course Benefits
- Learn to install and Configure SQL Server and all its components using PowerShell.
- Learn to manage day-to-day SQL Server Administration with PowerShell.
- Learn to maintain the SQL Server environment using PowerShell scripting and programming options.
Course Outline
- Install and Configure SQL Server with PowerShell
- Module Objectives
- Install SQL Server
- Configure Database Settings
- Configure SQL Server Settings
- Configure SQL Server Policy-Based Management
- Review
- Lab: Configuring SQL Server with PowerShell
- Administering SQL Servers with PowerShell
- Module Objectives
- Managing Users and Roles
- Managing Database Performance
- Managing Database Availability
- Managing SQL Server Features
- Review
- Lab: Administering SQL Servers with PowerShell
- Maintaining SQL Server with PowerShell
- Module Objectives
- Managing Backups and Restores
- Maintaining Database Integrity and Performance
- Monitoring and Auditing
- Task Automation
- Generating Reports
- Review
- Lab: Maintaining SQL Servers with PowerShell
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this SQL Server class:
- 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.
Courses that can help you meet these prerequisites:
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.