Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

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

E-COURSE:

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

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-764) exam. In this course, you will learn how to administer a SQL Server 2016 Database. Prepare for Microsoft's 70-764 certification exam as you learn to configure data access and auditing, manage database backup and restore, manage high availability and disaster recovery, and manage and monitor SQL server instances. At the end of this course, you will have developed the knowledge and skills necessary to pass the Administering a SQL Database Infrastructure Exam. So let's get started.

Target Audience
  • Database developers
  • Software Developers
  • Programmers
  • Database analysts
  • Anyone who wants to pass Exam 70-764

Module 1: Encryption

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

Module 2: Configure Data Access and Permissions

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

Module 3. Configure Auditing

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

Module 4: Develop a Backup Strategy

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

Module 5: Restore Databases

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

Module 6: Manage Database Integrity

6.1 Implement Database Consistency Checks

6.2 Implement Database Consistency Checks Lab

6.3 Identify Database Corruption

6.4 Recover From Database Corruption

E-COURSE E-Learning Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
  • 30:50:00
    + Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top