TOIT Training

Facebook X-twitter Linkedin Instagram
Menu
SQL Server

70-764: Administering a SQL Server 2016 Database Infrastructure

ToIT ToIT
0 (0)
Duration

24h

Students

0

Level

Intermediate

Last Updated

November 14, 2024

70-764: Administering a SQL Server 2016 Database Infrastructure
  • Overview
  • Curriculum
  • Reviews

 

In this instructor-led, online training course, students will learn the knowledge and skills to administer a SQL server database infrastructure. Students will be taught how to authenticate and authorize users, protect data with encryption and auditing, backup and restore SQL Server, configure security for the SQL Server agent, and more.

  • 14 Sections
  • 49 Lessons
  • 0 Quizzes
  • 24h Duration
Expand All

Configuring auditing

5 Lessons 0 Quizzes
  • Configure an audit on SQL Server
  • Query the SQL Server audit log
  • Manage a SQL Server audit
  • Configure an Azure SQL database audit
  • Analyze audit logs and reports from Azure SQL database

Developing a backup strategy

6 Lessons 0 Quizzes
  • Configure database recovery models
  • Managing transaction log backups
  • Back up very large databases
  • Configure alerting for failed backups
  • Back up databases to Azure
  • Configure backup automation

Monitoring database activity

4 Lessons 0 Quizzes
  • Monitor current sessions
  • Identify sessions that cause blocking activity
  • Identify sessions that consume tempdb resources
  • Configure the data collector

Monitoring Queries

4 Lessons 0 Quizzes
  • Manage the Query Store
  • Configure extended events and trace events
  • Identify problematic execution plans
  • Troubleshoot server health using extended events

Managing indexes

4 Lessons 0 Quizzes
  • Identify and repair index fragmentation
  • Identify and create missing indexes
  • Identify and drop underutilized indexes
  • Manage existing columnstore indexes

 Managing statistics

3 Lessons 0 Quizzes
  • Identify and correct outdated statistics
  • Implement auto update statistics
  • Implement statistics for large tables

Monitoring queries

7 Lessons 0 Quizzes
  • Create and manage operators
  • Create and manage SQL Agent alerts
  • Define custom alert actions and failure actions
  • Configure database mail
  • Configure Policy-Based Management
  • Identify available space on data volumes
  • Identify the cause of performance degradation

Implement log shipping

2 Lessons 0 Quizzes
  • Configure log shipping
  • Monitor log shipping

Implement AlwaysOn availability groups

5 Lessons 0 Quizzes
  • Configure Windows clustering
  • Create an availability group
  • Configure read-only routing
  • Manage failover
  • Create distributed availability groups

Implement failover cluster instances

2 Lessons 0 Quizzes
  • Manage shared disks
  • Configure cluster shared volumes (CSV)

 Monitoring database activity

7 Lessons 0 Quizzes
  • SQL edition capability map
  • Replication definitions
  • Publishing industry metaphor concepts
  • What can be replicated?
  • How replication works
  • Replication use cases
  • Typical transactional replication use case

Replication setup walkthrough

0 Lessons 0 Quizzes

 Monitoring replication

0 Lessons 0 Quizzes

Performance tuning

0 Lessons 0 Quizzes

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • 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

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

70-764: Administering a SQL Server 2016 Database Infrastructure
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)
Choose Group(s)
Sync Group(s)
Create a new group Go to Checkout