Administering a SQL Database Infrastructure (exam 70-764) 16:24 hours

Microsoft SQL Server 2016: Encryptio

Course: 1 Hour, 38 Minutes

• Course Introduction
• Encryption Features
• Transparent Data Encryption
• Using Transparent Data Encryption

Microsoft SQL Server 2016: Data Access and Permissions

Course: 2 Hours, 14 Minutes

• Course Introduction
• Database Users
• Creating a Database User with SSMS
• Creating a Database User with T-SQL
• Permissions
• User Access
• Granting Database Object Access
• Revoking Database Object Access

Microsoft SQL Server 2016: Auditing

Course: 2 Hours, 2 Minutes

• Course Introduction
• Auditing
• Auditing with Triggers
• Auditing with Temporal Tables Part
• Auditing with Temporal Tables Part

Microsoft SQL Server 2016: Backing Up Databases

Course: 1 Hour, 47 Minutes

• Course Introduction
• Database Backups
• Backup Strategies
• Backup Media
• Backup Retention Policies
• Creating Backups Using SSMS
• Creating Backups Using T-SQL
• Transaction Logs and Backups
• Automating Backup

Microsoft SQL Server 2016: Restoring Databases

Course: 2 Hours, 7 Minutes

• Course Introduction
• Database Restore
• Complete Database Restores with the Simple Model
• Restoring a Database with the Simple Model
• Complete Database Restores with the Full Model
• Restoring a Database with the Full Model Part
• Restoring a Database with the Full Model Part
• Automating and Testing Restores

Microsoft SQL Server 2016: Managing Database Integrity

Course: 57 Minutes

• Course Introduction
• Database Consistency Checker
• Using Database Consistency Checker in SSMS
• Viewing Progress Reports for DBCC Commands
• Performing Checks on Databases
• Performing Checks on Tables and Indexes
• Consistency Check Errors

Microsoft SQL Server 2016: Monitoring Database Activity and Queries

Course: 2 Hours, 10 Minutes

• Course Introduction
• Activity Monitor
• Using Activity Monitor in SSMS
• Identifying Blocks

Microsoft SQL Server 2016: Monitoring SQL Server Instances

Course: 2 Hours, 7 Minutes

• Course Introduction
• Database Mail
• Logs and Retention in Database Mail
• Configuring Database Mail

Microsoft SQL Server 2016: Managing Indexes and Statistics

Course: 1 Hour, 31 Minutes

• Course Introduction
• Indexes
• Detecting Index Fragmentation
• Repairing Index Fragmentation Using SSMS
• Repairing Index Fragmentation Using T-SQL
• Identifying and Creating Missing Indexes
• Finding and Removing Underutilized Indexes

Microsoft SQL Server 2016: High Availability and Disaster Recovery

Course: 1 Hour, 45 Minutes

• Course Introduction
• Log Shipping
• Configuring Log Shipping with SSMS
• Configuring Log Shipping with T-SQL
• Log Shipping Management
• Monitoring Log Shipping

Provisioning SQL Databases (exam 70-765) 16:16 hours

Components of a SQL Server 2016 Installation

Course: 1 Hour, 59 Minutes

• Course Introduction
• SQL Server Components
• SQL Server Instances
• SQL Server Editions
• SQL Server Versions
• 32-bit Systems
• 64-bit Systems

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 49 Minutes

• Course Introduction
• Tempdb Files
• Tempdb Attributes
• Tempdb Sizing
• SQL Installation Options
• Installing SQL Server 2016
• Post-installation Best Practices
• SQL Server Servicing Installation
• Unattended Installation Options
• Performing an Unattended Installation

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 54 Minutes

• Course Introduction
• SQL Server on Azure VM Overview
• Usage Scenarios
• Licensing Considerations
• IaaS vs On-premises Deployment Options
• Connecting to the SQL Server Azure VM
• Migrate a Database to a SQL Server Azure VM
• Backing up a Database to an Azure URL
• Restoring a Database from an Azure URL
• Configuring Automatic SQL Server Updates in Azure VM
• Customer Experience Improvement Program (CEIP)

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 38 Minutes

• Course Introduction
• SQL Server Instances Overview
• Hosting a SQL Server Instance Using Azure VMs
• Azure Automation
• Azure Resource Manager
• Deploying SQL Server by Using Templates

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 35 Minutes

• Course Introduction
• SQL Server Firewall
• Configuring SQL Server Firewall Rules
• Managing Existing Firewall Rules in Azure
• Connection Security
• TCP Ports
• Authentication
• Contained Database Users
• Managing Logins and Users
• SQL Database Auditing
• SQL Server Authorization

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 35 Minutes

• Course Introduction
• Transparent Data Encryption Overview
• Implementing Transparent Data Encryption
• TDE Commands and Functions
• TDE Catalog Views
• TDE Dynamic Management Views
• TDE Considerations

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 17 Minutes

• Course Introduction
• Evaluate Database Performance
• Changing Service Tiers
• Elastic Database Pools
• Configuring the Database Scope

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 36 Minutes

• Course Introduction
• Single Tenant vs Multi Tenant
• Architectural Considerations
• Multiple Tenant Considerations
• Managing Multi-tenant Data
• Isolating Tenant Data
• Deploying Applications to Azure SQL Database

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 30 Minutes

• Course Overview
• Migration Methods
• Azure VM Deployment Wizard
• Backing up to a File and URL
• AzCopy Command-line Utility
• Microsoft Azure Import/Export Service

Microsoft SQL Server 2016: Provisioning

Course: 1 Hour, 23 Minutes

• Course Overview
• Connection Strings
• Storing Connection Strings
• Connection Strings for Azure Storage Accounts
• Shared Access Signatures
• Explicit Storage Endpoint
• Parsing Connection Strings
• Retry Logic