Menu
Microsoft 70-764 : Administering a SQL Database Infrastructure 2016
$99.00
- 1-855-488-5327
- customerservice@ituonline.com
- Login To My Training
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.
Course Lesson Preview Video
Take this opportunity to view a lesson included in this course.
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.
Looking for Microsoft MCSA SQL Server 2016 Database Administration certification? Check out our Certification Path Bundle for this training.
To see more Microsoft related training, click here.
Additional information
21 Hours 13 Minutes |
|
106 Course Videos |
|
250 Test Questions |
Course Videos
This course contains the following modules and videos. Click the down arror to view video details.
SQL Server 2016 - Module 1: Configure Encryption
- 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
SQL Server 2016 - Module 2: Configure Data Access and Permissions
- 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
SQL Server 2016 - Module 3: Configure Auditing
- Manage a SQL Server Audit
- Manage a SQL Server Audit Lab
- Query the SQL Server Audit Log
- Manage an Azure SQL Server Audit
SQL Server 2016 - Module 4: Develop a Backup Strategy
- 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
SQL Server 2016 - Module 5: Restore Databases
- 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
SQL Server 2016 - Module 6: Manage Database Integrity
- Implement Database Consistency Checks
- Implement Database Consistency Checks Lab
- Identify Database Corruption
- Recover From Database Corruption
SQL Server 2016 - Module 7: Monitor Database Activity
- Monitor Current Sessions
- Monitor Current Sessions Lab
- Identify Sessions that Cause Blocking Activity
- Identify Sessions that Consume tempdb Resources
- Configure the Data Collector
SQL Server 2016 - Module 8: Monitor Queries
- Manage the Query Store
- Manage the Query Store Lab
- Configure Extended Events and Trace Events
- Identify Problematic Execution Plans
SQL Server - Module 9: Manage Indexes
- 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
SQL Server 2016 - Module 10: Monitor SQL Server Instances
- 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
SQL Server 2016 - Module 11: Implement Log Shipping
- Configure and Monitor Log Shipping
- Configure and Monitor Log Shipping Lab Part 1
- Configure and Monitor Log Shipping Lab Part 2
SQL Server 2016 - Module 12: Implement Failover Cluster Instances
- Windows Server Failover Cluster
- Manage Shared Disks
- Configure Cluster Shared Volumes
- Configuring WSFC Lab
SQL Server 2016 - Module 13: Implement Always On Availability Groups
- 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
Microsoft 70-764 : Administering a SQL Database Infrastructure 2016
$99.00
Other Popular Courses
-
All Access IT Training Library (12 Month Access)
Lowest price guaranteed for unlimited IT training courses for 1 full year. No one has a lower price!
$199.00$99.001 Year of Unlimited Online Access to ITU Online Training Videos & IT Certification Training!... (View Details)Add to cart -
MCSA SQL 2016 Database Administration
This Certification Path includes 2 courses and is the path to SQL 2016 Database Administration.
$129.00Looking to get a MCSA designation for Microsoft SQL 2016 The Microsoft Certified Solutions... (View Details)Add to cart -
SQL Server 2016 (70-765): Provisioning SQL Databases
22 Hours 19 Minutes
102 Course Videos
247 Test Questions
$99.00The Microsoft SQL Server 2016: Provisioning SQL Databases course prepares you for the Certification... (View Details)Add to cart
Instructor Led Courses
All ITU 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
ITU 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 deliver 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
ITU 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
ITU 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.
Need help? Call our support team at (855) 488-5327
Shop Courses
Menu
ALL ACCESS OPTIONS
Contact
Phone Number
347-650-2528
855-488-5327
Email
customerservice@ituonline.com
Address
2430 Estancia Blvd, Suite 201 & 202
Clearwater, FL 33761
