Loading...

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 

Prerequisites

Advanced SQL or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to SQL Security
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
May 10, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 08, 2024
Transfer Request Deadline
May 08, 2024
Section Title
Introduction to SQL Security
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
May 10, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 08, 2024
Transfer Request Deadline
May 08, 2024
Required fields are indicated by .