[ WebToolTip.com ] Udemy - Complete SQL for Data Analysis - Scenario Based Learning

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1. Welcome - What This Course Is Really About.mp4

2.9 MB

~Get Your Files Here !/1 - Introduction/10. DBeaver Editor Space.mp4

11 MB

~Get Your Files Here !/1 - Introduction/11. Course Structure - Flow and Approach.mp4

20 MB

~Get Your Files Here !/1 - Introduction/2. Introduction to SQL.mp4

13 MB

~Get Your Files Here !/1 - Introduction/3. Example - User Login Activity.mp4

5.8 MB

~Get Your Files Here !/1 - Introduction/4. SQL - Real Life Analogy.mp4

12 MB

~Get Your Files Here !/1 - Introduction/5. Database Used in this Course.mp4

8.6 MB

~Get Your Files Here !/1 - Introduction/6. PostgreSQL - DBeaver Connection.mp4

17 MB

~Get Your Files Here !/1 - Introduction/7. Business Story.mp4

14 MB

~Get Your Files Here !/1 - Introduction/8. Dataset Overview.mp4

15 MB

~Get Your Files Here !/1 - Introduction/9. Relationship Diagram with concept of Primary and Foreign Key.mp4

42 MB

~Get Your Files Here !/2 - Fetch and Filter Data/12. Dataset Creation Script.mp4

20 MB

~Get Your Files Here !/2 - Fetch and Filter Data/12. superffg_create_script.txt

30 kB

~Get Your Files Here !/2 - Fetch and Filter Data/13. Introduction to SELECT.mp4

5.6 MB

~Get Your Files Here !/2 - Fetch and Filter Data/14. SELECT - Use Cases.mp4

33 MB

~Get Your Files Here !/2 - Fetch and Filter Data/15. SELECT DISTINCT - Use Case.mp4

16 MB

~Get Your Files Here !/2 - Fetch and Filter Data/16. Introduction to WHERE.mp4

9.2 MB

~Get Your Files Here !/2 - Fetch and Filter Data/17. WHERE Equals (=) - Use Cases.mp4

45 MB

~Get Your Files Here !/2 - Fetch and Filter Data/18. WHERE AND OR - Use Cases.mp4

76 MB

~Get Your Files Here !/2 - Fetch and Filter Data/19. WHERE IN - Use Cases.mp4

55 MB

~Get Your Files Here !/2 - Fetch and Filter Data/20. Introduction to WHERE - LIKE.mp4

11 MB

~Get Your Files Here !/2 - Fetch and Filter Data/21. WHERE LIKE - Use Cases.mp4

58 MB

~Get Your Files Here !/2 - Fetch and Filter Data/22. WHERE BETWEEN - Use Cases.mp4

75 MB

~Get Your Files Here !/2 - Fetch and Filter Data/23. Introduction to NULL.mp4

3.1 MB

~Get Your Files Here !/2 - Fetch and Filter Data/24. WHERE NULL - Use Cases.mp4

77 MB

~Get Your Files Here !/2 - Fetch and Filter Data/25. COALESCE - Use Case.mp4

54 MB

~Get Your Files Here !/2 - Fetch and Filter Data/26. WHERE - QUICK RECAP.mp4

32 MB

~Get Your Files Here !/2 - Fetch and Filter Data/27. Introduction to ORDER BY and LIMIT.mp4

9.6 MB

~Get Your Files Here !/2 - Fetch and Filter Data/28. ORDER BY and LIMIT - Use Cases.mp4

108 MB

~Get Your Files Here !/2 - Fetch and Filter Data/29. Practice Q&A.html

6.0 kB

~Get Your Files Here !/2 - Fetch and Filter Data/29. Practice_Questions_Fetch_filter.pdf

213 kB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/30. Introduction to Aggregate functions.mp4

5.5 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/31. COUNT - Use Cases.mp4

65 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/32. SUM AVG - Use Cases.mp4

55 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/33. MAX MIN - Use Cases.mp4

26 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/34. Introduction to GROUP BY and HAVING.mp4

5.2 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/35. Working Principle - GROUP BY and HAVING.mp4

13 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/36. GROUP BY - Use Case 1.mp4

26 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/37. GROUP BY - Use Case 2.mp4

53 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/38. GROUP BY - Use Case 3.mp4

24 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/39. GROUP BY - Use Case 4.mp4

32 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/40. Introduction to CASE.mp4

5.6 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/41. CASE - Use Case 1.mp4

31 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/42. CASE - Use Case 2.mp4

66 MB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/43. Practice Q&A.html

6.0 kB

~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/43. Practice Questions_Aggregates_Grouping.pdf

242 kB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/44. Why JOINs.mp4

32 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/45. Different Types of JOIN.mp4

17 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/46. JOIN - Use Case 1.mp4

54 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/47. JOIN - Use Case 2.mp4

59 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/48. JOIN - Use Case 3.mp4

92 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/49. JOIN - Use Case 4.mp4

