Overview
Learn about database security concepts in this course. The course covers security principles, server-level security, SQL Server security, Windows authentication, object permissions, and more. The goal is to understand how to secure databases effectively. The course teaches skills such as setting up server roles, user authentication, and granting access to databases. The teaching method includes video lessons, follow-along labs, and practice exams. This course is intended for individuals interested in IT certification training, particularly those looking to enhance their database security knowledge.
Syllabus
Intro
Objectives
Security principles
Simplified security model
Server-level security
Fixed server roles
SQL Server security
Windows authentication - T-SQL commands
SQL Server user authentication
Granting access to a database
Fixed database roles
Object permissions
Granting object permission examples
Taught by
Paul Browning