Microsoft 70-764 : Administering a SQL Database Infrastructure 2016

$199.00

Course Description

The Microsoft 70-764 SQL Server 2016 Administration course prepares student for the Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server.

This Microsoft 70-764 SQL Server 2016 Administration course is for students intended for IT professionals responsible for installing, configuring and maintaining a Microsoft SQL Server environment. Students preparing for the 70-764 exam will typically will have at least 2 years of experience working with SQL Server.

Microsoft recommends having experience setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. You will be able to engage these topics on multiple platforms, including SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases. Students studying for the Microsoft Administering a SQL Database Infrastructure exam are database professionals who perform installation, maintenance, and configuration tasks.

In this Microsoft 70-764 SQL Server course, you will learn are how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting and ending with creating an Availability Group, manage failover, configure read-only routing and create distributed availability groups. Examining topics through the lenses of various platforms, comparing what they look like in SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases.

Students taking this course do so to sit for Exam 70-764 and want to become proficient about using Microsoft SQL server.

About The Administering a SQL Server Database Infrastructure 2016 (70-764) Exam

During this exam, you should be knowledgeable in the following areas:

  • Configure data access and auditing (20–25%)
  • Manage backup and restore of databases (20–25%)
  • Manage and monitor SQL Server instances (35–40%)
  • Manage high availability and disaster recovery (20–25%)

Microsoft currently charges $165 for this exam. Check the Microsoft site for confirmation and if any, updated information.

Course Videos

This course contains the following modules and videos. Click the down arror to view video details.

  • Introduction
  • Exam Objectives and Lab Setup
  • Restoring AdventureWorks 2016 Database Lab Part 1
  • Restoring AdventureWorks 2016 Database Lab Part 2
  • Restoring AdventureWorks 2016 Database Lab Part 3
  • Configure Encryption
  • Cell-Level Encryption Part 1
  • Cell-Level Encryption Part 2
  • Cell-Level Encryption Lab Part 1
  • Cell-Level Encryption Lab Part 2
  • Transparent Data Encryption
  • Transparent Data Encryption Lab
  • Always Encrypted
  • Always Encrypted Lab
  • Backup Encryption
  • Backup Encryption Lab
  • Connection Encryption
  • Encryption Troubleshooting
  • Create and Maintain Users
  • Create and Maintain Users Lab Part 1
  • Create and Maintain Users Lab Part 2
  • Configure and Maintain Custom Roles
  • Configure and Maintain Custom Roles Lab
  • Manage Database Object Permissions Part 1
  • Manage Database Object Permissions Part 2
  • Manage Database Object Permissions Lab Part 1
  • Manage Database Object Permissions Lab Part 2
  • Configure User Options for Azure SQL Database
  • Configure Row-Level Security
  • Configure Dynamic Data Masking
  • Configure Dynamic Data Masking Lab
  • Manage a SQL Server Audit
  • Manage a SQL Server Audit Lab
  • Query the SQL Server Audit Log
  • Manage an Azure SQL Server Audit
  • Backup Types Part 1
  • Backup Types Part 2
  • Manage, Backup, and Restore Databases Lab Part 1
  • Manage, Backup, and Restore Databases Lab Part 2
  • Backup Very Large Databases Part 1
  • Backup Very Large Databases Part 2
  • Backup Very Large Databases Part 3
  • Backup Very Large Databases Part 4
  • 4.9 Managing Very Large Databases Lab Part 1
  • 4.10 Managing Very Large Databases Lab Part 2
  • 4.11 Managing Very Large Databases Lab Part 3
  • Configure Alerting for Failed Backups
  • Configure Alerting for Failed Backups Lab Part 1
  • Configure Alerting for Failed Backups Lab Part 2
  • Back up Databases to Azure
  • Manage Transaction Log Backups
  • Configure Database Recovery Models
  • Set Database Recovery Model Lab
  • Configure Backup Automation
  • Configure Backup Automation Lab
  • Perform Piecemeal Restores
  • Restore Databases Lab Part 1
  • Restore Databases Lab Part 2
  • Restore Databases Lab Part 3
  • Perform Page Recovery
  • Perform Point-in-Time Recovery
  • Perform Point-in-Time Recovery Lab
  • Restore File Groups
  • Develop a Plan to Automate and Test Restores
  • Implement Database Consistency Checks
  • Implement Database Consistency Checks Lab
  • Identify Database Corruption
  • Recover From Database Corruption
  • Monitor Current Sessions
  • Monitor Current Sessions Lab
  • Identify Sessions that Cause Blocking Activity
  • Identify Sessions that Consume tempdb Resources
  • Configure the Data Collector
  • Manage the Query Store
  • Manage the Query Store Lab
  • Configure Extended Events and Trace Events
  • Identify Problematic Execution Plans
  • Identify and Repair Index Fragmentation
  • Identify and Create Missing Indexes
  • Identify and Drop Underutilized Indexes
  • Manage Existing Columnstore Indexes Part 1
  • Manage Existing Columnstore Indexes Part 2
  • Partitioned Tables
  • Create and Manage Operators
  • Create and Manage SQL Agent Alerts
  • Configure Policy-Based Management
  • Configure Policy-Based Management Lab
  • Identify Available Space on Data Volumes
  • Identify the Cause of- Manage Performance Degradation
  • Identify the Cause of- Manage Performance Degradation Lab Part 1
  • Identify the Cause of- Manage Performance Degradation Lab Part 2
  • Configure and Monitor Log Shipping
  • Configure and Monitor Log Shipping Lab Part 1
  • Configure and Monitor Log Shipping Lab Part 2
  • Windows Server Failover Cluster
  • Manage Shared Disks
  • Configure Cluster Shared Volumes
  • Configuring WSFC Lab
  • Database Mirroring
  • Create an Availability Group
  • Manage Failover
  • Configure Read-Only Routing
  • Create Distributed Availability Groups
  • Configuring Always On Availability Group Lab Part 1
  • Configuring Always On Availability Group Lab Part 2
  • Conclusion

Instructor led lectures

All IT Nuggets Courses replicate a live class experience with an instructor on screen delivering the course’s theories and concepts.

These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast forwarded.

Visual Demonstrations, Educational Games & Flashcards

IT Nuggets recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we delivery our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimization & Progress Tracking

Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.

Practice Quizzes and Exams

IT Nuggets Online’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.

World Class Learning Management System

IT Nuggets provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.