Azure Databricks SQL Introduction and Deep Dive

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.

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