Getting Started with Apache Spark SQL

Course Details
Code: SPARK-SQL-SELF
Tuition (USD): $75.00 • Self Paced
Generate a quote

This hands-on self-paced training course targets Analysts and Data Scientists getting started using Databricks to analyze big data with Apache Spark™ SQL. The course ends with a capstone project demonstrating Exploratory Data Analysis with Spark SQL on Databricks.

Skills Gained

  • Use the interactive Databricks notebook environment
  • Examine external data sets
  • Query existing data sets using Spark SQL
  • Visualize query results and data using the built-in Databricks visualization features
  • Perform exploratory data analysis using Spark SQL

Who Can Benefit

  • Primary Audience: Data Analysts
  • Secondary Audiences: Data Scientists and Engineers

Prerequisites

Knowledge of SQL — required.

Course Details

Course Outline

  • Getting Started and Accessing the Course
  • Querying Files with SQL
  • Aggregations, JOINs and Nested Queries
  • Uploading and Accessing Data
  • Querying JSON & Hierarchical Data with SQL
  • Querying Data Lakes with SQL
  • Capstone Project: Exploratory Data Analysis

Platforms

Supported platforms include Azure Databricks, Databricks Community Edition, and non-Azure Databricks.

  • If you're planning to use the course on Azure Databricks, select the "Azure Databricks" Platform option.
  • If you're planning to use the course on Databricks Community Edition or on a non-Azure version of Databricks, select the "Other Databricks" Platform option.

Format: SELF-PACED

The course is a series of six self-paced lessons plus a final capstone project performing Exploratory Data Analysis using Spark SQL on Databricks. Each lesson includes hands-on exercises.