Microsoft 70-764 SQL 2016 - Administering a SQL Database Infrastructure

Course Title: Microsoft 70-764 – SQL Server 2016 Administration
Total Video Hours: 21 Hrs 13 Min
Total Videos: 106 On-demand Videos
Instructor: Chrys Thorsen
Training Level: Intermediate to Advanced
Objective: Prepare learners to administer Microsoft SQL Server 2016 and understand the core knowledge areas for Microsoft Exam 70-764
Ideal For: IT professionals, SQL Server administrators, database managers, DB developers, systems engineers, IT students, and database infrastructure professionals
Format: Self-paced online training
Closed Captions: Included
Course Topics: 13 Structured Topics
Prep Questions: 250 Practice Questions
Certificate of Completion: Included

This training remains valuable for anyone working within SQL Server environments, even though the certification exam is no longer available. The skills taught apply directly to real-world SQL Server administration.

Included in This Course

21 Hrs 14 Min of detailed SQL Server 2016 training
106 On-demand, self-paced training videos
Closed Captions for all lessons
13 Comprehensive course topics
250 Prep questions for practice
Certificate of Completion
Up-to-date demonstrations on SQL Server administration
Practical insights into database security, backup, restore, and monitoring

Full Course Outline

1. Configure Encryption

• Implement Cell-level Encryption

• Configure Transparent Data Encryption (TDE)

• Implement Always Encrypted

• Configure Backup Encryption

• Secure Connection Encryption

• Troubleshoot Encryption Failures

2. Configure Data Access and Permissions

• Create and Maintain SQL Server Users

• Implement and Manage Custom Roles

• Manage Database Object Permissions

• Configure User Options for Azure SQL Database

• Implement Row-Level Security

• Configure Dynamic Data Masking

3. Configure Auditing

• Manage SQL Server Audits

• Query SQL Server Audit Logs

• Manage Azure SQL Database Audits

4. Develop a Backup Strategy

• Back Up Very Large Databases

• Configure Alerts for Failed Backups

• Backup Databases to Azure

• Manage Transaction Log Backups

• Configure Database Recovery Models

• Implement Backup Automation

5. Restore Databases

• Perform Piecemeal Restores

• Perform Page Recovery

• Execute Point-in-Time Recovery

• Restore File Groups

• Automate and Test Restore Plans

6. Manage Database Integrity

• Implement Database Consistency Checks

• Identify Database Corruption

• Recover from Database Corruption

7. Monitor Database Activity

• Monitor Current Sessions

• Identify Sessions Causing Blocking

• Manage High TempDB Resource Use

• Configure the SQL Data Collector

8. Monitor Queries

• Manage the Query Store

• Configure Extended Events and Trace Events

• Identify Problematic Execution Plans

9. Manage Indexes

• Identify and Repair Index Fragmentation

• Create Missing Indexes

• Drop Underutilized Indexes

• Manage Columnstore Indexes

• Manage Statistics

10. Monitor SQL Server Instances

• Create and Manage Operators

• Configure SQL Agent Alerts

• Define Custom Alert Actions

• Configure Failure Actions

• Configure Database Mail

• Configure Policy-Based Management

• Identify Free Volume Space

• Manage and Investigate Performance Degradation

11. Implement Log Shipping

• Configure Log Shipping

• Manage Failover Cluster Instances

• Configure Always On Availability Groups

12. Implement Failover Cluster Instances

• Manage Shared Disks

• Configure Cluster Shared Volumes

13. Implement Always On Availability Groups

• Create Availability Groups

• Manage Failover Operations

• Configure Read-only Routing

• Create Distributed Availability Groups

The Microsoft 70-764 – SQL Server 2016 Administration course is designed for IT professionals who want to master the essential skills required to administer SQL Server environments in today’s enterprise data centers. SQL Server remains one of the most widely implemented relational database platforms, powering business applications, enterprise reporting, financial analytics, and mission-critical workloads across industries. This course provides a deep, structured pathway toward understanding SQL Server 2016 architecture, security, performance monitoring, disaster recovery, and administrative best practices.

