Data Warehousing Practitioner

DATB-DW : Data Warehousing with Databricks

Course Duration

4 Hours

Delivery

ILT/VILT

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

This course is designed for professionals who:

Are data analysts, BI engineers, or data warehousing practitioners who want to leverage the Databricks Lakehouse Platform as a modern, cloud-native data warehouse.
Are responsible for ingesting, transforming, and analysing large volumes of structured (and semi-structured) data with SQL, dashboards or BI tools, and want to work in a unified environment.
Want to implement or optimise data-warehousing workflows: defining schemas/tables, ETL/ELT pipelines, serverless SQL warehouses, and performing data governance and monitoring.
Have working knowledge of SQL and basic data-warehousing concepts (such as tables, schemas, ETL/ELT) and now wish to deepen their platform-specific skills using Databricks.
Are part of teams moving from legacy data-warehouse or siloed environments to a modern lakehouse architecture, and seek practical hands-on experience with Databricks features such as SQL warehouses, dashboards, tagging, monitoring and AI-driven data exploration.

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...

1.Data Warehousing with Databricks

1.1.Databricks Overview

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

1.2.Ingesting and Transforming Data

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

1.3.Orchestration

Introduction to Workflows
Demo: Exploring Workflow Capabilities

1.4.Monitoring

Tagging
System Tables
Cost Optimization

1.5.Visualization

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

1.6.Genie

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

1.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.