Apache Spark™
Advanced for PySpark Developers Workshop 2 Days Online

@jaceklaskowski / StackOverflow / GitHub / LinkedIn
The "Internals" Books: Apache Spark / Spark SQL / Delta Lake

"The Internals Of" Online Books:

## Agenda

1. [The Internals of Structured Query Execution](spark-sql-internals-of-structured-query-execution.html)
              * [Exercise: How to add days (as values of a column) to date?](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/How-to-add-days-as-values-of-a-column-to-date.html)
            1. [Joins](spark-sql-joins.html)
              * [Exercise: Finding Most Populated Cities Per Country](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/Finding-Most-Populated-Cities-Per-Country.html)
            1. [Caching and Persistence](spark-sql-dataset-caching-and-persistence.html)
              * [Exercise: Finding 1st and 2nd Bestsellers Per Genre](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/Finding-1st-and-2nd-Bestsellers-Per-Genre.html)
            1. Web UI
              * [Exercise: Calculating Gap Between Current And Highest Salaries Per Department](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/Calculating-Gap-Between-Current-And-Highest-Salaries-Per-Department.html)
              * [Exercise: Using pivot for Cost Average and Collecting Values](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/Using-pivot-for-Cost-Average-and-Collecting-Values.html)
            1. Logical and Physical Query Optimizations
              * [Exercise: split function with variable delimiter per row](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/split-function-with-variable-delimiter-per-row.html)
              * [Exercise: Adding count to the source DataFrame](https://jaceklaskowski.github.io/spark-workshop/exercises/sql/adding-count-to-the-source-dataframe.html)
            1. [Adaptive Query Execution](https://books.japila.pl/spark-sql-internals/adaptive-query-execution/)

Apache Spark™
Advanced for PySpark Developers Workshop 2 Days Online

@jaceklaskowski / StackOverflow / GitHub / LinkedIn
The "Internals" Books: Apache Spark / Spark SQL / Delta Lake

In-Class Preparations

Make Instructor's Life Slightly Easier. Thanks!

Introduce Yourself

Schedule

Addendum

Apache Spark™Advanced for PySpark Developers Workshop 2 Days Online

@jaceklaskowski / StackOverflow / GitHub / LinkedIn The "Internals" Books: Apache Spark / Spark SQL / Delta Lake

In-Class Preparations

Make Instructor's Life Slightly Easier. Thanks!

Introduce Yourself

Schedule

Addendum

Apache Spark™
Advanced for PySpark Developers Workshop 2 Days Online

@jaceklaskowski / StackOverflow / GitHub / LinkedIn
The "Internals" Books: Apache Spark / Spark SQL / Delta Lake