Introduction to Databricks SQL
Course facts
- Payment: Free Preview (Paid Upgrade)
- Learning style: Self-paced, start anytime
- Format: Text & Interactive
- Video access: Streaming Only
- Before you start: Intermediate SQL; Introduction to Databricks
DataCamp details
- Chapters: 4
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Load, clean and model lakehouse data in Databricks SQL, then query it, build dashboards and keep tables current with MERGE and window functions.
Databricks SQL puts a data warehouse inside the lakehouse, so business intelligence queries run on the same platform that stores the data rather than on a separate warehousing tool. You load raw files, clean and layer them through the medallion architecture, and query coffee sales and insurance claims data with ANSI-based SQL before presenting results in dashboards. Later lessons deal with fast-changing records: choosing between appending rows and capturing changes, and merging new data as it arrives.
What You Will Achieve
- Bring raw files into lakehouse tables and choose a suitable ingestion approach for each source
- Clean raw tables and promote the data through medallion layers ready for analytics teams
- Build an executive dashboard with filters and query parameters for end users
- Keep sales tables up to date as new records arrive and compare stores with windowed calculations
Program Overview
Data Warehousing and Engineering in the Lakehouse
Introduces Databricks SQL within the Data Intelligence Platform, then ingests, cleans and models data into layered tables.
- Lakehouse benefits and Databricks SQL key assets
- Manual uploads, COPY INTO and Auto Loader
- Cleaning raw tables and building a silver layer
- A table of large premium claims
Analytical Queries, Visualizations and Dashboards
Writes queries against coffee and insurance claims data, adds functions, and turns the results into dashboards for end users.
- Querying with SQL functions
- Visualizing query results
- Dashboard filters and query parameters
- The role of Partner Connect
Advanced Databricks SQL Patterns
Handles high-velocity data and deeper analysis with the platform’s update commands, window functions and sub-queries.
- Append vs. CDC loading patterns
- INSERT and MERGE for updating data
- Window functions and sub-queries
- Coffee sales analysis by store
Certificate Awarded (Paid)
Job Outlook
These skills apply on data engineering and analytics teams that run warehousing, reporting and dashboard work on a Databricks lakehouse.
Good for: Data engineers and analysts whose team runs, or plans to run, its warehouse and BI dashboards on the Databricks lakehouse.
Keep in mind: It is tied to one platform: ingestion, dashboards and merge patterns are all taught through Databricks SQL features such as Auto Loader and Partner Connect.
Bottom line: Following one coffee dataset through ingestion, cleanup, dashboards and incremental updates gives the Databricks SQL workflow a clear single thread.
Frequently Asked Questions
What is the medallion architecture in Databricks SQL?
It is a way of organizing lakehouse data into bronze, silver and gold layers. In the lessons you create a coffee data layer, clean up the raw tables and build a silver layer that is ready for analysis.
Which datasets are used in the exercises?
Most exercises work with coffee sales data, which you ingest, clean, query, chart and later update. A second dataset of insurance claims is used to build a table of large premium claims and to practice analytical queries.
How does the course handle data that changes often?
The final chapter compares appending new rows with CDC, then uses INSERT and MERGE to update coffee sales data. It also applies window functions and sub-queries, separately and together, to analyze sales by store.
What ways of loading data into the lakehouse are shown?
The ingestion lessons cover a GUI-based ingest and a manual file upload, then the programmatic options COPY INTO and Auto Loader, so you can see how each method fills lakehouse tables.
User Reviews
No reviews yet. Be the first to review this course.
Write your review Cancel reply
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in, then you will return here to post.


There are no reviews yet.