CS341 - Introduction to SQL Security

Course Description

Understand how data is your most valuable asset and the importance of keeping the data secure. Learn how to manage your SQL Server’s database permissions. Discover how to create roles and assign roles to users, making it easier if a user leaves the company or changes positions. Use and create schemas to provide natural data groupings so securing an application or group of applications becomes easier. Discover stored procedures to control and limit what roles can do. Learn about securables, the items that can be secured in a SQL Server, and manage permissions using grant, revoke, and deny to protect the data.

In this course, you will learn to: 

• Security terms and definitions 

• SQL Server and Windows Authentication modes 

• Encrypting SQL Server communication 

• Schemas and how to use them for security 

• Creating and managing logins 

• Granting database access 

• When to use SQL Server roles and how to manage permissions 

• Learning about Securable hierarchies and scopes 

• Managing permissions using Roles and Securables 

• Creating scripts to automatically create logins and permissions 

• Ownership Chaining to give permissions by task or job 

• Encrypting columns 

Applies Towards the Following Certificates

• Database Technology Certificate : Electives