Collections     Essentials     Microsoft SQL     Microsoft SQL Server 2016: Administering

---

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 learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

---

---

Objectives

Configuring Auditing start the course describe why auditing is required and auditing methods use triggers for auditing use temporal tables for auditing use temporal tables for auditing Configuring SQL Server Audit 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 Auditing an Azure SQL Database 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 Practice: Configuring Auditing configure auditing in SQL Server 2016