Administering a SQL Database Infrastructure - Exam 70-764 Certification Training

Video description

Administering a SQL Database Infrastructure - Exam 70-764 Certification Training

Video description

Microsoft's SQL Server platform is one of the top three relational database products in the world's enterprise marketplace, which means that those with SQL Server skills are in high demand everywhere. This course is designed for those who want to become a SQL Server administrator.

The course prepares you to take Microsoft exam 70-764, the first of two tests you must pass in order to earn the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration certification. Passing the 70-764 exam indicates to the world that you have what it takes to administer the SQL database infrastructure.

Learn about the topics that will be covered on Microsoft exam 70-764
Get closer to earning the MCSA SQL 2016 Database Administration certification
Understand the structure and implementation of SQL Server security
Discover how encryption is utilized and implemented in SQL Server 2016
Learn how to manage indexes on the SQL Server platform
See how data backups and restorations happen on the SQL Server 2016 platform
Survey the tools used to monitor and tune SQL Server performance

Mark Long is a long term contributor to O'Reilly Media having authored more than a dozen book and video titles including CompTIA Security+ SY0-401 (2014 Objectives), Windows Presentation Foundation Basics, Learning Windows PowerShell, and Securing Windows Networks. Mark holds many certifications including Microsoft's MCSE, MCDBA, and MCT; and as the head of his own consulting company, he solves IT issues for numerous Fortune 500 companies.

Publisher resources

Download Example Code

Introduction

Welcome To The Course 00:02:54

About The Author 00:03:43

Course Overview 00:07:04

Microsoft’s SQL Server 00:08:09

SQL Server 2016 Certifications 00:07:52

Examples And Code 00:03:18

SQL Server Basics

SQL Server Platform Acronyms 00:07:18

SQL Server Editions 00:06:14

Understanding Databases 00:08:16

Database Structures 00:08:20

Transact-SQL 00:05:36

Getting And Installing SQL Server 2016

Getting SQL Server 2016 00:08:13

Installing SQL Server 2016 00:10:23

Installing SQL Server Management Studio 00:04:46

Attaching The Sample Database 00:07:32

Verifying The Installation 00:05:06

SQL Server Security

SQL Server Security Overview 00:07:27

Server Level Security 00:08:48

Restarting SQL Server 00:05:13

Creating Logins 00:07:52

Database Level Security 00:06:47

Database User Account Types 00:08:25

Cross Server Authorization 00:07:49

Partially Contained Databases 00:06:23

Dynamic Data Masking 00:06:45

DDM Example Part - 1 00:05:42

DDM Example Part - 2 00:08:01

SQL Server Roles

Understanding Roles 00:07:31

Fixed Server Roles 00:06:24

Fixed Database Roles 00:05:30

User-Defined Roles 00:06:03

Grant, Revoke, And Deny 00:04:37

Schema Level Permissions 00:05:51

Encryption

SQL Server Encryption Basics Part - 1 00:09:57

SQL Server Encryption Basics Part - 2 00:08:23

Dark Side Of Encryption 00:06:58

Asymmetric Vs. Symmetric 00:06:24

Encryption Options 00:06:13

Encrypting Backups Part - 1 00:07:11

Encrypting Backups Part - 2 00:06:17

Transparent Data Encryption 00:07:29

Implementing TDE 00:08:25

Always Encrypted 00:09:44

Implementing Always Encrypted 00:05:47

Index Management

Index Management Basics Part - 1 00:10:14

Index Management Basics Part - 2 00:04:15

Identifying Fragmentation 00:06:43

Repairing Fragmentation 00:06:18

Database Engine Tuning Advisor - Part 1 00:10:40

Database Engine Tuning Advisor - Part 2 00:05:13

Backup And Restore

Backup Plan 00:09:47

Backup Types 00:07:38

Understanding Recovery Models 00:09:46

Copy-Only Backups 00:10:09

Backup Terminology 00:05:41

System Database Backups 00:06:46

Transaction Log Basics 00:09:19

Transaction Log Backups 00:08:55

Tail-Log Backups 00:04:37

Restoring Databases 00:10:49

Restoring With SSMS 00:04:58

Recovering The Master DB 00:07:37

Point In Time Recovery 00:06:23

Understanding Log Shipping 00:05:35

Monitoring SQL Server

Performance And Monitoring Part - 1 00:10:07

Performance And Monitoring Part - 2 00:05:47

Session Identification Overview 00:07:36

Identifying Blocking Sessions Part - 1 00:09:31

Identifying Blocking Sessions Part - 2 00:05:49

Understanding UCPs 00:07:46

Data Collector Basics 00:05:25

Data Collector Configuration 00:07:38

Query Store Basics 00:08:23

Understanding Extended Events 00:06:44

Creating An Extended Event Part - 1 00:08:49

Creating An Extended Event Part - 2 00:02:42

Editing An Extended Event 00:07:09

Conclusion

Wrap Up 00:06:01

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.