Overview
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.
This course consists of two four-hour modules.
Prerequisites
Participants should have:
- A working knowledge of SQL for data analysis. Learners should have attended QATSQL or have equivalent knowledge.
- Familiarity with data formats such as CSV, JSON, TXT, and Parquet
- Understanding of how data is created, stored, and managed
- Prior experience or familiarity with the Databricks Workspace UI
- A basic understanding of dashboard use in business intelligence
Target audience
This course is ideal for:
- Data analysts and BI professionals looking to use Databricks for SQL-based analytics
- Business professionals seeking to convert raw data into actionable insights
- Teams responsible for producing dashboards, reporting tools, and automated alerts
- Organisations adopting Databricks to scale data intelligence and self-service analytics
Delegates will learn how to
SQL Analytics on Databricks
In this course, you'll learn how to effectively use Databricks for data analytics, with a specific focus on Databricks SQL. As a Databricks Data Analyst, your responsibilities will include finding relevant data, analyzing it for potential applications, and transforming it into formats that provide valuable business insights.
You will also understand your role in managing data objects and how to manipulate them within the Databricks Data Intelligence Platform, using tools such as Notebooks, the SQL Editor, and Databricks SQL.
Additionally, you will learn about the importance of Unity Catalog in managing data assets and the overall platform. Finally, the course will provide an overview of how Databricks facilitates performance optimization and teach you how to access Query Insights to understand the processes occurring behind the scenes when executing SQL analytics on Databricks.
AI/BI for Data Analysts
In this course, you’ll learn how to use the features Databricks provides for business intelligence needs: AI/BI Dashboards and AI/BI Genie. As a Databricks Data Analyst, you will be tasked with creating AI/BI Dashboards and AI/BI Genie Spaces within the platform, managing the access to these assets by stakeholders and necessary parties, and maintaining these assets as they are edited, refreshed, or decommissioned over the course of their lifespan. This course intends to instruct participants on how to design dashboards for business insights, share those with collaborators and stakeholders, and maintain those assets within the platform. Participants will also learn how to utilize AI/BI Genie Spaces to support self-service analytics through the creation and maintenance of these environments powered by the Databricks Data Intelligence Engine.
Outline
SQL Analytics on Databricks
Data Discovery
- Using Unity Catalog as a Data Discovery Tool
- Understanding Data Object Ownership
- Use Unity Catalog to Locate and Inspect Datasets
Data Importing
- Ingesting Data into Databricks
- Uploading Data to Databricks Using the UI
- Programmatic Exploration and Data Ingestion to Unity Catalog
- Import Data into Databricks
SQL Execution
- Databricks SQL and Databricks SQL Warehouses
- The Unified SQL Editor
- Manipulate and Transform Data with Databricks SQL
- Creating Views with Databricks SQL
- Manipulate and Analyze a Table
Query Analysis
- Databricks Photon and Optimization in Databricks
- Query Insights
- Best Practices for SQL Analytics
AI/BI for Data Analysts
- Dashboards and Visualizations in Databricks
- AI/BI Dashboards
- Just enough SQL
- Designing Datasets for Dashboards
- Creating Visualizations and adding Summary Statistics to Dashboards
- AI Enhanced Features
- Filters
- Sharing Dashboards with Stakeholders and Others
- Managing Dashboards in Production
- Dashboard and Visualization Lab Activity
AI/BI Genie
- AI/BI Genie
- Developing Genie Spaces
- Sharing Genie Spaces
- AI/BI Genie Development Activity Lab
Databricks training partner
Maximise your data and AI potential with Databricks certified training. Bridge skills gaps across your organisation to accelerate data-driven innovation, by enabling teams to scale insights and deploy AI for business growth.
Frequently asked questions
How can I create an account on myQA.com?
There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.
If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".
If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.
Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.
How do QA’s virtual classroom courses work?
Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.
We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.
How do QA’s online courses work?
QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.
All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.
When will I receive my joining instructions?
Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.
When will I receive my certificate?
Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.