Zenler Player
Your course is loading. Hang tight.
SQL Server Encryption for Developers and DBAs
Back to curriculum
0% Complete
0% Complete
Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment
Following demo code
What are cryptography and encryption?
Encryption vs obfuscation
Symmetric key cryptography
Public key cryptography
Cryptographic algorithms
Applying salt
Digital envelopes and signatures
Hashes
Quiz 1: Core encryption concepts
Certificates defined
Certificate authorities
SSL
Certificate requests
Quiz 2: Working with certificates
Supported certificate and key objects
Service master key
Database Master Key
Supported encryption algorithms
SQL Server symmetric keys
SQL Server asymmetric keys
SQL Server certificates
Creating users from certificates
Digitally signing stored procedures
Moving a database with keys
Lab 3: SQL Server keys and certificates
Lab 3: Solution
Quiz 3: SQL Server keys and certificates
CHECKSUM function
HASHBYTES function
Using cell level encryption
Decryption keys
Built-in encryption and decryption functions
Lab 4: Using cell level encryption and hashing
Lab 4: Solution
Quiz 4: Using cell level encryption and hashing
Rationale for TDE
Implementing TDE
Application impacts
Moving encrypted databases
Feature compatibility
Backup encryption
Lab 5: Using Transparent Database Encryption
Lab 5: Solution
Quiz 5: Using Transparent Database Encryption
Extensible Key Management
EKM key hierarchy
Enabling an EKM provider
Using Azure Key Vault for EKM
Quiz 6: Using Extensible Key Management
Rationale for Always Encrypted
Typical Scenarios
How Always Encrypted works
Deterministic vs randomized encryption
Associated permissions
Limitations of Always Encrypted
Using client drivers with Always Encrypted
Refreshing cached parameter metadata
Quiz 7: Using Always Encrypted
Configuring Always Encrypted
Creating a column master key
Creating a column encryption key
Defining encrypted columns
Using the Always Encrypted Wizard
Bulk loading encrypted data
Lab 8: Implementing Always Encrypted
Lab 8: Video walk-through
Quiz 8: Implementing Always Encrypted
Rationale for Always Encrypted with Secure Enclaves
Secure Enclaves defined
Available secure enclave providers
Current limitations
The need for attestation
Configuring an attestation service
Enabling in SQL Server
Enclave-enabled keys and columns
A quick tour of Always Encrypted with Secure Enclaves
Lab 9: (Optional) Using Always Encrypted with Secure Enclaves
Quiz 9: Using Always Encrypted with Secure Enclaves
Summary and further steps
Module 0: Getting started
Who is this course for?
Preview
Who is Greg?
Preview
What will I learn in this course?
Preview
Configuring your lab environment
Following demo code
Module 1: Core encryption concepts
What are cryptography and encryption?
Encryption vs obfuscation
Symmetric key cryptography
Public key cryptography
Cryptographic algorithms
Applying salt
Digital envelopes and signatures
Hashes
Quiz 1: Core encryption concepts
Module 2: Working with certificates
Certificates defined
Certificate authorities
SSL
Certificate requests
Quiz 2: Working with certificates
Module 3: SQL Server keys and certificates
Supported certificate and key objects
Service master key
Database Master Key
Supported encryption algorithms
SQL Server symmetric keys
SQL Server asymmetric keys
SQL Server certificates
Creating users from certificates
Digitally signing stored procedures
Moving a database with keys
Lab 3: SQL Server keys and certificates
Lab 3: Solution
Quiz 3: SQL Server keys and certificates
Module 4: Using cell level encryption and hashing
CHECKSUM function
HASHBYTES function
Using cell level encryption
Decryption keys
Preview
Built-in encryption and decryption functions
Lab 4: Using cell level encryption and hashing
Lab 4: Solution
Quiz 4: Using cell level encryption and hashing
Module 5: Using Transparent Database Encryption
Rationale for TDE
Preview
Implementing TDE
Application impacts
Moving encrypted databases
Feature compatibility
Backup encryption
Lab 5: Using Transparent Database Encryption
Lab 5: Solution
Quiz 5: Using Transparent Database Encryption
Module 6: Using Extensible Key Management
Extensible Key Management
EKM key hierarchy
Enabling an EKM provider
Using Azure Key Vault for EKM
Quiz 6: Using Extensible Key Management
Module 7: Using Always Encrypted
Rationale for Always Encrypted
Preview
Typical Scenarios
How Always Encrypted works
Deterministic vs randomized encryption
Associated permissions
Limitations of Always Encrypted
Using client drivers with Always Encrypted
Refreshing cached parameter metadata
Quiz 7: Using Always Encrypted
Module 8: Implementing Always Encrypted
Configuring Always Encrypted
Creating a column master key
Creating a column encryption key
Defining encrypted columns
Using the Always Encrypted Wizard
Bulk loading encrypted data
Lab 8: Implementing Always Encrypted
Lab 8: Video walk-through
Quiz 8: Implementing Always Encrypted
Module 9: Using Always Encrypted with Secure Enclaves
Rationale for Always Encrypted with Secure Enclaves
Preview
Secure Enclaves defined
Available secure enclave providers
Current limitations
The need for attestation
Configuring an attestation service
Enabling in SQL Server
Enclave-enabled keys and columns
A quick tour of Always Encrypted with Secure Enclaves
Lab 9: (Optional) Using Always Encrypted with Secure Enclaves
Quiz 9: Using Always Encrypted with Secure Enclaves
Module 10: Next steps
Summary and further steps
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson