Overview
-
Learn how to administer SQL Server 2016, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.
Syllabus
-
Introduction
- Welcome
- Use the exercise files
- What you should know
- Install the sample database
- Encryption overview
- Implement cell-level encryption
- Configure transparent data encryption
- Implement Always Encrypted
- Implement backup encryption
- Configure encryption for connections
- Create and maintain users
- Manage database object permissions
- Create and maintain custom roles
- User options for Azure SQL Database
- Configure row-level security
- Configure dynamic data masking
- SQL Server audits
- Create an audit on SQL Server
- Query the SQL Server audit log
- Configure an Azure SQL Database audit
- Analyze logs from Azure SQL Database
- Back up very large databases
- Configure database recovery models
- Manage transaction log backups
- Configure backup automation
- Back up databases to Azure
- Automate and test restores
- Perform page recovery
- Restore file groups
- Perform piecemeal restores
- Identify database corruption
- Implement database consistency checks
- Recover from database corruption
- Monitor current sessions
- Identify causes of blocking activity
- Find sessions that use tempdb resources
- Configure the data collector
- Manage the Query Store
- Configure trace events
- Identify problematic execution plans
- Server health and extended events
- Identify and repair index fragmentation
- Identify and create missing indexes
- Identify and drop underutilized indexes
- Manage existing columnstore indexes
- Statistics objects
- Identify and correct outdated statistics
- Implement auto update statistics
- Implement statistics for large tables
- Configure database mail
- Create and manage operators
- Create and manage SQL Server Agent alerts
- Define failure actions
- Identify available space on data volumes
- Introduction to Policy-Based Management
- Log shipping overview
- Configure log shipping
- Configure Windows clustering
- Create an availability group
- Configure read-only routing
- Manage failover
- Create distributed availability groups
- Next steps
