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-25 out of 51
Location
Start Date
Price
LVC, United States
6th Aug 2020
$1800
LVC, France
6th Aug 2020
€1600
LVC, Germany
6th Aug 2020
€1600
LVC, United Kingdom
6th Aug 2020
£850
LVC, United States
6th Aug 2020
$1800
LVC, United States
6th Aug 2020
$1800
LVC, Spain
6th Aug 2020
€1600
LVC, Italy
6th Aug 2020
€1600
Bath, United Kingdom
19th Aug 2020
£850
LVC, United Kingdom
7th Sep 2020
£850
LVC, United States
7th Sep 2020
$1800
LVC, United States
7th Sep 2020
$1800
New York, United States
7th Sep 2020
$1800
LVC, Germany
7th Sep 2020
€1600
LVC, France
7th Sep 2020
€1600
Madrid, Spain
7th Sep 2020
€1600
Milan, Italy
7th Sep 2020
€1600
LVC, United States
7th Sep 2020
$1800
Berlin, Germany
7th Sep 2020
€1600
London, United Kingdom
7th Sep 2020
£850
San Francisco, United States
7th Sep 2020
$1800
Chicago, United States
7th Sep 2020
$1800
Paris, France
7th Sep 2020
€1600
LVC, Spain
7th Sep 2020
€1600
LVC, Italy
7th Sep 2020
€1600

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