Databricks SQL for Data Analysts

Databricks SQL for Data Analysts

Other
Size
5 GB
Seeders
5
Leechers
0
Files
98
Category
Other
Added
09/18/23 at 9:08am GMT+1
Infohash
901fde49ceb8c5b9841fe225ec30a11f03daf4aa

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

File list
  • Databricks SQL for Data Analysts
  • TutsNode.net.txt 63 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/11.1 Get started using Unity Catalog.html 153 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/12.1 Data Lake Storage - Introduction.html 145 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/15.1 Azure Pricing Calculator.html 114 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/2. Introduction to Big Data (Optional).mp4 153.6 MB
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/4.1 Comparing Databricks to Apache Spark.html 130 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/5.1 Azure Account Creation Link.html 89 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/6.1 Azure Portal Overview.html 135 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/1. Set Up and Overview of Databricks/8.1 Supported Regions - Serverless SQL.html 139 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/1.1 16 - Your First Query.txt 948 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/1.2 ANSI SQL.html 131 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/1.3 Evolution of Databricks SQL Language.html 220 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/2.1 17 - Switching Catalogs and Schemas.txt 652 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/2.2 Syntax - Use Catalog.html 162 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/2.3 Syntax - Use Schema.html 161 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/3.1 18 - Scheduling Queries.txt 165 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/3.2 Schedule a Query.html 143 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/2. Introduction to Queries/5.1 Course Resources - SQL Code.zip 75.6 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/1.1 21 - Creating Catalogs.txt 10.6 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/11.1 31 - Truncate Tables.txt 407 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/11.2 Truncate Table Command.html 165 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/12.1 32 - Alter Table.txt 968 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/12.2 Alter Table Command.html 162 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/13.1 33 - Dropping Tables, Schemas and Views.txt 836 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/13.2 Drop Catalog Command.html 163 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/13.3 Drop Schema Command.html 162 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/13.4 Drop Table Command.html 161 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/2.1 22 - Creating Schemas.txt 786 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/3.1 Data Types in Databricks SQL.html 149 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/5.1 25 - Creating Managed Tables with SQL.txt 1.2 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/8.1 Managed External Locations and Storage Credentials.html 209 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/9.1 29 - Creating External Tables.txt 1.1 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/3. Catalogs, Schemas, Tables and Views/9.2 Files for External Storage.zip 5.5 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/1.1 34 - Select Statement Recap.txt 870 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/10.1 43 - Numerical Functions.txt 972 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/10.2 Numerical Functions.html 182 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/11.1 44 - Date and Timestamp Functions.txt 669 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/11.2 Date and Timestamp Functions.html 195 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/12.1 45 - Converting Strings to DatesTimestamps.txt 1.5 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/12.2 Conversion Functions.html 189 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/13.1 46 - Conditional Functions.txt 1.3 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/14.1 47 - Aggregate Functions.txt 489 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/14.2 Aggregate Functions.html 177 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/15.1 48 - Group By Clause.txt 1.7 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/16.1 49 - Filtering Aggregated Tables with the Having Clause.txt 1.1 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/18.1 51 - Joining Tables Demo.txt 1.4 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/19.1 52 - Order By and Limit Clauses.txt 854 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/2.1 35 - Select Distinct.txt 374 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/20.1 53 - SQL Order of Execution.txt 885 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/21.1 54 - Subqueries.txt 833 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/22.1 55 - Views.txt 757 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/23.1 56 - Set Operators.txt 1.2 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/24.1 57 - SQL Challenge 1.txt 535 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/25.1 58 - SQL Challenge 2.txt 629 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/26.1 59 - SQL Challenge 3.txt 385 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/27.1 60 - SQL Challenge 4.txt 730 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/28.1 61 - SQL Challenge 5.txt 901 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/4.1 37 - Filtering Records with the WHERE Clause.txt 1 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/4.2 WHERE Clause.html 163 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/5.1 38 - Filtering Records Based on Multiple Conditions.txt 1.4 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/5.2 AND Operator.html 145 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/5.3 BETWEEN Operator.html 149 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/5.4 NOT Operator.html 145 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/5.5 OR Operator.html 144 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/6.1 39 - Filtering Records with the IN and LIKE Operators.txt 853 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/6.2 IN Operator.html 144 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/6.3 LIKE Operator.html 146 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/7.1 40 - Deleting Records.txt 514 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/7.2 DELETE FROM Syntax.html 149 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/8.1 Built In Functions Documentation.html 157 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/9.1 42 - String Functions.txt 889 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/4. Data Analysis with SQL/9.2 String Functions.html 185 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/5. Delta Lake/4.1 66 - Merge Into.txt 3 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/5. Delta Lake/5.1 67 - Table Audit History and Time Travel.txt 895 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/10.1 80 - Sankey Charts.txt 926 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/11.1 81 - Tables.txt 351 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/12.1 82 - Pivot Tables.txt 222 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/16.1 86 - Adding Missing Data to the JC Bike Data 22 Table.txt 460 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/17.1 87 - Creating a View To Simplify Upcoming Demos.txt 560 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/18.1 88 - Query Filters.txt 426 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/19.1 89 - Query Parameters.txt 466 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/2.1 72 - Our First Chart in Databricks SQL.txt 1.2 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/20.1 90 - Query Parameters (Dates).txt 300 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/21.1 91 - Introduction to Dashboards.txt 771 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/22.1 92 - Adding Parameters to Dashboards.txt 1002 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/23.1 93 - Adding Filters to Dashboards.txt 520 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/24.1 94 - Trip Duration Analysis Challenge.txt 836 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/25.1 95 - Rider Analysis Challenge.txt 477 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/3.1 73 - Line and Area Charts.txt 711 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/4.1 74 - Combo Chart.txt 902 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/5.1 75 - Pie Chart.txt 915 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/6.1 76 - Scatter and Bubble Plots.txt 1.2 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/7.1 77 - Histograms.txt 804 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/8.1 78 - Box Plots.txt 1.3 KB
  • [TutsNode.net] - Databricks SQL for Data Analysts/7. Visualizations and Dashboards in Databricks SQL/9.1 79 - Heatmaps.txt 958 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/8. Access Control, Data Governance and Unity Catalog/7.1 Folder Access Control.html 179 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/9. Congratulations on completing the course!/1. Congratulations.html 594 B
  • [TutsNode.net] - Databricks SQL for Data Analysts/9. Congratulations on completing the course!/2. Bonus Lecture.html 4 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
15 MB07/19/2648763245
15 MB07/19/2648713243
65 MB07/18/2646583104
50 MB07/14/2644592968
15 MB07/16/2643952928
65 MB07/15/2643652912
9 MB07/15/2643402888
14 MB07/19/2643292885
44 MB07/14/2642762846
14 MB07/15/2642642837
32 MB01/06/2641612770
65 MB08/14/2636492436
14 MB08/04/2636232412
3 MB08/14/2636102404
15 MB08/10/2636032401