-
Module 1: Core encryption concepts
9 Lessons -
Module 3: SQL Server keys and certificates
13 Lessons-
StartSupported certificate and key objects
-
StartService master key
-
StartDatabase Master Key
-
StartSupported encryption algorithms
-
StartSQL Server symmetric keys
-
StartSQL Server asymmetric keys
-
StartSQL Server certificates
-
StartCreating users from certificates
-
StartDigitally signing stored procedures
-
StartMoving a database with keys
-
StartLab 3: SQL Server keys and certificates
-
StartLab 3: Solution
-
StartQuiz 3: SQL Server keys and certificates
-
-
Module 4: Using cell level encryption and hashing
8 Lessons -
Module 5: Using Transparent Database Encryption
9 Lessons -
Module 7: Using Always Encrypted
9 Lessons-
PreviewRationale for Always Encrypted
-
StartTypical Scenarios
-
StartHow Always Encrypted works
-
StartDeterministic vs randomized encryption
-
StartAssociated permissions
-
StartLimitations of Always Encrypted
-
StartUsing client drivers with Always Encrypted
-
StartRefreshing cached parameter metadata
-
StartQuiz 7: Using Always Encrypted
-
-
Module 8: Implementing Always Encrypted
9 Lessons-
StartConfiguring Always Encrypted
-
StartCreating a column master key
-
StartCreating a column encryption key
-
StartDefining encrypted columns
-
StartUsing the Always Encrypted Wizard
-
StartBulk loading encrypted data
-
StartLab 8: Implementing Always Encrypted
-
StartLab 8: Video walk-through
-
StartQuiz 8: Implementing Always Encrypted
-
-
Module 9: Using Always Encrypted with Secure Enclaves
11 Lessons-
PreviewRationale for Always Encrypted with Secure Enclaves
-
StartSecure Enclaves defined
-
StartAvailable secure enclave providers
-
StartCurrent limitations
-
StartThe need for attestation
-
StartConfiguring an attestation service
-
StartEnabling in SQL Server
-
StartEnclave-enabled keys and columns
-
StartA quick tour of Always Encrypted with Secure Enclaves
-
StartLab 9: (Optional) Using Always Encrypted with Secure Enclaves
-
StartQuiz 9: Using Always Encrypted with Secure Enclaves
-
SQL Server Encryption for Developers and DBAs
Every day, companies are in the news for exposing private data. Don't be the next statistic ! Encryption can help.
Course Summary
Are you worried about protecting private or sensitive data?
- Or more importantly, will you get blamed if it all goes wrong?
- Do you understand how SQL Server encryption can help?
- Don't know your cell-level encryption from your Always Encrypted with Secure Enclaves?
- Don't know why adding a digital signature to a stored proc might be helpful?
- Need a refresher on keys, certificates, hashes, digital signatures, and encryption?
