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
“Tomi was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions, so the Informatica materials and lab books are super helpful.”
- Leroy Smith, ETL Developer, US Army
“The content was great for an introduction to Tableau. I truly appreciate the way Michael was able to explain everything, and would recommend this class to anyone needing to get their feet wet with Tableau.”
- Shianne DeGeorge, Business Intelligence Group, Kaiser Permanente
Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.
- Rick Kirk, CTO, Alliant Energy / Ernst & Young
