Microsoft 55207: PowerShell for SQL Administration

• Examine and install modules
• Examine and understand SQL Server Cmdlets
• Understand SQL Server Management Objects (SMO)
• Understand recent updates
• Retrieve SQL Server instance information
• Understand and create logins
• Understand how to add files and filegroups
• Understand how to detach and attach databases
• Understand how to backup and restore databases
• Understand how to reorganise/rebuild indexes
• Explore available cmdlets
• Understand scheduling options
• Understand options for tracking performance metrics
• Understand and utilise SSAS
• Understand and use SSIS
• Understand and utilise SSRS
• Understand the evolution of PowerShell
• Understand and use the PowerShell environment
• Understand and utilise the all-important Help System
• Understand and use PowerShell
• Understand and utilise working with the file system
• Understand and use parameters
• Understand and utilise user-defined variables
• Understand and use arrays
• Understand and utilise hash tables
• Understand and execute cmdlets
• Understand and use the pipeline
• Understand how to control the output with formatting
• Understand background jobs
• Understand aliases
• Understand and utilise loops
• Understand and use While loops
• Understand and utilise Do While loops
• Understand and use Do Until loops
• Understand and use For loops
• Understand and use ForEach loops
• Understand altering loop execution
• Understand and use scripting
• Understand functions and filters
• Understand the basics of script design
• Understand scripting pitfalls

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• Database Administrators
• IT Infrastructure Leads
• Systems Administrators
• Senior SQL Administrators
• Microsoft Power Platform Consultants
• Senior Operation Analysts
• IT Systems Administrators
• Data Engineers
• IT Support Managers
• SQL Administrators
• SQL Developers

• Examining Modules and Installing the SQLPS Module
• Examining SQL Server Cmdlets
• Discussing SQL Server Management Objects (SMO)
• Recent Updates – July 2016
• Examining SQL Information Retrieval
• Exploring Logins
• Adding Files and Filegroups
• Detach and Attach Databases
• Understanding Backup and Restore
• Examining Indexes
• Exploring Cmdlets
• Discussing Scheduling
• Understanding Performance Metrics
• Examining SQL Server Analysis Services (SSAS)
• Exploring SQL Server Integration Services (SSIS)
• Utilizing SQL Server Reporting Services (SSRS)
• Successfully log into their virtual machine
• Have a full understanding of what the course intends to cover
• Installing the PowerShell SQL Module
• Examine and install modules
• Examine and understand SQL Server Cmdlets
• Understand SQL Server Management Objects (SMO)
• Understand recent updates
• SQL Server Instances
• Databases
• Tables
• Processes
• Features
• Jobs
• Logins
• Files and FileGroups
• Detach and Attach Databases
• Backup and Restore
• Indexes
• Retrieve SQL Server instance information
• Understand and create logins
• Understand how to add files and filegroups
• Understand how to detach and attach databases
• Understand how to backup and restore databases
• Understand how to reorganise/rebuild indexes
• Explore available cmdlets
• Understand scheduling options
• Understand options for tracking performance metrics
• SSAS, SSIS, AND SSRS
• Understand and utilise SSAS
• Understand and use SSIS
• Understand and use SSRS