Apache Spark 2 and 3 using Scala (Formerly CCA 175)

As part of this course, you will learn all the key skills to build Data Engineering Pipelines using Spark SQL and Data Frame APIs using Scala as Programming language. This course used to be CCA 175 Spark and Hadoop Developer course for the preparation of Certification Exam. As of 10/31/2021, the exam is sunset and we have renamed it to Apache Spark 2 and 3 using Scala 3 as it covers industry relevant topics beyond the scope of certification.

About Data Engineering

Data Engineering is nothing but processing the data depending upon our downstream needs. We need to build different pipelines such as Batch Pipelines, Streaming Pipelines, etc as part of Data Engineering. All roles related to Data Processing are consolidated under Data Engineering. Conventionally, they are known as ETL Development, Data Warehouse Development, etc.

Course Details

Here is the high level outline of the topics related to this course.

• Quick recap of Scala

• Data Engineering using Spark SQL

Let us, deep-dive into Spark SQL to understand how it can be used to build Data Engineering Pipelines. Spark with SQL will provide us the ability to leverage distributed computing capabilities of Spark coupled with easy-to-use developer-friendly SQL-style syntax.

1. Getting Started with Spark SQL

2. Basic Transformations

3. Managing Tables - Basic DDL and DML

4. Managing Tables - DML and Partitioning

5. Overview of Spark SQL Functions

6. Windowing Functions

• Data Engineering using Spark Data Frame APIs

Spark Data Frame APIs are an alternative way of building Data Engineering applications at scale leveraging distributed computing capabilities of Spark. Data Engineers from application development backgrounds might prefer Data Frame APIs over Spark SQL to build Data Engineering applications.

1. Data Processing Overview

2. Processing Column Data

3. Basic Transformations - Filtering, Aggregations, and Sorting

4. Joining Data Sets

5. Windowing Functions - Aggregations, Ranking, and Analytic Functions

6. Spark Metastore Databases and TablesPlease note that the syllabus is recently changed and now the exam is primarily focused on Spark Data Frames and/or Spark SQL.

All the demos are given on our state of the art Big Data cluster. You can avail one-month complimentary lab access by reaching out to support@itversity.com with Udemy receipt.