Securing SQL Server (1 day)


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.

While our courses are based on SQL Server 2017, 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, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

 



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