| 1. Create Delta Table for Course Catalog Data Set.mp4 | 23.1 MB | ||
| 1. Getting Started with Databricks fs Commands using Databricks CLI.mp4 | 23.8 MB | ||
| 1. Install Databricks CLI using Python 3 Pip Command.mp4 | 29.3 MB | ||
| 1. Introduction to Getting Started with Basic SQL Queries using Databricks SQL.mp4 | 10.3 MB | ||
| 1. Introduction to Insert or Merge Query Results or View into Delta Tables using D.mp4 | 18.2 MB | ||
| 1. Introduction to Merge Query Results and Data from Delta Table with Delete in.mp4 | 13.9 MB | ||
| 1. Introduction.html | 204.8 B | ||
| 1. List Databases and Save Databricks SQL Script.mp4 | 6.7 MB | ||
| 1. Overview of Databricks SQL Platform - Introduction.mp4 | 21.9 MB | ||
| 1. Queries to Process Values in JSON String Columns.mp4 | 10.3 MB | ||
| 1. Review Databases using Databricks SQL Data Explorer.mp4 | 11.5 MB | ||
| 10. Analyze JSON Data using Spark APIs.mp4 | 30.2 MB | ||
| 10. Merge Data into Instructors Table from Course Catalog using Databricks SQL.mp4 | 56.7 MB | ||
| 10. Overview of Unique or Distinct in Databricks SQL.mp4 | 12.8 MB | ||
| 10. Perform Operations to Insert and Update records in Bronze Users Table.mp4 | 38.4 MB | ||
| 10. Update Existing Records in Databricks SQL Warehouse table based on Null Values.mp4 | 15.1 MB | ||
| 11. Analyze Delta Table Schemas using Spark APIs.mp4 | 19.3 MB | ||
| 11. Delete Existing Records in Databricks SQL Warehouse table.mp4 | 20.4 MB | ||
| 11. Exercise to merge Courses Data from Course Catalog into Courses Table.mp4 | 21.7 MB | ||
| 11. Merge Incremental Data with Delete into Silver Users Table with Condition on.mp4 | 16.9 MB | ||
| 11. Overview of Distinct to get unique records using Databricks SQL.mp4 | 31.8 MB | ||
| 12. Cleanup Users Tables from Databricks SQL Warehouse Database or Schema.mp4 | 32.4 MB | ||
| 12. Exercise - Get Distinct Count of Every Column.mp4 | 21.4 MB | ||
| 12. Exercise to Develop Merge Statement with Condition avoiding Column Names.mp4 | 17.1 MB | ||
| 12. Load Data from Spark Data Frames into Delta Tables.mp4 | 18.7 MB | ||
| 13. Create View using Query for Unique Records.mp4 | 34.9 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 | ||
| 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 | ||
| 15. Using COPY Command to Copy Data into Delta Tables.mp4 | 42.9 MB | ||
| 16. Manage Databricks SQL Endpoints.mp4 | 16.4 MB | ||
| 2. Configure Databricks CLI using Token and Profile.mp4 | 48.1 MB | ||
| 2. Create Course Catalog and Instructors Tables using Databricks SQL.mp4 | 30.2 MB | ||
| 2. Create Database or Schema using Databricks SQL.mp4 | 14.5 MB | ||
| 2. Create Folder in DBFS using Databricks CLI Commands.mp4 | 16.8 MB | ||
| 2. Create Table using Delta Format in Databricks SQL Warehouse.mp4 | 17 MB | ||
| 2. Exploring Databricks Data Sets.mp4 | 17.3 MB | ||
| 2. Get Distinct and Count based on Key using Course Catalog Data.mp4 | 28.9 MB | ||
| 2. Get File Names along with Data using Databricks SQL Queries.mp4 | 11.9 MB | ||
| 2. Overview of Merge with Delete Real Life Scenario.mp4 | 17.3 MB | ||
| 2. Run First Query using SQL Editor of Databricks SQL.mp4 | 25.5 MB | ||
| 3. Copy Data into Course Catalog Table from JSON Files using Databricks SQL.mp4 | 33.9 MB | ||
| 3. Copy Files from Local File System into DBFS using Databricks CLI Commands.mp4 | 48.9 MB | ||
| 3. Create Database and Temporary Table to Preview the Data.mp4 | 16.2 MB | ||
| 3. Create Users Table using Delta format for Merge with Delete.mp4 | 34.5 MB | ||
| 3. Filter Data using Basic Databricks SQL Queries using Course Catalog Data.mp4 | 27.6 MB | ||
| 3. Overview of Dashboards using Databricks SQL.mp4 | 12.4 MB | ||
| 3. Overview of Databricks SQL COPY Command.mp4 | 21 MB | ||
| 3. Setup Git Repository for Material and Data Sets related to Databricks SQL Course.mp4 | 10.4 MB | ||
| 3. Understand Location and Using Clause to specify File Format for Databricks.mp4 | 33.8 MB | ||
| 3. Using IF NOT EXISTS while Creating Databases using Databricks SQL.mp4 | 7.9 MB | ||
| 4. Copy Data from single file into Delta Tables using Files.mp4 | 27.5 MB | ||
| 4. Create External Table using Delta Format in Databricks SQL Warehouse.mp4 | 22.4 MB | ||
| 4. Exploring Functions using Databricks SQL.mp4 | 33.1 MB | ||
| 4. Insert Query Results into Delta Table using Databricks SQL.mp4 | 36.6 MB | ||
| 4. Listing or Showing Databases and Getting Metadata of Databases using Databricks.mp4 | 13.1 MB | ||
| 4. Merge First Set of Records into Users Table.cmproj.mp4 | 26.2 MB | ||
| 4. Overview of Databricks SQL Data Explorer to review Metastore Database and Tables.mp4 | 12.5 MB | ||
| 4. Overwrite Files while Copying into DBFS using Databricks CLI Command.mp4 | 45.8 MB | ||
| 4. Understand Characteristics of Online Retail Dataset.mp4 | 21.6 MB | ||
| 5. Copy Data from multiple files into Delta Tables using Files.mp4 | 15.7 MB | ||
| 5. Create External Table with Columns and Datatypes.mp4 | 29.3 MB | ||
| 5. Drop External Table and Delete Folder in Databricks SQL Warehouse.mp4 | 29.4 MB | ||
| 5. Exercise to Create Courses Table and Insert Data.mp4 | 10.9 MB | ||
| 5. Perform DML Operations on Users Table in Bronze Layer.mp4 | 27.3 MB | ||
| 5. Understand Course Catalog Data in the files uploaded to DBFS.mp4 | 33.5 MB | ||
| 5. Understand Default Location of Databricks SQL Database or Schema.mp4 | 12.9 MB | ||
| 5. Understand Record Column Values in Course Catalog Table.mp4 | 16.1 MB | ||
| 5. Use Databricks SQL Editor to develop scripts or queries.mp4 | 25 MB | ||
| 6. Copy Data from multiple files into Delta Tables using Pattern.mp4 | 28.8 MB | ||
| 6. Copy Instructors Data into Course Catalog Table from new file.mp4 | 22.6 MB | ||
| 6. Create Database or Schema using Location in Databricks SQL Warehouse.mp4 | 12.5 MB | ||
| 6. Get Count of Not Null Values of all Columns using Databricks SQL.mp4 | 36.5 MB | ||
| 6. Merge Updated Data into Users Table in Silver Layer.mp4 | 21 MB | ||
| 6. Options to Analyze Data using Databricks SQL Queries.mp4 | 9.1 MB | ||
| 6. Overview of DML or CRUD Operations using Databricks SQL.mp4 | 13.2 MB | ||
| 6. Processing JSON String Values using Databricks SQL Queries.mp4 | 48.8 MB | ||
| 6. Review Metadata of Tables using Databricks SQL Platform.mp4 | 19.8 MB | ||
| 7. Create Course Catalog Table in Databricks SQL Warehouse with additional Column.mp4 | 22.8 MB | ||
| 7. Drop Databases in Databricks SQL Warehouse.mp4 | 20.3 MB | ||
| 7. Insert Records into Databricks SQL Warehouse table.mp4 | 41.4 MB | ||
| 7. Overview of Stack or Unpivot or Transpose of Data.mp4 | 10.5 MB | ||
| 7. Overview of loading data into retail_db tables.mp4 | 6 MB | ||
| 7. Process Instructors JSON Records using Databricks SQL Queries.mp4 | 22.1 MB | ||
| 7. Run Select Queries using DBFS Path in From Cluase.mp4 | 25.4 MB | ||
| 7. Scenarios for Merge into Databricks SQL Delta Tables.mp4 | 24.7 MB | ||
| 7. Understand the Concept of Merge or Upsert in DML or CRUD Operations.mp4 | 10.2 MB | ||
| 8. Alter Database in Databricks SQL Warehouse.mp4 | 26.5 MB | ||
| 8. Configure Databricks CLI to push data into Databricks Platform.mp4 | 29.6 MB | ||
| 8. Copy Data from Files using Queries into Delta Tables.mp4 | 37.8 MB | ||
| 8. Create View for Instructors using Databricks SQL Queries.mp4 | 23.2 MB | ||
| 8. Develop Query to Get the latest Instructors Records from Course Catalog Table.mp4 | 16.4 MB | ||
| 8. Insert Multiple Records into Databricks SQL Warehouse table.mp4 | 22.7 MB | ||
| 8. Reset Users Table to Merge Data Incrementally into the target table.mp4 | 22.1 MB | ||
| 8. Run Queries using Temporary Views in Databricks SQL.mp4 | 35.1 MB | ||
| 8. Transpose Data using Stack in Databricks SQL.mp4 | 36.1 MB | ||
| 9. Comments on Databases in Databricks SQL Warehouse.mp4 | 27 MB | ||
| 9. Copy JSON Data into DBFS using Databricks CLI.mp4 | 48 MB | ||
| 9. Merge Into Databricks Table using Conditions on Updated Timestamp.mp4 | 43.5 MB | ||
| 9. Overview of Merge Statement Syntax using Databricks SQL.mp4 | 23.6 MB | ||
| 9. Run Queries using External Tables in Databricks SQL.mp4 | 18 MB | ||
| 9. Transpose Not Null Counts into Multiple Rows using Databricks SQL.mp4 | 24.3 MB | ||
| 9. Update Existing Records in Databricks SQL Warehouse table.mp4 | 23.8 MB | ||
| 9. Validate Course Catalog Table in Bronze Layer.mp4 | 25.6 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 107 total files | |||
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
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Mastering CAN Network - Vector CANoe,CANalyzer, CAPL and Theory Posted by
freecoursewb in Other
|
1.4 GB | freecoursewb | 5 days | 0 | 0 |
| 1.2 GB | freecoursewb | 5 days | 0 | 0 | |
| 540.5 MB | freecoursewb | 5 days | 73 | 2 | |
| 2.7 GB | freecoursewb | 5 days | 0 | 0 | |
| 625.6 MB | freecoursewb | 3 weeks | 10 | 4 |
All Comments