FILENAME | SIZE |  | 1. Introduction/1. Introduction.mp4 | 29.7 MB |
 | 1. Introduction/1. Introduction.srt | 4.9 KB |
 | 10. Group By Commands/1. GROUP BY.mp4 | 93.3 MB |
 | 10. Group By Commands/1. GROUP BY.srt | 13.8 KB |
 | 10. Group By Commands/1.1 Lecture_22_group by.pdf | 174.6 KB |
 | 10. Group By Commands/2. HAVING.mp4 | 37.9 MB |
 | 10. Group By Commands/2. HAVING.srt | 5.4 KB |
 | 10. Group By Commands/2.1 Lecture_23_HAVING.pdf | 166.5 KB |
 | 10. Group By Commands/3. Exercise 9 Group By.mp4 | 6.2 MB |
 | 10. Group By Commands/3. Exercise 9 Group By.srt | 1.8 KB |
 | 10. Group By Commands/4. Quiz.html | 198 B |
 | 11. Conditional Statement/1. CASE WHEN.mp4 | 28.5 MB |
 | 11. Conditional Statement/1. CASE WHEN.srt | 6.6 KB |
 | 11. Conditional Statement/1.1 Lecture_CASE.pdf | 160 KB |
 | 12. JOINS/1. Introduction to Joins.mp4 | 7.9 MB |
 | 12. JOINS/1. Introduction to Joins.srt | 3.1 KB |
 | 12. JOINS/1.1 Lecture_24_Joins_Query.txt | 417 B |
 | 12. JOINS/10. Except.mp4 | 12.7 MB |
 | 12. JOINS/10. Except.srt | 3.5 KB |
 | 12. JOINS/10.1 Lecture_29_EXCEPT.pdf | 173.9 KB |
 | 12. JOINS/11. Union.mp4 | 15.1 MB |
 | 12. JOINS/11. Union.srt | 3.5 KB |
 | 12. JOINS/11.1 Lecture_30_UNION.pdf | 166.9 KB |
 | 12. JOINS/12. Exercise 10 Joins.mp4 | 6.9 MB |
 | 12. JOINS/12. Exercise 10 Joins.srt | 1.7 KB |
 | 12. JOINS/13. Quiz.html | 198 B |
 | 12. JOINS/2. Concepts of Joining and Combining Data.mp4 | 59.8 MB |
 | 12. JOINS/2. Concepts of Joining and Combining Data.srt | 13.4 KB |
 | 12. JOINS/3. Preparing the data.mp4 | 13.9 MB |
 | 12. JOINS/3. Preparing the data.srt | 2.3 KB |
 | 12. JOINS/3.1 M3_T1_V3 Joins_Query.txt | 417 B |
 | 12. JOINS/4. Inner Join.mp4 | 47.2 MB |
 | 12. JOINS/4. Inner Join.srt | 8 KB |
 | 12. JOINS/4.1 Lecture_24_INNER join.pdf | 214.2 KB |
 | 12. JOINS/5. Left Join.mp4 | 36.8 MB |
 | 12. JOINS/5. Left Join.srt | 8.4 KB |
 | 12. JOINS/5.1 Lecture_25_LEFT join.pdf | 219 KB |
 | 12. JOINS/6. Right Join.mp4 | 36 MB |
 | 12. JOINS/6. Right Join.srt | 6.6 KB |
 | 12. JOINS/6.1 Lecture_26_RIGHT join.pdf | 221.8 KB |
 | 12. JOINS/7. Full Outer Join.mp4 | 32.1 MB |
 | 12. JOINS/7. Full Outer Join.srt | 4.9 KB |
 | 12. JOINS/7.1 Lecture_27_OUTER join.pdf | 219.1 KB |
 | 12. JOINS/8. Cross Join.mp4 | 18.8 MB |
 | 12. JOINS/8. Cross Join.srt | 5.3 KB |
 | 12. JOINS/8.1 Lecture_28_Cross join.pdf | 186.7 KB |
 | 12. JOINS/9. Intersect and Intersect ALL.mp4 | 24.7 MB |
 | 12. JOINS/9. Intersect and Intersect ALL.srt | 7.6 KB |
 | 13. Subqueries/1. Subqueries.mp4 | 103.8 MB |
 | 13. Subqueries/1. Subqueries.srt | 19.4 KB |
 | 13. Subqueries/1.1 Lecture_31_SUBQUERY.pdf | 207.5 KB |
 | 13. Subqueries/2. Exercise 11 Subqueries.mp4 | 5.1 MB |
 | 13. Subqueries/2. Exercise 11 Subqueries.srt | 2 KB |
 | 14. Views and Indexes/1. VIEWS.mp4 | 42.5 MB |
 | 14. Views and Indexes/1. VIEWS.srt | 9.7 KB |
 | 14. Views and Indexes/1.1 Lecture_32_VIEWS.pdf | 220.7 KB |
 | 14. Views and Indexes/2. INDEX.mp4 | 40.3 MB |
 | 14. Views and Indexes/2. INDEX.srt | 9.9 KB |
 | 14. Views and Indexes/2.1 Lecture_33_INDEX.pdf | 201.6 KB |
 | 14. Views and Indexes/3. Exercise 12 Views.mp4 | 3.2 MB |
 | 14. Views and Indexes/3. Exercise 12 Views.srt | 1.2 KB |
 | 15. String Functions/1. LENGTH.mp4 | 18.6 MB |
 | 15. String Functions/1. LENGTH.srt | 4.6 KB |
 | 15. String Functions/1.1 Lecture_34_STRING functions.pdf | 209.5 KB |
 | 15. String Functions/2. UPPER LOWER.mp4 | 11.6 MB |
 | 15. String Functions/2. UPPER LOWER.srt | 3.4 KB |
 | 15. String Functions/3. REPLACE.mp4 | 25.3 MB |
 | 15. String Functions/3. REPLACE.srt | 5.5 KB |
 | 15. String Functions/4. TRIM, LTRIM, RTRIM.mp4 | 50 MB |
 | 15. String Functions/4. TRIM, LTRIM, RTRIM.srt | 9.6 KB |
 | 15. String Functions/5. CONCATENATION.mp4 | 16.9 MB |
 | 15. String Functions/5. CONCATENATION.srt | 3.8 KB |
 | 15. String Functions/6. SUBSTRING.mp4 | 42.3 MB |
 | 15. String Functions/6. SUBSTRING.srt | 7.4 KB |
 | 15. String Functions/7. LIST AGGREGATION.mp4 | 33.1 MB |
 | 15. String Functions/7. LIST AGGREGATION.srt | 6.7 KB |
 | 15. String Functions/8. Exercise 13 String Functions.mp4 | 16.5 MB |
 | 15. String Functions/8. Exercise 13 String Functions.srt | 3.9 KB |
 | 16. Mathematical Functions/1. CEIL & FLOOR.mp4 | 21 MB |
 | 16. Mathematical Functions/1. CEIL & FLOOR.srt | 4.8 KB |
 | 16. Mathematical Functions/1.1 Lecture_35_MATH functions.pdf | 192.9 KB |
 | 16. Mathematical Functions/2. RANDOM.mp4 | 31.4 MB |
 | 16. Mathematical Functions/2. RANDOM.srt | 6.6 KB |
 | 16. Mathematical Functions/3. SETSEED.mp4 | 24.8 MB |
 | 16. Mathematical Functions/3. SETSEED.srt | 4.5 KB |
 | 16. Mathematical Functions/4. ROUND.mp4 | 16.8 MB |
 | 16. Mathematical Functions/4. ROUND.srt | 3.2 KB |
 | 16. Mathematical Functions/5. POWER.mp4 | 12.1 MB |
 | 16. Mathematical Functions/5. POWER.srt | 3.1 KB |
 | 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.mp4 | 10.3 MB |
 | 16. Mathematical Functions/6. Exercise 14 Mathematical Functions.srt | 2.5 KB |
 | 17. Date-Time Functions/1. CURRENT DATE & TIME.mp4 | 32.3 MB |
 | 17. Date-Time Functions/1. CURRENT DATE & TIME.srt | 6.3 KB |
 | 17. Date-Time Functions/1.1 Lecture_36_DATETIME functions.pdf | 232.4 KB |
 | 17. Date-Time Functions/2. AGE.mp4 | 26.6 MB |
 | 17. Date-Time Functions/2. AGE.srt | 4.2 KB |
 | 17. Date-Time Functions/3. EXTRACT.mp4 | 58.7 MB |