TOIT Training
(909) 252-7584
[email protected]
Search
Log in
Menu
Home
Library
IT Library
Developer Courses
User Cuorses
Plans & Pricing
Features
About Us
Contact Sales
Roadmap
Home
Courses
Microsoft
70-764: Administering a SQL Server 2016 Database Infrastructure
Curriculum
14 Sections
49 Lessons
24 Hours
Expand all sections
Collapse all sections
01. Configuring auditing
5
1.1
Analyze audit logs and reports from Azure SQL database
1.2
Configure an Azure SQL database audit
1.3
Manage a SQL Server audit
1.4
Query the SQL Server audit log
1.5
Configure an audit on SQL Server
02. Developing a backup strategy
6
2.1
Configure backup automation
2.2
Back up databases to Azure
2.3
Configure alerting for failed backups
2.4
Back up very large databases
2.5
Managing transaction log backups
2.6
Configure database recovery models
03. Monitoring database activity
4
3.1
Configure the data collector
3.2
Identify sessions that consume tempdb resources
3.3
Identify sessions that cause blocking activity
3.4
Monitor current sessions
04. Monitoring Queries
4
4.1
Troubleshoot server health using extended events
4.2
Identify problematic execution plans
4.3
Configure extended events and trace events
4.4
Manage the Query Store
05. Managing indexes
4
5.1
Manage existing columnstore indexes
5.2
Identify and drop underutilized indexes
5.3
Identify and create missing indexes
5.4
Identify and repair index fragmentation
06. Managing statistics
3
6.1
Implement auto update statistics
6.2
Identify and correct outdated statistics
6.3
Implement statistics for large tables
07. Monitoring queries
7
7.1
Identify the cause of performance degradation
7.2
Identify available space on data volumes
7.3
Create and manage SQL Agent alerts
7.4
Define custom alert actions and failure actions
7.5
Configure database mail
7.6
Configure Policy-Based Management
7.7
Create and manage operators
08. Implement log shipping
2
8.1
Monitor log shipping
8.2
Configure log shipping
09. Implement AlwaysOn availability groups
5
9.1
Create distributed availability groups
9.2
Manage failover
9.3
Configure read-only routing
9.4
Create an availability group
9.5
Configure Windows clustering
10. Implement failover cluster instances
2
10.1
Configure cluster shared volumes (CSV)
10.2
Manage shared disks
11. Monitoring database activity
7
11.1
Typical transactional replication use case
11.2
Replication definitions
11.3
Replication use cases
11.4
SQL edition capability map
11.5
How replication works
11.6
What can be replicated?
11.7
Publishing industry metaphor concepts
12. Replication setup walkthrough
0
13. Monitoring replication
0
14. Performance tuning
0
This content is protected, please
login
and
enroll
in the course to view this content!
