Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of PowerShell for DBAs
Before the Class (Free Previews)
Welcome and Class Roadmap (17:45)
How Drew Sets Up His Workstation (7:06)
Setting Up Your Computer (2:13)
Download the Slide Decks and Helper Files
Working with Variables and CMDLETs
What's PowerShell? (13:08)
Using Variables and Lab 1 Assignment (23:58)
Using CMDLETs and the Pipeline: Lecture (8:25)
Using CMDLETs and the Pipeline: Demos (14:46)
CMDLETs: Aliasing and the Pipeline: Lecture (4:47)
CMDLETs: Aliasing and the Pipeline: Demo (9:17)
Lab 2 Assignment (1:51)
Working with Objects
Working with Objects: Lecture (6:39)
Working with Objects: Demo (4:56)
Object Properties and the Pipeline: Lecture (3:35)
Object Properties and the Pipeline: Demo (9:19)
Object Methods (8:42)
Making Your Own Objects (5:34)
Lab 3 Assignment (2:00)
Logical Operators and Loops
Logical Operators and Loops: Lecture (6:30)
Logical Operators and Loops: Demo (15:06)
Filtering with WHERE (9:54)
WHILE Loops: Lecture (5:59)
WHILE Loops: Demo (6:03)
IF - THEN - ELSE (5:21)
Lab 4 Assignment (2:30)
Functions and Parameters
Functions and Parameters: Lecture (9:21)
Functions and Parameters: Demo (7:19)
Parameters and Error Handling: Lecture (9:26)
Parameters and Error Handling: Demo (29:54)
Lab 5 Assignment (5:21)
Using PowerShell with SQL Server
The SQL Server Module: Lecture (12:57)
The SQL Server Module: Demo (13:21)
The SQLSERVER:\ Drive (20:34)
Working With SQLSERVER Objects (12:45)
Lab 6 Assignment (2:28)
Scripting SQL Server Objects with PowerShell
Scripting Objects: Lecture (4:03)
Scripting Objects: Demo (15:53)
Objects and Namespaces (8:05)
Lab 7 Assignment (2:46)
SQL Server Agent Jobs
PowerShell and the SQL Server Agent (12:58)
Creating Agent Jobs with PowerShell (5:39)
Scheduling PowerShell Job Steps (19:17)
Lab 8 Assignment (3:04)
Putting It All Together
Auditing Permissions with PowerShell: Lecture (6:26)
Auditing Permissions with PowerShell: Demo (15:30)
Exporting the Permissions to CSV (11:18)
Lab 9 Assignment (2:07)
Recap and What To Do Next
Okay, What's Next? (8:41)
Lab 7 Assignment
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock