All Brands   >   Microsoft   >   Microsoft SQL Server   >   SQL Server Audit and Security

CMDBID: 44911 | Course Code: SQL | Duration: 2 Days
Overview >

This course is intended for computer auditors and security specialists who need to understand the mechanisms available to secure a SQL Server installation, and how to successfully audit user access and activity following best practices and guidelines. The coverage of SQL Server security is quite in-depth, and the remaining topics focus on the major tools and techniques utilised for auditing.

Course content and delivery is based on SQL Server 2012, however the material covered can be applied to previous releases if required.

Besides excellent coverage of the theory and concepts, time is also devoted to hands on activities to put into practice the topics introduced in each module.

Upon successful completion of this course, students will be able to:

  • Understand the fundamental structure and architecture of SQL Server
  • Work confidently in SQL Server Management Studio (SSMS)
  • Understand the purpose of the system databases
  • Understand SQL Server database architecture and objects
  • Configure SQL Server security and audit related features
  • Manage access to a SQL Server
  • Understand and work with server principals and securables
  • Understand and work with database principals and securables
  • Implement permissions on securables
  • Understand encryption options in SQL Server
  • Secure code modules with signatures
  • Implement Transparent Data Encryption (TDE)
  • Understand SQL Server Agent Security
  • Utilise DML Triggers for Auditing
  • Utilise SQL Server Profiler for Auditing
  • Use dedicated SQL Server auditing tools
  • Implement Policy Based Management
  • Retrieve security and audit related metadata
  • Implement best practices for auditing and compliance
Audience >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-5 out of 5
Start Date
Bath, United Kingdom
2 Days
1st Jun 2021
Bath, United Kingdom
2 Days
16th Aug 2021
Bath, United Kingdom
2 Days
11th Oct 2021
Bath, United Kingdom
2 Days
22nd Nov 2021
ONSITE, United States
2 Days

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes