This course is intended for SQL administrators with little or basic knowledge of PowerShell. The course centers on SQL administrative tasks that are commonly used, and provides the basic understanding needed for administrators to utilize the expanding PowerShell SQL interoperations. The course concludes with a copy of course 752552 PowerShell 5.0 Basics.
Before attending this course, students must have:
This course is intended for SQL Administrators and SQL Developers.
This module explains how the class will be structured and introduces course materials and additional administrative information.
What We’ll Be Discussing
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
PowerShell and SQL
In this module, we will be discussing SQL Server Cmdlets and SQL Server Management Objects. In addition, we will look at modules and the process to install the SQLPS Module.
Examining Modules and Installing the SQLPS Module
Examining SQL Server Cmdlets
Discussing SQL Server Management Objects (SMO)
Recent Updates – July 2016
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 Administration with PowerShell
In this module, we will examine ways of retrieving information pertaining to the SQL Server instance installed, and look at ways of accomplishing many other management and administrative tasks that can be quickly and efficiently tackled with PowerShell.
Examining SQL Information Retrieval
Adding Files and Filegroups
Detach and Attach Databases
Understanding Backup and Restore
SQL Server Instances
Files and FileGroups
Detach and Attach Databases
Backup and Restore
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 reorganize/rebuild indexes.
Monitoring and Automation
In this module, we will examine a handful of helpful cmdlets, discuss options for scheduling, and explore ways to track performance metrics.
Understanding Performance Metrics
Explore available cmdlets.
Understand scheduling options.
Understand options for tracking performance metrics.
SSAS, SSIS, AND SSRS
In this module, we will examine ways of working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). This module is not meant to be an exhaustive reference but instead is intended to give you a brief look at the capabilities built into the system and encourage you to further explore ways of managing your SQL Server environment using PowerShell.
Examining SQL Server Analysis Services (SSAS)
Exploring SQL Server Integration Services (SSIS)
Utilizing SQL Server Reporting Services (SSRS)
Understand and utilize SSAS.
Understand and utilize SSIS.
Understand and utilize SSRS.
Microsoft Power Platform App Maker
Designing & Implementing Azure AI Solution
Microsoft Azure Administrator
Developing Solutions For Microsoft Azure
Microsoft Azure Architect Design Exam
Implementing Azure Data Solution
Administering Relational Databases On Microsoft Azure