01 Create and organize workspace folders difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
02 Create and run a basic notebook (Python) difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
03 Create and run a basic notebook (SQL) difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
04 Understand notebook cell types and magic commands difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
05 Export and import notebooks (DBC, HTML, Python) difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
06 Use dbutils.fs commands to explore DBFS difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
07 Create and attach to a cluster difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
08 Configure cluster size and autoscaling difficulty:Medium_(30-45_min) @Week_1:_Fundamentals
09 Understand cluster termination policies difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
10 Use cluster UI to monitor resource usage difficulty:Easy_(15-30_min) @Week_1:_Fundamentals
11 Connect Git repository to Databricks Repos difficulty:Medium_(30-45_min) @Week_1:_Fundamentals
12 Commit changes from Databricks to Git difficulty:Medium_(30-45_min) @Week_1:_Fundamentals
13 Create and switch between Git branches difficulty:Medium_(30-45_min) @Week_1:_Fundamentals
14 Pull changes from remote repository difficulty:Medium_(30-45_min) @Week_1:_Fundamentals
01 Create Delta table using SQL DDL difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
02 Create Delta table using DataFrameWriter difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
03 Create Delta table from existing Parquet files difficulty:Medium_(30-45_min) @Week_2:_Delta_Lake_Basics
04 Use CTAS (CREATE TABLE AS SELECT) difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
05 Understand managed vs. external tables difficulty:Medium_(30-45_min) @Week_2:_Delta_Lake_Basics
06 Create partitioned Delta table difficulty:Medium_(30-45_min) @Week_2:_Delta_Lake_Basics
07 Query Delta table transaction log difficulty:Medium_(30-45_min) @Week_2:_Delta_Lake_Basics
08 INSERT data into Delta table difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
09 UPDATE rows in Delta table difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
10 DELETE rows from Delta table difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
11 Understand DELETE behavior with partitions difficulty:Medium_(30-45_min) @Week_2:_Delta_Lake_Basics
12 Use WHERE clause with UPDATE/DELETE difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
13 Verify changes using table history difficulty:Easy_(15-30_min) @Week_2:_Delta_Lake_Basics
01 Perform basic MERGE (upsert) operation difficulty:Medium_(30-45_min) @Week_3:_Delta_Advanced
02 Use MERGE with WHEN MATCHED clause difficulty:Medium_(30-45_min) @Week_3:_Delta_Advanced
03 Use MERGE with WHEN NOT MATCHED clause difficulty:Medium_(30-45_min) @Week_3:_Delta_Advanced
04 Use MERGE with multiple WHEN conditions difficulty:Hard_(45-60_min) @Week_3:_Delta_Advanced
05 Handle duplicates in source data during MERGE difficulty:Hard_(45-60_min) @Week_3:_Delta_Advanced
06 Test MERGE with NULL values difficulty:Medium_(30-45_min) @Week_3:_Delta_Advanced
07 Understand MERGE atomicity guarantees difficulty:Hard_(45-60_min) @Week_3:_Delta_Advanced
08 Query Delta table at specific version difficulty:Easy_(15-30_min) @Week_3:_Delta_Advanced
09 Query Delta table at specific timestamp difficulty:Easy_(15-30_min) @Week_3:_Delta_Advanced
10 Use DESCRIBE HISTORY command difficulty:Easy_(15-30_min) @Week_3:_Delta_Advanced
11 Restore table to previous version difficulty:Medium_(30-45_min) @Week_3:_Delta_Advanced
12 Understand version retention limits difficulty:Medium_(30-45_min) @Week_3:_Delta_Advanced
01 Run OPTIMIZE command on Delta table difficulty:Medium_(30-45_min) @Week_4:_Optimization
02 Understand small file problem difficulty:Medium_(30-45_min) @Week_4:_Optimization
03 Use Z-ORDER clustering difficulty:Medium_(30-45_min) @Week_4:_Optimization
04 Compare query performance before/after Z-ORDER difficulty:Medium_(30-45_min) @Week_4:_Optimization
05 Understand when to use OPTIMIZE difficulty:Hard_(45-60_min) @Week_4:_Optimization
06 Configure Auto Optimize on table difficulty:Medium_(30-45_min) @Week_4:_Optimization
07 Test Auto Compaction behavior difficulty:Medium_(30-45_min) @Week_4:_Optimization
08 Run VACUUM command difficulty:Easy_(15-30_min) @Week_4:_Optimization
09 Understand VACUUM retention period difficulty:Medium_(30-45_min) @Week_4:_Optimization
10 Test time travel after VACUUM difficulty:Medium_(30-45_min) @Week_4:_Optimization
11 Configure retention settings difficulty:Medium_(30-45_min) @Week_4:_Optimization
12 Understand VACUUM dry run mode difficulty:Easy_(15-30_min) @Week_4:_Optimization
01 Read streaming data from files difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
02 Read streaming data from Delta table difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
03 Use readStream with schema difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
04 Understand trigger modes (once, continuous, micro-batch) difficulty:Hard_(45-60_min) @Week_5:_Streaming_Basics
05 Configure maxFilesPerTrigger option difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
06 Test trigger(once=True) behavior difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
07 Test trigger(availableNow=True) behavior difficulty:Hard_(45-60_min) @Week_5:_Streaming_Basics
08 Write stream to Delta table difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
09 Use append mode for streaming writes difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
10 Configure checkpoint location difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
11 Understand streaming write guarantees difficulty:Hard_(45-60_min) @Week_5:_Streaming_Basics
12 Test stream restart from checkpoint difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
13 Write stream with partitioning difficulty:Medium_(30-45_min) @Week_5:_Streaming_Basics
01 Set up Auto Loader for JSON files difficulty:Medium_(30-45_min) @Week_6:_Auto_Loader
02 Set up Auto Loader for CSV files difficulty:Medium_(30-45_min) @Week_6:_Auto_Loader
03 Set up Auto Loader for Parquet files difficulty:Medium_(30-45_min) @Week_6:_Auto_Loader
04 Configure cloudFiles.format option difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
05 Use schema inference with Auto Loader difficulty:Medium_(30-45_min) @Week_6:_Auto_Loader
06 Configure schema evolution difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
07 Set up cloudFiles notification mode difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
08 Test Auto Loader with arriving files difficulty:Medium_(30-45_min) @Week_6:_Auto_Loader
09 Apply transformations in streaming query difficulty:Easy_(15-30_min) @Week_6:_Auto_Loader
10 Use watermarking for late data difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
11 Perform streaming aggregations difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
12 Join streaming with static data difficulty:Medium_(30-45_min) @Week_6:_Auto_Loader
13 Join two streams together difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
14 Handle streaming duplicates with dropDuplicates difficulty:Hard_(45-60_min) @Week_6:_Auto_Loader
01 Process CDC data with MERGE difficulty:Hard_(45-60_min) @Week_7:_Incremental_Processing
02 Handle INSERT/UPDATE/DELETE operations difficulty:Hard_(45-60_min) @Week_7:_Incremental_Processing
03 Apply CDC from streaming source difficulty:Hard_(45-60_min) @Week_7:_Incremental_Processing
04 Test CDC with out-of-order records difficulty:Hard_(45-60_min) @Week_7:_Incremental_Processing
05 Understand SCD Type 1 implementation difficulty:Medium_(30-45_min) @Week_7:_Incremental_Processing
06 Understand SCD Type 2 implementation difficulty:Hard_(45-60_min) @Week_7:_Incremental_Processing
07 Implement append-only pattern difficulty:Easy_(15-30_min) @Week_7:_Incremental_Processing
08 Implement full table overwrite pattern difficulty:Easy_(15-30_min) @Week_7:_Incremental_Processing
09 Implement merge/upsert pattern difficulty:Medium_(30-45_min) @Week_7:_Incremental_Processing
10 Use COPY INTO for idempotent loads difficulty:Medium_(30-45_min) @Week_7:_Incremental_Processing
11 Configure COPY INTO file filtering difficulty:Medium_(30-45_min) @Week_7:_Incremental_Processing
12 Test COPY INTO with duplicate files difficulty:Medium_(30-45_min) @Week_7:_Incremental_Processing
01 Read data with spark.read difficulty:Easy_(15-30_min) @Week_8:_Transformations
02 Filter rows with .filter() and .where() difficulty:Easy_(15-30_min) @Week_8:_Transformations
03 Select and rename columns difficulty:Easy_(15-30_min) @Week_8:_Transformations
04 Add computed columns with .withColumn() difficulty:Easy_(15-30_min) @Week_8:_Transformations
05 Drop columns with .drop() difficulty:Easy_(15-30_min) @Week_8:_Transformations
06 Handle NULL values (fillna, dropna) difficulty:Medium_(30-45_min) @Week_8:_Transformations
07 Cast column data types difficulty:Easy_(15-30_min) @Week_8:_Transformations
08 Use SQL functions (col, lit, concat, etc.) difficulty:Easy_(15-30_min) @Week_8:_Transformations
09 Perform GROUP BY aggregations difficulty:Easy_(15-30_min) @Week_8:_Transformations
10 Use multiple aggregation functions difficulty:Easy_(15-30_min) @Week_8:_Transformations
11 Use window functions (row_number, rank, lag) difficulty:Medium_(30-45_min) @Week_8:_Transformations
12 Partition window functions difficulty:Medium_(30-45_min) @Week_8:_Transformations
13 Order within window partitions difficulty:Medium_(30-45_min) @Week_8:_Transformations
14 Perform inner join difficulty:Easy_(15-30_min) @Week_8:_Transformations
15 Perform left/right outer join difficulty:Easy_(15-30_min) @Week_8:_Transformations
16 Perform full outer join difficulty:Medium_(30-45_min) @Week_8:_Transformations
17 Handle join key mismatches difficulty:Medium_(30-45_min) @Week_8:_Transformations
18 Union DataFrames difficulty:Easy_(15-30_min) @Week_8:_Transformations
19 Use broadcast joins for small tables difficulty:Medium_(30-45_min) @Week_8:_Transformations
01 CREATE DATABASE/SCHEMA difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
02 USE database command difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
03 SHOW TABLES command difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
04 DESCRIBE TABLE command difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
05 DESCRIBE EXTENDED for metadata difficulty:Medium_(30-45_min) @Week_9:_SQL_&_Views
06 DROP TABLE command difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
07 ALTER TABLE ADD COLUMN difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
08 ALTER TABLE RENAME difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
09 Create VIEW difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
10 Create TEMPORARY VIEW difficulty:Medium_(30-45_min) @Week_9:_SQL_&_Views
11 Create GLOBAL TEMPORARY VIEW difficulty:Medium_(30-45_min) @Week_9:_SQL_&_Views
12 Understand view lifecycle and scope difficulty:Medium_(30-45_min) @Week_9:_SQL_&_Views
13 Query information_schema for metadata difficulty:Medium_(30-45_min) @Week_9:_SQL_&_Views
14 Use CTEs (Common Table Expressions) difficulty:Easy_(15-30_min) @Week_9:_SQL_&_Views
01 Define DLT streaming table difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
02 Define DLT materialized view difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
03 Define DLT view (non-materialized) difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
04 Understand table/view differences in DLT difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
05 Use @dlt.table decorator difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
06 Configure table properties in DLT difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
07 Use STREAMING keyword difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
08 Create DLT pipeline in UI difficulty:Easy_(15-30_min) @Week_10:_Delta_Live_Tables
09 Configure pipeline mode (triggered/continuous) difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
10 Set pipeline target schema difficulty:Easy_(15-30_min) @Week_10:_Delta_Live_Tables
11 Configure pipeline storage location difficulty:Easy_(15-30_min) @Week_10:_Delta_Live_Tables
12 Add expectations for data quality difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
13 Use expect/expect or drop/expect or fail difficulty:Hard_(45-60_min) @Week_10:_Delta_Live_Tables
14 View DLT event log difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
15 Chain DLT tables (table dependencies) difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
16 Read from streaming source in DLT difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
17 Apply transformations in DLT difficulty:Easy_(15-30_min) @Week_10:_Delta_Live_Tables
18 Test DLT pipeline execution difficulty:Medium_(30-45_min) @Week_10:_Delta_Live_Tables
19 Understand DLT auto-scaling difficulty:Hard_(45-60_min) @Week_10:_Delta_Live_Tables
01 Create single-task job difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
02 Create multi-task job difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
03 Configure task dependencies difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
04 Set job schedule (cron expression) difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
05 Configure job cluster vs. existing cluster difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
06 Set job timeout settings difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
07 Configure retry policy difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
08 Add job parameters difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
09 Use job parameters in notebook difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
10 View job run history difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
11 Understand job run states difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
12 Monitor task-level execution difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
13 View job logs difficulty:Easy_(15-30_min) @Week_11:_Workflows_&_Jobs
14 Set up job failure alerts difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
15 Understand job repair runs difficulty:Medium_(30-45_min) @Week_11:_Workflows_&_Jobs
01 Understand 3-level namespace (catalog.schema.table) difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
02 Create catalog difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
03 Create schema within catalog difficulty:Easy_(15-30_min) @Week_12:_Unity_Catalog
04 Create tables in Unity Catalog difficulty:Easy_(15-30_min) @Week_12:_Unity_Catalog
05 Query tables with fully qualified names difficulty:Easy_(15-30_min) @Week_12:_Unity_Catalog
06 Use USE CATALOG and USE SCHEMA difficulty:Easy_(15-30_min) @Week_12:_Unity_Catalog
07 Understand metastore concept difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
08 Grant SELECT privilege on table difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
09 Grant MODIFY privilege on table difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
10 Grant CREATE privilege on schema difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
11 Grant USAGE privilege on catalog difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
12 Revoke privileges difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
13 Understand privilege inheritance difficulty:Hard_(45-60_min) @Week_12:_Unity_Catalog
14 Query system tables for permissions difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
15 Create managed table in Unity Catalog difficulty:Easy_(15-30_min) @Week_12:_Unity_Catalog
16 Create external table with location difficulty:Medium_(30-45_min) @Week_12:_Unity_Catalog
17 Understand storage credential concept difficulty:Hard_(45-60_min) @Week_12:_Unity_Catalog
18 Understand external location concept difficulty:Hard_(45-60_min) @Week_12:_Unity_Catalog
19 Query table metadata (DESCRIBE EXTENDED) difficulty:Easy_(15-30_min) @Week_12:_Unity_Catalog
01 Use EXPLAIN command to view query plan difficulty:Medium_(30-45_min) @Week_13:_Performance
02 Identify full table scans in query plan difficulty:Medium_(30-45_min) @Week_13:_Performance
03 Use partition pruning effectively difficulty:Medium_(30-45_min) @Week_13:_Performance
04 Configure adaptive query execution difficulty:Hard_(45-60_min) @Week_13:_Performance
05 Use caching for repeated queries difficulty:Medium_(30-45_min) @Week_13:_Performance
06 Understand broadcast vs. shuffle joins difficulty:Hard_(45-60_min) @Week_13:_Performance
07 Choose appropriate partition columns difficulty:Medium_(30-45_min) @Week_13:_Performance
08 Avoid over-partitioning (too many small files) difficulty:Medium_(30-45_min) @Week_13:_Performance
09 Use Z-ORDER on commonly filtered columns difficulty:Medium_(30-45_min) @Week_13:_Performance
10 Understand data skipping with min/max stats difficulty:Hard_(45-60_min) @Week_13:_Performance
11 Test query performance with different layouts difficulty:Medium_(30-45_min) @Week_13:_Performance
12 Avoid SELECT * in production code difficulty:Easy_(15-30_min) @Week_13:_Performance
13 Use explicit schemas vs. inference difficulty:Medium_(30-45_min) @Week_13:_Performance
14 Configure appropriate retention periods difficulty:Medium_(30-45_min) @Week_13:_Performance
15 Use table constraints when appropriate difficulty:Medium_(30-45_min) @Week_13:_Performance
16 Implement proper error handling difficulty:Easy_(15-30_min) @Week_13:_Performance
17 Use widgets for notebook parameters difficulty:Easy_(15-30_min) @Week_13:_Performance
01 Complete practice exam set 1 (50 questions) difficulty:Hard_(45-60_min) @Week_14:_Exam_Prep
02 Review incorrect answers from exam 1 difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
03 Test confusing concepts hands-on difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
04 Complete practice exam set 2 (50 questions) difficulty:Hard_(45-60_min) @Week_14:_Exam_Prep
05 Review incorrect answers from exam 2 difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
06 Create flashcards for weak areas difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
07 Complete practice exam set 3 (50 questions) difficulty:Hard_(45-60_min) @Week_14:_Exam_Prep
08 Take full-length mock exam (timed) difficulty:Hard_(45-60_min) @Week_14:_Exam_Prep
09 Score 80%+ on mock exam consistently difficulty:Hard_(45-60_min) @Week_14:_Exam_Prep
10 Review all 'gotcha' notes difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
11 Re-test top 10 confusing topics difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
12 Review Delta Lake transaction log difficulty:Easy_(15-30_min) @Week_14:_Exam_Prep
13 Review Auto Loader vs. COPY INTO difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
14 Review streaming triggers difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
15 Review Unity Catalog privileges difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
16 Review DLT expectations difficulty:Medium_(30-45_min) @Week_14:_Exam_Prep
17 Schedule actual exam date difficulty:Easy_(15-30_min) @Week_14:_Exam_Prep
18 Do light review day before exam difficulty:Easy_(15-30_min) @Week_14:_Exam_Prep
19 Take exam! difficulty:Easy_(15-30_min) @Week_14:_Exam_Prep