O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table of Contents

  1. Introduction
    1. Welcome To The Course 00:02:54
    2. About The Author 00:03:43
    3. Course Overview 00:07:04
    4. Microsoft's SQL Server 00:08:09
    5. SQL Server 2016 Certifications 00:07:52
    6. Examples And Code 00:03:18
  2. SQL Server Basics
    1. SQL Server Platform Acronyms 00:07:18
    2. SQL Server Editions 00:06:14
    3. Understanding Databases 00:08:16
    4. Database Structures 00:08:20
    5. Transact-SQL 00:05:36
  3. Getting And Installing SQL Server 2016
    1. Getting SQL Server 2016 00:08:13
    2. Installing SQL Server 2016 00:10:23
    3. Installing SQL Server Management Studio 00:04:46
    4. Attaching The Sample Database 00:07:32
    5. Verifying The Installation 00:05:06
  4. SQL Server Security
    1. SQL Server Security Overview 00:07:27
    2. Server Level Security 00:08:48
    3. Restarting SQL Server 00:05:13
    4. Creating Logins 00:07:52
    5. Database Level Security 00:06:47
    6. Database User Account Types 00:08:25
    7. Cross Server Authorization 00:07:49
    8. Partially Contained Databases 00:06:23
    9. Dynamic Data Masking 00:06:45
    10. DDM Example Part - 1 00:05:42
    11. DDM Example Part - 2 00:08:01
  5. SQL Server Roles
    1. Understanding Roles 00:07:31
    2. Fixed Server Roles 00:06:24
    3. Fixed Database Roles 00:05:30
    4. User-Defined Roles 00:06:03
    5. Grant, Revoke, And Deny 00:04:37
    6. Schema Level Permissions 00:05:51
  6. Encryption
    1. SQL Server Encryption Basics Part - 1 00:09:57
    2. SQL Server Encryption Basics Part - 2 00:08:23
    3. Dark Side Of Encryption 00:06:58
    4. Asymmetric Vs. Symmetric 00:06:24
    5. Encryption Options 00:06:13
    6. Encrypting Backups Part - 1 00:07:11
    7. Encrypting Backups Part - 2 00:06:17
    8. Transparent Data Encryption 00:07:29
    9. Implementing TDE 00:08:25
    10. Always Encrypted 00:09:44
    11. Implementing Always Encrypted 00:05:47
  7. Index Management
    1. Index Management Basics Part - 1 00:10:14
    2. Index Management Basics Part - 2 00:04:15
    3. Identifying Fragmentation 00:06:43
    4. Repairing Fragmentation 00:06:18
    5. Database Engine Tuning Advisor - Part 1 00:10:40
    6. Database Engine Tuning Advisor - Part 2 00:05:13
  8. Backup And Restore
    1. Backup Plan 00:09:47
    2. Backup Types 00:07:38
    3. Understanding Recovery Models 00:09:46
    4. Copy-Only Backups 00:10:09
    5. Backup Terminology 00:05:41
    6. System Database Backups 00:06:46
    7. Transaction Log Basics 00:09:19
    8. Transaction Log Backups 00:08:55
    9. Tail-Log Backups 00:04:37
    10. Restoring Databases 00:10:49
    11. Restoring With SSMS 00:04:58
    12. Recovering The Master DB 00:07:37
    13. Point In Time Recovery 00:06:23
    14. Understanding Log Shipping 00:05:35
  9. Monitoring SQL Server
    1. Performance And Monitoring Part - 1 00:10:07
    2. Performance And Monitoring Part - 2 00:05:47
    3. Session Identification Overview 00:07:36
    4. Identifying Blocking Sessions Part - 1 00:09:31
    5. Identifying Blocking Sessions Part - 2 00:05:49
    6. Understanding UCPs 00:07:46
    7. Data Collector Basics 00:05:25
    8. Data Collector Configuration 00:07:38
    9. Query Store Basics 00:08:23
    10. Understanding Extended Events 00:06:44
    11. Creating An Extended Event Part - 1 00:08:49
    12. Creating An Extended Event Part - 2 00:02:42
    13. Editing An Extended Event 00:07:09
  10. Conclusion
    1. Wrap Up 00:06:01