Powershell Essential Training on Automation and Scripting

Course Curriculum

Chapter 1: Introduction about the Course and Instructer

Lecture 1: About me : A very very short Intro !!!

Lecture 2: What this course is about ?

Lecture 3: Why Powershell and NOT Command Prompt

Chapter 2: Slides of the course

Lecture 1: Slides Download

Chapter 3: Easy Set up a Lab : An Infrastructure set up.

Lecture 1: Download VMWare Player – Steps

Lecture 2: Install VMWare Player in your Workstation

Lecture 3: Create Virtual Machine VM1 using VMWare Player

Lecture 4: Install VMVare Tools for enhancement of the Virtual Machine features

Lecture 5: Create VM2 and CENTRAL SERVER

Lecture 6: Domain and Domain Controller Set Up

Lecture 7: Joining the Servers to the domain 'LAB'

Lecture 8: (Optional)Set up Virtual Machine (VM1) using VMWare Workstation Pro

Lecture 9: Internet connectivity Issues – VMWARE Virtual machines

Lecture 10: License Extension – Windows Server Evaluation Edition

Chapter 4: Powershell Essentials for Automation

Lecture 1: Know Powershell ISE – The IDE for powershell

Lecture 2: Variables and Datatypes in Powershell

Lecture 3: Arrays

Lecture 4: Looping – for loop

Lecture 5: Looping – foreach

Lecture 6: Conditional Operators (if, else, if-else)

Lecture 7: Comparison Operators (-eq, -ne, -gt , -le , -and , -or , not ,-in,-match)

Lecture 8: Looping – while & do-while

Lecture 9: Get-Content Cmdlet

Lecture 10: Get-Services Commandlet

Lecture 11: Get-Child Item Commandlet

Lecture 12: Demo – Get-ChildItem

Lecture 13: functions

Lecture 14: Modules in Powershell

Lecture 15: Error Handling (try, catch, finally)

Lecture 16: Secure Your credentias in Powershell

Lecture 17: What If switch in Powershell

Chapter 5: File Handling in Powershell

Lecture 1: A quick intro : File Handling in Powershell

Lecture 2: Handling text files

Lecture 3: Handling Csv files

Lecture 4: Handling XML files

Chapter 6: Output Display Options with Powershell

Lecture 1: Saving output to text file (Out-File Cmdlet)

Lecture 2: Displaying output to gridview

Lecture 3: Saving output as CSV file

Lecture 4: Displaying output to HTML

Chapter 7: Scripting using Powershell

Lecture 1: Your Scripting Journey Starts here

Lecture 2: Execution Policy and Run your first script

Lecture 3: Windows drive space analysis using powershell

Lecture 4: Query database and Convert the output to HTML

Lecture 5: Sending Mails using powershell : Send-MailMessage

Chapter 8: Automation with Powershell

Lecture 1: Automation – Introduction

Lecture 2: Automate your script through Windows Task Scheduler -Part 1

Lecture 3: Automate your script through Windows Task Scheduler – Part 2

Lecture 4: Automate your script thorugh the Jenkins (a widely used free Devops Tool)

Lecture 5: Automate your scripts through SQL Server Agent

Chapter 9: Desired State Configuration Powershell

Lecture 1: Powershell DSC Introduction

Lecture 2: SQL Server and Powershell DSC

Lecture 3: Scripts detailing – SQL Server Installation

Lecture 4: Installing SQL Server using Powershell DSC

Lecture 5: Install SSIS, SSAS, SSRS along with SQL Server using DSC

Chapter 10: Ad hoc scripts

Lecture 1: Script – Automate free space reporting in your server

Chapter 11: BONUS : Download your FREE Tool : Exclusively for Udemy Students

Lecture 1: ServerRemoteChecker Tool : Know the Tool

Lecture 2: Powershell Academy : Other courses in Udemy