Dive into Azure Databricks Structured Query Language (SQL) in this comprehensive 45-minute tutorial. Learn powerful techniques and essential tips for using SQL in Databricks notebooks. Explore SparkSQL syntax requirements, SQL in cells and databases, widgets, and common table expressions. Discover how to create and manage tables, use temporary views, and implement pivot tables. Master case statements and gain insights into coding errors and troubleshooting. Access accompanying slides, code, and sample files on GitHub to enhance your learning experience.
Azure Databricks SQL Introduction and Deep Dive
Overview
Syllabus
Introduction
Spark
SQL
syntactic requirements
Notebooks
SQL in Cells
Widgets
Dropdown
Query
Widget
Race
Multiselect
Birthweight
Get Argument
SQL in Spark
SQL in databases
Download datasets
Use statement
Explain query
Columns
Show Create Table
Show Table Properties
Create Temporary Table
Summary
Drop Table
Select from Table
Select from Default
Coding Errors
Refresh
Views
Temporary Views
Common Table Expressions
Pivot Table
Map
Case Statements
Conclusion
Wrap Up
Taught by
Bryan Cafferky
Related Courses
-
Write advanced Transact-SQL queries
-
Implement a data lakehouse analytics solution with Azure Databricks
-
Perform data science with Azure Databricks
-
Build data analytics solutions using Azure Synapse serverless SQL pools
-
Work with Data Warehouses using Azure Synapse Analytics
-
Using SQL Views in Databricks and Apache Spark - Lesson 12
