Torrent Downloads » Other » [ WebToolTip com ] Udemy - Complete SQL for Data Analysis - Scenario Based Learning
Other
[ WebToolTip com ] Udemy - Complete SQL for Data Analysis - Scenario Based Learning
-
-
- Rate this torrent + | -
Download Anonymously! Get Protected Today And Get your 70% discount
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 3.77 GB) (Files: 126)
Get Bonus Downloads Here.url
~Get Your Files Here !
1 - Introduction
1. Welcome - What This Course Is Really About.mp4
10. DBeaver Editor Space.mp4
11. Course Structure - Flow and Approach.mp4
2. Introduction to SQL.mp4
3. Example - User Login Activity.mp4
4. SQL - Real Life Analogy.mp4
5. Database Used in this Course.mp4
6. PostgreSQL - DBeaver Connection.mp4
7. Business Story.mp4
8. Dataset Overview.mp4
9. Relationship Diagram with concept of Primary and Foreign Key.mp4
2 - Fetch and Filter Data
12. Dataset Creation Script.mp4
12. superffg_create_script.txt
13. Introduction to SELECT.mp4
14. SELECT - Use Cases.mp4
15. SELECT DISTINCT - Use Case.mp4
16. Introduction to WHERE.mp4
17. WHERE Equals (=) - Use Cases.mp4
18. WHERE AND OR - Use Cases.mp4
19. WHERE IN - Use Cases.mp4
20. Introduction to WHERE - LIKE.mp4
21. WHERE LIKE - Use Cases.mp4
22. WHERE BETWEEN - Use Cases.mp4
23. Introduction to NULL.mp4
24. WHERE NULL - Use Cases.mp4
25. COALESCE - Use Case.mp4
26. WHERE - QUICK RECAP.mp4
27. Introduction to ORDER BY and LIMIT.mp4
28. ORDER BY and LIMIT - Use Cases.mp4
29. Practice Q&A.html
29. Practice_Questions_Fetch_filter.pdf
3 - Summarizing Data (Aggregates & Grouping)
30. Introduction to Aggregate functions.mp4
31. COUNT - Use Cases.mp4
32. SUM AVG - Use Cases.mp4
33. MAX MIN - Use Cases.mp4
34. Introduction to GROUP BY and HAVING.mp4
35. Working Principle - GROUP BY and HAVING.mp4
36. GROUP BY - Use Case 1.mp4
37. GROUP BY - Use Case 2.mp4
38. GROUP BY - Use Case 3.mp4
39. GROUP BY - Use Case 4.mp4
40. Introduction to CASE.mp4
41. CASE - Use Case 1.mp4
42. CASE - Use Case 2.mp4
43. Practice Q&A.html
43. Practice Questions_Aggregates_Grouping.pdf
4 - Combining Data (JOINs, SubQueries, UNION)
44. Why JOINs.mp4
45. Different Types of JOIN.mp4
46. JOIN - Use Case 1.mp4
47. JOIN - Use Case 2.mp4
48. JOIN - Use Case 3.mp4
49. JOIN - Use Case 4.mp4
50. JOIN - QUICK RECAP.mp4
51. Introduction to SubQueries.mp4
52. SubQueries - Use Cases.mp4
53. Introduction to UNION.mp4
54. UNION - Use Case.mp4
55. Rules of UNION usage.mp4
56. Execution Order of SQL Keywords.mp4
57. Practice Q&A.html
57. Practice Questions_JOINS_Subqueries.pdf
5 - Advanced Analysis - CTE, Window Functions, String and Date Functions
58. Introduction to CTE.mp4
59. CTE - Use Case 1.mp4
59. Query1_without_CTE.txt
60. CTE - Use Case 2.mp4
60. Query2_without_CTE.txt
61. Introduction to Window Functions.mp4
62. Aggregate Window Function - Category 1.mp4
63. Ranking Window Function - Category 2.mp4
64. LAG LEAD Window Function - Category 3.mp4
65. Concept of RUNNING TOTAL.mp4
66. Concept of MOVING AVERAGE.mp4
67. WF_usecase1.txt
67. Window Function - Use Case 1.mp4
68. WF_usecase2.txt
68. Window Function - Use Case 2.mp4
69. WF_usecase3.txt
69. Window Function - Use Case 3.mp4
70. Window Function - QUICK RECAP.mp4
71. Introduction to String Functions.mp4
72. String Functions - Quick Note on Syntax.mp4
73. Commonly Used String Functions in SQL.mp4
74. String Function - Use Cases.mp4
75. Introduction to Date Functions.mp4
76. Date Extract Function.mp4
77. Date Arithmetics.mp4
78. Date Format and Conversion.mp4
79. Current Date Time Functions.mp4
80. Date Function Use Cases.mp4
81. Practice Q&A.html
81. Practice_Questions_Window_Str_Date_func.pdf
6 - Capstone (SuperFastFood Global Business Story)
82. SuperFastFood Global - Business Story Analytics.mp4
83. Dataset RECAP.mp4
84. Date Functions RECAP.mp4
85. Busiest Day Store Wise - Analytics.mp4
85. Busiest Day Store Wise.txt
86. City Leader by Revenue each Month - Analytics.mp4
86. City Leader each Month - by Revenue.txt
87. Product Category Revenue each Month - Analytics.mp4
87. Product Category Revenue each Month.txt
88. Product Wise Revenue Top 5 Bottom 5 - Quick Context.mp4
88. Top 5 and bottom 5 products based on revenue - per store.txt
7 - Managing Data (DDL and DML)
100. ALTER - Quick Summary.mp4
101. Introduction to DELETION.mp4
102. DELETION - Use Cases.mp4
103. DELETION- Quick Summary.mp4
89. Introduction to Create, Insert, Update.mp4
90. Create Table Structure - SuperFastFood Global.mp4
91. Datatypes Constraints - Quick Summary.mp4
92. CREATE TABLE - Use Case.mp4
93. INSERT - Use Case.mp4
94. CREATE INSERT - Using SELECT QUERY.mp4
95. UPDATE - Use Case.mp4
96. Create Insert Update - QUICK RECAP.mp4
97. Introduction to ALTER.mp4
98. ALTER - Use Cases - ADD-RENAME a Column.mp4
99. ALTER - Use Cases - MODIFY - DROP.mp4
8 - Indexing, Views, Normalization
104. Introduction to Indexing.mp4
105. Introduction to Views.mp4
106. View - Use Case.mp4
107. Introduction to Normalization.mp4
9 - Conclusion
108. Conclusion Video - Thank You.mp4
109. Important Interview Questions - Basics to Advanced.html
109. SQL_Basics_to_Advanced_Interview_questions.pdf
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ WebToolTip com ] Udemy - Complete SQL for Data Analysis - Scenario Based Learning Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
comments (0)
RECENT SEARCHES search cloud »
- Wyrmwood Road of the Dead 2014 720p BluRay H264 AAC RARBG
- Udemy 17 Beginner C Walkthrough Projects step by step
- Phoenix 1947
- Y Marshals S01E13
- superfly
- My Fellow Americans
- Finan M A First Course in Elementary Differential Equations
- brazzers elly clutch nerd to fox while riding cock rq mp4
- Y Marshals
- secret skinwalker
