X
ODT

Managing and Configuring SQL Server with PowerShell
On-Demand Training

Starting At: $195
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Managing and Configuring SQL Server with PowerShell
$195
Per User Per Year
Unlimited Elite Pack
$895

$995

Per User Per Year
Free Trial

Unlimited Elite Pack $100 off through March 31th.

3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

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.


Prerequisites


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

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

Curriculum For This Course

Image

Joshua Corrick

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.



Related Courses

Course Info
10 Comprehensive Modules
10 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
8h 20m
Enrollment Price:
$195/Year
Share this course with your friends