64 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/50. JOIN - QUICK RECAP.mp4

15 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/51. Introduction to SubQueries.mp4

4.1 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/52. SubQueries - Use Cases.mp4

64 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/53. Introduction to UNION.mp4

5.0 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/54. UNION - Use Case.mp4

30 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/55. Rules of UNION usage.mp4

34 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/56. Execution Order of SQL Keywords.mp4

11 MB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/57. Practice Q&A.html

6.0 kB

~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/57. Practice Questions_JOINS_Subqueries.pdf

202 kB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/58. Introduction to CTE.mp4

5.9 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/59. CTE - Use Case 1.mp4

60 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/59. Query1_without_CTE.txt

315 B

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/60. CTE - Use Case 2.mp4

60 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/60. Query2_without_CTE.txt

707 B

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/61. Introduction to Window Functions.mp4

14 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/62. Aggregate Window Function - Category 1.mp4

17 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/63. Ranking Window Function - Category 2.mp4

24 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/64. LAG LEAD Window Function - Category 3.mp4

18 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/65. Concept of RUNNING TOTAL.mp4

14 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/66. Concept of MOVING AVERAGE.mp4

20 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/67. WF_usecase1.txt

574 B

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/67. Window Function - Use Case 1.mp4

132 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/68. WF_usecase2.txt

800 B

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/68. Window Function - Use Case 2.mp4

72 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/69. WF_usecase3.txt

956 B

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/69. Window Function - Use Case 3.mp4

211 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/70. Window Function - QUICK RECAP.mp4

16 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/71. Introduction to String Functions.mp4

4.0 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/72. String Functions - Quick Note on Syntax.mp4

3.1 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/73. Commonly Used String Functions in SQL.mp4

12 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/74. String Function - Use Cases.mp4

74 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/75. Introduction to Date Functions.mp4

9.6 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/76. Date Extract Function.mp4

7.4 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/77. Date Arithmetics.mp4

11 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/78. Date Format and Conversion.mp4

11 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/79. Current Date Time Functions.mp4

7.0 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/80. Date Function Use Cases.mp4

53 MB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/81. Practice Q&A.html

6.1 kB

~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/81. Practice_Questions_Window_Str_Date_func.pdf

241 kB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/82. SuperFastFood Global - Business Story Analytics.mp4

14 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/83. Dataset RECAP.mp4

54 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/84. Date Functions RECAP.mp4

33 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/85. Busiest Day Store Wise - Analytics.mp4

109 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/85. Busiest Day Store Wise.txt

307 B

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/86. City Leader by Revenue each Month - Analytics.mp4

145 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/86. City Leader each Month - by Revenue.txt

559 B

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/87. Product Category Revenue each Month - Analytics.mp4

122 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/87. Product Category Revenue each Month.txt

530 B

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/88. Product Wise Revenue Top 5 Bottom 5 - Quick Context.mp4

72 MB

~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/88. Top 5 and bottom 5 products based on revenue - per store.txt

811 B

~Get Your Files Here !/7 - Managing Data (DDL and DML)/100. ALTER - Quick Summary.mp4

12 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/101. Introduction to DELETION.mp4

3.9 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/102. DELETION - Use Cases.mp4

64 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/103. DELETION- Quick Summary.mp4

5.4 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/89. Introduction to Create, Insert, Update.mp4

4.6 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/90. Create Table Structure - SuperFastFood Global.mp4

133 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/91. Datatypes Constraints - Quick Summary.mp4

17 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/92. CREATE TABLE - Use Case.mp4

107 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/93. INSERT - Use Case.mp4

22 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/94. CREATE INSERT - Using SELECT QUERY.mp4

71 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/95. UPDATE - Use Case.mp4

26 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/96. Create Insert Update - QUICK RECAP.mp4

3.3 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/97. Introduction to ALTER.mp4

6.0 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/98. ALTER - Use Cases - ADD-RENAME a Column.mp4

54 MB

~Get Your Files Here !/7 - Managing Data (DDL and DML)/99. ALTER - Use Cases - MODIFY - DROP.mp4

68 MB

~Get Your Files Here !/8 - Indexing, Views, Normalization/104. Introduction to Indexing.mp4

12 MB

~Get Your Files Here !/8 - Indexing, Views, Normalization/105. Introduction to Views.mp4

16 MB

~Get Your Files Here !/8 - Indexing, Views, Normalization/106. View - Use Case.mp4

71 MB

~Get Your Files Here !/8 - Indexing, Views, Normalization/107. Introduction to Normalization.mp4

14 MB

~Get Your Files Here !/9 - Conclusion/108. Conclusion Video - Thank You.mp4

3.7 MB

~Get Your Files Here !/9 - Conclusion/109. Important Interview Questions - Basics to Advanced.html

6.0 kB

~Get Your Files Here !/9 - Conclusion/109. SQL_Basics_to_Advanced_Interview_questions.pdf

3.9 MB

~Get Your Files Here !/Bonus Resources.txt

70 B