Databricks Certified Data Engineer Associate Study Guide

by Derar Alhussein

Cloud Computing

Book Details

Book Title

Databricks Certified Data Engineer Associate Study Guide

Author

Derar Alhussein

Publisher

O'Reilly Media, Inc

Publication Date

2025

ISBN

9781098166830

Number of Pages

957

Language

English

Format

PDF

File Size

13.1MB

Subject

Data Engineering

Table of Contents

  • Preface
  • Chapter 1. Getting Started with Databricks
  • Introducing the Databricks Platform
  • Setting Up a Databricks Workspace
  • Exploring the Databricks Workspace
  • Creating Clusters
  • Working with Notebooks
  • Versioning with Git
  • Conclusion
  • Sample Exam Questions
  • Chapter 2. Managing Data with Delta Lake
  • Introducing Delta Lake
  • Working with Delta Lake Tables
  • Exploring Delta Time Travel
  • Optimizing Delta Lake Tables
  • Vacuuming
  • Dropping Delta Lake Tables
  • Conclusion
  • Sample Exam Questions
  • Chapter 3. Mastering Relational Entities in Databricks
  • Understanding Relational Entities
  • Putting Relational Entities into Practice
  • Setting Up Delta Tables
  • Exploring Views
  • Conclusion
  • Sample Exam Questions
  • Chapter 4. Transforming Data with Apache Spark
  • Querying Data Files
  • Writing to Tables
  • Performing Advanced ETL Transformations
  • Working with Higher-Order Functions
  • Developing SQL UDFs
  • Conclusion
  • Sample Exam Questions
  • Chapter 5. Processing Incremental Data
  • Streaming Data with Apache Spark
  • Implementing Structured Streaming
  • Incremental Data Ingestion
  • Medallion Architecture
  • Conclusion
  • Sample Exam Questions
  • Chapter 6. Building Production Pipelines
  • Exploring Delta Live Tables
  • Capturing Data Changes
  • Orchestrating Workflows
  • Conclusion
  • Sample Exam Questions
  • Chapter 7. Exploring Databricks SQL
  • What Is Databricks SQL?
  • Creating SQL Warehouses
  • Designing Dashboards
  • Managing SQL Queries
  • Setting Up Alerts
  • Conclusion
  • Sample Exam Questions
  • Chapter 8. Implementing Data Governance
  • What Is Data Governance?
  • Managing Data Security in the Hive Metastore
  • Governing Data with Unity Catalog
  • Conclusion
  • Sample Exam Questions
  • Chapter 9. Certification Overview
  • Exploring the Exam Format
  • Registering for the Exam
  • Troubleshooting and Support
  • Getting Ready for the Assessment
  • Practice Exams
  • Seeking Assistance
  • Final Thoughts
  • Appendix A. Signing Up for Databricks
  • Appendix B. Databricks Community Edition
  • Appendix C. Answers to Sample Exam Questions
  • Index
  • About the Author