Data Analysis with Databricks SQL

Description

This course provides a comprehensive introduction to Databricks SQL. Learners will ingest data, write queries, produce visualizations and dashboards, and configure alerts.

This course will prepare you to take the Databricks Certified Data Analyst Associate exam.

Duration

1 full day or 2 half days

Objectives

• Import data and persist it in Databricks SQL as tables and views
• Query data in Databricks SQL
• Use Databricks SQL to create visualizations and dashboards
• Create Alerts to notify stakeholders of specific events
• Share queries and dashboards with others

Prerequisites

• Basic SQL experience (e.g. can write a basic select from where clause)

Outline

Day 1

• Databricks SQL overview
• Tables and views
• Ingesting data
• Delta Commands in Databricks SQL
• Data visualization and dashboards
• Notifying Stakeholders
• Final lab assessment

Location

Online – Virtual