MICROSOFT 55069: PowerShell for SQL Server Administrators (501515)

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.

After completing this course, students will be able to:

• 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

Module 1: Install and Configure SQL Server with PowerShell

• Module Objectives
  
• Lesson 1: Install SQL Server
  
• Lesson 2: Configure Database Settings
  
• Lesson 3: Configure SQL Server Settings
  
• Lesson 4: Configure SQL Server Policy-Based Management
  
• Review

Module 2: Administering SQL Servers with PowerShell

• Module Objectives
  
• Lesson 1: Managing Users and Roles
  
• Lesson 2: Managing Database Performance
  
• Lesson 3: Managing Database Availability
  
• Lesson 4: Managing SQL Server Features
  
• Review

Module 3: Maintaining SQL Server with PowerShell

• Module Objectives
  
• Managing Backups and Restores
  
• Maintaining Database Integrity and Performance
  
• Monitoring and Auditing
  
• Task Automation
  
• Generating Reports
  
• Review

• Microsoft Official Courseware
• Bloc notes e penna
• Attestato di fine corso

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