Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server Security Basics - Security

PASS Data Community Summit via YouTube

Overview

Limited-Time Offer: Up to 75% Off Coursera Plus!
7000+ certificate courses from Google, Microsoft, IBM, and many more.
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

Reviews

Start your review of SQL Server Security Basics - Security

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.