SQL Server 2014, Part 6 of 9: Permissions and Data Protection

Course description

In the SQL Server 2014: Permissions and Data Protection course you will understand permissions in SQL Server and how they provide granular control over data and objects. Then you will learn how to provide a final layer of defense by encrypting data.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course assumes that you have at least a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it, as well as how to create and manage objects using Management Studio.

Meet the expert

Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.

Video Runtime

110 Minutes

Time to complete

425 Minutes

Course Outline

Permissions, Schemas, Metadata

Permissions (19:28)

• Introduction (00:41)
• Permissions (01:25)
• Permission Types (04:15)
• Permission Statements (02:01)
• Demo: Assigning Permissions (04:58)
• Summary (00:38)
• Default Schemas for Users (00:53)
• Default Schemas for Groups (00:49)
• Demo: Potential Problems (06:40)

Default Schemas (17:15)

• Demo: Assigning Permissions (04:58)
• Introduction (00:52)
• Default Schemas for Users (00:53)
• Default Schemas for Groups (00:49)
• Demo: Potential Problems (06:40)
• Summary (00:41)

Execution and Metadata (21:30)

• Introduction (00:44)
• Execution Context (02:23)
• Ownership Chaining (01:13)
• Changing the Execution Content (04:14)
• Demo: Execution content (06:25)
• Metadata Security (01:57)
• Demo: Permissions and Metadata (04:17)
• Summary (00:13)

Encryption

Data Encryption (21:29)

• Introduction (00:35)
• Data Encryption (03:28)
• Encryption Keys (04:33)
• Demo: How Encryption Works (10:30)
• Key Management (01:48)
• Summary (00:32)

Encrypting Data (30:48)

• Introduction (00:40)
• Demo: Table Creation (01:59)
• Demo: Certificate Keys (08:45)
• Demo: Asymmetric Keys (07:46)
• Demo: Symmetric Keys (10:10)
• Summary (01:26)