
Administering a SQL Database Infrastructure (20764)
Course Overview
This hands-on, 5-day instructor-led course teaches you the knowledge and skills to fully administer a SQL server database infrastructure.
Who should attend
- IT professionals responsible for administering and maintaining SQL Server databases
- Anyone pursuing their MCSA: SQL Server 2016 Database Administration
- Application Developers that work with SQL Server databases
Certifications
This course is part of the following Certifications:
Prerequisites
- Basic knowledge of the Microsoft Windows operating system and its core functionality
- Working knowledge of Transact-SQL and relational databases
- Some experience with database design
Course Objectives
- 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
Follow On Courses
Online Training
Duration 5 days
Price (excl. VAT)
- £ 2,395.-
-
SA Voucher:
5
hardcoded default SA
Schedule
English
2 hours difference
3 hours difference
4 hours difference
French
1 hour difference
Portuguese
Time zone GMT
Time zone: Western European Summer Time (WEST)
German
1 hour difference
Time zone: Central European Summer Time (CEST)
Time zone: Central European Summer Time (CEST)
Time zone: Central European Summer Time (CEST)
Spanish
1 hour difference
Time zone: Central European Summer Time (CEST)
Italian
1 hour difference
United Kingdom
For more information please email enquiries@flane.co.uk to discuss training options available.
Europe
Germany
Online Training This is an English language FLEX course. Time zone: Europe/Berlin | Enroll | ||
Online Training This is an English language FLEX course. Time zone: Europe/Berlin | Enroll | ||
Online Training This is an English language FLEX course. Time zone: Europe/Berlin | Enroll | ||
Munich | Enroll | ||
Online Training This is an English language FLEX course. Time zone: Europe/Berlin | Enroll | ||
Frankfurt | Enroll |