When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Practical SQL Server Security, Compliance, and Auditing
This course is a practical approach to leveraging SQL Server to meet the needs of your industry compliance, audit, security, and encryption standards.
This Course Includes
pluralsight
5 (42 reviews )
3 hour 40 minutes 
english
Online - Self Paced
core courses
pluralsight
About Practical SQL Server Security, Compliance, and Auditing
Nearly every professional industry must adhere to some form of professional standard, regulation, or legislative requirement. While requirements vary, many of the approaches and methods you as the technical administrator will employ can be standardized across many tools available within SQL Server. In this course, Practical SQL Server Security, Compliance, and Auditing, you'll learn the most relevant features including new ones such as Always Encrypted released with SQL 2016. First, you'll discover how to use auditing features that are found within SQL Server. Next, you'll explore how to establish good sound encryption including capabilities that are new to SQL Server such as the 2016 release. Finally, you'll learn how SQL Server manages the different principles in groups and logical organizations of objects within a database instance. By the end of this course, you'll learn valuable security and auditing information in SQL Server.
What You Will Learn?
- Course Overview : 1min.
- Understanding Regulatory Compliance : 17mins.
- Implementing Security with Users, Groups, and Roles : 34mins.
- Modeling Schemas to Support Security Best Practices : 17mins.
- Protecting Sensitive Data With Encryption : 32mins.
- Protecting Sensitive Data in Transit : 26mins.
- Setting up Compliance Enforcement, Monitoring, and Logging : 38mins.
- Watching the Watcher with SQL Audit : 28mins.
- Passing Audits with Compliance Reports and Documentation : 23mins.