![](https://ccweb.imgix.net/https%3A%2F%2Fwww.classcentral.com%2Fimages%2Ficon-black-friday.png?auto=format&ixlib=php-4.1.0&s=fe56b83c82babb2f8fce47a2aed2f85d)
Overview
![](https://ccweb.imgix.net/https%3A%2F%2Fwww.classcentral.com%2Fimages%2Ficon-black-friday.png?auto=format&ixlib=php-4.1.0&s=fe56b83c82babb2f8fce47a2aed2f85d)
This course aims to teach learners the fundamentals of SQL Server security. By the end of the course, students will understand database security concepts such as permissions, securables, and principals. They will learn how to manage database security effectively and explore best practices for keeping data safe. The course covers various topics including permissions, principles, logins, users, roles, and system views. The teaching method includes theoretical explanations, practical demonstrations, and discussions on best practices. This course is designed for individuals who work with SQL Server and want to enhance their understanding of database security to protect their company's valuable data.
Syllabus
Introduction
Questions
Definitions
Permissions
Principles
Logins Users
Roles
System Views
S ID
Orphan Users
I Cant anymore
Exceptions
Admin Permissions
GUI Demo
Instance Level Permissions
Database Level Permissions
Table Level Permissions
Script
Server Level Roles
Best Practices
Least Maintenance
Active Directory Groups
Taught by
PASS Data Community Summit