by Integrity Training | Released May 2019 | ISBN: 300000006CA314

This course will introduce students to SQL Server 2014 security fundamentals, as well as teach them about authentication, contained databases, authorization, permissions, schemas, metadata, and encryption. This course will teach students about SQL Server authentication, contained databases, authorization, permissions, schemas, execution and metadata. The final chapter of the course covers the theory and implementation of encryption. Show and hide more

1. Introduction and Authentication
   • Topic A: Introduction - Part 1 00:00:24
   • Introduction - Part 2 00:13:59
   • Introduction - Part 3 00:00:25
   • Topic B: Authentication - Part 1 00:00:22
   • Authentication - Part 2 00:18:01
   • Authentication - Part 3 00:00:21
   • Topic C: SQL Server Authentication - Part 1 00:00:49
   • SQL Server Authentication - Part 2 00:13:43
   • SQL Server Authentication - Part 3 00:00:38
2. Contained and Authorization
   • Topic A: Contained Databases - Part 1 00:00:49
   • Contained Databases - Part 2 00:19:07
   • Contained Databases - Part 3 00:00:32
   • Topic B: Authorization - Part 1 00:00:24
   • Authorization - Part 2 00:28:05
   • Authorization - Part 3 00:00:20
3. Permissions, Schemas, Metadata
   • Topic A: Permissions - Part 1 00:00:26
   • Permissions - Part 2 00:18:08
   • Permissions - Part 3 00:00:39
   • Topic B: Default Schemas - Part 1 00:00:38
   • Default Schemas - Part 2 00:15:43
   • Default Schemas - Part 3 00:00:41
   • Topic C: Execution and Metadata - Part 1 00:00:30
   • Execution and Metadata - Part 2 00:20:32
   • Execution and Metadata - Part 3 00:00:14
4. Encryption
   • Topic A: Data Encryption - Part 1 00:00:21
   • Data Encryption - Part 2 00:20:22
   • Data Encryption - Part 3 00:00:33
   • Topic B: Encrypting Data - Part 1 00:00:26
   • Encrypting Data - Part 2 00:28:42
   • Encrypting Data - Part 3 00:01:26
Show and hide more