Learn how to create and utilize SQL views in Databricks and Apache Spark for efficient data analysis and pipeline development. Explore techniques for creating replace views, working with common table expressions, excluding and exploring data, performing aggregation queries, and combining CTEs with case statements. Discover methods for creating permanent tables and dropping views, with practical demonstrations and homework exercises to reinforce your understanding. Access supplementary resources, including example notebooks and related videos, to enhance your learning experience and master the art of using SQL views in your data projects.
Using SQL Views in Databricks and Apache Spark - Lesson 12
Overview
Syllabus
Intro
Demo
Create a replace view
Common table expressions
Excluding and exploring data
Aggregation query
Combining common table expression with case statement
Creating a permanent table
Dropping views
Homework
Help
Solution
Wrap Up
Taught by
Bryan Cafferky
Related Courses
-
Handling Batch Data with Apache Spark on Databricks
-
Handling Batch Data with Apache Spark on Databricks
-
Intermediate SQL
-
Azure Databricks SQL Introduction and Deep Dive
-
Master Databricks and Apache Spark - SparkR Usage - Lesson 35
-
Using SQL Window Functions in Databricks and Apache Spark - Lesson 16
