Databricks SQL for Data Analysts

[Farid]

Databricks Sql For Data Analysts
Published 8/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.96 GB | Duration: 10h 5m
Master Azure Databricks SQL and Unity Catalog. Your Hands-On Guide to Data Analysis with Databricks

What you'll learn

Azure Databricks

SQL

Delta Lake

Unity Catalog

Data Visualization

Data Analysis

Big Data

Requirements

No prior experience needed

Azure Account (set up instructions provided)

Description

Databricks is one of the most in demand big data tools around. More than 9,000 organizations worldwide - including and over 40% of the Fortune 500 - rely on the Databricks Lakehouse Platform.We will be focussing specifically on the Databricks SQL Platform.Databricks SQL is a powerful tool used for querying and analyzing large datasets, making it highly relevant in today's data-driven world. Learning this skill can enhance your employability and career prospects.This course can be taken by experienced data analysts who are interested in learning about Databricks or even aspiring Data Analysis with no prior experience. I will teach you everything you need to know including how to code in SQL!It can also be taken as a guide for students who are aiming to achieve the Databricks Data Analyst Certification.The course is packed with lectures and hands-on development. This should be more than enough to keep you engaged and learning! The course is aimed at teaching you Data Analysis on Databricks, Unity Catalog and the Databricks Lakehouse Architecture.The curriculum is extensive and will cover a variety of areas including:Set Up and OverviewDatabricks QueriesStoring and Managing Data with DatabricksExternal and Managed TablesData Analysis with SQLData Lakehouse ArchitectureDelta File FormatData Visualization and DashboardsAccess Control and Data GovernanceUnity Catalog

Overview

Section 1: Set Up and Overview of Databricks

Lecture 1 Course Overview

Lecture 2 Introduction to Big Data (Optional)

Lecture 3 Apache Spark Ecosystem (Optional)

Lecture 4 Overview of Databricks

Lecture 5 Azure Account Set Up

Lecture 6 Azure Portal Overview

Lecture 7 Cost Management and Billing

Lecture 8 Creating a Databricks Premium Workspace

Lecture 9 Databricks Workspace User Interface

Lecture 10 Unity Catalog Overview

Lecture 11 Enabling Unity Catalog - Overview

Lecture 12 ADLS Overview and Storage Creation

Lecture 13 Access Connector for Databricks

Lecture 14 Enabling Unity Catalog

Lecture 15 Creating a SQL Warehouse

Section 2: Introduction to Queries

Lecture 16 Your First Query

Lecture 17 Switching Catalogs and Schemas

Lecture 18 Scheduling Queries

Lecture 19 Adding Comments to Queries

Lecture 20 Course Resources - SQL Code Download

Section 3: Catalogs, Schemas, Tables and Views

Lecture 21 Creating Catalogs

Lecture 22 Creating Schemas

Lecture 23 Data Types in Databricks SQL

Lecture 24 Overview of Tables in Databricks

Lecture 25 Creating Managed Tables with SQL

Lecture 26 Creating Managed Tables in Hive Metastore

Lecture 27 Creating Managed Tables using the Data Explorer

Lecture 28 Creating an External Storage Location

Lecture 29 Creating External Tables

Lecture 30 Overriding Unity Catalog's Default Managed Table Storage Location

Lecture 31 Truncate Table

Lecture 32 Alter Table

Lecture 33 Drop Tables, Schemas and Catalogs

Section 4: Data Analysis with SQL

Lecture 34 Select Statement Recap

Lecture 35 Select Distinct

Lecture 36 Note on the JC_BIKE_DATA_22 Table

Lecture 37 Filtering Records with the WHERE Clause

Lecture 38 Filtering Records Based on Multiple Conditions

Lecture 39 Filtering Records with the IN and LIKE Operators

Lecture 40 Deleting Records

Lecture 41 Databricks SQL Built In Functions Overview

Lecture 42 String Functions

Lecture 43 Numerical Functions

