Advanced

Optimize Storage and Performance with Delta Lake

Delta Lake internals, ACID, OPTIMIZE, Z-Order, liquid clustering, caching and Photon acceleration.

Level: Intermediate / Advanced | Platform: Azure Databricks Premium

Sign in to read this course

A free account unlocks all 514 courses. 20 are readable without one.

What's inside

35 sections
  1. 1 Table of Contents
  2. 2 Data Lakehouse Architecture and Delta Lake
  3. 3 Storage Formats Compared
  4. 4 Delta Tables and Transaction Log
  5. 5 ACID Properties in Delta Lake
  6. 6 Creating and Managing Delta Tables
  7. 7 Loading Data from ADLS Gen2
  8. 8 Streaming to Delta Tables
  9. 9 Schema Enforcement and Evolution
  10. 10 Delta Lake Optimization Techniques
  11. 11 Partitioning — Directory-based Organization
  12. 12 Z-Order — Data Co-location
  13. 13 OPTIMIZE — Small File Compaction
  14. 14 Liquid Clustering — Adaptive Partitioning
  15. 15 Delta Caching — Local Acceleration
  16. 16 Data Skipping and Column Statistics
  17. 17 Photon Acceleration
  18. 18 Time Travel and Versioning
  19. 19 VACUUM — Cleaning Up Obsolete Files
  20. 20 Monitoring Delta Tables
  21. 21 Optimistic Concurrency Control
  22. 22 Advanced Azure Use Cases
  23. 23 Summary and Best Practices
  24. 24 Glossary
  25. 25 Module 2 – Working with Delta Lake
  26. 26 Module 3 – Optimizing Performance
  27. 27 Module 4 – Data Integrity and Versioning
  28. 28 Azure Use Cases with Delta Lake
  29. 29 Delta Lake Command Reference
  30. 30 Module 5 – Photon Engine
  31. 31 Module 6 – OPTIMIZE and Z-ORDER
  32. 32 Module 7 – Delta Lake Internals
  33. 33 Module 8 – Caching in Depth
  34. 34 Module 9 – Adaptive Query Execution (AQE)
  35. 35 Module 10 – Join Optimizations

Interested in this course?

Contact us to book it or get a custom training plan for your team.