Course SQL Server 2008 Encryption

Duration (days): 3/a>
Price (CZK): 12000

SQL Server 2008 Encryption topics:

Introduction to Encryption

• What Is Encryption?
• A Short History of Information Security
• SQL Server Encryption Tools

Encryption Key Management

• SQL Encryption Key Hierarchy
• Service Master Key
• Database Master Key
• Other Keys and Certificates
• Permissions
• Catalog Views
• Dynamic Management Views and Functions

Symmetric Encryption

• Symmetric Keys
• Encryption with Passphrases
• Encryption Algorithms

Asymmetric Encryption

• Asymmetric Keys
• Certificates
• Digital Signatures
• Signing Modules

Extensible Key Management

• What Is EKM?
• Configuring EKM
• Creating Asymmetric Keys
• Creating Symmetric Keys
• EKM Limitations

Transparent Data Encryption

• What Is TDE?
• Using TDE with EKM
• Checking Status
• Backups and Compression
• Windows-Based Encryption Options

Hashing

• Cryptographic Hash Functions
• SHA Hash Function
• Message Digest Family of Hash Functions
• CHECKSUM Functions

SQL CLR Cryptography

• Encrypting By Passphrase
• SQL CLR Hashing
• Additional SQL CLR Considerations

Indexing Encrypted Data

• The Problem of Searching Encrypted Data
• Storing Partial Plaintext Values
• Storing Hashed Values
• Storing Salted Hashed Values
• Storing Hash-Based Message Authentication Codes
• Range Queries

Encrypting Connections to SQL Server 2008

• Encryption Concepts
• Network Monitor
• SQL Server Encryption Out of the Box
• Applying a Self-Signed Certificate
• Requesting a Certificate from a Valid CA
• Enforcing Encryption Between Server and Client
• Creating and Testing Secure Connections

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs