Databricks SQL for Data Analysts

Focused View

Malvik Vaghadia

10:04:38

107 View

1. Set Up and Overview of Databricks

1. Course Overview.mp4

05:15

2. Introduction to Big Data (Optional).mp4

09:48

3. Apache Spark Ecosystem (Optional).mp4

03:53

4.1 Comparing Databricks to Apache Spark.html

4. Overview of Databricks.mp4

10:11

5.1 Azure Account Creation Link.html

5. Azure Account Set Up.mp4

03:17

6.1 Azure Portal Overview.html

6. Azure Portal Overview.mp4

08:03

7. Cost Management and Billing.mp4

06:32

8.1 Supported Regions - Serverless SQL.html

8. Creating a Databricks Premium Workspace.mp4

07:03

9. Databricks Workspace User Interface.mp4

06:32

10. Unity Catalog Overview.mp4

04:24

11.1 Get started using Unity Catalog.html

11. Enabling Unity Catalog - Overview.mp4

01:39

12.1 Data Lake Storage - Introduction.html

12. ADLS Overview and Storage Creation.mp4

08:24

13. Access Connector for Databricks.mp4

03:46

14. Enabling Unity Catalog.mp4

05:20

15.1 Azure Pricing Calculator.html

15. Creating a SQL Warehouse.mp4

06:15

2. Introduction to Queries

1.1 16 - Your First Query.txt

1.2 ANSI SQL.html

1.3 Evolution of Databricks SQL Language.html

1. Your First Query.mp4

13:10

2.1 17 - Switching Catalogs and Schemas.txt

2.2 Syntax - Use Catalog.html

2.3 Syntax - Use Schema.html

2. Switching Catalogs and Schemas.mp4

04:21

3.1 18 - Scheduling Queries.txt

3.2 Schedule a Query.html

3. Scheduling Queries.mp4

02:51

4. Adding Comments to Queries.mp4

01:40

5.1 Course Resources - SQL Code.zip

5. Course Resources - SQL Code Download.mp4

02:31

3. Catalogs, Schemas, Tables and Views

1.1 21 - Creating Catalogs.txt

1. Creating Catalogs.mp4

11:31

2.1 22 - Creating Schemas.txt

2. Creating Schemas.mp4

05:00

3.1 Data Types in Databricks SQL.html

3. Data Types in Databricks SQL.mp4

04:48

4. Overview of Tables in Databricks.mp4

02:17

5.1 25 - Creating Managed Tables with SQL.txt

5. Creating Managed Tables with SQL.mp4

14:44

6. Creating Managed Tables in Hive Metastore.mp4

03:42

7.1 JC Bike Share 22 Course Data.zip

7. Creating Managed Tables using the Data Explorer.mp4

06:06

8.1 Managed External Locations and Storage Credentials.html

8. Creating an External Storage Location.mp4

07:36

9.1 29 - Creating External Tables.txt

9.2 Files for External Storage.zip

9. Creating External Tables.mp4

09:37

10. Overriding Unity Catalogs Default Managed Table Storage Location.mp4

07:29

11.1 31 - Truncate Tables.txt

11.2 Truncate Table Command.html

11. Truncate Table.mp4

02:27

12.1 32 - Alter Table.txt

12.2 Alter Table Command.html

12. Alter Table.mp4

04:22

13.1 33 - Dropping Tables, Schemas and Views.txt

13.2 Drop Catalog Command.html

13.3 Drop Schema Command.html

13.4 Drop Table Command.html

13. Drop Tables, Schemas and Catalogs.mp4

05:05

4. Data Analysis with SQL

1.1 34 - Select Statement Recap.txt

1. Select Statement Recap.mp4

06:46

2.1 35 - Select Distinct.txt

2. Select Distinct.mp4

03:50

3. Note on the JC BIKE DATA 22 Table.mp4

00:34

4.1 37 - Filtering Records with the WHERE Clause.txt

4.2 WHERE Clause.html

4. Filtering Records with the WHERE Clause.mp4

07:35

5.1 38 - Filtering Records Based on Multiple Conditions.txt

5.2 AND Operator.html

5.3 BETWEEN Operator.html

5.4 NOT Operator.html

5.5 OR Operator.html

5. Filtering Records Based on Multiple Conditions.mp4

06:33

6.1 39 - Filtering Records with the IN and LIKE Operators.txt

6.2 IN Operator.html

6.3 LIKE Operator.html

6. Filtering Records with the IN and LIKE Operators.mp4

05:03

7.1 40 - Deleting Records.txt

7.2 DELETE FROM Syntax.html

7. Deleting Records.mp4

