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

Table of contents

  1. Introduction
    1. Welcome To The Course
    2. About The Author
    3. Course Overview
    4. Microsoft's SQL Server
    5. SQL Server 2016 Certifications
    6. Examples And Code
  2. SQL Server Basics
    1. SQL Server Platform Acronyms
    2. SQL Server Editions
    3. Understanding Databases
    4. Database Structures
    5. Transact-SQL
  3. Getting And Installing SQL Server 2016
    1. Getting SQL Server 2016
    2. Installing SQL Server 2016
    3. Installing SQL Server Management Studio
    4. Attaching The Sample Database
    5. Verifying The Installation
  4. SQL Server Security
    1. SQL Server Security Overview
    2. Server Level Security
    3. Restarting SQL Server
    4. Creating Logins
    5. Database Level Security
    6. Database User Account Types
    7. Cross Server Authorization
    8. Partially Contained Databases
    9. Dynamic Data Masking
    10. DDM Example Part - 1
    11. DDM Example Part - 2
  5. SQL Server Roles
    1. Understanding Roles
    2. Fixed Server Roles
    3. Fixed Database Roles
    4. User-Defined Roles
    5. Grant, Revoke, And Deny
    6. Schema Level Permissions
  6. Encryption
    1. SQL Server Encryption Basics Part - 1
    2. SQL Server Encryption Basics Part - 2
    3. Dark Side Of Encryption
    4. Asymmetric Vs. Symmetric
    5. Encryption Options
    6. Encrypting Backups Part - 1
    7. Encrypting Backups Part - 2
    8. Transparent Data Encryption
    9. Implementing TDE
    10. Always Encrypted
    11. Implementing Always Encrypted
  7. Index Management
    1. Index Management Basics Part - 1
    2. Index Management Basics Part - 2
    3. Identifying Fragmentation
    4. Repairing Fragmentation
    5. Database Engine Tuning Advisor - Part 1
    6. Database Engine Tuning Advisor - Part 2
  8. Backup And Restore
    1. Backup Plan
    2. Backup Types
    3. Understanding Recovery Models
    4. Copy-Only Backups
    5. Backup Terminology
    6. System Database Backups
    7. Transaction Log Basics
    8. Transaction Log Backups
    9. Tail-Log Backups
    10. Restoring Databases
    11. Restoring With SSMS
    12. Recovering The Master DB
    13. Point In Time Recovery
    14. Understanding Log Shipping
  9. Monitoring SQL Server
    1. Performance And Monitoring Part - 1
    2. Performance And Monitoring Part - 2
    3. Session Identification Overview
    4. Identifying Blocking Sessions Part - 1
    5. Identifying Blocking Sessions Part - 2
    6. Understanding UCPs
    7. Data Collector Basics
    8. Data Collector Configuration
    9. Query Store Basics
    10. Understanding Extended Events
    11. Creating An Extended Event Part - 1
    12. Creating An Extended Event Part - 2
    13. Editing An Extended Event
  10. Conclusion
    1. Wrap Up

Product information

  • Title: Administering a SQL Database Infrastructure - Exam 70-764 Certification Training
  • Author(s): Mark Long
  • Release date: June 2017
  • Publisher(s): Infinite Skills
  • ISBN: 9781491989166