Microsoft SQL Server 2016: Auditing

Course Overview

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

Learning Objectives

• describe why auditing is required and auditing methods
• use triggers for auditing
• use temporal tables for auditing
• use temporal tables for auditing
• describe the purpose of Extended Events
• describe the purpose of SQL Server Audit, auditing levels, and components
• define an audit using SQL Server Audit
• describe the purpose of actions and actions groups
• create server audit specifications
• view the audit log using SQL Server Management Studio or sys.fn_get_audit_file
• create database audit specifications
• use dynamic management and system views to manage an audit
• compare auditing in Azure SQL Database with SQL Server auditing and describe its purpose
• configure auditing for Azure SQL Database
• describe the purpose of audit logs and reports when auditing in Azure SQL Database
• analyze audit logs and reports when auditing in Azure SQL Database
• configure auditing in SQL Server 2016