NEED HELP? TALK TO AN EXPERT (904) 638-5743

Managing and Configuring SQL Server with PowerShell

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • To use Windows PowerShell to automate and manage SQL Server
  • DML, DDL and DCL tasks with PowerShell
  • How to test your instances
  • To install SQL Server via a push deployment and maintain settings with a pull deployment
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

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.

Outline

 

Module 00 | Course Introduction
09m 35s total

 

Module 00A | Course Introduction
09m 35s

 

Module 01 | Modules for SQL
33m 37s total

 

Module 01A | Modules for SQL Overview
12m 00s

 

Module 01B | Getting the Modules and Resources
12m 26s

 

Module 01C | Connecting with PowerShell
09m 11s

 

Module 02 | DML Tasks with PowerShell
54m 09s total

 

Module 02A | DML Tasks with PowerShell Overview
11m 12s

 

Module 02B | Querying Tables
23m 15s

 

Module 02C | Inserting, Updating, Deleting
18m 16s

 

Module 02D | DML Tasks with PowerShell Review
01m 26s

 

Module 03 | DDL Tasks with PowerShell
39m 32s total

 

Module 03A | DDL Tasks with PowerShell Overview
07m 06s

 

Module 03B | Creating and Editing
18m 06s

 

Module 03C | Dropping Database Objects
14m 20s

 

Module 04 | DCL Tasks with PowerShell
39m 44s total

 

Module 04A | DCL Tasks with PowerShell Overview
11m 05s

 

Module 04B | Creating Logins and Granting Access
08m 38s

 

Module 04C | Login Lifecycles
10m 01s

 

Module 04D | Auditing Systems
08m 41s

 

Module 04E | DCL Tasks with PowerShell Review
01m 19s

 

Module 05 | Backups and Agent Jobs
44m 49s total

 

Module 05A | Backups and Agent Jobs Overview
16m 22s

 

Module 05B | Backups
20m 51s

 

Module 05C | Agent Jobs
05m 18s

 

Module 05D | Backups and Agent Jobs Review
02m 18s

 

Module 06 | Managing SSRS With PowerShell
37m 27s total

 

Module 06A | Managing SSRS With PowerShell Overview
10m 17s

 

Module 06B | Managing Report Services
27m 15s

 

Module 07 | Testing Your Instances
49m 31s total

 

Module 07A | Testing Your Instances Overview
15m 22s

 

Module 07B | Using DbaChecks
34m 10s

 

Module 08 | PowerShell Desired State Configuration
30m 15s total

 

Module 08A | PowerShell Desired State Configuration Overview
21m 16s

 

Module 08B | Setting Local Configuration Manager
08m 59s

 

Module 09 | Installing SQL Server via a Push Deployment
67m 43s total

 

Module 09A | Installing SQL Server via a Push Deployment Overview
10m 15s

 

Module 09B | Installing SQL Server with a Push Config
57m 28s

 

Module 10 | Maintaining Settings with a Pull Deployment
39m 49s total

 

Module 10A | Maintaining Settings with a Pull Deployment
05m 34s

 

Module 10B | Setting up a Pull Server
02m 32s

 

Module 10C | Using Azure Automation
31m 43s


Instructor

JOSHUA CORRICK

IT Systems Engineer
Joshua is a Systems Engineer at the University of North Florida and has been in this position for 2 years. Joshua wears many different hats in his role, 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 and has lived in Jacksonville, FL since 2014.

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

What to Know Before Class

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

REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required