Training
Securing SQL Server
SQL Server is Microsoft's primary database management tool. This course is designed to take you through a critical aspect of SQL Server Administration, with just the right amount of depth, within one day.

The course is most suitable for those that need to know how to configure security for a SQL Server system. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

Even though our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.

City
Dates
Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Day
Code
Module
1
AD205
Managing Users and Roles
- Working with SQL Server Authentication Options
- Managing Database Users
- Managing Server and Database Roles
- LAB: Managing Users and Roles
1
AD206
Managing Server and Database Permissions
- Managing Permissions for Server Objects
- Managing Permissions for Database Objects
- Managing Permissions for Code Execution
- LAB: Managing Server and Database Permissions
1
AD207
Managing SQL Server Certificates and Encryption
- Understanding Certificates and Encryption
- Managing Column Encryption
- Managing Transparent Database Encryption
- Managing Extensible Key Management
- LAB: Managing SQL Server Certificates and Encryption
1
AD208
Auditing SQL Server Databases
- Understanding Audit Options for SQL Server
- Configuring SQL Server Audits
- Configuring Server Audit Specifications
- Configuring Database Audit Specifications
- Reading Audit Output
- LAB: Auditing SQL Server Databases
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement