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.

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.

• 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