Description: Data is an important enterprise asset and it is vital that it be protected, retrievable, and highly available. This course covers managing high availability and disaster recovery in SQL Server 2016. This includes configuring and monitoring log shipping, as well as managing shared disks and configuring cluster shared volumes. In addition, this course covers configuring Windows clustering, creating an availability group and distributed availability groups, configuring read-only routing, and managing failover. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 01:45
Description: By carefully managing aspects of your database like indexes and statistics, you are able to better tune performance and identify potential issues. This course teaches you about index management tasks, such as identifying and repairing fragmentation, identifying and creating missing indexes, identifying and dropping underused indexes, and managing existing columnstore indexes. In addition, this course covers statistic management topics, such as identifying and correcting outdated statistics, using Auto Update Statistics, and statistics for large tables. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 01:31
Description: Regularly monitoring your SQL Server instances helps you to identify and correct issues before they cause damage and provides valuable insight for performance tuning. This course teaches you about monitoring SQL Server 2016 instances, including creating and managing operators and SQL Server Agent alerts, defining custom alert actions and failure actions, configuring Database Mail and Policy-Based Management, and identifying available space on data volumes and performance degradation. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 02:07
Description: An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. This course focuses on managing and monitoring SQL Server database activity and queries. Covered topics include monitoring current sessions, identifying sessions that cause blocking activity or consume tempdb resources, configuring a data collector, and creating a utility control point. In addition, it covers query monitoring activities such as managing the Query Store, configuring Extended Events and trace events, identifying problematic execution plans, and troubleshooting server health using Extended Events. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 02:10
Description: Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. This course teaches you how to implement database consistency checks, as well as how to identify and recover from database corruption. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 00:57
Description: An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. This course covers restoring SQL Server 2016 databases, including how to perform piecemeal and page restores. It also covers performing point-in-time recovery, restoring file groups, and planning automation for restore testing. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 02:07
Description: A tested backup strategy is the most effective means of protecting your data from media failure, user errors, hardware failures, and other potential disasters. This course teaches you about backing up data in SQL Server 2016, including backing up large databases, configuring alerting for backup issues, and managing translation log backups. In addition, this course covers backing up to Azure SQL Database, configuring recovery models, and automating backup jobs. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 01:47
Description: Auditing allows you to track and log database events to ensure the database is performing properly - an essential administration task. This course teaches you about auditing, including how to configure and manage an audit and query the audit log. Additionally, configuring an Azure SQL Database audit and analyzing audit logs and reports from Azure SQL Database are covered. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 02:02
Description: To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. In this course, you will learn about configuring data access and permissions. This includes managing database object permissions, as well as creating and maintaining users and custom roles. In addition, this course covers configuring user options for Azure SQL Database, row-level security, and dynamic data masking. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database administrators and database professionals
Duration: 02:14
Description: Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. This course will teach you about encryption-related tools and processes used in SQL Server 2016, including cell-level, backup, and connection encryption. In addition, this course covers the Always Encrypted feature, Transparent Data Encryption, and troubleshooting. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.
Target Audience: Database Administrators, database professionals
Duration: 01:38