02:57

8.1 Built In Functions Documentation.html

8. Databricks SQL Built In Functions Overview.mp4

03:21

9.1 42 - String Functions.txt

9.2 String Functions.html

9. String Functions.mp4

08:04

10.1 43 - Numerical Functions.txt

10.2 Numerical Functions.html

10. Numerical Functions.mp4

04:27

11.1 44 - Date and Timestamp Functions.txt

11.2 Date and Timestamp Functions.html

11.3 Datetime Patterns.html

11. Date and Timestamp Functions.mp4

06:14

12.1 45 - Converting Strings to DatesTimestamps.txt

12.2 Conversion Functions.html

12.3 Datetime Patterns.html

12.4 TO DATE.html

12.5 TO TIMESTAMP.html

12. Converting Strings to DatesTimestamps.mp4

06:20

13.1 46 - Conditional Functions.txt

13.2 CASE Expression.html

13.3 IF Function.html

13. Conditional Functions.mp4

08:10

14.1 47 - Aggregate Functions.txt

14.2 Aggregate Functions.html

14. Aggregate Functions.mp4

04:02

15.1 48 - Group By Clause.txt

15. Group By Clause.mp4

06:01

16.1 49 - Filtering Aggregated Tables with the Having Clause.txt

16.2 Having Clause.html

16. Filtering Aggregated Tables with the Having Clause.mp4

06:12

17. Joining Tables Overview.mp4

03:47

18.1 51 - Joining Tables Demo.txt

18.2 JOIN.html

18. Joining Tables Demo.mp4

09:06

19.1 52 - Order By and Limit Clauses.txt

19.2 Limit Clause.html

19.3 Order By Clause.html

19. Order By and Limit Clauses.mp4

04:58

20.1 53 - SQL Order of Execution.txt

20. SQL Order of Execution.mp4

06:13

21.1 54 - Subqueries.txt

21.2 Subqueries.html

21. Subqueries.mp4

05:28

22.1 55 - Views.txt

22.2 CREATE VIEW.html

22. Views.mp4

05:14

23.1 56 - Set Operators.txt

23.2 Set Operators.html

23. Set Operators.mp4

05:11

24.1 57 - SQL Challenge 1.txt

24. SQL Challenge 1.mp4

02:58

25.1 58 - SQL Challenge 2.txt

25. SQL Challenge 2.mp4

03:42

26.1 59 - SQL Challenge 3.txt

26. SQL Challenge 3.mp4

04:07

27.1 60 - SQL Challenge 4.txt

27. SQL Challenge 4.mp4

04:32

28.1 61 - SQL Challenge 5.txt

28. SQL Challenge 5.mp4

07:58

29. Schema Clean Up.mp4

00:34

5. Delta Lake

1.1 Medallion Architecture.html

1. Medallion Architecture and Last Mile ETL.mp4

05:56

2. Medallion Architecture Demo.mp4

04:30

3.1 Delta Lake.html

3. Benefits of Delta File Format.mp4

04:56

4.1 66 - Merge Into.txt

4.2 Merge Into.html

4. Upsert Merge Into.mp4

09:21

5.1 67 - Table Audit History and Time Travel.txt

5.2 Delta History and Time Travel.html

5. Table Audit History and Time Travel.mp4

08:33

6. Query Alerts and Monitoring

1.1 Query History.html

1.2 Query Profile.html

1. Query History and Profile.mp4

05:26

2.1 Query Caching.html

2. Query Caching in Databricks SQL.mp4

07:40

3.1 Query Alerts.html

3. Query Alerts.mp4

07:41

7. Visualizations and Dashboards in Databricks SQL

1. Visualizations and Dashboards Overview.mp4

02:34

2.1 72 - Our First Chart in Databricks SQL.txt

2.2 Bar Chart.html

2. Our First Chart in Databricks SQL.mp4

10:37

3.1 73 - Line and Area Charts.txt

3.2 Area Chart.html

3.3 Line Chart.html

3. Line and Area Charts.mp4

07:36

4.1 74 - Combo Chart.txt

4.2 Combo Chart.html

4. Combo Chart.mp4

04:00

5.1 75 - Pie Chart.txt

5.2 Pie Charts.html

5. Pie Chart.mp4

04:58

6.1 76 - Scatter and Bubble Plots.txt

6.2 Bubble Plots.html

6.3 Scatter Plots.html

6. Scatter and Bubble Plots.mp4

04:58

7.1 77 - Histograms.txt

7.2 Histogram.html

7. Histograms.mp4

03:49

8.1 78 - Box Plots.txt

8.2 Box Plots.html

