-
Course
- Data
Query Data with Databricks SQL
Databricks is quickly becoming a standard for modern data platforms. This course will teach you about the components of Databricks SQL, how they integrate into the Lakehouse, and how to write and optimize SQL statements to generate insight.
What you'll learn
Many companies now leverage Databricks to ingest and transform their data, and having a good knowledge of Databricks SQL is critical to understand and analyse that data.
In this course, Query Data with Databricks SQL, you’ll gain the ability to query data efficiently within Databricks SQL.
First, you’ll explore the Databricks SQL interface and gain an understanding of its various components such as warehouses, editor, and endpoints, and gain context on how they relate to the wider Lakehouse architecture and the various data sources it can have.
Next, you’ll discover how to write SQL queries against pre-existing datasets, first with simple queries but also with complex SQL functions to derive meaningful insight from the data.
Finally, you’ll learn how to optimize these queries so that they run effectively, understanding partitioning, indexing, and caching, and how you can diagnose performance bottlenecks by investigating the query profile.
When you’re finished with this course, you’ll have the skills and knowledge of Databricks SQL needed to query data effectively.
Table of contents
About the author
Lewis is a Microsoft Data Platform specialist with 15 years of experience, including expertise in Power BI, Microsoft Fabric, and Azure SQL. He presents regularly in the UK at various events.
More Courses by Lewis