Study guide

Databricks Spark Developer Associate study guide

Read a lesson, then practice the ideas you want to remember.

Lessons

  1. Built-in SQL Expressions and an Integrated Q
  2. SQL Join Semantics and Integrated Analytics
  3. SQL Queries, CTEs, Subqueries, and Built-in
  4. Window Functions and Complex Joins in Spark
  5. Dates, Unix Epoch, and Time-Zone Conversions
  6. Grouping, Multi-Dimensional Aggregations, an
  7. Data Sources, SaveModes, and Partitioning
  8. DataFrame Joins and Combining Datasets — Free Study Guide 2026
  9. Column Operations: Selecting, Renaming, Deri
  10. Complex Nested Types and User-Defined Functi
  11. DataFrame Construction, Schemas, and StructT
  12. Schema Inspection, Row Iteration, and List C
  13. Handling Missing and Null Data — Free Study Guide 2026
  14. Row Operations: Filtering, Sorting, and Dedu
  15. Spark Connect Architecture & Client-Server D
  16. Working with Spark Connect: Connections and
  17. Pandas API on Apache Spark: Core Architectur
  18. Pandas-on-Spark Operations, Indexing, and Op
  19. Caching, Persistence, and StorageLevels
  20. Memory Management, Fault Tolerance, and Garb
  21. Narrow vs Wide Dependencies and the Shuffle
  22. Driver, Executors, and Cluster Managers
  23. Execution Hierarchy: Applications, Jobs, Sta
  24. Lazy Evaluation, Transformations vs Actions,
  25. Spark Benefits, Modules, and DataFrame/Datas
  26. Managed vs External Tables and CTAS — Free Study Guide 2026
  27. SparkSession, Catalogs, Databases, and Names
  28. Views: Temporary vs Global Temporary Views
  29. JDBC Reads, Writes, and Parallelism — Free Study Guide 2026
  30. Direct File SQL, Save Modes, and Persistent
  31. Event-Time Processing, Watermarking, and Win
  32. Output Modes, Triggers, and Checkpointing
  33. Streaming Architecture, Sources, and Sinks
  34. Streaming Deduplication With and Without Wat
  35. Data Skew and Partition Tuning: repartition
  36. Diagnosing Performance with the Spark UI & E
  37. Join Optimization and Broadcast Hash Joins
  38. Broadcast Variables, Accumulators, and Closu
  39. Stateless UDFs, Stateful Operators, and Stat