70-764: Administering a SQL Server 2016 Database Infrastructure
Intermediate
24h
By: Doug Perez
Overview
In this instructor-led, online training course, students will learn the knowledge and skills to administer a SQL server database infrastructure. Students will be taught how to authenticate and authorize users, protect data with encryption and auditing, backup and restore SQL Server, configure security for the SQL Server agent, and more.
Modules
1. Configuring Data Access and Auditing with SQL Server 2016
1.1 Administering a SQL Database Infrastructure38 min
1.2 Users and Roles in SQL Server31 min
1.3 Managing Object Permissions, Security Options54 min
1.4 Row Level Security, DDM, SQL in Azure40 min
1.5 Configuring Encryption, Key Types and Always Encrypted59 min
1.6 Encryption by Key, TDE, Backup Encryption39 min
1.7 Configuring Auditing in a Locally Hosted SQL Server1h 6m
1.8 Configure Azure SQL Database Auditing16 min
2. Managing Backups and Restores with SQL Server 2016
2.1 Managing and Restoring Backups50 min
2.2 Transaction Log Restores and Database Backups1h 4m
2.3 Powershell Backups, SQL Server Agent, Troubleshooting Backups56 min
2.4 Backup Automation32 min
2.5 Backup Alerts, Blob Storage, Azure Containers36 min
3. Managing and Monitoring SQL Server 2016 Instances
3.1 Manage and Monitor SQL Server Instances52 min
3.2 Monitoring tempdb, Isolation Levels, Data Collector54 min
3.3 Monitoring Queries, Query Store39 min
3.4 Query Store Views, Extended Events, Trace Events, Execution Plans,45 min
3.5 Index Fragmentation, Missing Indexes36 min
3.6 Columnstore Indexes Within Tables, Statistics53 min
3.7 Update and Managing Statistics, Performance Options57 min
3.8 Monitoring Queries, Creating an Operator, Alerts1h 3m
3.9 Alert Responses with Tokens, Failure Actions, Database Mail55 min
3.10 Policy Based Management, Space Management, Performance Degredation Identification40 min
4. Managing High Availability and Disaster Recovery Options with SQL Server 2016 - Part 1
4.1 Managing HA and Disaster Recovery, Log Shipping,1h 7m
4.2 AlwaysOn Availability Groups, Failover Clustering41 min
4.3 Clustering in T-SQL, Read Only Routing, Manage Failover59 min
5. Managing High Availability and Disaster Recovery Options with SQL Server 2016 - Part 2
5.1 SQL Server Transactional Replication, Replication Agents, Use Cases, Setup Replication1h 2m
5.2 New Publication Options, Snapshot Agent, Customizing Replication Settings, Subscription Wizard57 min
5.3 Monitoring Replication, ReplMon Performance, Snapshot Delivery41 min
5.4 Performance Tuning, Server Configuration Tips, Ansi Padding34 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES