Microsoft SQL Server 2016 Certification (70-764)
4.3 (1,126 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,370 students enrolled

Microsoft SQL Server 2016 Certification (70-764)

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-764) exam.
Bestseller
4.3 (1,126 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,370 students enrolled
Last updated 2/2020
English
English [Auto], Portuguese [Auto]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Configure data access and auditing
  • Manage backup and restore of databases
  • Manage and monitor SQL Server instances
  • Manage high availability and disaster recovery
Requirements
  • A PC
  • Internet Access
Description

Welcome to this course: Microsoft SQL Server 2016 Certification (70-764) - Administering a SQL Database Infrastructure. This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

In this course, you'll learn:
  • Configure data access and auditing 
  • Manage backup and restore of databases 
  • Manage and monitor SQL Server instances 
  • Manage high availability and disaster recovery 

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.

Who this course is for:
  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-764
Course content
Expand all 79 lectures 09:11:46
+ Getting Started With This Course
4 lectures 26:27
Introduction
07:05
Getting Started - Overview: MS SQL Server
08:11
Getting Started - The Certifications
07:54
Getting Started - Microsoft SQL Server Examples
03:17
+ Learn About SQL Server
5 lectures 35:51
Introduction
07:20
Learn About SQL Server - Learn About Editions
06:15
Learn About SQL Server - SQL Server Databases
08:18
Learn About SQL Server - Learn and Understand Database Structures
08:21
Learn About SQL Server - SQL Server: Transact-SQL
05:37
+ Learn About MS SQL Server 2016
5 lectures 36:10
MS SQL Server 2016: Learn How To Install SQL Server 2016
10:26
MS SQL Server 2016: Learn How To Install SQL Server Management Studio
04:47
MS SQL Server 2016: Attaching The Sample Database
07:35
MS SQL Server 2016: Verifying The Installation
05:07
+ Microsoft SQL Server Security
11 lectures 01:19:33
Introduction
07:29
Learning Microsoft SQL Server Level Security
08:50
SQL Server Security: Restarting SQL Server
05:14
SQL Server Security: Creating Logins
07:55
SQL Server Security: Database Level Security
06:49
SQL Server Security: Database User Account Types
08:27
SQL Server Security: Cross Server Authorization
07:51
SQL Server Security: Partially Contained Databases
06:25
SQL Server Security: Dynamic Data Masking
06:46
SQL Server Security: DDM Example - 1
05:43
SQL Server Security: DDM Example - 2
08:04
+ Microsoft SQL Server Roles
6 lectures 36:01
Introduction
07:33
SQL Server Roles: Fixed Server Roles
06:25
SQL Server Roles: Fixed Database Roles
05:30
SQL Server Roles: User-Defined Roles
06:04
SQL Server Roles: Grant, Revoke, And Deny
04:37
SQL Server Roles: Schema Level Permissions
05:52
+ SQL Server - Encryption
11 lectures 01:23:07
Introduction
10:00
Learn and Understand SQL Server Encryption
08:25
SQL Server Encryption: Dark Side Of Encryption
07:00
SQL Server Encryption: Asymmetric Vs. Symmetric
06:25
SQL Server Encryption: Encryption Options
06:14
SQL Server Encryption: Encrypting Backups - 1
07:12
SQL Server Encryption: Encrypting Backups - 2
06:18
SQL Server Encryption: Transparent Data Encryption
07:31
SQL Server Encryption: Implementing TDE
08:26
SQL Server Encryption: Always Encrypted
09:47
SQL Server Encryption: Implementing Always Encrypted
05:49
+ SQL Server - Index Management
6 lectures 43:37
Introduction
10:17
SQL Server - Learn and Understand Index Management
04:16
Index Management - Identifying Fragmentation
06:45
Index Management - Repairing Fragmentation
06:20
Index Management - Database Engine Tuning Advisor - 1
10:44
Index Management - Database Engine Tuning Advisor - 2
05:15
+ MS SQL Server - Backup & Restore
14 lectures 01:48:29
Introduction
09:50
MS SQL Server - Backup: Backup Types
07:40
MS SQL Server - Backup: Understanding Recovery Models
09:49
MS SQL Server - Backup: Copy-Only Backups
10:12
MS SQL Server - Backup: Backup Terminology
05:42
MS SQL Server - Backup: System Database Backups
06:46
MS SQL Server - Backup: Transaction Log Basics
09:22
MS SQL Server - Backup: Transaction Log Backups
08:58
MS SQL Server - Backup: Tail-Log Backups
04:38
MS SQL Server - Restore: Restoring Databases
10:52
MS SQL Server - Restore: Restoring With SSMS
05:00
MS SQL Server - Restore: Recovering The Master DB
07:39
MS SQL Server - Restore: Point In Time Recovery
06:25
MS SQL Server - Restore: Understanding Log Shipping
05:36
+ Monitoring Microsoft SQL Server
13 lectures 01:33:52
Introduction
10:10
Monitoring Microsoft SQL Server: Performance & Monitoring
05:48
Monitoring Microsoft SQL Server: Session Identification
07:38
Monitoring Microsoft SQL Server: Identifying Blocking Sessions - 1
09:34
Monitoring Microsoft SQL Server: Identifying Blocking Sessions - 2
05:51
Monitoring Microsoft SQL Server: Understanding UCPs
07:49
Monitoring Microsoft SQL Server: Data Collector
05:26
Monitoring Microsoft SQL Server: Data Collector Configuration
07:40
Monitoring Microsoft SQL Server: Query Store
08:25
Monitoring Microsoft SQL Server: Understanding Extended Events
06:46
Monitoring Microsoft SQL Server: Creating An Extended Event - 1
08:52
Monitoring Microsoft SQL Server: Creating An Extended Event - 2
02:43
Monitoring Microsoft SQL Server: Editing An Extended Event
07:10