![]](https://flcdnk4-914d.kxcdn.com/medi_a/img/guaranteed-training_465fb3e77d00837866c9d37343e27407.png)
MS-20764
Online Training
Duration 5 days
Price (excl. VAT)
- United Kingdom: £ 2,391.-
-
SA Voucher:
5
hardcoded default SA
E-Learning MOC on Demand
Duration 90 days
Price (excl. VAT)
- United Kingdom: £ 449.-
-
SA Voucher:
2
hardcoded default SA
Onsite Training
Request training
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)
- United Kingdom: £ 2,391.-
-
SA Voucher:
5
hardcoded default SA
E-Learning MOC on Demand
Duration 90 days
Price (excl. VAT)
- United Kingdom: £ 449.-
-
SA Voucher:
2
hardcoded default SA