Microsoft SQL Server 2016: Auditing


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Microsoft SQL Server 2016: 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
  • 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

    • Course Number:
    df_sqla_a03_it_enus

    Expertise Level
    Intermediate