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

Learn to administer a SQL Server 2016 database

  • 12 months Unlimited Access
  • Visual Demonstrations
  • Multimedia Presentations
  • Social Learning & Networking
  • Certificate of Completion
  • Expert Instructor-led Training
  • Quizzes & Exam Simulators
  • Leads to a Recognised Qualification
Category:

What you'll learn

  • Learn to administer a SQL Server 2016 database
  • Prepare youself for exam 70-764
  • You will learn to administer a Microsoft SQL 2016 Server
  • Get the knowledge and skills required for SQL 2016 Server

Microsoft 70-764: SQL 2016 - Administering A SQL Database Infrastructure Modules

  • 1.1 Introduction
  • 1.2 Exam Objectives and Lab Setup
  • 1.3 Restoring AdventureWorks 2016 Database Lab Part 1
  • 1.4 Restoring AdventureWorks 2016 Database Lab Part 2
  • 1.5 Restoring AdventureWorks 2016 Database Lab Part 3
  • 1.6 Configure Encryption
  • 1.7 Cell-Level Encryption Part 1
  • 1.8 Cell-Level Encryption Part 2
  • 1.9 Cell-Level Encryption Lab Part 1
  • 1.10 Cell-Level Encryption Lab Part 2
  • 1.11 Transparent Data Encryption
  • 1.12 Transparent Data Encryption Lab
  • 1.13 Always Encrypted
  • 1.14 Always Encrypted Lab
  • 1.15 Backup Encryption
  • 1.16 Backup Encryption Lab
  • 1.17 Connection Encryption
  • 1.18 Encryption Troubleshooting
  • 2.1 Create and Maintain Users
  • 2.2 Create and Maintain Users Lab Part 1
  • 2.3 Create and Maintain Users Lab Part 2
  • 2.4 Configure and Maintain Custom Roles
  • 2.5 Configure and Maintain Custom Roles Lab
  • 2.6 Manage Database Object Permissions Part 1
  • 2.7 Manage Database Object Permissions Part 2
  • 2.8 Manage Database Object Permissions Lab Part 1
  • 2.9 Manage Database Object Permissions Lab Part 2
  • 2.10 Configure User Options for Azure SQL Database
  • 2.11 Configure Row-Level Security
  • 2.12 Configure Dynamic Data Masking
  • 2.13 Configure Dynamic Data Masking Lab
  • 3.1 Manage a SQL Server Audit
  • 3.2 Manage a SQL Server Audit Lab
  • 3.3 Query the SQL Server Audit Log
  • 3.4 Manage an Azure SQL Server Audit
  • 4.1 Backup Types Part 1
  • 4.2 Backup Types Part 2
  • 4.3 Manage, Backup, and Restore Databases Lab Part 1
  • 4.4 Manage, Backup, and Restore Databases Lab Part 2
  • 4.5 Backup Very Large Databases Part 1
  • 4.6 Backup Very Large Databases Part 2
  • 4.7 Backup Very Large Databases Part 3
  • 4.8 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
  • 4.12 Configure Alerting for Failed Backups
  • 4.13 Configure Alerting for Failed Backups Lab Part 1
  • 4.14 Configure Alerting for Failed Backups Lab Part 2
  • 4.15 Back up Databases to Azure
  • 4.16 Manage Transaction Log Backups
  • 4.17 Configure Database Recovery Models
  • 4.18 Set Database Recovery Model Lab
  • 4.19 Configure Backup Automation
  • 4.20 Configure Backup Automation Lab
  • 5.1 Perform Piecemeal Restores
  • 5.2 Restore Databases Lab Part 1
  • 5.3 Restore Databases Lab Part 2
  • 5.4 Restore Databases Lab Part 3
  • 5.5 Perform Page Recovery
  • 5.6 Perform Point-in-Time Recovery
  • 5.7 Perform Point-in-Time Recovery Lab
  • 5.8 Restore File Groups
  • 5.9 Develop a Plan to Automate and Test Restores
  • 6.1 Implement Database Consistency Checks
  • 6.2 Implement Database Consistency Checks Lab
  • 6.3 Identify Database Corruption
  • 6.4 Recover From Database Corruption

Description

Preparation for Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment.

Requirements

  • A Mac or PC required
  • Access to the internet
  • No previous experience required

Student also bought

This really depends on the individual course. But, in any case, you have 12 months access to any of our courses. The more time you put into your studies, the sooner you finish and with having 24/7 access, you might finish it faster than you expected in the beginning. However, we don’t push you to finish the course or take your exam before you are ready; that’s why you have 12 months membership for each course. We want to make sure that you are not put under pressure; after all, we understand that everyone has their own commitments and life doesn’t always go as planned so there might be a few obstacles that slow your studies.
If you’re not sure what course to choose you can contact our student support team (0121 389 0414); they know which courses are in demand and what courses are best for your chosen career. So, let us help you choose the best course for your chosen path.
There are no requirements for the level of education or knowledge. Each course has its own criteria. For some of the courses, you would have need to finish the foundation course first before going forward. For more information on these specifications please visit the overview of each course.
After you’ve signed up on any of our courses, our student support team will provide you with the login details and you are ready to go. Each of our courses comes with a welcome tutorial which helps you to understand how to navigate through the course. They are all very easy so you shouldn’t have any problems. But if you have any problems, please get in touch with our student support team.
By getting certified, you gain the necessary documents to prove that you have gained skills and knowledge in your area of study. This will open opportunities for new employment (if you are looking for a new career path) or give you the upper hand to get that promotion you have been chasing. Some employers need specific qualifications before the start of the employment for certain roles; being certified gives you the opportunity to enhance your CV and get the job you were dreaming of.
You will receive a confirmation email with your login details as soon as your payment has been successfully processed (usually within 3 days) and then you can start your course.
We suggest that you only take your exam when you get a score of 85% or above on the practice exams. Not just once but over and over again. If you keep doing the practice exams and get a high score, naturally you will be more confident for your official exam and the chances of you passing them will be much higher.
We have a student support team that their main responsibility is to make sure that your study journey is smooth and easy. If you encounter any problems, just call or email them and they will be happy to help you.

Be the first to add a review.

Enrolled: 32 students
Duration: 12 Months
Video: 21.13 hrs
Level: Intermediate

Enquiry Form

Complete the form below to receive more details about the course.

0121 389 0414

Please read our Privacy Policy for more information.

All our courses are geared towards the certification exams, and therefore are very robust in content as they go over each objective, with knowledge checks at the end.