Lecture 44 Date and Timestamp Functions

Lecture 45 Converting Strings to Dates/Timestamps

Lecture 46 Conditional Functions

Lecture 47 Aggregate Functions

Lecture 48 Group By Clause

Lecture 49 Filtering Aggregated Tables with the Having Clause

Lecture 50 Joining Tables Overview

Lecture 51 Joining Tables Demo

Lecture 52 Order By and Limit Clauses

Lecture 53 SQL Order of Execution

Lecture 54 Subqueries

Lecture 55 Views

Lecture 56 Set Operators

Lecture 57 SQL Challenge 1

Lecture 58 SQL Challenge 2

Lecture 59 SQL Challenge 3

Lecture 60 SQL Challenge 4

Lecture 61 SQL Challenge 5

Lecture 62 Schema Clean Up

Section 5: Delta Lake

Lecture 63 Medallion Architecture and Last Mile ETL

Lecture 64 Medallion Architecture Demo

Lecture 65 Benefits of Delta File Format

Lecture 66 Upsert / Merge Into

Lecture 67 Table Audit History and Time Travel

Section 6: Query Alerts and Monitoring

Lecture 68 Query History and Profile

Lecture 69 Query Caching in Databricks SQL

Lecture 70 Query Alerts

Section 7: Visualizations and Dashboards in Databricks SQL

Lecture 71 Visualizations and Dashboards Overview

Lecture 72 Our First Chart in Databricks SQL

Lecture 73 Line and Area Charts

Lecture 74 Combo Chart

Lecture 75 Pie Chart

Lecture 76 Scatter and Bubble Plots

Lecture 77 Histograms

Lecture 78 Box Plots

Lecture 79 Heatmaps

Lecture 80 Sankey Charts

Lecture 81 Tables

Lecture 82 Pivot Tables

Lecture 83 Counters

Lecture 84 Additional Guidance on Charts in Databricks SQL

Lecture 85 Exploratory Data Analysis - Challenge

Lecture 86 Adding Missing Data to the JC_BIKE_DATA_22 Table

Lecture 87 Creating a View to Simplify Upcoming Demos

Lecture 88 Query Filters

Lecture 89 Query Parameters

Lecture 90 Query Parameters (Dates)

Lecture 91 Introduction to Dashboards

Lecture 92 Adding Parameters to Dashboards

Lecture 93 Adding Filters to Dashboards

Lecture 94 Trip Duration Analysis Challenge

Lecture 95 Rider Type Analysis Challenge

Section 8: Access Control, Data Governance and Unity Catalog

Lecture 96 Administrative Roles in Databricks

Lecture 97 Adding a New User to our Azure Account

Lecture 98 Adding a New User to our Databricks Environment

Lecture 99 Workspace Admin Settings

Lecture 100 Workspace Object Access Control

Lecture 101 SQL Warehouse Access Control

Lecture 102 Folder Access Control

Lecture 103 Query Access Control

Lecture 104 Dashboard Access Control

Lecture 105 Workspace Object Access Control - Summary

Lecture 106 Unity Catalog Securable Objects and Priveledges

Lecture 107 Granting and Revoking Privileges with SQL (Unity Catalog)

Lecture 108 Granting and Revoking Privileges via the Data Explorer (Unity Catalog)

Lecture 109 Redacting Data with Dynamic Views (PII)

Lecture 110 Data Discovery

Lecture 111 Data Lineage

Lecture 112 Delta Sharing Overview

Lecture 113 Databricks to Databricks Delta Sharing

Lecture 114 Open Delta Sharing

Section 9: Congratulations on completing the course!

Lecture 115 Congratulations

Lecture 116 Bonus Lecture

Anyone wanting to learn Databricks SQL,Students studying for the Databricks Data Analyst Certification,Aspiring Cloud Data Analysts

Databricks SQL for Data Analysts (4.96 GB)

KatFile Link(s)

[To see links please register or login]

RapidGator Link(s)

[To see links please register or login]