Skip to main content
TOIT Training
(909) 252-7584
support@toittraining.com
Search
Search
Courses
Close Courses
Open Courses
IT Courses
AI
Aruba
Automation
AWS
Check Point
Cisco
Citrix
Comp Tia
Containerization
Cyber security
Linux
F5
Fortinet
Google
Isaca
Juniper
Project Management
Microsoft
ISC2
OpenStack
Palo Alto
Python
SonicWall
VMware
See All
User Courses
30 Minutes (MS Office)
Accounting
Business Skills
Communication Skills
Data Analysis
HIPPA
Meeting Managment
Microsoft Office 2016
Microsoft Office 2019
Microsoft Office 2021
Manager Training
Workplace Safety
Office 365
Google Workspace
End-User Training
Mini Courses
Sales and Marketing
See All
Developer Courses
.NET Courses
AI Coding Courses
Dart Courses
Databases Courses
Deno Courses
Development Principles Courses
DevOps
Firebase Courses
Golang Courses
Imba Courses
Interviewing Courses
Qwik Courses
React Courses
Javascript
MERN Courses
Netlify Courses
Next.Js Courses
Node.Js Courses
Nuxt.Js Courses
PHP Courses
Python Courses
Sapper Courses
Strapi Courses
TypeScript Courses
Ui UX Courses
Vue js Courses
See All
Plan and Pricing
About us
Features
Contact Sales
Roadmap
Log in
Home
Courses
IT 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!
