Databricks SQL for Data Analysts

/.../1. Set Up and Overview of Databricks/

2. Introduction to Big Data (Optional).mp4

4.1 Comparing Databricks to Apache Spark.html

5.1 Azure Account Creation Link.html

6.1 Azure Portal Overview.html

8.1 Supported Regions - Serverless SQL.html

11.1 Get started using Unity Catalog.html

12.1 Data Lake Storage - Introduction.html

15.1 Azure Pricing Calculator.html

4. Overview of Databricks.mp4

1. Course Overview.mp4

12. ADLS Overview and Storage Creation.mp4

10. Unity Catalog Overview.mp4

3. Apache Spark Ecosystem (Optional).mp4

6. Azure Portal Overview.mp4

7. Cost Management and Billing.mp4

8. Creating a Databricks Premium Workspace.mp4

9. Databricks Workspace User Interface.mp4

15. Creating a SQL Warehouse.mp4

14. Enabling Unity Catalog.mp4

13. Access Connector for Databricks.mp4

11. Enabling Unity Catalog - Overview.mp4

5. Azure Account Set Up.mp4

/

TutsNode.net.txt

[TGx]Downloaded from torrentgalaxy.to .txt

/.../2. Introduction to Queries/

5.1 Course Resources - SQL Code.zip

1.1 16 - Your First Query.txt

1.2 ANSI SQL.html

1.3 Evolution of Databricks SQL Language.html

2.1 17 - Switching Catalogs and Schemas.txt

2.2 Syntax - Use Catalog.html

2.3 Syntax - Use Schema.html

3.1 18 - Scheduling Queries.txt

3.2 Schedule a Query.html

1. Your First Query.mp4

5. Course Resources - SQL Code Download.mp4

2. Switching Catalogs and Schemas.mp4

3. Scheduling Queries.mp4

4. Adding Comments to Queries.mp4

/.../3. Catalogs, Schemas, Tables and Views/

1.1 21 - Creating Catalogs.txt

9.2 Files for External Storage.zip

5.1 25 - Creating Managed Tables with SQL.txt

9.1 29 - Creating External Tables.txt

12.1 32 - Alter Table.txt

2.1 22 - Creating Schemas.txt

3.1 Data Types in Databricks SQL.html

8.1 Managed External Locations and Storage Credentials.html

13.1 33 - Dropping Tables, Schemas and Views.txt

11.1 31 - Truncate Tables.txt

11.2 Truncate Table Command.html

12.2 Alter Table Command.html

13.2 Drop Catalog Command.html

13.3 Drop Schema Command.html

13.4 Drop Table Command.html

5. Creating Managed Tables with SQL.mp4

1. Creating Catalogs.mp4

9. Creating External Tables.mp4

3. Data Types in Databricks SQL.mp4

8. Creating an External Storage Location.mp4

7. Creating Managed Tables using the Data Explorer.mp4

10. Overriding Unity Catalog’s Default Managed Table Storage Location.mp4

2. Creating Schemas.mp4

4. Overview of Tables in Databricks.mp4

13. Drop Tables, Schemas and Catalogs.mp4

12. Alter Table.mp4

6. Creating Managed Tables in Hive Metastore.mp4

7.1 JC Bike Share 22 Course Data.zip

11. Truncate Table.mp4

/.../9. Congratulations on completing the course!/

2. Bonus Lecture.html

1. Congratulations.html

/5. Delta Lake/

4.1 66 - Merge Into.txt

5.1 67 - Table Audit History and Time Travel.txt

4.2 Merge Into.html

1.1 Medallion Architecture.html

5.2 Delta History and Time Travel.html

3.1 Delta Lake.html

1. Medallion Architecture and Last Mile ETL.mp4

3. Benefits of Delta File Format.mp4

4. Upsert Merge Into.mp4

5. Table Audit History and Time Travel.mp4

2. Medallion Architecture Demo.mp4

/.../4. Data Analysis with SQL/

15.1 48 - Group By Clause.txt

12.1 45 - Converting Strings to DatesTimestamps.txt

18.1 51 - Joining Tables Demo.txt

5.1 38 - Filtering Records Based on Multiple Conditions.txt

13.1 46 - Conditional Functions.txt

23.1 56 - Set Operators.txt

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

4.1 37 - Filtering Records with the WHERE Clause.txt

10.1 43 - Numerical Functions.txt

28.1 61 - SQL Challenge 5.txt

9.1 42 - String Functions.txt

20.1 53 - SQL Order of Execution.txt

1.1 34 - Select Statement Recap.txt

19.1 52 - Order By and Limit Clauses.txt

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

21.1 54 - Subqueries.txt

22.1 55 - Views.txt

27.1 60 - SQL Challenge 4.txt

11.1 44 - Date and Timestamp Functions.txt

25.1 58 - SQL Challenge 2.txt

2.1 35 - Select Distinct.txt

24.1 57 - SQL Challenge 1.txt

4.2 WHERE Clause.html

7.1 40 - Deleting Records.txt

14.1 47 - Aggregate Functions.txt

5.2 AND Operator.html

5.3 BETWEEN Operator.html

5.4 NOT Operator.html

5.5 OR Operator.html

6.2 IN Operator.html

6.3 LIKE Operator.html

7.2 DELETE FROM Syntax.html

26.1 59 - SQL Challenge 3.txt

8.1 Built In Functions Documentation.html

9.2 String Functions.html

11.2 Date and Timestamp Functions.html

10.2 Numerical Functions.html

12.2 Conversion Functions.html

14.2 Aggregate Functions.html

