Skip to content

Latest commit

 

History

History
55 lines (41 loc) · 1.67 KB

File metadata and controls

55 lines (41 loc) · 1.67 KB
title ETL with Spark SQL and Python
type category
tags
etl
spark
sql
python
status published

ETL with Spark SQL and Python (29% of Exam)

The highest-weighted section covering data transformation and processing.

Topics Overview

flowchart TD
    ETL[ETL Processing] --> SQL[Spark SQL]
    ETL --> DF[DataFrames]
    ETL --> Joins[Joins & Aggregations]
    ETL --> UDFs[UDFs & Advanced]
Loading

Section Contents

File Topic Priority
01-spark-sql-fundamentals.md SQL queries, tables, views on Delta High
02-dataframe-operations.md DataFrame API, transformations, actions High
03-joins-aggregations.md Join types, grouping, aggregations High
04-advanced-transformations.md UDFs, window functions, complex operations High

Key Concepts

  • Spark SQL: SQL interface to structured data
  • DataFrames: Distributed collection of rows with schema
  • Transformations: Lazy operations (map, filter, select, etc.)
  • Actions: Operations that trigger execution (collect, write, etc.)

Related Resources

Next Steps

Progress to 03-Delta Lake to learn persistence and versioning.


← Back to Certification