Data Analysis with Databricks SQL
Enroll in this course now
Description
This course provides a comprehensive introduction to Databricks SQL. You’ll 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 (for example, the ability to 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