Course Description
Audience
Prerequisites
16 Module Course Outline Below
Course Summary
Next Public Course Dates | |
| Duration |
|
| Available Formats |
|
Course Modules
- Introduction
- SQL Server Security
- Assigning Server and Database Roles
- Authorizing Users to Access Resources
- Protecting Data with Encryption and Auditing
- Recovery Models and Backup Strategies
- Backing Up SQL Server Databases
- Restoring SQL Server Databases
- Automating SQL Server Management
- Configuring Security for SQL Server Agent
- Monitoring SWL Server with Alerts and Notifications
- Introduction to Managing SQL Server by using PowerShell
- Tracing Access to SQL Server with Extended Events
- Monitoring SQL Server
- Troubleshooting SQL Server
- Importing and Exporting Data
Testimonials
“The course was comprehensive and interactive, and the trainer really understood the content. I have been able to implement much of what I learned into my daily work activities and have saved a lot of time.”
- Susan Medina, Senior Business Analyst, Advocate Health Care
I enjoyed the class a lot! I had problems with queries, so it was super helpful when Mahesh copies them into the chat. All explanations were thorough and be able to do it was awesome.
- Lisa Kruta, Environmental Coordinator, US Air Force
“Instructor was very passionate about the subject and definitely helped me to stay engaged. Great pace, great knowledge, and instructor was amazing overall :) ”
- John Smith, Analyst, Dept. of Homeland Security
