Data Analytics and Warehousing with Databricks SQL
Contact us to book this course
Learning Track
Data Analysis and SQL
Delivery methods
On-Site, Virtual
Duration
1 day
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
- Get Started with Databricks SQL
- Demonstrations: Setting up a Catalog and Schema, Data Importing, A Quick Query and Visualization
- Unity Catalog in Databricks SQL
- Databricks SQL Warehouses
- Demonstration: Delta Lake in Databricks SQL
- Demonstrations: Data Visualizations and Dashboards, Create Interactive Dashboards, Databricks SQL in Production
