Databricks Data Engineer Associate Certification Preparation
- Description
- Curriculum
- FAQ
- Reviews
Whether you’re a seasoned data professional or just starting your journey, this course provides the perfect blend of theory and hands-on examples to ensure your success. With practical exercises and step-by-step guidance, you will learn how to navigate the Data Lakehouse architecture, explore the Data Science and Engineering workspace, and master the powerful Delta Lake.
A Certified Databricks Data Engineer unlocks endless possibilities in the world of data processing and analytics. In this comprehensive course, you will gain the knowledge and skills to harness the power of the Databricks Lakehouse Platform, empowering you to tackle real-world data challenges with confidence and efficiency.
Here’s a breakdown of the topics covered in this course:
- Understand how to use and the benefits of using the Databricks Lakehouse Platform and its tools, including:
- Data Lakehouse (architecture, descriptions, benefits)
- Data Science and Engineering workspace (clusters, notebooks, data storage)
- Delta Lake (general concepts, table management and manipulation, optimizations)
- Build ETL pipelines using Apache Spark SQL and Python, including:
- Relational entities (databases, tables, views)
- ELT (creating tables, writing data to tables, cleaning data, combining and reshaping tables, SQL UDFs)
- Python (facilitating Spark SQL with string manipulation and control flow, passing data between PySpark and Spark SQL)
- Incrementally process data, including:
- Structured Streaming (general concepts, triggers, watermarks)
- Auto Loader (streaming reads)
- Multi-hop Architecture (bronze-silver-gold, streaming applications)
- Delta Live Tables (benefits and features)
- Build production pipelines for data engineering applications and Databricks SQL queries and dashboards, including:
- Jobs (scheduling, task orchestration, UI)
- Dashboards (endpoints, scheduling, alerting, refreshing)
- Understand and follow best security practices, including:
- Unity Catalog (benefits and features)
- Entity Permissions (team-based permissions, user-based permissions)
These topics provide a comprehensive coverage of the Databricks Lakehouse Platform and its tools, allowing learners to gain a solid understanding of data engineering concepts and practices using Databricks.
-
1IntroductionVideo lesson
-
2(lab) Databricks community accountVideo lesson
-
3(lab) Free Databricks on AzureVideo lesson
-
4Databricks Workspace tourVideo lesson
-
5Account and workspacesVideo lesson
-
6ClustersVideo lesson
-
7(lab) Creating Clusters mp4Video lesson
-
8Course resourcesVideo lesson
-
9What is databricksVideo lesson
-
10Databricks architectureVideo lesson
-
11Notebook basicsVideo lesson
-
12DeltalakeVideo lesson
-
13(Theory & lab) Reading txt and csv formatsVideo lesson
-
14(Theory & lab) Reading Delta format dataVideo lesson
-
15(Theory & lab) Creating Delta tables using CTASVideo lesson
-
16(Theory & lab) Delta table constraintsVideo lesson
-
17(Theory & lab) Delta table PartitionsVideo lesson
-
18(Theory & lab) Delta table OperationsVideo lesson
-
19(Theory & lab) Time-travel and optimizationVideo lesson
-
20(Theory & lab) Delta table optimization and VACCUMVideo lesson
-
21(Theory) Delta cloning and external tablesVideo lesson
-
22(lab) Delta cloning and external tablesVideo lesson
-
23(Theory & lab) Relational EntitiesVideo lesson
-
24Persistent, Temporary & Global ViewsVideo lesson
-
25Combining and reshaping tables, and higher order functionsVideo lesson
-
26(Lab) Combining and reshaping tables, and higher order functionsVideo lesson
-
27(Theory & Lab) Joins and SetsVideo lesson
-
28Passing data between pyspark DF and Spark SQLVideo lesson
-
29(Theory & lab) UDF and control flowsVideo lesson
-
30Incremental data processingVideo lesson
-
31(Lab) Structured streamingVideo lesson
-
32(Lab) AutoloaderVideo lesson
-
33Multihop architectureVideo lesson
-
34Multihop architecture discussionVideo lesson
-
35(Lab) Multihop architecture implementationVideo lesson
-
36Delta Live TablesVideo lesson
-
37(Lab) Delta live tablesVideo lesson
External Links May Contain Affiliate Links read more