SQL Server Security Fundamentals

سرفصل های دوره

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.

1. Course Overview

1. Course Overview

2. Getting Started with SQL Server Security

1. Introduction

2. Importance of SQL Server Security

3. Authentication, Authorization, and Encryption

4. Demo - Securing Database Files by Folder Permissions

5. Demo - Securing Database Access by Login Audit

6. Best Practices

3. Understanding Authentication and Authorization

1. Introduction

2. Understanding Authentication

3. Demo - Creating Logins and Users for Authentication

4. Demo - Mapping Logins to Database Users

5. Authorization and Permissions

6. Demo - Granting and Revoking Permissions

7. Summary

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

01. Introduction

02. Principals in SQL Server

03. Understanding Roles and Groups

04. Demo - Creating and Managing Principals with Roles

05. Demo - Adding and Removing Principals from Groups

06. Certificates and Asymmetric Keys

07. Demo - Certificates and Asymmetric Keys in SQL Server

08. Objects and Security Considerations

09. Demo - Granting and Revoking Permissions on Objects

10. Schema Bound Objects and Security

11. Demo - Schema Bound Objects and Security

12. Summary

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight