Databricks SQL for Data Analysts

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size5 GB
  • Uploaded Bytutsnode
  • Downloads163
  • Last checkedSep. 18th '23
  • Date uploadedSep. 17th '23
  • Seeders 31
  • Leechers25
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 901FDE49CEB8C5B9841FE225EC30A11F03DAF4AA


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 Overview
Databricks Queries
Storing and Managing Data with Databricks
External and Managed Tables
Data Analysis with SQL
Data Lakehouse Architecture
Delta File Format
Data Visualization and Dashboards
Access Control and Data Governance
Unity Catalog

Who this course is for:

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

Requirements

No prior experience needed
Azure Account (set up instructions provided)

Last Updated 9/2023

Files:

Databricks SQL for Data Analysts [TutsNode.net] - Databricks SQL for Data Analysts 1. Set Up and Overview of Databricks
  • 2. Introduction to Big Data (Optional).mp4 (153.6 MB)
  • 4.1 Comparing Databricks to Apache Spark.html (0.1 KB)
  • 5.1 Azure Account Creation Link.html (0.1 KB)
  • 6.1 Azure Portal Overview.html (0.1 KB)
  • 8.1 Supported Regions - Serverless SQL.html (0.1 KB)
  • 11.1 Get started using Unity Catalog.html (0.1 KB)
  • 12.1 Data Lake Storage - Introduction.html (0.1 KB)
  • 15.1 Azure Pricing Calculator.html (0.1 KB)
  • 4. Overview of Databricks.mp4 (153.4 MB)
  • 1. Course Overview.mp4 (83.1 MB)
  • 12. ADLS Overview and Storage Creation.mp4 (76.5 MB)
  • 10. Unity Catalog Overview.mp4 (69.6 MB)
  • 3. Apache Spark Ecosystem (Optional).mp4 (63.6 MB)
  • 6. Azure Portal Overview.mp4 (61.8 MB)
  • 7. Cost Management and Billing.mp4 (49.3 MB)
  • 8. Creating a Databricks Premium Workspace.mp4 (48.9 MB)
  • 9. Databricks Workspace User Interface.mp4 (46.7 MB)
  • 15. Creating a SQL Warehouse.mp4 (35.4 MB)
  • 14. Enabling Unity Catalog.mp4 (31.6 MB)
  • 13. Access Connector for Databricks.mp4 (28.5 MB)
  • 11. Enabling Unity Catalog - Overview.mp4 (27.5 MB)
  • 5. Azure Account Set Up.mp4 (24.3 MB)
2. Introduction to Queries
  • 5.1 Course Resources - SQL Code.zip (75.6 KB)
  • 1.1 16 - Your First Query.txt (0.9 KB)
  • 1.2 ANSI SQL.html (0.1 KB)
  • 1.3 Evolution of Databricks SQL Language.html (0.2 KB)
  • 2.1 17 - Switching Catalogs and Schemas.txt (0.6 KB)
  • 2.2 Syntax - Use Catalog.html (0.2 KB)
  • 2.3 Syntax - Use Schema.html (0.2 KB)
  • 3.1 18 - Scheduling Queries.txt (0.2 KB)
  • 3.2 Schedule a Query.html (0.1 KB)
  • 1. Your First Query.mp4 (92.8 MB)
  • 5. Course Resources - SQL Code Download.mp4 (38.5 MB)
  • 2. Switching Catalogs and Schemas.mp4 (30.7 MB)
  • 3. Scheduling Queries.mp4 (21.9 MB)
  • 4. Adding Comments to Queries.mp4 (9.8 MB)
3. Catalogs, Schemas, Tables and Views
  • 1.1 21 - Creating Catalogs.txt (10.6 KB)
  • 9.2 Files for External Storage.zip (5.5 KB)
  • 5.1 25 - Creating Managed Tables with SQL.txt (1.2 KB)
  • 9.1 29 - Creating External Tables.txt (1.1 KB)
  • 12.1 32 - Alter Table.txt (0.9 KB)
  • 2.1 22 - Creating Schemas.txt (0.8 KB)
  • 3.1 Data Types in Databricks SQL.html (0.1 KB)
  • 8.1 Managed External Locations and Storage Credentials.html (0.2 KB)
  • 13.1 33 - Dropping Tables, Schemas and Views.txt (0.8 KB)
  • 11.1 31 - Truncate Tables.txt (0.4 KB)
  • 11.2 Truncate Table Command.html (0.2 KB)
  • 12.2 Alter Table Command.html (0.2 KB)
  • 13.2 Drop Catalog Command.html (0.2 KB)
  • 13.3 Drop Schema Command.html (0.2 KB)
  • 13.4 Drop Table Command.html (0.2 KB)
  • 5. Creating Managed Tables with SQL.mp4 (102.4 MB)
  • 1. Creating Catalogs.mp4 (78.4 MB)
  • 9. Creating External Tables.mp4 (72.9 MB)
  • 3. Data Types in Databricks SQL.mp4 (67.6 MB)
  • 8. Creating an External Storage Location.mp4 (62.4 MB)
  • 7. Creating Managed Tables using the Data Explorer.mp4 (59.6 MB)
  • 10. Overriding Unity Catalog’s Default Managed Table Storage Location.mp4 (48.6 MB)
  • 2. Creating Schemas.mp4 (34.6 MB)
  • 4. Overview of Tables in Databricks.mp4 (33.3 MB)
  • 13. Drop Tables, Schemas and Catalogs.mp4 (33.0 MB)
  • 12. Alter Table.mp4 (29.3 MB)
  • 6. Creating Managed Tables in Hive Metastore.mp4 (24.8 MB)
  • 7.1 JC Bike Share 22 Course Data.zip (19.9 MB)
  • 11. Truncate Table.mp4 (14.1 MB)
