Data Warehousing Practitioner

DATB-DW : Data Warehousing with Databricks

Course Duration

4 Hours

Delivery

ILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

This course is designed for data professionals who want to explore the data warehousing capabilities of Databricks. Assuming no prior knowledge of Databricks, it provides an introduction to leveraging Databricks as a modern cloud-based data warehousing solution. Learners will explore how use the Databricks Data Intelligence Platform to ingest, transform, govern, and analyze data efficiently using the industry-standard TCP-DI dataset as a reference. Learners will also explore Genie, an innovative Databricks feature that simplifies data exploration through natural language queries. By the end of this course, participants will be equipped with the foundational skills to implement and optimize a data warehouse using Databricks.

What You'll Learn

Databricks Overview
Ingesting and Transforming Data
Orchestration
Monitoring
Visualization
Genie
Power BI Integration

Who Should Attend

Data analysts, BI engineers and data-warehouse practitioners looking to build or modernise warehousing solutions on the Databricks Lakehouse Platform.
Professionals responsible for ingesting, transforming and analysing structured and semi-structured data using SQL and BI tools.
Individuals seeking to implement or optimise data-warehouse workflows, including schema design, ETL/ELT pipelines, serverless SQL warehouses and governance practices.
Practitioners with SQL experience who want to deepen their skills using Databricks features such as SQL warehouses, dashboards, monitoring and Unity Catalog.
Teams transitioning from legacy data-warehouse systems to a unified lakehouse architecture for improved performance, scalability and collaboration.

Prerequisites

Basic understanding of SQL and data querying concepts
General knowledge of data warehousing concepts, including tables, schemas, and ETL/ELT processes is recommended
Some experience with BI and/or data visualization tools is helpful but not required

Learning Journey

Coming Soon...

Module 1. Databricks Overview

Data Warehousing with Databricks
Unity Catalog Overview
Databricks SQL Warehouses
Demo: Databricks SQL Warehouses

Module 2. Ingesting and Transforming Data

Data Ingestion Techniques
Data Transformation
Demo: Ingesting Data
Demo: Exploring Data

Module 3. Orchestration

Introduction to Workflows
Demo: Exploring Workflow Capabilities

Module 4. Monitoring

Tagging
System Tables
Cost Optimization

Module 5. Visualization

Introduction to AI/BI
Demo: Creating and Managing a Dashboard
Lab: Creating a Dashboard Lab

Module 6. Genie

Introduction to Genie
Demo: Creating Genie Spaces
Lab: Genie Spaces Lab

Module 7. Power BI Integration

Power BI Integration
Star Schema Overview

Frequently Asked Questions (FAQs)

None

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By Databricks

Browse All Courses

Data Engineer

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name

Phone

I'm inquiring for

Myself

Company

Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.