8. Box Plots.mp4

05:56

9.1 79 - Heatmaps.txt

9. Heatmaps.mp4

04:30

10.1 80 - Sankey Charts.txt

10.2 Datetime Patterns.html

10. Sankey Charts.mp4

04:25

11.1 81 - Tables.txt

11. Tables.mp4

05:07

12.1 82 - Pivot Tables.txt

12. Pivot Tables.mp4

02:28

13. Counters.mp4

05:53

14.1 Visualization Types.html

14. Additional Guidance on Charts in Databricks SQL.mp4

00:33

15. Exploratory Data Analysis - Challenge.mp4

12:05

16.1 86 - Adding Missing Data to the JC Bike Data 22 Table.txt

16.2 JC Bike Data July 22.zip

16. Adding Missing Data to the JC BIKE DATA 22 Table.mp4

02:06

17.1 87 - Creating a View To Simplify Upcoming Demos.txt

17. Creating a View to Simplify Upcoming Demos.mp4

02:32

18.1 88 - Query Filters.txt

18.2 Query Filters.html

18. Query Filters.mp4

03:15

19.1 89 - Query Parameters.txt

19.2 Query Parameters.html

19. Query Parameters.mp4

04:39

20.1 90 - Query Parameters (Dates).txt

20. Query Parameters (Dates).mp4

02:46

21.1 91 - Introduction to Dashboards.txt

21.2 Dashboards.html

21. Introduction to Dashboards.mp4

11:33

22.1 92 - Adding Parameters to Dashboards.txt

22. Adding Parameters to Dashboards.mp4

05:46

23.1 93 - Adding Filters to Dashboards.txt

23. Adding Filters to Dashboards.mp4

03:08

24.1 94 - Trip Duration Analysis Challenge.txt

24. Trip Duration Analysis Challenge.mp4

07:38

25.1 95 - Rider Analysis Challenge.txt

25. Rider Type Analysis Challenge.mp4

07:47

8. Access Control, Data Governance and Unity Catalog

1. Administrative Roles in Databricks.mp4

01:57

2. Adding a New User to our Azure Account.mp4

04:11

3. Adding a New User to our Databricks Environment.mp4

04:43

4. Workspace Admin Settings.mp4

03:02

5. Workspace Object Access Control.mp4

00:25

6.1 SQL Warehouse Access Control.html

6. SQL Warehouse Access Control.mp4

02:59

7.1 Folder Access Control.html

7. Folder Access Control.mp4

03:35

8.1 Query Access Control.html

8. Query Access Control.mp4

04:10

9.1 Dashboard Access Control.html

9. Dashboard Access Control.mp4

02:55

10.1 Workspace Access Control.html

10. Workspace Object Access Control - Summary.mp4

00:51

11.1 Manage Privileges with Unity Catalog.html

11. Unity Catalog Securable Objects and Priveledges.mp4

04:34

12.1 GRANT.html

12.2 REVOKE.html

12. Granting and Revoking Privileges with SQL (Unity Catalog).mp4

08:25

13. Granting and Revoking Privileges via the Data Explorer (Unity Catalog).mp4

04:54

14.1 is account group member().html

14. Redacting Data with Dynamic Views (PII).mp4

05:55

15. Data Discovery.mp4

04:49

16. Data Lineage.mp4

03:37

17.1 Delta Sharing.html

17. Delta Sharing Overview.mp4

02:39

18. Databricks to Databricks Delta Sharing.mp4

04:07

19. Open Delta Sharing.mp4

02:32

9. Congratulations on completing the course!

1. Congratulations.html

2. Bonus Lecture.html

Description

Your Hands-On Guide to Data Analysis with Databricks. Master Azure Databricks SQL and Unity Catalog.

What You'll Learn?

Azure Databricks
SQL
Delta Lake
Unity Catalog
Data Visualization
Data Analysis
Big Data

Who is this for?

Anyone wanting to learn Databricks SQL

Students studying for the Databricks Data Analyst Certification

Aspiring Cloud Data Analysts

What You Need to Know?

No prior experience needed

Azure Account (set up instructions provided)

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Malvik is an Instructor specialising in Data Analytics and Visualization.He has spent 10+ years working for and consulting a number of publicly listed / unlisted companies as a Data and BI specialist. Over the course of his career Malvik has developed a skillset in data engineering, data analytics and visualisation, with expertise across a number of technologies and programming languages including SQL, Python and R. He has worked extensively with a number of leading software platforms including Azure, Hadoop, Spark, Databricks, MongoDB, Oracle, MySQL, MS SQL Server, Qlik and Microsoft Power Platforms.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.