Udemy - Mastering Databricks SQL Warehouse and Spark SQL

seeders: 1
leechers: 32
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Mastering Databricks SQL Warehouse and Spark SQL
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction to Mastering Databricks SQL Warehouse and Spark SQL
    • 1. Introduction.html (0.2 KB)
    10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u
    • 1. Introduction to Merge Query Results and Data from Delta Table with Delete in.mp4 (13.9 MB)
    • 10. Perform Operations to Insert and Update records in Bronze Users Table.mp4 (38.4 MB)
    • 11. Merge Incremental Data with Delete into Silver Users Table with Condition on.mp4 (16.9 MB)
    • 12. Exercise to Develop Merge Statement with Condition avoiding Column Names.mp4 (17.1 MB)
    • 2. Overview of Merge with Delete Real Life Scenario.mp4 (17.3 MB)
    • 3. Create Users Table using Delta format for Merge with Delete.mp4 (34.5 MB)
    • 4. Merge First Set of Records into Users Table.cmproj.mp4 (26.2 MB)
    • 5. Perform DML Operations on Users Table in Bronze Layer.mp4 (27.3 MB)
    • 6. Merge Updated Data into Users Table in Silver Layer.mp4 (21.0 MB)
    • 7. Scenarios for Merge into Databricks SQL Delta Tables.mp4 (24.7 MB)
    • 8. Reset Users Table to Merge Data Incrementally into the target table.mp4 (22.1 MB)
    • 9. Merge Into Databricks Table using Conditions on Updated Timestamp.mp4 (43.5 MB)
    11. Getting Started with Basic SQL Queries using Databricks SQL
    • 1. Introduction to Getting Started with Basic SQL Queries using Databricks SQL.mp4 (10.3 MB)
    • 10. Overview of Unique or Distinct in Databricks SQL.mp4 (12.8 MB)
    • 11. Overview of Distinct to get unique records using Databricks SQL.mp4 (31.8 MB)
    • 12. Exercise - Get Distinct Count of Every Column.mp4 (21.4 MB)
    • 13. Create View using Query for Unique Records.mp4 (34.9 MB)
    • 14. Structure of SQL Query and Overview of Clauses.mp4 (18.6 MB)
    • 15. Overview of Comments in Databricks SQL Queries.mp4 (38.1 MB)
    • 2. Exploring Databricks Data Sets.mp4 (17.3 MB)
    • 3. Create Database and Temporary Table to Preview the Data.mp4 (16.2 MB)
    • 4. Understand Characteristics of Online Retail Dataset.mp4 (21.6 MB)
    • 5. Create External Table with Columns and Datatypes.mp4 (29.3 MB)
    • 6. Get Count of Not Null Values of all Columns using Databricks SQL.mp4 (36.5 MB)
    • 7. Overview of Stack or Unpivot or Transpose of Data.mp4 (10.5 MB)
    • 8. Transpose Data using Stack in Databricks SQL.mp4 (36.1 MB)
    • 9. Transpose Not Null Counts into Multiple Rows using Databricks SQL.mp4 (24.3 MB)
    2. Setup Course Material and Environment for Databricks SQL
    • 1. Install Databricks CLI using Python 3 Pip Command.mp4 (29.3 MB)
    • 2. Configure Databricks CLI using Token and Profile.mp4 (48.1 MB)
    • 3. Setup Git Repository for Material and Data Sets related to Databricks SQL Course.mp4 (10.4 MB)
    3. Getting Started with Databricks SQL
    • 1. Overview of Databricks SQL Platform - Introduction.mp4 (21.9 MB)
    • 10. Analyze JSON Data using Spark APIs.mp4 (30.2 MB)
    • 11. Analyze Delta Table Schemas using Spark APIs.mp4 (19.3 MB)
    • 12. Load Data from Spark Data Frames into Delta Tables.mp4 (18.7 MB)
    • 13. Run Adhoc Queries using Databricks SQL Editor to validate data.mp4 (20.8 MB)
    • 14. Overview of External Tables using Databricks SQL.mp4 (18.4 MB)
    • 15. Using COPY Command to Copy Data into Delta Tables.mp4 (42.9 MB)
    • 16. Manage Databricks SQL Endpoints.mp4 (16.4 MB)
    • 2. Run First Query using SQL Editor of Databricks SQL.mp4 (25.5 MB)
    • 3. Overview of Dashboards using Databricks SQL.mp4 (12.4 MB)
    • 4. Overview of Databricks SQL Data Explorer to review Metastore Database and Tables.mp4 (12.5 MB)
    • 5. Use Databricks SQL Editor to develop scripts or queries.mp4 (25.0 MB)
    • 6. Review Metadata of Tables using Databricks SQL Platform.mp4 (19.8 MB)
    • 7. Overview of loading data into retail_db tables.mp4 (6.0 MB)
    • 8. Configure Databricks CLI to push data into Databricks Platform.mp4 (29.6 MB)
    • 9. Copy JSON Data into DBFS using Databricks CLI.mp4 (48.0 MB)
    4. Managing Databases using Databricks SQL Warehouse
    • 1. Review Databases using Databricks SQL Data Explorer.mp4 (11.5 MB)
    • 2. Create Database or Schema using Databricks SQL.mp4 (14.5 MB)
    • 3. Using IF NOT EXISTS while Creating Databases using Databricks SQL.mp4 (7.9 MB)
    • 4. Listing or Showing Databases and Getting Metadata of Databases using Databricks.mp4 (13.1 MB)
    • 5. Understand Default Location of Databricks SQL Database or Schema.mp4 (12.9 MB)
    • 6. Create Database or Schema using Location in Databricks SQL Warehouse.mp4 (12.5 MB)
    • 7. Drop Databases in Databricks SQL Warehouse.mp4 (20.3 MB)
    • 8. Alter Database in Databricks SQL Warehouse.mp4 (26.5 MB)
    • 9. Comments on Databases in Databricks SQL Warehouse.mp4 (27.0 MB)
    5. Manage Delta Tables in Databricks SQL Warehouse
    • 1. List Databases and Save Databricks SQL Script.mp4 (6.7 MB)
    • 10. Update Existing Records in Databricks SQL Warehouse table based on Null Values.mp4 (15.1 MB)
    • 11. Delete Existing Records in Databricks SQL Warehouse table.mp4 (20.4 MB)
    • 12. Cleanup Users Tables from Databricks SQL Warehouse Database or Schema.mp4 (32.4 MB)
    • 2. Create Table using Delta Format in Databricks SQL Warehouse.mp4 (17.0 MB)
    • 3. Understand Location and Using Clause to specify File Format for Databricks.mp4 (33.8 MB)
    • 4. Create External Table using Delta Format in Databricks SQL Warehouse.mp4 (22.4 MB)
    • 5. Drop External Table and Delete Folder in Databricks SQL Warehouse.mp4 (29.4 MB)
    • 6. Overview of DML or CRUD Operations using Databricks SQL.mp4 (13.2 MB)
    • 7. Insert Records into Databricks SQL Warehouse table.mp4 (41.4 MB)
    • 8. Insert Multiple Records into Databricks SQL Warehouse table.mp4 (22.7 MB)
    • 9. Update Existing Records in Databricks SQL Warehouse table.mp4 (23.8 MB)
    6. Setup Data Set for Databricks SQL Views and Copy Commands
    • 1. Getting Started with Databricks fs Commands using Databricks CLI.mp4 (23.8 MB)
    • 2. Create Folder in DBFS using Databricks CLI Commands.mp4 (16.8 MB)
    • 3. Copy Files from Local File System into DBFS using Databricks CLI Commands.mp4 (48.9 MB)
    • 4. Overwrite Files while Copying into DBFS using Databricks CLI Command.mp4 (45.8 MB)
    • 5. Understand Course Catalog Data in the files uploaded to DBFS.mp4 (33.5 MB)
    • 6. Options to Analyze Data using Databricks SQL Queries.mp4 (9.1 MB)
    • 7. Run Select Queries using DBFS Path in From Cluase.mp4 (25.4 MB)
    • 8. Run Queries using Temporary Views in Data

Description

Mastering Databricks SQL Warehouse and Spark SQL



https://DevCourseWeb.com

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

A Comprehensive Course on Databricks SQL Warehouse and Spark SQL for Data Engineers, Data Analysts, BI Developers, etc

What you'll learn
Getting Started with Databricks SQL for Data Analysis or Data Engineering
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

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



Download torrent
2.4 GB
seeders:1
leechers:32
Udemy - Mastering Databricks SQL Warehouse and Spark SQL

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
2.4 GB
seeders:1
leechers:32
Udemy - Mastering Databricks SQL Warehouse and Spark SQL

Torrent hash: 538D62E5791952E105621696A821BE60CF0DB1FE