• Online, Self-Paced
Course 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.

Learning Objectives

Configuring Auditing

  • start the course
  • describe why auditing is required and auditing methods
  • use triggers 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


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration