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

Big Data Essentials
A Cloud Guru
Big Data
University of Adelaide via edX
Advanced Data Science with IBM
IBM via Coursera
Amazon EMR Getting Started (Indonesian)
Amazon Web Services via AWS Skill Builder
Analisar e preparar dados com o Amazon SageMaker Data Wrangler e o Amazon EMR (Português (Brasil)) | Lab - Analyze and Prepare Data with Amazon SageMaker Data Wrangler and Amazon EMR (Portuguese (Brazil))
Amazon Web Services via AWS Skill Builder