Name [ DevCourseWeb.com ] Udemy - Mastering Databricks SQL Warehouse and Spark SQL

File Type video

Size 2.45GB

UpdateDate 2024-11-20

hash *****2E5791952E105621696A821BE60CF0DB1F

Hot 47

Files Get Bonus Downloads Here.url | 182B ~Get Your Files Here !/1. Introduction to Mastering Databricks SQL Warehouse and Spark SQL/1. Introduction.html | 197B ~Get Your Files Here !/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.86MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/10. Perform Operations to Insert and Update records in Bronze Users Table.mp4 | 38.40MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/11. Merge Incremental Data with Delete into Silver Users Table with Condition on.mp4 | 16.86MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/12. Exercise to Develop Merge Statement with Condition avoiding Column Names.mp4 | 17.07MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/2. Overview of Merge with Delete Real Life Scenario.mp4 | 17.33MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/3. Create Users Table using Delta format for Merge with Delete.mp4 | 34.51MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/4. Merge First Set of Records into Users Table.cmproj.mp4 | 26.18MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/5. Perform DML Operations on Users Table in Bronze Layer.mp4 | 27.33MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/6. Merge Updated Data into Users Table in Silver Layer.mp4 | 20.99MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/7. Scenarios for Merge into Databricks SQL Delta Tables.mp4 | 24.68MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/8. Reset Users Table to Merge Data Incrementally into the target table.mp4 | 22.10MB ~Get Your Files Here !/10. Merge Query Results and Data from Delta Table with Delete into Delta Tables u/9. Merge Into Databricks Table using Conditions on Updated Timestamp.mp4 | 43.49MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/1. Introduction to Getting Started with Basic SQL Queries using Databricks SQL.mp4 | 10.32MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/10. Overview of Unique or Distinct in Databricks SQL.mp4 | 12.82MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/11. Overview of Distinct to get unique records using Databricks SQL.mp4 | 31.75MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/12. Exercise - Get Distinct Count of Every Column.mp4 | 21.39MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/13. Create View using Query for Unique Records.mp4 | 34.91MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/14. Structure of SQL Query and Overview of Clauses.mp4 | 18.64MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/15. Overview of Comments in Databricks SQL Queries.mp4 | 38.07MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/2. Exploring Databricks Data Sets.mp4 | 17.34MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/3. Create Database and Temporary Table to Preview the Data.mp4 | 16.17MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/4. Understand Characteristics of Online Retail Dataset.mp4 | 21.63MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/5. Create External Table with Columns and Datatypes.mp4 | 29.33MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/6. Get Count of Not Null Values of all Columns using Databricks SQL.mp4 | 36.51MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/7. Overview of Stack or Unpivot or Transpose of Data.mp4 | 10.45MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/8. Transpose Data using Stack in Databricks SQL.mp4 | 36.10MB ~Get Your Files Here !/11. Getting Started with Basic SQL Queries using Databricks SQL/9. Transpose Not Null Counts into Multiple Rows using Databricks SQL.mp4 | 24.33MB ~Get Your Files Here !/2. Setup Course Material and Environment for Databricks SQL/1. Install Databricks CLI using Python 3 Pip Command.mp4 | 29.29MB ~Get Your Files Here !/2. Setup Course Material and Environment for Databricks SQL/2. Configure Databricks CLI using Token and Profile.mp4 | 48.13MB ~Get Your Files Here !/2. Setup Course Material and Environment for Databricks SQL/3. Setup Git Repository for Material and Data Sets related to Databricks SQL Course.mp4 | 10.38MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/1. Overview of Databricks SQL Platform - Introduction.mp4 | 21.92MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/10. Analyze JSON Data using Spark APIs.mp4 | 30.17MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/11. Analyze Delta Table Schemas using Spark APIs.mp4 | 19.31MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/12. Load Data from Spark Data Frames into Delta Tables.mp4 | 18.70MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/13. Run Adhoc Queries using Databricks SQL Editor to validate data.mp4 | 20.77MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/14. Overview of External Tables using Databricks SQL.mp4 | 18.45MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/15. Using COPY Command to Copy Data into Delta Tables.mp4 | 42.93MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/16. Manage Databricks SQL Endpoints.mp4 | 16.36MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/2. Run First Query using SQL Editor of Databricks SQL.mp4 | 25.49MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/3. Overview of Dashboards using Databricks SQL.mp4 | 12.37MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/4. Overview of Databricks SQL Data Explorer to review Metastore Database and Tables.mp4 | 12.54MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/5. Use Databricks SQL Editor to develop scripts or queries.mp4 | 25.04MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/6. Review Metadata of Tables using Databricks SQL Platform.mp4 | 19.82MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/7. Overview of loading data into retail_db tables.mp4 | 5.96MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/8. Configure Databricks CLI to push data into Databricks Platform.mp4 | 29.62MB ~Get Your Files Here !/3. Getting Started with Databricks SQL/9. Copy JSON Data into DBFS using Databricks CLI.mp4 | 48.00MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/1. Review Databases using Databricks SQL Data Explorer.mp4 | 11.54MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/2. Create Database or Schema using Databricks SQL.mp4 | 14.53MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/3. Using IF NOT EXISTS while Creating Databases using Databricks SQL.mp4 | 7.94MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/4. Listing or Showing Databases and Getting Metadata of Databases using Databricks.mp4 | 13.15MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/5. Understand Default Location of Databricks SQL Database or Schema.mp4 | 12.93MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/6. Create Database or Schema using Location in Databricks SQL Warehouse.mp4 | 12.53MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/7. Drop Databases in Databricks SQL Warehouse.mp4 | 20.29MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/8. Alter Database in Databricks SQL Warehouse.mp4 | 26.47MB ~Get Your Files Here !/4. Managing Databases using Databricks SQL Warehouse/9. Comments on Databases in Databricks SQL Warehouse.mp4 | 26.96MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/1. List Databases and Save Databricks SQL Script.mp4 | 6.70MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/10. Update Existing Records in Databricks SQL Warehouse table based on Null Values.mp4 | 15.15MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/11. Delete Existing Records in Databricks SQL Warehouse table.mp4 | 20.39MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/12. Cleanup Users Tables from Databricks SQL Warehouse Database or Schema.mp4 | 32.40MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/2. Create Table using Delta Format in Databricks SQL Warehouse.mp4 | 16.99MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/3. Understand Location and Using Clause to specify File Format for Databricks.mp4 | 33.80MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/4. Create External Table using Delta Format in Databricks SQL Warehouse.mp4 | 22.40MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/5. Drop External Table and Delete Folder in Databricks SQL Warehouse.mp4 | 29.36MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/6. Overview of DML or CRUD Operations using Databricks SQL.mp4 | 13.18MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/7. Insert Records into Databricks SQL Warehouse table.mp4 | 41.42MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/8. Insert Multiple Records into Databricks SQL Warehouse table.mp4 | 22.65MB ~Get Your Files Here !/5. Manage Delta Tables in Databricks SQL Warehouse/9. Update Existing Records in Databricks SQL Warehouse table.mp4 | 23.82MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/1. Getting Started with Databricks fs Commands using Databricks CLI.mp4 | 23.78MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/2. Create Folder in DBFS using Databricks CLI Commands.mp4 | 16.76MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/3. Copy Files from Local File System into DBFS using Databricks CLI Commands.mp4 | 48.93MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/4. Overwrite Files while Copying into DBFS using Databricks CLI Command.mp4 | 45.84MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/5. Understand Course Catalog Data in the files uploaded to DBFS.mp4 | 33.52MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/6. Options to Analyze Data using Databricks SQL Queries.mp4 | 9.09MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/7. Run Select Queries using DBFS Path in From Cluase.mp4 | 25.37MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/8. Run Queries using Temporary Views in Databricks SQL.mp4 | 35.10MB ~Get Your Files Here !/6. Setup Data Set for Databricks SQL Views and Copy Commands/9. Run Queries using External Tables in Databricks SQL.mp4 | 18.00MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/1. Queries to Process Values in JSON String Columns.mp4 | 10.31MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/2. Get Distinct and Count based on Key using Course Catalog Data.mp4 | 28.89MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/3. Filter Data using Basic Databricks SQL Queries using Course Catalog Data.mp4 | 27.63MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/4. Exploring Functions using Databricks SQL.mp4 | 33.06MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/5. Understand Record Column Values in Course Catalog Table.mp4 | 16.10MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/6. Processing JSON String Values using Databricks SQL Queries.mp4 | 48.80MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/7. Process Instructors JSON Records using Databricks SQL Queries.mp4 | 22.11MB ~Get Your Files Here !/7. Queries to Process Values in JSON String Columns/8. Create View for Instructors using Databricks SQL Queries.mp4 | 23.17MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/1. Create Delta Table for Course Catalog Data Set.mp4 | 23.06MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/2. Get File Names along with Data using Databricks SQL Queries.mp4 | 11.94MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/3. Overview of Databricks SQL COPY Command.mp4 | 20.99MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/4. Copy Data from single file into Delta Tables using Files.mp4 | 27.52MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/5. Copy Data from multiple files into Delta Tables using Files.mp4 | 15.73MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/6. Copy Data from multiple files into Delta Tables using Pattern.mp4 | 28.80MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/7. Create Course Catalog Table in Databricks SQL Warehouse with additional Column.mp4 | 22.75MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/8. Copy Data from Files using Queries into Delta Tables.mp4 | 37.84MB ~Get Your Files Here !/8. Copy Data into Delta Tables in Databricks SQL Warehouse/9. Validate Course Catalog Table in Bronze Layer.mp4 | 25.64MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/1. Introduction to Insert or Merge Query Results or View into Delta Tables using D.mp4 | 18.15MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/10. Merge Data into Instructors Table from Course Catalog using Databricks SQL.mp4 | 56.68MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/11. Exercise to merge Courses Data from Course Catalog into Courses Table.mp4 | 21.66MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/2. Create Course Catalog and Instructors Tables using Databricks SQL.mp4 | 30.22MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/3. Copy Data into Course Catalog Table from JSON Files using Databricks SQL.mp4 | 33.91MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/4. Insert Query Results into Delta Table using Databricks SQL.mp4 | 36.58MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/5. Exercise to Create Courses Table and Insert Data.mp4 | 10.94MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/6. Copy Instructors Data into Course Catalog Table from new file.mp4 | 22.64MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/7. Understand the Concept of Merge or Upsert in DML or CRUD Operations.mp4 | 10.19MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/8. Develop Query to Get the latest Instructors Records from Course Catalog Table.mp4 | 16.45MB ~Get Your Files Here !/9. Insert or Merge Query Results or View into Delta Tables using Databricks SQL/9. Overview of Merge Statement Syntax using Databricks SQL.mp4 | 23.59MB ~Get Your Files Here !/Bonus Resources.txt | 386B