Data Analysis with Databricks SQL

This course provides a comprehensive introduction to Databricks SQL, equipping learners with the skills to ingest data, write queries, produce visualizations, and configure alerts. Participants will gain hands-on experience with Databricks SQL capabilities, including data management, visualization, and dashboarding. The course also prepares learners for the Databricks Certified Data Analyst Associate exam.

By the end of this course, learners will be able to:

• Describe the key services and capabilities of Databricks SQL.
• Configure and manage Databricks SQL Warehouses and Unity Catalog.
• Perform data ingestion and querying in Databricks SQL.
• Develop visualizations and interactive dashboards.
• Implement security best practices for data management.
• Apply Databricks SQL in production environments.

Participants should have basic SQL experience, including the ability to write simple SELECT FROM WHERE queries.

If you do not have one or more of the pre-requisites QA recommends:

• QATSQL - Querying SQL Databases

Target Audience

This course is designed for:

• Data analysts who want to use Databricks SQL for querying and visualizing data.
• Business intelligence professionals looking to create dashboards and reports in Databricks.
• Data engineers who need to manage and optimize data ingestion and transformation in Databricks SQL.
• SQL developers aiming to expand their skills to include Databricks SQL and the Lakehouse architecture.
• Aspiring data professionals preparing for the Databricks Certified Data Analyst Associate exam.

Databricks SQL services and capabilities

• Introduction to Databricks SQL and its role in data analysis.
• Demonstrations:
  • Setting up a catalog and schema.
  • Data importing workflows.
  • Writing and executing basic queries.
  • Creating visualizations.
• Unity Catalog in Databricks SQL.
• Overview of the Lakehouse architecture.

Data management in Databricks SQL

• Understanding Databricks SQL Warehouses and their configurations.
• Demonstrations:
  • Implementing Delta Lake in Databricks SQL.
• Data security and access control mechanisms.

Data visualization and dashboarding

• Creating and customizing data visualizations.
• Building and managing interactive dashboards.
• Demonstrations and lab exercises:
  • Designing interactive dashboards.
  • Using Databricks SQL in production environments.

Exams and Assessments

This course does not include formal assessments but does prepare learners for the Databricks Certified Data Analyst Associate certification exam. The cost of the exam is not included with this course. Please speak to your account manager to add it to your order.

Hands-On Learning

This course includes:

• Live demonstrations of Databricks SQL setup, querying, and visualization.
• Guided lab exercises for data ingestion, transformation, and analysis.
• Practical dashboard creation tasks to reinforce learning.