
Loved by learners at thousands of companies
Course Description
Every organization has a need for a data warehousing capability to run critical business intelligence analyses. Over the years, there have been many different tools to satisfy these needs, but often were separate technology stacks that struggled to keep up with modern data needs and scale.Databricks is a powerful Data Intelligence Platform that can satisfy many of an organization's analytical needs. By leveraging Databricks SQL, an organization can utilize a hyper scalable and performant data warehouse solution directly in the lakehouse architecture.In this course, you will be introduced to the key components and workflows within Databricks SQL.First, you will learn how to use Databricks SQL to perform different data engineering tasks and moving your data through the medallion architecture to serve data teams. You will earn the common techniques many data engineers use, how to choose between different data storage techniques, and how to keep your data up to date.Next, you will learn how to analyze your data in Databricks SQL like many data analysts do in the industry. You will learn the common functions and techniques using ANSI based SQL, and will then create in-platform visualizations and dashboards to better tell a story about your data.Finally, you will learn some more advanced techniques that leverage the key differentiators of the Databricks platform. You will learn how to handle high-velocity and fast changing data using window functions, and will be able to merge datasets together as they come in.
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.- 1
Data Warehousing in Databricks
FreeBuild a strong data warehousing foundation with the Databricks Data Intelligence Platform! You will learn how Databricks and the lakehouse architecture set your organization up for a modern SQL and BI stack. You will also explore the key components of the Databricks SQL product, ranging from data storage techniques to compute optimizations.
- 2
Data engineering with Databricks SQL
Build a strong data foundation for the lakehouse architecture! You will learn how to ingest, transform, and model your data using the capabilities in Databricks SQL. You will explore GUI-based and programmatic approaches to building out the medallion architecture, and creating a data ecosystem ready for any analytics workload.
Ingesting Data50 xpGUI-based data ingest100 xpHydrating the lakehouse50 xpUpload data manually100 xpUsing COPY INTO100 xpLeveraging Auto Loader50 xpTransforming data50 xpSQL and the medallion architecture100 xpCreating a coffee data layer50 xpCleaning up raw tables100 xpCreating the silver layer100 xpCreating a table of large premium claims100 xp - 3
Data analysis with Databricks SQL
Create powerful data insights using Databricks SQL! You will learn how to write queries, create visualizations, and power dashboards using in-platform Databricks capabilities. You will practice leveraging SQL code, filters, and parameters to create a robust analytical application for your end users.
Querying in the Data Intelligence Platform50 xpAnalytical assets in Databricks SQL100 xpQuerying our coffee dataset50 xpAnalyzing insurance claims100 xpSupplementing queries with functions100 xpVisualizing query results100 xpCreating an analytics application50 xpThe role of Partner Connect50 xpA coffee data dashboard50 xpAdding filters to dashboards100 xpUsing parameters in queries100 xpCreate an executive dashboard100 xp - 4
Advanced patterns with Databricks SQL
In the final chapter, you will learn some more advanced techniques that leverage the key differentiators of the Databricks platform. You will learn how to handle high-velocity and fast-changing data using window functions, and will be able to merge datasets as they come in.
Common data engineering patterns50 xpAppend vs. CDC100 xpUpdating coffee sales data50 xpOptimizing data with SQL100 xpUsing INSERT100 xpUsing MERGE100 xpAdvanced data analysis patterns50 xpUnderstanding window functions and sub-queries50 xpAnalyzing coffee sales by store50 xpWriting a sub-query100 xpUsing a window function100 xpUsing windows and sub-queries together100 xpCourse recap50 xp
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.collaborators

Content Developer at DataCamp
Iason holds a Master’s degree in Chemistry from UCL and is now a Curriculum Manager at DataCamp. He is also a certified Power BI data analyst. Prior to working at DataCamp, Iason held a number of analytics roles within a range of industries across different countries. Having a passion for education, data, and storytelling, he has found a great place at DataCamp to develop engaging content for learning. As an avid sports fan, he has a keen interest in sports statistics.
Data Professional
Kevin has over a decade of experience working with data in various applications. He is passionate about helping people and companies find insights from their data and hopes to teach you some of the strategies and techniques he has learned throughout his career.
Join over 18 million learners and start Introduction to Databricks SQL today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.