Databricks SQL for Data Analysts

seeders: 4
leechers: 1
Added 2 years ago by tutsnode in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Databricks SQL for Data Analysts (Size: 5 GB)
  0 287.4 KB
  1. Administrative Roles in Databricks.mp4 30.1 MB
  1. Congratulations.html 614.4 B
  1. Course Overview.mp4 83.1 MB
  1. Creating Catalogs.mp4 78.4 MB
  1. Medallion Architecture and Last Mile ETL.mp4 86.2 MB
  1. Query History and Profile.mp4 58.2 MB
  1. Visualizations and Dashboards Overview.mp4 36 MB
  1. Your First Query.mp4 92.8 MB
  1 583.4 KB
  1. Select Statement Recap.mp4 50.7 MB
  1.1 16 - Your First Query.txt 921.6 B
  1.1 21 - Creating Catalogs.txt 10.6 KB
  1.1 34 - Select Statement Recap.txt 819.2 B
  1.1 Medallion Architecture.html 102.4 B
  1.1 Query History.html 102.4 B
  1.2 ANSI SQL.html 102.4 B
  1.2 Query Profile.html 102.4 B
  1.3 Evolution of Databricks SQL Language.html 204.8 B
  2 583.8 KB
  10. Numerical Functions.mp4 31 MB
  10. Overriding Unity Catalog’s Default Managed Table Storage Location.mp4 48.6 MB
  10. Sankey Charts.mp4 33.5 MB
  10. Unity Catalog Overview.mp4 69.6 MB
  10. Workspace Object Access Control - Summary.mp4 9.1 MB
  10.1 43 - Numerical Functions.txt 921.6 B
  10.1 80 - Sankey Charts.txt 921.6 B
  10.1 Workspace Access Control.html 102.4 B
  10.2 Datetime Patterns.html 204.8 B
  10.2 Numerical Functions.html 204.8 B
  11. Date and Timestamp Functions.mp4 50 MB
  11. Enabling Unity Catalog - Overview.mp4 27.5 MB
  11. Tables.mp4 29.3 MB
  11. Truncate Table.mp4 14.1 MB
  11. Unity Catalog Securable Objects and Priveledges.mp4 67.8 MB
  11.1 31 - Truncate Tables.txt 409.6 B
  11.1 44 - Date and Timestamp Functions.txt 716.8 B
  11.1 81 - Tables.txt 307.2 B
  11.1 Get started using Unity Catalog.html 102.4 B
  11.1 Manage Privileges with Unity Catalog.html 204.8 B
  11.2 Date and Timestamp Functions.html 204.8 B
  11.2 Truncate Table Command.html 204.8 B
  11.3 Datetime Patterns.html 204.8 B
  12. ADLS Overview and Storage Creation.mp4 76.5 MB
  12. Alter Table.mp4 29.3 MB
  12. Converting Strings to DatesTimestamps.mp4 40.4 MB
  12. Granting and Revoking Privileges with SQL (Unity Catalog).mp4 60 MB
  12. Pivot Tables.mp4 15.5 MB
  12.1 32 - Alter Table.txt 921.6 B
  12.1 45 - Converting Strings to DatesTimestamps.txt 1.5 KB
  12.1 82 - Pivot Tables.txt 204.8 B
  12.1 Data Lake Storage - Introduction.html 102.4 B
  12.1 GRANT.html 102.4 B
  12.2 Alter Table Command.html 204.8 B
  12.2 Conversion Functions.html 204.8 B
  12.2 REVOKE.html 102.4 B
  12.3 Datetime Patterns.html 204.8 B
  12.4 TO_DATE.html 102.4 B
  12.5 TO_TIMESTAMP.html 204.8 B
  13. Access Connector for Databricks.mp4 28.5 MB
  13. Conditional Functions.mp4 53.6 MB
  13. Counters.mp4 42.6 MB
  13. Drop Tables, Schemas and Catalogs.mp4 33 MB
  13. Granting and Revoking Privileges via the Data Explorer (Unity Catalog).mp4 32.9 MB
  13.1 33 - Dropping Tables, Schemas and Views.txt 819.2 B
  13.1 46 - Conditional Functions.txt 1.3 KB
  13.2 CASE Expression.html 102.4 B
  13.2 Drop Catalog Command.html 204.8 B
  13.3 Drop Schema Command.html 204.8 B
  13.3 IF Function.html 102.4 B
  13.4 Drop Table Command.html 204.8 B
  14. Additional Guidance on Charts in Databricks SQL.mp4 4.1 MB
  14. Aggregate Functions.mp4 23.2 MB
  14. Enabling Unity Catalog.mp4 31.6 MB
  14. Redacting Data with Dynamic Views (PII).mp4 41.5 MB
  14.1 47 - Aggregate Functions.txt 512 B
  14.1 Visualization Types.html 102.4 B
  14.1 is_account_group_member().html 204.8 B
  14.2 Aggregate Functions.html 204.8 B
  15. Creating a SQL Warehouse.mp4 35.4 MB
  15. Data Discovery.mp4 39.6 MB
  15. Exploratory Data Analysis - Challenge.mp4 87.8 MB
  15. Group By Clause.mp4 44.4 MB
  15.1 48 - Group By Clause.txt 1.7 KB
  15.1 Azure Pricing Calculator.html 102.4 B
  16. Adding Missing Data to the JC_BIKE_DATA_22 Table.mp4 14.7 MB
  16. Data Lineage.mp4 53.9 MB
  16. Filtering Aggregated Tables with the Having Clause.mp4 41.8 MB
  16.1 49 - Filtering Aggregated Tables with the Having Clause.txt 1.1 KB
  16.1 86 - Adding Missing Data to the JC Bike Data 22 Table.txt 409.6 B
  16.2 Having Clause.html 204.8 B
  16.2 JC Bike Data July 22.zip 3.3 MB
  17. Creating a View to Simplify Upcoming Demos.mp4 20.7 MB
  17. Delta Sharing Overview.mp4 30.1 MB
  17. Joining Tables Overview.mp4 59.8 MB
  17.1 87 - Creating a View To Simplify Upcoming Demos.txt 512 B
  17.1 Delta Sharing.html 102.4 B
  18. Databricks to Databricks Delta Sharing.mp4 27.7 MB
  18. Joining Tables Demo.mp4 70.8 MB
  18. Query Filters.mp4 27.1 MB
  18.1 51 - Joining Tables Demo.txt 1.4 KB
  18.1 88 - Query Filters.txt 409.6 B
  18.2 JOIN.html 204.8 B
  18.2 Query Filters.html 102.4 B
  19. Open Delta Sharing.mp4 21.8 MB
  19. Order By and Limit Clauses.mp4 41.9 MB
  19. Query Parameters.mp4 35.6 MB
  19.1 52 - Order By and Limit Clauses.txt 819.2 B
  19.1 89 - Query Parameters.txt 512 B
  19.2 Limit Clause.html 204.8 B
  19.2 Query Parameters.html 102.4 B
  19.3 Order By Clause.html 204.8 B
  2. Adding a New User to our Azure Account.mp4 28.6 MB
  2. Bonus Lecture.html 4 KB
  2. Creating Schemas.mp4 34.6 MB
  2. Introduction to Big Data (Optional).mp4 153.6 MB
  2. Medallion Architecture Demo.mp4 35.8 MB
  2. Our First Chart in Databricks SQL.mp4 69.3 MB
  2. Query Caching in Databricks SQL.mp4 93.8 MB
  2. Select Distinct.mp4 31.5 MB
  2. Switching Catalogs and Schemas.mp4 30.7 MB
  2.1 17 - Switching Catalogs and Schemas.txt 614.4 B
  2.1 22 - Creating Schemas.txt 819.2 B
  2.1 35 - Select Distinct.txt 409.6 B
  2.1 72 - Our First Chart in Databricks SQL.txt 1.2 KB
  2.1 Query Caching.html 102.4 B
  2.2 Bar Chart.html 204.8 B
  2.2 Syntax - Use Catalog.html 204.8 B
  2.3 Syntax - Use Schema.html 204.8 B
  3. Apache Spark Ecosystem (Optional).mp4 63.6 MB
  3. Scheduling Queries.mp4 21.9 MB
  3 505.6 KB
  3. Adding a New User to our Databricks Environment.mp4 24.1 MB
  3. Benefits of Delta File Format.mp4 70.3 MB
  3. Data Types in Databricks SQL.mp4 67.6 MB
  3. Line and Area Charts.mp4 60.2 MB
  3. Note on the JC_BIKE_DATA_22 Table.mp4 8.2 MB
  3. Query Alerts.mp4 50.1 MB
  3.1 18 - Scheduling Queries.txt 204.8 B
  3.1 73 - Line and Area Charts.txt 716.8 B
  3.1 Data Types in Databricks SQL.html 102.4 B
  3.1 Delta Lake.html 102.4 B
  3.1 Query Alerts.html 102.4 B
  3.2 Area Chart.html 204.8 B
  3.2 Schedule a Query.html 102.4 B
  3.3 Line Chart.html 204.8 B
  4. Adding Comments to Queries.mp4 9.8 MB
  4. Combo Chart.mp4 23.7 MB
  4. Overview of Tables in Databricks.mp4 33.3 MB
  4. Workspace Admin Settings.mp4 19.8 MB
  4 185.5 KB
  4. Filtering Records with the WHERE Clause.mp4 56.3 MB
  4. Overview of Databricks.mp4 153.4 MB
  4. Upsert Merge Into.mp4 65.3 MB
  4.1 37 - Filtering Records with the WHERE Clause.txt 1 KB
  4.1 66 - Merge Into.txt 3 KB
  4.1 74 - Combo Chart.txt 921.6 B
  4.1 Comparing Databricks to Apache Spark.html 102.4 B
  4.2 Combo Chart.html 102.4 B
  4.2 Merge Into.html 102.4 B
  4.2 WHERE Clause.html 204.8 B
  5. Pie Chart.mp4 33.4 MB
  5 174.1 KB
  5. Azure Account Set Up.mp4 24.3 MB
  5. Course Resources - SQL Code Download.mp4 38.5 MB
  5. Creating Managed Tables with SQL.mp4 102.4 MB
  5. Filtering Records Based on Multiple Conditions.mp4 55.7 MB
  5. Table Audit History and Time Travel.mp4 64.4 MB
  5. Workspace Object Access Control.mp4 5.7 MB
  5.1 25 - Creating Managed Tables with SQL.txt 1.2 KB
  5.1 38 - Filtering Records Based on Multiple Conditions.txt 1.4 KB
  5.1 67 - Table Audit History and Time Travel.txt 921.6 B
  5.1 75 - Pie Chart.txt 921.6 B
  5.1 Azure Account Creation Link.html 102.4 B
  5.1 Course Resources - SQL Code.zip 75.6 KB
  5.2 AND Operator.html 102.4 B
  5.2 Delta History and Time Travel.html 102.4 B
  5.2 Pie Charts.html 204.8 B
  5.3 BETWEEN Operator.html 102.4 B
  5.4 NOT Operator.html 102.4 B
  5.5 OR Operator.html 102.4 B
  6. Azure Portal Overview.mp4 61.8 MB
  6. Creating Managed Tables in Hive Metastore.mp4 24.8 MB
  6. SQL Warehouse Access Control.mp4 22.1 MB
  6. Scatter and Bubble Plots.mp4 33.4 MB
  6 238.2 KB
  20. Query Parameters (Dates).mp4 20.6 MB
  20. SQL Order of Execution.mp4 37.6 MB
  20.1 53 - SQL Order of Execution.txt 921.6 B
  20.1 90 - Query Parameters (Dates).txt 307.2 B
  21. Introduction to Dashboards.mp4 98.5 MB
  21. Subqueries.mp4 38 MB
  21.1 54 - Subqueries.txt 819.2 B
  21.1 91 - Introduction to Dashboards.txt 819.2 B
  21.2 Dashboards.html 102.4 B
  21.2 Subqueries.html 204.8 B
  22. Adding Parameters to Dashboards.mp4 58.7 MB
  22. Views.mp4 54 MB
  22.1 55 - Views.txt 716.8 B
  22.1 92 - Adding Parameters to Dashboards.txt 1 KB
  22.2 CREATE VIEW.html 204.8 B
  23. Adding Filters to Dashboards.mp4 24.4 MB
  23. Set Operators.mp4 45.4 MB
  23.1 56 - Set Operators.txt 1.2 KB
  23.1 93 - Adding Filters to Dashboards.txt 512 B
  23.2 Set Operators.html 204.8 B
  24. SQL Challenge 1.mp4 18.9 MB
  24. Trip Duration Analysis Challenge.mp4 69.8 MB
  24.1 57 - SQL Challenge 1.txt 512 B
  24.1 94 - Trip Duration Analysis Challenge.txt 819.2 B
  25. Rider Type Analysis Challenge.mp4 61.9 MB
  25. SQL Challenge 2.mp4 26.1 MB
  25.1 58 - SQL Challenge 2.txt 614.4 B
  25.1 95 - Rider Analysis Challenge.txt 512 B
  26. SQL Challenge 3.mp4 25.8 MB
  26.1 59 - SQL Challenge 3.txt 409.6 B
  27. SQL Challenge 4.mp4 29.6 MB
  27.1 60 - SQL Challenge 4.txt 716.8 B
  28. SQL Challenge 5.mp4 55 MB
  28.1 61 - SQL Challenge 5.txt 921.6 B
  29. Schema Clean Up.mp4 4.3 MB
  6. Filtering Records with the IN and LIKE Operators.mp4 40.9 MB
  6.1 39 - Filtering Records with the IN and LIKE Operators.txt 819.2 B
  6.1 76 - Scatter and Bubble Plots.txt 1.2 KB
  6.1 Azure Portal Overview.html 102.4 B
  6.1 SQL Warehouse Access Control.html 204.8 B
  6.2 Bubble Plots.html 102.4 B
  6.2 IN Operator.html 102.4 B
  6.3 LIKE Operator.html 102.4 B
  6.3 Scatter Plots.html 204.8 B
  7. Cost Management and Billing.mp4 49.3 MB
  7. Creating Managed Tables using the Data Explorer.mp4 59.6 MB
  7. Deleting Records.mp4 18.8 MB
  7. Folder Access Control.mp4 28 MB
  7. Histograms.mp4 23 MB
  7 813.8 KB
  7.1 40 - Deleting Records.txt 512 B
  7.1 77 - Histograms.txt 819.2 B
  7.1 Folder Access Control.html 204.8 B
  7.1 JC Bike Share 22 Course Data.zip 19.9 MB
  7.2 DELETE FROM Syntax.html 102.4 B
  7.2 Histogram.html 204.8 B
  8. Creating a Databricks Premium Workspace.mp4 48.9 MB
  8 898.7 KB
  8. Box Plots.mp4 30.5 MB
  8. Creating an External Storage Location.mp4 62.4 MB
  8. Databricks SQL Built In Functions Overview.mp4 22.9 MB
  8. Query Access Control.mp4 28.5 MB
  8.1 78 - Box Plots.txt 1.3 KB
  8.1 Built In Functions Documentation.html 204.8 B
  8.1 Managed External Locations and Storage Credentials.html 204.8 B
  8.1 Query Access Control.html 204.8 B
  8.1 Supported Regions - Serverless SQL.html 102.4 B
  8.2 Box Plots.html 102.4 B
  9. Databricks Workspace User Interface.mp4 46.7 MB
  9. String Functions.mp4 62.1 MB
  9 630.5 KB
  9. Creating External Tables.mp4 72.9 MB
  9. Dashboard Access Control.mp4 23.2 MB
  9. Heatmaps.mp4 36 MB
  9.1 29 - Creating External Tables.txt 1.1 KB
  9.1 42 - String Functions.txt 921.6 B
  9.1 79 - Heatmaps.txt 921.6 B
  9.1 Dashboard Access Control.html 204.8 B
  9.2 Files for External Storage.zip 5.5 KB
  9.2 String Functions.html 204.8 B
  TutsNode.net.txt 102.4 B
  [TGx]Downloaded from torrentgalaxy.to .txt 614.4 B
  10 509.7 KB
  11 65.9 KB
  12 220.4 KB
  13 767.4 KB
  14 222.5 KB
  15 405 KB
  16 680.6 KB
  17 166.5 KB
  18 423.2 KB
  19 706.2 KB
  20 615.8 KB
  21 397.1 KB
  22 608.7 KB
  23 891.2 KB
  24 93.1 KB
  25 162.4 KB
  26 812.7 KB
  27 9.5 KB
  28 227.4 KB
  29 362.8 KB
  30 265.6 KB
  31 820.3 KB
  32 706.2 KB
  33 327 KB
  35 973.1 KB
  36 118.7 KB
  37 448.7 KB
  38 256.3 KB
  39 896.9 KB
  41 757.8 KB
  42 57.2 KB
  43 406.2 KB
  44 301.9 KB
  45 645.9 KB
  46 602.1 KB
  47 412.3 KB
  48 109.4 KB
  49 240.4 KB
  50 467.8 KB
  51 64 KB
  52 571.4 KB
  53 382.8 KB
  54 530.7 KB
  55 983.2 KB
  56 379.1 KB
  57 0 B
  58 24.9 KB
  59 251.3 KB
  60 397.5 KB
  61 646.2 KB
  62 381.4 KB
  63 533.5 KB
  64 632.1 KB
  65 656.6 KB
  66 745.5 KB
  67 32.7 KB
  68 62.1 KB
  69 369.3 KB
  70 507.5 KB
  71 17.4 KB
  72 283.3 KB
  73 478.8 KB
  74 885.8 KB
  75 941.4 KB
  76 429.1 KB
  77 713.4 KB
  78 751 KB
  79 419.9 KB
  80 498.2 KB
  81 556.5 KB
  82 27.7 KB
  83 309.4 KB
  84 550 KB
  85 938.2 KB
  86 939 KB
  87 251 KB
  88 205.7 KB
  89 571.3 KB
  90 684.2 KB
  91 904.1 KB
  92 326.4 KB
  93 804.3 KB
  94 804.8 KB
  96 99.6 KB
  97 957.7 KB
  98 79 KB
  99 182 KB
  100 281.7 KB
  101 399.6 KB
  102 79.9 KB
  103 234.9 KB
  104 106.9 KB
  105 228.8 KB
  106 476 KB
  107 341.7 KB
  108 907.9 KB
  109 186.9 KB
  110 963.8 KB
  111 825.4 KB
  112 278.4 KB
  113 694.3 KB
  114 878.8 KB
  ▲ 370 total files

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

Related Torrents

torrent name size uploader age seed leech
5
2
0
3
2