Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

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

EDUTAINMENT COURSE E-Learning

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

Interactive and entertaining talk-show style format presented by industry leading experts.
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

EDUTAINMENT COURSE E-Learning
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59
  • 30:50:00
    Hours of learning
  • 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