![]](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,395.-
-
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,395.-
-
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
Click on the location to go directly to the booking page Schedule
This course is guaranteed to run. Please see our complete terms and conditions for full details of this offer.
This class will become guaranteed to run with one more student registration.
This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
United Kingdom
For more information please email enquiries@flane.co.uk to discuss training options available.
Europe
Germany
| 20/04/2020 ― 24/04/2020 guaranteed date! | Online Training Time zone: Europe/Berlin Course language: German | Enroll | |
| 13/07/2020 ― 17/07/2020 | Munich | Enroll | |
| 17/08/2020 ― 21/08/2020 | Berlin | Enroll | |
| 21/09/2020 ― 25/09/2020 | Frankfurt | Enroll | |
| 26/10/2020 ― 30/10/2020 | Stuttgart | Enroll | |
| 30/11/2020 ― 04/12/2020 | Münster | Enroll |
France
Italy
| 11/05/2020 ― 15/05/2020 | Online Training Time zone: Europe/Rome Course language: Italian | Enroll | |
| 22/06/2020 ― 26/06/2020 | Online Training Time zone: Europe/Rome Course language: Italian | Enroll | |
| 03/08/2020 ― 07/08/2020 | Rome | Enroll | |
| 21/09/2020 ― 25/09/2020 | Milan | Enroll | |
| 26/10/2020 ― 30/10/2020 | Rome | Enroll | |
| 30/11/2020 ― 04/12/2020 | Milan | Enroll |
North America
Middle East
Qatar
| 10/05/2020 ― 14/05/2020 | Online Training Time zone: Asia/Qatar Course language: English | Enroll | |
| 15/11/2020 ― 19/11/2020 | Doha Course language: English | Enroll |
United Arab Emirates
| 10/05/2020 ― 14/05/2020 | Online Training Time zone: Asia/Dubai Course language: English This course is being delivered by iTLS. | Enroll | |
| 30/08/2020 ― 03/09/2020 | Dubai Course language: English This course is being delivered by iTLS. | Enroll | |
| 15/11/2020 ― 19/11/2020 | Dubai Course language: English This course is being delivered by iTLS. | Enroll |