Mastering Databricks SQL Warehouse and Spark SQL

[LeeAndro]

Published 09/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English | Duration: 105 lectures (7h 28m) | Size: 2.5 GB

Getting Started with Databricks SQL for Data Analysis or Data Eeering
Overview of building reports and dashboards using Databricks SQL
Creating Databases and Tables using Databricks SQL or Spark SQL
Writing Basic Queries using Databricks SQL or Spark SQL
DML to load data into Databricks SQL or Spark SQL Tables
Advanced Operations such as Ranking and Aggregations using Databricks SQL or Spark SQL
Processing Semi-Structured Data using Databricks SQL or Spark SQL

Basic SQL Skills and Data Analysis Skills
Computer with decent configuration and Internet

Databricks SQL Warehouse is relatively new technology to build Data Lakehouse or Data Warehouse leveraging powerful Apache Spark Ee where the analytics can be built at scale.​

As part of this comprehensive course, you will learn all key skills required to master Databricks SQL Warehouse including Spark SQL as the SQL in Databricks SQL Warehouse is based on Spark SQL.

This course also covers most of the curriculum relevant to clear the Databricks Certified Data Analyst Associate Exam offered by Databricks itself.

Here are the high-level details related to this course. This is a bner level course where you will be able to not only learn syntax and semantics of Databricks SQL or Spark SQL, you will also understand the concepts of the same.

Setup Course Material and Environment for Databricks SQL Warehouse

Managing Databases using Databricks SQL Warehouse

Manage Delta Tables in Databricks SQL Warehouse

Setup Data Set for Databricks SQL Views and Copy Commands

Databricks SQL or Spark SQL Queries to Process Values in JSON String Columns

Copy Data into Delta Tables in Databricks SQL Warehouse

Insert or Merge Spark SQL or Databricks SQL Query Results or View into Delta Tables

Merge Spark SQL or Databricks SQL Query Results and Data from Delta Table with Delete into Delta Tables

Basic SQL Queries using Spark SQL or Databricks SQL

Perfog Aggregations using Group By and filtering using Having leveraging Spark SQL or Databricks SQL

Aggregations using Windowing or Analytical Functions including Cumulative Aggregations using Spark SQL or Databricks SQL

Ranking using Windowing or Analytical Functions using Spark SQL or Databricks SQL

Dealing with different file formats such as parquet, json, csv, etc using Spark SQL or Databricks SQL

All Important types of Joins such as Inner, left or right outer, full outer using Spark SQL or Databricks SQL

Visualizations and Dashboards using Databricks SQL Warehouse

We have also provided quite a few exercises along with solutions with explanations through the course.

Key Takeaways of Mastering Databricks SQL and Spark SQL using Databricks SQL Warehouse

Setup Environment to learn Databricks SQL and Spark SQL using Azure

Support via Udemy Q&A backed by our expert team

Data Sets and Material via GitHub Repository along with instructions to practice Databricks SQL or Spark SQL

Life Access to High Quality Video Lectures to learn Databricks SQL and Spark SQL

Data Analysts and BI Developers who want to understand Databricks SQL or Spark SQL Queries to analyze the data
Data Eeers who would like to understand Databricks SQL
QA Analysts or Eeers who would like to understand Databricks SQL for the validation of the data
Business Analysts to analyze the Data in the Data Lake using Databricks SQL or Spark SQL Queries
BI Developers who want to understand how to connect BI Tools to Databricks SQL Endpoint and develop required reports and dashboards

HomePage:

https://anonymz.com/https://www.udemy.com/course/databricks-sql-warehouse-and-spark-sql/

DOWNLOAD

https://1dl.net/7zkx55wzxsta/r8THhhbi__Mastering_.part1.rar.html
https://1dl.net/nlaalkr47tzc/r8THhhbi__Mastering_.part2.rar.html
https://1dl.net/kkhck12q336r/r8THhhbi__Mastering_.part3.rar.html