Administering SQL Database Infrastructure
This course is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
Exam 70-764 Administering a SQL Database Infrastructure
This course is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
Course Content
Configure data access and auditing (20–25%)
- Configure encryption
- Configure data access and permissions
- Configure auditing
Manage backup and restore of databases (20–25%)
- Develop a backup strategy
- Restore databases
- Manage database integrity
Manage and monitor SQL Server instances (35–40%)
- Monitor database activity
- Monitor queries
- Manage indexes
- Manage statistics
- Monitor SQL Server instances
Manage high availability and disaster recovery (20–25%)
- Implement log shipping
- Implement AlwaysOn Availability Groups
Implement failover cluster instances