Skip to Main Content
DB Security - Advanced Compression and Transparent Data Encryption (TDE)

About This Workshop

Youtube Video

About This Workshop
This workshop is designed to show you how to use Transparent Data Encryption and Advanced Compression together and the its benefits.

Transparent Data Encryption has been implemented by many customers to protect sensitive data, but in doing so, they have discovered that storage level compression is no longer a viable solution. Customers are now seeking an integrated solution that not only provides encryption of their data but also enables them to save storage space by compressing encrypted data. This integrated solution of Oracle Transparent Data Encryption and Oracle Advanced Compression not only enhances data security but also reduces the overall costs of storing data in a secure manner, allowing organizations to allocate their resources more efficiently.

With this lab, you will not need important resources on your PC (storage, CPU or memory), nor complex tools to master, making you completely autonomous to discover at your rhythm this integrated solution.

Workshop Info

1 hour
  • Introduction
    • About this Workshop
  • Lab 1: Environment Setup
    • Introduction
    • Task 1: Create Stack: Choose a Path
      • Task 1A: Create Stack: Compute + Networking
      • Task 1B: Create Stack: Compute Only
    • Task 2: Terraform Apply
    • Task 3: Access the Graphical Remote Desktop
    • Appendix 1: Use Auto-generated SSH Keys to Connect to Your Instance via an SSH Terminal
    • Appendix 2: Terraform and Resource Manager
    • Appendix 3: Troubleshooting Tips
    • Acknowledgments
  • Lab 2: Initialize Environment
    • Introduction
    • Task 1: Validate That the Required Processes are Up and Running.
    • Appendix 1: Managing Startup Services
    • Appendix 2: External Web Access
    • Acknowledgments
  • Lab 3: Sample Schema Setup
    • Introduction
    • Task 1: Install Sample Data
    • Oracle Database Sample Schemas Agreement
    • Acknowledgments
  • Lab 4: Transparent Data Encryption(TDE)
    • Introduction
    • Task 1: Allow DB Restore
    • Task 2: Create Keystore
    • Task 3: Create Master Key
    • Task 4: Create Auto-Login Wallet
    • Task 5: Encrypt Existing Tablespace TEST_DATA
    • Task 6: Encrypt All New Tablespaces
    • Appendix: About the Product
    • Want to Learn More? 
    • Acknowledgments
  • Lab 5: Enable Advanced Compression for Encrypted data
    • Introduction
    • Key Advanced Compression Features
    • Task 1: Compression Advisor to estimate the segment compression ratio
    • Task 2: Compression Option 1: Offline compression method
    • Task 3: Compression Option 2: Online compression via Online Redefinition REDEF_TABLE
    • Task 4: Space benefit of Oracle TDE with compression
    • Task 5: (Optional) Enable session parallelism to speed up compression process via online redefinition
    • Task 6: Restore the database if needed
    • Learn More
    • Acknowledgments
  • Familiarity with Database is desired
  • Familiarity with Oracle Transparent Data Encryption is helpful
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
  • Some basic understanding of data protection and security is a plus
  • Some familiarity with Linux/Bash commands is helpful
  • Access to an OCI tenancy

Other Workshops you might like