Although Microsoft’s legacy certification exam 70-764 has been retired, the knowledge components taught in this program remain integral for professionals managing SQL Server infrastructures. For organizations still operating SQL Server 2016 or upgrading from prior versions, the skills delivered in this course are directly applicable to real-world database administration scenarios.

This training program is built around Microsoft’s original exam objectives, making it a comprehensive learning path for individuals pursuing roles in database administration, enterprise system management, and cloud-integrated data solutions. The course uses a hands-on, practical style that mirrors the real tasks administrators face every day—from configuring encryption to implementing Always On Availability Groups.

Why This SQL Server 2016 Administration Course Matters

As organizations rely more heavily on data, the need for skilled SQL Server administrators continues to grow. The Microsoft 70-764 course offers a complete learning framework for professionals who require deep technical knowledge related to database integrity, backup and recovery, encryption, access control, monitoring, and high availability.

SQL Server 2016 introduced powerful capabilities such as Always Encrypted, improved diagnostics, and enhanced performance features that still form the backbone of many enterprise systems today. Even organizations upgrading to newer versions benefit from professionals who understand foundational administration principles and SQL Server’s core architecture.

This course provides these essential competencies through a professionally structured, step-by-step curriculum.

Key Skills Covered in the Microsoft 70-764 Course

1. Configuration of Encryption and Data Security

2. Data Access and Permission Management

3. SQL Server Auditing

4. Backup and Recovery Strategies

5. Database Integrity and Corruption Recovery

6. Performance Monitoring and Optimization

7. High Availability and Disaster Recovery (HADR)

Each module contributes to a full, practical understanding of SQL Server administration, making this course an excellent preparation tool for real-world operational roles.

Who Should Take This SQL Server 2016 Administration Course?

This training is structured for professionals who work with SQL Server databases, including:

• SQL Server Database Administrators

• IT Infrastructure Specialists

• Systems Engineers

• Database Developers

• Cloud and Hybrid Data Professionals

• Data Analysts transitioning into database administration.

Career Opportunities After Completing the Microsoft 70-764 Training

Professionals can pursue roles such as:

• SQL Server Database Administrator

• Database Infrastructure Engineer

• Systems Engineer

• Database Developer

• Business Data Analyst

• IT Consultant

Industry Salary Expectations

SQL Server administrative professionals typically earn:

• SQL Server DBA: $80,000 – $120,000

• Database Manager: $90,000 – $130,000

• Database Developer: $75,000 – $110,000

• Data Analyst: $70,000 – $100,000

• IT Consultant: $85,000 – $140,000

Why Choose This Microsoft SQL Server Online Course?

With 21+ hours of instruction, 106 videos, practice questions, and real-world demonstrations, learners gain a practical, job-ready foundation. SQL Server 2016 remains widely used, making these administration skills essential for performance, security, and reliability.

Start Your SQL Server 2016 Administration Training Today

This course equips you with the knowledge and confidence to manage SQL Server infrastructures effectively.

Frequently Asked Questions

1. What is the Microsoft 70-764 – SQL Server 2016 Administration course about?
This course teaches SQL Server 2016 administration, covering encryption, data access, backup strategies, auditing, performance monitoring, and HADR.

2. Is the Microsoft 70-764 exam still available?
No, it is retired, but the skills remain relevant.

3. Do I need prior database experience?
Basic SQL or IT knowledge helps, but it is not required.

4. What job roles can I pursue?
Roles include SQL Server DBA, Database Developer, Systems Engineer, and IT Consultant.

5. Does this course include hands-on exercises?
Yes, the course includes practical demonstrations.

6. Is SQL Server 2016 still relevant?
Yes. Many organizations still run SQL Server 2016.

7. Will I receive a certificate?
Yes. A Certificate of Completion is provided.