• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/15/2018 11/16/2018
  • VLT
Live Online
12/13/2018 12/14/2018
  • VLT
Live Online
11/15/2018 11/16/2018
  • VLT
Live Online
12/13/2018 12/14/2018
  • VLT
Live Online
11/19/2018 11/20/2018
  • VLT
  • GTR
Live Online

About the Course 

This two-day teacher drove course gives hopefuls the learning and abilities expected to utilize PowerShell and SMO segments for SQL Server organization on SQL Server 2016, 2014 or 2012. Understudies will figure out how to oversee everyday and booked support assignments. The primary concentration will be organization of the database motor, yet discretionary material and activities on Analysis Services (SSAS) and Integration Services (SSIS) are likewise included. 

On the off chance that all the discretionary lab practices are incorporated, the class may should be educated in three days rather than two. 

Audience Profile

This course is proposed for SQL Server directors who work in a Windows arrange condition. No less than one year of experience overseeing SQL Servers and utilizing PowerShell is prescribed. 

At Course Completion

Subsequent to finishing 55069: PowerShell for SQL Server Administrators course, understudies will have the capacity to: 

  • Introduce and Configure SQL Server and every one of its segments utilizing PowerShell 
  • Oversee everyday SQL Server Administration with PowerShell 
  • Keep up the SQL Server condition utilizing PowerShell scripting and programming alternatives 

Module 1: Install and Configure SQL Server with PowerShell 

55069: PowerShell for SQL Server Administrators module discloses how to setup SQL Server parts utilizing PowerShell. 

Lessons 

  • Module Objectives 
  • Lesson 1: Install SQL Server 
  • Lesson 2: Configure Database Settings 
  • Lesson 3: Configure SQL Server Settings 
  • Lesson 4: Configure SQL Server Policy-Based Management 
  • Survey 

Lab : Configuring SQL Server with PowerShell 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Introduce SQL Server 
  • Include/Remove parts to a current case (SSRS, SSIS, SSAS, and so forth.) 
  • Arrange SQL Server and Database Settings 
  • Arrange SQL Server Policy-Based Management 

Module 2: Administering SQL Servers with PowerShell 

55069: PowerShell for SQL Server Administrators module discloses how to perform everyday authoritative undertakings on SQL Server Servers utilizing PowerShell. 

Lessons 

  • Module Objectives 
  • Lesson 1: Managing Users and Roles 
  • Lesson 2: Managing Database Performance 
  • Lesson 3: Managing Database Availability 
  • Lesson 4: Managing SQL Server Features 
  • Survey 

Lab : Administering SQL Servers with PowerShell 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Oversee Users and Roles 
  • Oversee Database Performance 
  • Oversee Database Availability with Clustering and AlwaysOn Availability Groups 
  • Oversee Integration Services and Analysis Services 

Module 3: Maintaining SQL Server with PowerShell 

55069: PowerShell for SQL Server Administrators module discloses how to perform support assignments on SQL Servers utilizing PowerShell. 

Lessons 

  • Module Objectives 
  • Overseeing Backups and Restores 
  • Keeping up Database Integrity and Performance 
  • Observing and Auditing 
  • Undertaking Automation 
  • Producing Reports 
  • Audit 

Lab : Maintaining SQL Servers with PowerShell 

  • Subsequent to finishing this module, understudies will have the capacity to: 
  • Oversee SQL Server Backups and Restores 
  • Keep up Database Integrity and Performance 
  • Screen and Audit changes to a SQL Server 
  • Undertaking Automation on SQL Server 
  • Produce SQL Server Reports 
  • Extra Reading 
  • To enable you to plan for this class, survey the accompanying assets: 
  • Classroom Training:  Course 10775A - Administering Microsoft SQL Server 2012 Databases

Before going to 55069: PowerShell for SQL Server Administrators course, understudies must have: 

  • Experience chipping away at Windows desktops or servers 
  • Experience working in a Windows space condition 
  • Experience Administering SQL Server Servers 
  • Principal involvement with PowerShell or Course 10961B – Automating Administration with Windows PowerShell

 

Awards