Microsoft SQL Server 2016: Auditing

Database administrators and database professionals

Prerequisite
None

Expected Duration
122 minutes

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.

Objective

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
  • view the audit log using SQL Server Management Studio or sys.fn_get_audit_file

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
  • 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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.