Databricks SQL for Data Analysts

seeders: 31
leechers: 25
updated:
Added by tutsnode in Other > Tutorials

Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 163
  • Language: English

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

Description


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



Download torrent
5 GB
seeders:31
leechers:25
Databricks SQL for Data Analysts


Trackers

tracker name
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
µTorrent compatible trackers list

Download torrent
5 GB
seeders:31
leechers:25
Databricks SQL for Data Analysts


Torrent hash: 901FDE49CEB8C5B9841FE225EC30A11F03DAF4AA