11.3 Datetime Patterns.html

19.3 Order By Clause.html

12.3 Datetime Patterns.html

12.4 TO_DATE.html

12.5 TO_TIMESTAMP.html

16.2 Having Clause.html

21.2 Subqueries.html

13.2 CASE Expression.html

13.3 IF Function.html

23.2 Set Operators.html

19.2 Limit Clause.html

18.2 JOIN.html

22.2 CREATE VIEW.html

18. Joining Tables Demo.mp4

9. String Functions.mp4

17. Joining Tables Overview.mp4

4. Filtering Records with the WHERE Clause.mp4

5. Filtering Records Based on Multiple Conditions.mp4

28. SQL Challenge 5.mp4

22. Views.mp4

13. Conditional Functions.mp4

1. Select Statement Recap.mp4

11. Date and Timestamp Functions.mp4

23. Set Operators.mp4

15. Group By Clause.mp4

19. Order By and Limit Clauses.mp4

16. Filtering Aggregated Tables with the Having Clause.mp4

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

12. Converting Strings to DatesTimestamps.mp4

21. Subqueries.mp4

20. SQL Order of Execution.mp4

2. Select Distinct.mp4

10. Numerical Functions.mp4

27. SQL Challenge 4.mp4

25. SQL Challenge 2.mp4

26. SQL Challenge 3.mp4

14. Aggregate Functions.mp4

8. Databricks SQL Built In Functions Overview.mp4

24. SQL Challenge 1.mp4

7. Deleting Records.mp4

3. Note on the JC_BIKE_DATA_22 Table.mp4

29. Schema Clean Up.mp4

/.../7. Visualizations and Dashboards in Databricks SQL/

8.1 78 - Box Plots.txt

2.1 72 - Our First Chart in Databricks SQL.txt

6.1 76 - Scatter and Bubble Plots.txt

22.1 92 - Adding Parameters to Dashboards.txt

9.1 79 - Heatmaps.txt

10.1 80 - Sankey Charts.txt

5.1 75 - Pie Chart.txt

4.1 74 - Combo Chart.txt

24.1 94 - Trip Duration Analysis Challenge.txt

7.1 77 - Histograms.txt

21.1 91 - Introduction to Dashboards.txt

3.1 73 - Line and Area Charts.txt

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

23.1 93 - Adding Filters to Dashboards.txt

25.1 95 - Rider Analysis Challenge.txt

19.1 89 - Query Parameters.txt

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

18.1 88 - Query Filters.txt

11.1 81 - Tables.txt

20.1 90 - Query Parameters (Dates).txt

12.1 82 - Pivot Tables.txt

3.2 Area Chart.html

3.3 Line Chart.html

5.2 Pie Charts.html

2.2 Bar Chart.html

7.2 Histogram.html

10.2 Datetime Patterns.html

6.3 Scatter Plots.html

6.2 Bubble Plots.html

4.2 Combo Chart.html

8.2 Box Plots.html

14.1 Visualization Types.html

19.2 Query Parameters.html

18.2 Query Filters.html

21.2 Dashboards.html

21. Introduction to Dashboards.mp4

15. Exploratory Data Analysis - Challenge.mp4

24. Trip Duration Analysis Challenge.mp4

2. Our First Chart in Databricks SQL.mp4

25. Rider Type Analysis Challenge.mp4

3. Line and Area Charts.mp4

22. Adding Parameters to Dashboards.mp4

13. Counters.mp4

9. Heatmaps.mp4

1. Visualizations and Dashboards Overview.mp4

19. Query Parameters.mp4

10. Sankey Charts.mp4

6. Scatter and Bubble Plots.mp4

5. Pie Chart.mp4

8. Box Plots.mp4

11. Tables.mp4

18. Query Filters.mp4

23. Adding Filters to Dashboards.mp4

4. Combo Chart.mp4

7. Histograms.mp4

17. Creating a View to Simplify Upcoming Demos.mp4

20. Query Parameters (Dates).mp4

12. Pivot Tables.mp4

16. Adding Missing Data to the JC_BIKE_DATA_22 Table.mp4

14. Additional Guidance on Charts in Databricks SQL.mp4

16.2 JC Bike Data July 22.zip

/.../8. Access Control, Data Governance and Unity Catalog/

7.1 Folder Access Control.html

11.1 Manage Privileges with Unity Catalog.html

14.1 is_account_group_member().html

6.1 SQL Warehouse Access Control.html

9.1 Dashboard Access Control.html

8.1 Query Access Control.html

10.1 Workspace Access Control.html

12.2 REVOKE.html

12.1 GRANT.html

17.1 Delta Sharing.html

11. Unity Catalog Securable Objects and Priveledges.mp4

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

16. Data Lineage.mp4

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

15. Data Discovery.mp4

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

17. Delta Sharing Overview.mp4

1. Administrative Roles in Databricks.mp4

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

8. Query Access Control.mp4

7. Folder Access Control.mp4

18. Databricks to Databricks Delta Sharing.mp4

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

9. Dashboard Access Control.mp4

6. SQL Warehouse Access Control.mp4

19. Open Delta Sharing.mp4

4. Workspace Admin Settings.mp4

10. Workspace Object Access Control - Summary.mp4

5. Workspace Object Access Control.mp4

/.../6. Query Alerts and Monitoring/

1.1 Query History.html

1.2 Query Profile.html

2.1 Query Caching.html

3.1 Query Alerts.html

2. Query Caching in Databricks SQL.mp4

1. Query History and Profile.mp4

3. Query Alerts.mp4

/.pad/

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

Total files 373