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

Advanced Relational Database and SQL
Coursera Project Network via Coursera
Analyzing Business Data in SQL
DataCamp
Combining and Filtering Data with MariaDB
Pluralsight
Advanced SQL for Data Science: Time Series
LinkedIn Learning
First Look: MySQL 8 for Developers
LinkedIn Learning