Data Modeling Strategies

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.

Note: Databricks Academy is transitioning from video lectures to a more streamlined PDF format with slides and notes for all self-paced courses. Please note that demo videos will still be available in their original format. We would love to hear your thoughts on this change, so please share your feedback through the course survey at the end. Thank you for being a part of our learning community!

Languages Available: English | 日本語 | Português BR | 한국어 

In this course, you will explore core SQL programming and procedural logic skills within Databricks, focusing on how to build modular, maintainable, and production-ready analytics workflows. You’ll start by learning about key SQL constructs—such as Common Table Expressions (including advanced recursive CTEs), session-scoped objects like temporary views and tables, and User Defined Functions—that make your SQL development cleaner and more reusable. The course then guides you through advanced SQL scripting techniques using compound statements, variables, control flow, conditionals, loops, and robust error handling to create structured and flexible SQL processes. You will also learn how to guarantee data consistency across these multi-step pipelines using ACID-compliant multi-statement transactions. Finally, you’ll discover how to encapsulate logic into SQL Stored Procedures and orchestrate complex workflows with Lakeflow Jobs and migration strategies, transforming legacy tasks into modular, automated pipelines that leverage the full capabilities of the Databricks platform.

Note: Databricks Academy is transitioning from video lectures to a more streamlined PDF format with slides and notes for all self-paced courses. Please note that demo videos will still be available in their original format. We would love to hear your thoughts on this change, so please share your feedback through the course survey at the end. Thank you for being a part of our learning community!

In this course, you will explore how Unity Catalog enables secure, centralized data governance and fine-grained access control on Databricks. You will learn about table and volume types, catalog and schema configuration, group-based access management, and strategies for migrating existing access controls into Unity Catalog. The course also explains how to design and apply fine-grained controls such as row-level security, column masking, and attribute-based access control, how to combine these mechanisms across data and AI assets, and how to align them with broader governance requirements for compliant, scalable access management.

Languages Available: English | 日本語 | 한국어