Course run in conjunction with Nexus Human (formerly New Horizons). Trading MicroWarehouse CSP partners enjoy a significant discount on the RRP price for selected Nexus Human courses

This is an intensive 5-day online course running from March 23rd – 27th inclusive.  MicroWarehouse trading partners can avail of our heavily discounted rate of €500 per candidate.  Please ensure you have cleared your calendar before registering as no refunds will be offered for cancellations made within 7 days of course commencement and places are limited.

Overview

Authenticate and authorize users Assign server and database roles Authorize users to access resources Protect data with encryption and auditing Describe recovery models and backup strategies Backup SQL Server databases Restore SQL Server databases Automate database management Configure security for the SQL Server agent Manage alerts and notifications Managing SQL Server using PowerShell Trace access to SQL Server Monitor a SQL Server infrastructure Troubleshoot a SQL Server infrastructure Import and export data

Description

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Prerequisites

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

Course Contents

1. SQL Server Security
2. Assigning Server and Database Roles
3. Authorizing Users to Access Resources
4. Protecting Data with Encryption and Auditin
5. Recovery Models and Backup Strategies
6. Backing Up SQL Server Databases
7. Restoring SQL Server Databases
8. Automating SQL Server Management
9. Configuring Security for SQL Server Agent
10. Monitoring SQL Server with Alerts and Notifications
11. Introduction to Managing SQL Server by using PowerShell
12. Tracing Access to SQL Server with Extended events
13. Monitoring SQL Server
14. Troubleshooting SQL Server
15. Importing and Exporting Data