Filename Size ~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 10.6 MB ~Get Your Files Here !/1 - Introduction/11. Course Structure - Flow and Approach.mp4 20.5 MB ~Get Your Files Here !/1 - Introduction/2. Introduction to SQL.mp4 13.1 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 11.9 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 13.8 MB ~Get Your Files Here !/1 - Introduction/8. Dataset Overview.mp4 15.4 MB ~Get Your Files Here !/1 - Introduction/9. Relationship Diagram with concept of Primary and Foreign Key.mp4 42.5 MB ~Get Your Files Here !/2 - Fetch and Filter Data/12. Dataset Creation Script.mp4 20.1 MB ~Get Your Files Here !/2 - Fetch and Filter Data/12. superffg_create_script.txt 29.8 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 32.6 MB ~Get Your Files Here !/2 - Fetch and Filter Data/15. SELECT DISTINCT - Use Case.mp4 15.5 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 75.5 MB ~Get Your Files Here !/2 - Fetch and Filter Data/19. WHERE IN - Use Cases.mp4 55.1 MB ~Get Your Files Here !/2 - Fetch and Filter Data/20. Introduction to WHERE - LIKE.mp4 10.8 MB ~Get Your Files Here !/2 - Fetch and Filter Data/21. WHERE LIKE - Use Cases.mp4 58.5 MB ~Get Your Files Here !/2 - Fetch and Filter Data/22. WHERE BETWEEN - Use Cases.mp4 74.9 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 76.6 MB ~Get Your Files Here !/2 - Fetch and Filter Data/25. COALESCE - Use Case.mp4 53.9 MB ~Get Your Files Here !/2 - Fetch and Filter Data/26. WHERE - QUICK RECAP.mp4 32.2 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 107.8 MB ~Get Your Files Here !/2 - Fetch and Filter Data/29. Practice Q&A.html 6 KB ~Get Your Files Here !/2 - Fetch and Filter Data/29. Practice_Questions_Fetch_filter.pdf 213.4 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 54.7 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/33. MAX MIN - Use Cases.mp4 26.4 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 12.8 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/36. GROUP BY - Use Case 1.mp4 26.3 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/37. GROUP BY - Use Case 2.mp4 52.7 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/38. GROUP BY - Use Case 3.mp4 24.5 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/39. GROUP BY - Use Case 4.mp4 32.2 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.1 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/42. CASE - Use Case 2.mp4 65.9 MB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/43. Practice Q&A.html 6 KB ~Get Your Files Here !/3 - Summarizing Data (Aggregates & Grouping)/43. Practice Questions_Aggregates_Grouping.pdf 242.5 KB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/44. Why JOINs.mp4 32.2 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 58.6 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/48. JOIN - Use Case 3.mp4 91.8 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/49. JOIN - Use Case 4.mp4 64.1 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 63.9 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/53. Introduction to UNION.mp4 5 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/54. UNION - Use Case.mp4 29.8 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/55. Rules of UNION usage.mp4 34.3 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/56. Execution Order of SQL Keywords.mp4 11.2 MB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/57. Practice Q&A.html 6 KB ~Get Your Files Here !/4 - Combining Data (JOINs, SubQueries, UNION)/57. Practice Questions_JOINS_Subqueries.pdf 202.4 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.4 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.5 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 13.6 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/62. Aggregate Window Function - Category 1.mp4 17.4 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/63. Ranking Window Function - Category 2.mp4 24.4 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/64. LAG LEAD Window Function - Category 3.mp4 18.1 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/65. Concept of RUNNING TOTAL.mp4 14.4 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/66. Concept of MOVING AVERAGE.mp4 20.5 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 131.9 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 71.9 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.2 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/70. Window Function - QUICK RECAP.mp4 16.4 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/71. Introduction to String Functions.mp4 4 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.5 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.4 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/78. Date Format and Conversion.mp4 11.2 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/79. Current Date Time Functions.mp4 7 MB ~Get Your Files Here !/5 - Advanced Analysis - CTE, Window Functions, String and Date Functions/80. Date Function Use Cases.mp4 52.9 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.2 KB ~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/82. SuperFastFood Global - Business Story Analytics.mp4 14.2 MB ~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/83. Dataset RECAP.mp4 53.6 MB ~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/84. Date Functions RECAP.mp4 33.3 MB ~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/85. Busiest Day Store Wise - Analytics.mp4 109.1 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 144.6 MB ~Get Your Files Here !/6 - Capstone (SuperFastFood Global Business Story)/86. City Leader each Month - by Revenue.txt 559 B