Using SQL Views in Databricks and Apache Spark - Lesson 12
Offered By: Bryan Cafferky via YouTube
Course Description
Overview
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.
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
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX