Managing and Configuring SQL Server with PowerShell

$95.00

Category:

Description

This class is designed to show you how to use Windows PowerShell to automate and manage SQL Serve. Throughout this course we will look at domain specific topics for Data Professionals Including cmdlets for traditional DBA workloads (DML, DDL, DCL), cmdlets for Reporting Services, community-built cmdlets, and the SMO provider. We will also introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. This course will include Labs and Projects that will help you practice what you learn. By the end of this course you should feel comfortable writing your own scripts for managing SQL Server.

Instructor

JOSHUA CORRICKJOSHUA CORRICK

Training Content Manager
Joshua is a Systems Engineer at the University of North Florida, and has been in this role for 2 years. Josh has many different hats on his team, but tends to be given the DBA responsibilities. He is also a passionate advocate for PowerShell and automation of any fashion. He is a husband and father of two boys (3 and 1) and Has lived in Jacksonville FL since 2014.

 

What to Know Before the Class

We recommend first taking the Introduction to PowerShell course first but this is not mandatory.


Duration: 5:51:32
This class is designed to show you how to use Windows PowerShell to automate and manage SQL Server. Throughout this course we will look at domain specific topics for Data Professionals Including cmdlets for traditional DBA workloads (DML, DDL, DCL), cmdlets for Reporting Services, community-built cmdlets, and the SMO provider. We will also introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. This course will include Labs and Projects that will help you practice what you learn. By the end of this course you should feel comfortable writing your own scripts for managing SQL Server. Quizzes will be at the end of each module .
Managing and Configuring SQL Server with PowerShell - What you will need to get started
Module 00 - Course Introduction - Managing and Configuring SQL Server with PowerShell
09:35
Module 01A - Modules for SQL (Overview)
12:00
Module 01B - Modules for SQL (Getting the Modules and Resources)
12:26
Module 01C - Modules for SQL (Connecting with PowerShell)
09:11
Module 02A - DML Tasks with PowerShell (Overview)
11:12
Module 02B - DML Tasks with PowerShell (Querying Tables)
23:15
Module 02C - DML Tasks with PowerShell (Inserting, Updating, Deleting)
18:16
Module 02D - DML Tasks with PowerShell (Review)
01:26
Module 03A - DDL Tasks with PowerShell (Overview)
07:06
Module 03B - DDL Tasks with PowerShell (Creating and Editing)
18:06
Module 03C - DDL Tasks with PowerShell (Dropping Database Objects)
14:20
Module 04A - DCL Tasks with PowerShell (Overview)
11:05
Module 04B - DCL Tasks with PowerShell (Creating Logins and Granting Access)
08:38
Module 04C - DCL Tasks with PowerShell (Login Lifecycles)
10:01
Module 04D - DCL Tasks with PowerShell (Auditing Systems)
08:41
Module 04E - DCL Tasks with PowerShell (Review)
01:19
Module 05A - Backups and Agent Jobs (Overview)
16:22
Module 05B - Backups and Agent Jobs (Backups)
20:51
Module 05C - Backups and Agent Jobs (Agent Jobs)
05:18
Module 05D - Backups and Agent Jobs (Review)
02:18
Module 06A - Managing SSRS With PowerShell (Overview)
10:17
Module 06B - Managing SSRS with PowerShell (Managing Report Services)
27:15
Module 07A - Testing Your Instances (Overview)
15:22
Module 07B - Testing your Instances Demo (Using DbaChecks)
34:10
Module 08A - PowerShell Desired State Configuration (Overview)
21:16
Module 08B - PowerShell Desired State Configuration (Setting LocalConfigurationManager)
08:59
Module 09A - Installing SQL Server via a Push Deployment (Overview)
10:15
Module 09B - Installing SQL Server via a Push Deployment (Installing SQL Server with a Push Config)
57:28
Module 10A - Maintaining Settings with a Pull Deployment (Overview)
05:34
Module 10B - Maintaining Settings with a Pull Deployment (Setting up a Pull Server)
02:32
Module 10C - Maintaining Settings with a Pull Deployment (Using Azure Automation)
31:43
Class Survey

System Requirements

  • SQL Server 2016 or higher
  • A• SQL Server PowerShell Modules
  • Microsoft Windows 7, Windows 8 or 8.1 desktop or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space