YoVDO

Using SQL Views in Databricks and Apache Spark - Lesson 12

Offered By: Bryan Cafferky via YouTube

Tags

Databricks Courses Data Analysis Courses Apache Spark Courses Data Aggregation Courses Common Table Expressions Courses

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 Analysis
University 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