Data Analytics and Warehousing with Databricks SQL
(1 day)
Course Description
This content provides a comprehensive introduction to Databricks SQL. It is designed to support individuals seeking the Associate Data Analysis of Databricks SQL certification. Participants will learn about ingesting data, writing queries, producing visualizations and dashboards, and connecting Databricks SQL to additional tools using Partner Connect.
Objectives
- Describe fundamental concepts about Databricks SQL.
- Define the terms metastore, catalog, schema, table, and view in the context of the Databricks DI Platform.
- Use the Databricks UI to create a catalog, schema, table, and view.
- Use the Databricks UI to upload data and create a managed table.
- Use the SQL Editor to complete multiple data analytics tasks.
- Create a data visualization associated with a query.
- Create an interactive dashboard.
- Create a refresh schedule and alert.
- Share data based assets in the Databricks DI Platform with others.
Prerequisites
At a minimum, you should be familiar with the following before attempting to take this content:
- General SQL fundamentals (e.g. write basic SELECT from statements)
Courses you should consider taking before taking this content include:
- Databricks Lakehouse Fundamentals
Course Outline
Module 1: Databricks SQL Services and Capabilities
- Get Started with Databricks SQL
- Demonstrations: Setting up a Catalog and Schema, Data Importing, A Quick Query and Visualization
- Unity Catalog in Databricks SQL
Module 2: Data Management in Databricks SQL
- Databricks SQL Warehouses
- Demonstration: Delta Lake in Databricks SQL
Module 3: Data Visualization and Dashboarding
- Demonstrations: Data Visualizations and Dashboards, Create Interactive Dashboards, Databricks SQL in Production
