PowerShell Scripting and Automation for SQL Server DBA
Develop essential engineering skills with expert instruction and practical examples.
Skills you'll gain:
Skill Level
Requirements
Who This Course Is For
About This Course
In this course you will get in depth knowledge of PowerShell after that you will be able to develop the script using PowerShell easily. Basically, this course has been divided in to 20 sessions/Module which include the HTML Session, Evendu you will find the others additional session in this course, which will be the subcategory of the main course. For Sub-category you have to go through each Module.
I am going to provide and discussed total 100+ script, you can download and start doing the practice after each session. I will be frequently uploading the video. For doubt clarification I will provide my email so that you can send me mail for any doubt.
This course has designed in such a way that anyone having the basic knowledge of DBA, they can easily learn and develop the script using PowerShell for SQL DBA at the end of this course. In this session will cover that how to start writing the PowerShell script from basic to advance level. It will be going to include Daily DBA Task like - Backup, Restore, how to script the Database objects, creating and scheduling SQL Job in Single or Multiple servers.
Running the script in multiple servers, BCP IN and BCP out, how to schedule the script using task scheduler or SQL Agent and many more things. How to pass the parameter using config file, creating own module ETC. Standard way of writing the script.
Topics Covered
Course Details
View pricing and check out the reviews. See what other learners had to say about the course.
This course includes:
Not sure if this is right for you?
Browse More Engineering CoursesContinue Your Learning Journey
Explore more Engineering courses to deepen your skills and advance your expertise.