9. Congratulations on completing the course!
  • 2. Bonus Lecture.html (4.0 KB)
  • 1. Congratulations.html (0.6 KB)
5. Delta Lake
  • 4.1 66 - Merge Into.txt (3.0 KB)
  • 5.1 67 - Table Audit History and Time Travel.txt (0.9 KB)
  • 4.2 Merge Into.html (0.1 KB)
  • 1.1 Medallion Architecture.html (0.1 KB)
  • 5.2 Delta History and Time Travel.html (0.1 KB)
  • 3.1 Delta Lake.html (0.1 KB)
  • 1. Medallion Architecture and Last Mile ETL.mp4 (86.2 MB)
  • 3. Benefits of Delta File Format.mp4 (70.3 MB)
  • 4. Upsert Merge Into.mp4 (65.3 MB)
  • 5. Table Audit History and Time Travel.mp4 (64.4 MB)
  • 2. Medallion Architecture Demo.mp4 (35.8 MB)
4. Data Analysis with SQL
  • 15.1 48 - Group By Clause.txt (1.7 KB)
  • 12.1 45 - Converting Strings to DatesTimestamps.txt (1.5 KB)
  • 18.1 51 - Joining Tables Demo.txt (1.4 KB)
  • 5.1 38 - Filtering Records Based on Multiple Conditions.txt (1.4 KB)
  • 13.1 46 - Conditional Functions.txt (1.3 KB)
  • 23.1 56 - Set Operators.txt (1.2 KB)
  • 16.1 49 - Filtering Aggregated Tables with the Having Clause.txt (1.1 KB)
  • 4.1 37 - Filtering Records with the WHERE Clause.txt (1.0 KB)
  • 10.1 43 - Numerical Functions.txt (0.9 KB)
  • 28.1 61 - SQL Challenge 5.txt (0.9 KB)
  • 9.1 42 - String Functions.txt (0.9 KB)
  • 20.1 53 - SQL Order of Execution.txt (0.9 KB)
  • 1.1 34 - Select Statement Recap.txt (0.8 KB)
  • 19.1 52 - Order By and Limit Clauses.txt (0.8 KB)
  • 6.1 39 - Filtering Records with the IN and LIKE Operators.txt (0.8 KB)
  • 21.1 54 - Subqueries.txt (0.8 KB)
  • 22.1 55 - Views.txt (0.7 KB)
  • 27.1 60 - SQL Challenge 4.txt (0.7 KB)
  • 11.1 44 - Date and Timestamp Functions.txt (0.7 KB)
  • 25.1 58 - SQL Challenge 2.txt (0.6 KB)
  • 2.1 35 - Select Distinct.txt (0.4 KB)
  • 24.1 57 - SQL Challenge 1.txt (0.5 KB)
  • 4.2 WHERE Clause.html (0.2 KB)
  • 7.1 40 - Deleting Records.txt (0.5 KB)
  • 14.1 47 - Aggregate Functions.txt (0.5 KB)
  • 5.2 AND Operator.html (0.1 KB)
  • 5.3 BETWEEN Operator.html (0.1 KB)
  • 5.4 NOT Operator.html (0.1 KB)
  • 5.5 OR Operator.html (0.1 KB)
  • 6.2 IN Operator.html (0.1 KB)
  • 6.3 LI

Code:

  • udp://open.stealth.si:80/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://fasttracker.foreverpirates.co:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://tracker.uw0.xyz:6969/announce
  • udp://opentracker.i2p.rocks:6969/announce
  • udp://tracker.birkenwald.de:6969/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.moeking.me:6969/announce
  • udp://tracker.dler.org:6969/announce
  • udp://9.rarbg.me:2970/announce