SQL Server Security Fundamentals

Focused View

Pinal Dave

1:29:25

131 View

1. Course Overview

1. Course Overview.mp4

01:18

2. Getting Started with SQL Server Security

1. Introduction.mp4

02:33

2. Importance of SQL Server Security.mp4

06:03

3. Authentication, Authorization, and Encryption.mp4

03:09

4. Demo - Securing Database Files by Folder Permissions.mp4

04:56

5. Demo - Securing Database Access by Login Audit.mp4

04:12

6. Best Practices.mp4

02:31

3. Understanding Authentication and Authorization

1. Introduction.mp4

01:22

2. Understanding Authentication.mp4

04:05

3. Demo - Creating Logins and Users for Authentication.mp4

06:00

4. Demo - Mapping Logins to Database Users.mp4

02:19

5. Authorization and Permissions.mp4

03:59

6. Demo - Granting and Revoking Permissions.mp4

07:05

7. Summary.mp4

01:57

04. Understanding Principals, Objects, and Role-based Security

01. Introduction.mp4

01:12

02. Principals in SQL Server.mp4

03:32

03. Understanding Roles and Groups.mp4

01:58

04. Demo - Creating and Managing Principals with Roles.mp4

05:16

05. Demo - Adding and Removing Principals from Groups.mp4

03:37

06. Certificates and Asymmetric Keys.mp4

02:59

07. Demo - Certificates and Asymmetric Keys in SQL Server.mp4

04:45

08. Objects and Security Considerations.mp4

02:22

09. Demo - Granting and Revoking Permissions on Objects.mp4

05:42

10. Schema Bound Objects and Security.mp4

01:36

11. Demo - Schema Bound Objects and Security.mp4

02:35

12. Summary.mp4

02:22

Description

In this course, you will learn essential concepts and practical techniques needed to effectively secure SQL Server databases, including authentication, authorization, encryption, management of principals, objects, and role-based security.

What You'll Learn?

SQL Server security is critical for protecting sensitive data, controlling access, and ensuring regulatory compliance. In this course, SQL Server Security Fundamentals, you'll gain the ability to effectively secure SQL Server databases and protect sensitive data. First, you'll explore the importance of SQL Server security and understand the various security threats and best practices. Next, you'll discover the fundamentals of authentication, authorization, and encryption, and learn how to implement them in real-world scenarios. Finally, you'll learn essential skills such as securing database files, implementing certifications, and data encryption. When you're finished with this course, you'll have the skills and knowledge of SQL Server security needed to safeguard your databases, control access, and ensure data protection.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Programming Fundamentals

Database Programming

Microsoft SQL

Cyber Security

Network Security

Information Security

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.