GetFreeCourses.Co-Udemy-SQL Masterclass SQL for Data Analytics

File Name

Size

1. Introduction/1. Introduction.mp4

30 MB

1. Introduction/1. Introduction.srt

4.9 kB

10. Group By Commands/1. GROUP BY.mp4

93 MB

10. Group By Commands/1. GROUP BY.srt

14 kB

10. Group By Commands/1.1 Lecture_22_group by.pdf

175 kB

10. Group By Commands/2. HAVING.mp4

38 MB

10. Group By Commands/2. HAVING.srt

5.4 kB

10. Group By Commands/2.1 Lecture_23_HAVING.pdf

166 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 MB

11. Conditional Statement/1. CASE WHEN.srt

6.6 kB

11. Conditional Statement/1.1 Lecture_CASE.pdf

160 kB

11. Conditional Statement/GetFreeCourses.Co.url

116 B

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

13 MB

12. JOINS/10. Except.srt

3.5 kB

12. JOINS/10.1 Lecture_29_EXCEPT.pdf

174 kB

12. JOINS/11. Union.mp4

15 MB

12. JOINS/11. Union.srt

3.5 kB

12. JOINS/11.1 Lecture_30_UNION.pdf

167 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

60 MB

12. JOINS/2. Concepts of Joining and Combining Data.srt

13 kB

12. JOINS/3. Preparing the data.mp4

14 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 MB

12. JOINS/4. Inner Join.srt

8.0 kB

12. JOINS/4.1 Lecture_24_INNER join.pdf

214 kB

12. JOINS/5. Left Join.mp4

37 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

222 kB

12. JOINS/7. Full Outer Join.mp4

32 MB

12. JOINS/7. Full Outer Join.srt

4.9 kB

12. JOINS/7.1 Lecture_27_OUTER join.pdf

219 kB

12. JOINS/8. Cross Join.mp4

19 MB

12. JOINS/8. Cross Join.srt

5.3 kB

12. JOINS/8.1 Lecture_28_Cross join.pdf

187 kB

12. JOINS/9. Intersect and Intersect ALL.mp4

25 MB

12. JOINS/9. Intersect and Intersect ALL.srt

7.6 kB

13. Subqueries/1. Subqueries.mp4

104 MB

13. Subqueries/1. Subqueries.srt

19 kB

13. Subqueries/1.1 Lecture_31_SUBQUERY.pdf

208 kB

13. Subqueries/2. Exercise 11 Subqueries.mp4

5.1 MB

13. Subqueries/2. Exercise 11 Subqueries.srt

2.0 kB

14. Views and Indexes/1. VIEWS.mp4

42 MB

14. Views and Indexes/1. VIEWS.srt

9.7 kB

14. Views and Indexes/1.1 Lecture_32_VIEWS.pdf

221 kB

14. Views and Indexes/2. INDEX.mp4

40 MB

14. Views and Indexes/2. INDEX.srt

9.9 kB

14. Views and Indexes/2.1 Lecture_33_INDEX.pdf

202 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

19 MB

15. String Functions/1. LENGTH.srt

4.6 kB

15. String Functions/1.1 Lecture_34_STRING functions.pdf

210 kB

15. String Functions/2. UPPER LOWER.mp4

12 MB

15. String Functions/2. UPPER LOWER.srt

3.4 kB

15. String Functions/3. REPLACE.mp4

25 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

17 MB

15. String Functions/5. CONCATENATION.srt

3.8 kB

15. String Functions/6. SUBSTRING.mp4

42 MB

15. String Functions/6. SUBSTRING.srt

7.4 kB

15. String Functions/7. LIST AGGREGATION.mp4

33 MB

15. String Functions/7. LIST AGGREGATION.srt

6.7 kB

15. String Functions/8. Exercise 13 String Functions.mp4

16 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

193 kB

16. Mathematical Functions/2. RANDOM.mp4

31 MB

16. Mathematical Functions/2. RANDOM.srt

6.6 kB

16. Mathematical Functions/3. SETSEED.mp4

25 MB

16. Mathematical Functions/3. SETSEED.srt

4.5 kB

16. Mathematical Functions/4. ROUND.mp4

17 MB

16. Mathematical Functions/4. ROUND.srt

3.2 kB

16. Mathematical Functions/5. POWER.mp4

12 MB

16. Mathematical Functions/5. POWER.srt

3.1 kB

16. Mathematical Functions/6. Exercise 14 Mathematical Functions.mp4

10 MB

16. Mathematical Functions/6. Exercise 14 Mathematical Functions.srt

2.5 kB

16. Mathematical Functions/GetFreeCourses.Co.url

116 B

17. Date-Time Functions/1. CURRENT DATE & TIME.mp4

32 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 kB

17. Date-Time Functions/2. AGE.mp4

27 MB

17. Date-Time Functions/2. AGE.srt

4.2 kB

17. Date-Time Functions/3. EXTRACT.mp4

59 MB

17. Date-Time Functions/3. EXTRACT.srt

10 kB

17. Date-Time Functions/4. Exercise 15 Date-time functions.mp4

5.7 MB

17. Date-Time Functions/4. Exercise 15 Date-time functions.srt

1.9 kB

18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.mp4

41 MB

18. PATTERN (STRING) MATCHING/1. PATTERN MATCHING BASICS.srt

11 kB

18. PATTERN (STRING) MATCHING/1.1 Lecture_Pattern_Matching.pdf

239 kB

18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).mp4

103 MB

18. PATTERN (STRING) MATCHING/2. ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS).srt

18 kB

18. PATTERN (STRING) MATCHING/2.1 User_table.txt

242 B

18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.mp4

8.3 MB

18. PATTERN (STRING) MATCHING/3. Exercise 16 Pattern Matching.srt

2.7 kB

19. Window Functions/1. Introduction to Window functions.mp4

58 MB

19. Window Functions/1. Introduction to Window functions.srt

10 kB

19. Window Functions/1.1 Windows Function PPT.pdf

617 kB

19. Window Functions/10. LAG and LEAD.mp4

71 MB

19. Window Functions/10. LAG and LEAD.srt

8.5 kB

19. Window Functions/2. Introduction to Row number.mp4

38 MB

19. Window Functions/2. Introduction to Row number.srt

6.0 kB

19. Window Functions/3. Implementing Row number in SQL.mp4

174 MB

19. Window Functions/3. Implementing Row number in SQL.srt

19 kB

19. Window Functions/4. RANK and DENSERANK.mp4

55 MB

19. Window Functions/4. RANK and DENSERANK.srt

7.6 kB

19. Window Functions/5. NTILE function.mp4

67 MB

19. Window Functions/5. NTILE function.srt

7.0 kB

19. Window Functions/6. AVERAGE function.mp4

59 MB

19. Window Functions/6. AVERAGE function.srt

8.0 kB

19. Window Functions/7. COUNT.mp4

32 MB

19. Window Functions/7. COUNT.srt

4.0 kB

19. Window Functions/8. SUM TOTAL.mp4

87 MB

19. Window Functions/8. SUM TOTAL.srt

11 kB

19. Window Functions/9. RUNNING TOTAL.mp4

64 MB

19. Window Functions/9. RUNNING TOTAL.srt

7.2 kB

2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.mp4

68 MB

2. Installation and getting started/1. Installing PostgreSQL and pgAdmin in your PC.srt

13 kB

2. Installation and getting started/1.1 00 Debugging PostgreSQL installation issues.pdf

253 kB

2. Installation and getting started/1.2 Installing+PostgreSQL+on+Mac.pdf

210 kB

2. Installation and getting started/2. This is a milestone!.mp4

21 MB

2. Installation and getting started/2. This is a milestone!.srt

3.9 kB

2. Installation and getting started/3. If pgAdmin is not opening....html

1.6 kB

2. Installation and getting started/4. Course Resources.html

411 B

20. COALESCE function/1. COALESCE function.mp4

43 MB

20. COALESCE function/1. COALESCE function.srt

6.1 kB

20. COALESCE function/1.1 Windows Function PPT.pdf

617 kB

20. COALESCE function/GetFreeCourses.Co.url

116 B

21. Data Type conversion functions/1. Converting Numbers Date to String.mp4

73 MB

21. Data Type conversion functions/1. Converting Numbers Date to String.srt

13 kB

21. Data Type conversion functions/1.1 Lecture_37_Conversion functions.pdf

220 kB

21. Data Type conversion functions/2. Converting String to Numbers Date.mp4

39 MB

21. Data Type conversion functions/2. Converting String to Numbers Date.srt

6.4 kB

22. User Access Control Functions/1. User Access Control.mp4

80 MB

22. User Access Control Functions/1. User Access Control.srt

16 kB

22. User Access Control Functions/1.1 Lecture_38_ACCESS control.pdf

208 kB

23. Nail that Interview!/1. Tablespace.mp4

36 MB

23. Nail that Interview!/1. Tablespace.srt

7.1 kB

23. Nail that Interview!/1.1 Lecture_TABLESPACE.pdf

189 kB

23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.mp4

25 MB

23. Nail that Interview!/2. PRIMARY KEY & FOREIGN KEY.srt

8.6 kB

23. Nail that Interview!/2.1 Lecture_5_Keys.pdf

235 kB

23. Nail that Interview!/3. ACID compliance.mp4

43 MB

23. Nail that Interview!/3. ACID compliance.srt

10 kB

23. Nail that Interview!/3.1 Lecture_ACID.pdf

191 kB

23. Nail that Interview!/4. Truncate.mp4

21 MB

23. Nail that Interview!/4. Truncate.srt

5.3 kB

23. Nail that Interview!/4.1 Lecture_TRUNCATE.pdf

160 kB

23. Nail that Interview!/5. Practice Test 1.html

198 B

23. Nail that Interview!/6. SQL Quiz.html

198 B

23. Nail that Interview!/GetFreeCourses.Co.url

116 B

24. Performance tuning tips/1. TIP 1 (EXPLAIN).mp4

26 MB

24. Performance tuning tips/1. TIP 1 (EXPLAIN).srt

4.2 kB

24. Performance tuning tips/1.1 Lecture_Performance_Tuning.pdf

285 kB

24. Performance tuning tips/2. TIP 2.mp4

5.8 MB

24. Performance tuning tips/2. TIP 2.srt

1.8 kB

24. Performance tuning tips/3. TIP 3.mp4

14 MB

24. Performance tuning tips/3. TIP 3.srt

4.1 kB

24. Performance tuning tips/4. TIP 4 (VACCUM).mp4

2.9 MB

24. Performance tuning tips/4. TIP 4 (VACCUM).srt

777 B

24. Performance tuning tips/5. TIP 5.mp4

12 MB

24. Performance tuning tips/5. TIP 5.srt

3.4 kB

24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).mp4

14 MB

24. Performance tuning tips/6. TIP 6 (STRING FUNCTIONS).srt

3.4 kB

24. Performance tuning tips/7. TIP 7 (JOINS).mp4

11 MB

24. Performance tuning tips/7. TIP 7 (JOINS).srt

2.8 kB

24. Performance tuning tips/8. TIP 8 (SCHEMAS).mp4

32 MB

24. Performance tuning tips/8. TIP 8 (SCHEMAS).srt

6.3 kB

25. Final Section Database Basics/1. What is SQL.mp4

8.7 MB

25. Final Section Database Basics/1. What is SQL.srt

2.3 kB

25. Final Section Database Basics/2. Tables and DBMS.mp4

15 MB

25. Final Section Database Basics/2. Tables and DBMS.srt

3.6 kB

25. Final Section Database Basics/3. Types of SQL commands.mp4

22 MB

25. Final Section Database Basics/3. Types of SQL commands.srt

5.6 kB

25. Final Section Database Basics/4. PostgreSQL.mp4

14 MB

25. Final Section Database Basics/4. PostgreSQL.srt

3.4 kB

25. Final Section Database Basics/5. The final milestone!.mp4

12 MB

25. Final Section Database Basics/5. The final milestone!.srt

1.8 kB

25. Final Section Database Basics/6. Bonus Lecture.html

2.3 kB

3. Case Study Demo/1. Case Study Part 1 - Business problems.mp4

38 MB

3. Case Study Demo/1. Case Study Part 1 - Business problems.srt

5.4 kB

3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.mp4

59 MB

3. Case Study Demo/2. Case Study Part 2 - How SQL is Used.srt

7.5 kB

4. Fundamental SQL statements/1. CREATE.mp4

91 MB

4. Fundamental SQL statements/1. CREATE.srt

14 kB

4. Fundamental SQL statements/10. Logical Operators.mp4

50 MB

4. Fundamental SQL statements/10. Logical Operators.srt

6.0 kB

4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.mp4

7.2 MB

4. Fundamental SQL statements/11. Exercise 3 SELECT & WHERE.srt

2.0 kB

4. Fundamental SQL statements/12. UPDATE.mp4

38 MB

4. Fundamental SQL statements/12. UPDATE.srt

5.6 kB

4. Fundamental SQL statements/12.1 Lecture_10_UPDATEDelete.pdf

211 kB

4. Fundamental SQL statements/13. DELETE.mp4

29 MB

4. Fundamental SQL statements/13. DELETE.srt

5.4 kB

4. Fundamental SQL statements/14. ALTER.mp4

126 MB

4. Fundamental SQL statements/14. ALTER.srt

19 kB

4. Fundamental SQL statements/14.1 Lecture_11_ALTER.pdf

202 kB

4. Fundamental SQL statements/15. Exercise 4 Updating Table.mp4

3.9 MB

4. Fundamental SQL statements/15. Exercise 4 Updating Table.srt

1.5 kB

4. Fundamental SQL statements/16. Fundamental SQL statements.html

198 B

4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.mp4

5.9 MB

4. Fundamental SQL statements/2. Exercise 1 Create DB and Table.srt

2.6 kB

4. Fundamental SQL statements/3. Solutions to all Exercises.html

120 B

4. Fundamental SQL statements/3.1 Solution.pdf

734 kB

4. Fundamental SQL statements/4. INSERT.mp4

73 MB

4. Fundamental SQL statements/4. INSERT.srt

9.6 kB

4. Fundamental SQL statements/5. Import data from File.mp4

42 MB

4. Fundamental SQL statements/5. Import data from File.srt

5.5 kB

4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.mp4

4.6 MB

4. Fundamental SQL statements/6. Exercise 2 Inserting and Importing.srt

1.2 kB

4. Fundamental SQL statements/6.1 Student.csv

129 B

4. Fundamental SQL statements/7. SELECT statement.mp4

32 MB

4. Fundamental SQL statements/7. SELECT statement.srt

4.6 kB

4. Fundamental SQL statements/8. SELECT DISTINCT.mp4

46 MB

4. Fundamental SQL statements/8. SELECT DISTINCT.srt

6.1 kB

4. Fundamental SQL statements/9. WHERE.mp4

33 MB

4. Fundamental SQL statements/9. WHERE.srt

4.1 kB

5. Restore and Back-up/1. Restore and Back-up.mp4

72 MB

5. Restore and Back-up/1. Restore and Back-up.srt

9.8 kB

5. Restore and Back-up/1.1 BackupFiles.zip

586 kB

5. Restore and Back-up/1.2 Supermart_DB.tar

1.2 MB

5. Restore and Back-up/2. Debugging restoration issues.mp4

50 MB

5. Restore and Back-up/2. Debugging restoration issues.srt

9.8 kB

5. Restore and Back-up/3. Creating DB using CSV files.mp4

36 MB

5. Restore and Back-up/3. Creating DB using CSV files.srt

6.4 kB

5. Restore and Back-up/4. Debugging summary and Code for CSV files.html

2.5 kB

5. Restore and Back-up/4.1 Customer.csv

64 kB

5. Restore and Back-up/4.2 Product.csv

140 kB

5. Restore and Back-up/4.3 Sales.csv

984 kB

5. Restore and Back-up/5. Exercise 5 Restore and Back-up.mp4

3.0 MB

5. Restore and Back-up/5. Exercise 5 Restore and Back-up.srt

1.3 kB

6. Selection commands Filtering/1. IN.mp4

29 MB

6. Selection commands Filtering/1. IN.srt

5.3 kB

6. Selection commands Filtering/1.1 Lecture_12_IN_12.pdf

157 kB

6. Selection commands Filtering/2. BETWEEN.mp4

50 MB

6. Selection commands Filtering/2. BETWEEN.srt

6.5 kB

6. Selection commands Filtering/2.1 Lecture_13_BETWEEN.pdf

188 kB

6. Selection commands Filtering/3. LIKE.mp4

61 MB

6. Selection commands Filtering/3. LIKE.srt

12 kB

6. Selection commands Filtering/3.1 Lecture_14_LIKE.pdf

174 kB

6. Selection commands Filtering/4. Exercise 6 In, Like & Between.mp4

5.3 MB

6. Selection commands Filtering/4. Exercise 6 In, Like & Between.srt

973 B

6. Selection commands Filtering/GetFreeCourses.Co.url

116 B

7. Selection commands Ordering/1. Side Lecture Commenting in SQL.mp4

12 MB

7. Selection commands Ordering/1. Side Lecture Commenting in SQL.srt

2.0 kB

7. Selection commands Ordering/2. ORDER BY.mp4

71 MB

7. Selection commands Ordering/2. ORDER BY.srt

10 kB

7. Selection commands Ordering/2.1 Lecture_15_ORDER BY.pdf

180 kB

7. Selection commands Ordering/3. LIMIT.mp4

30 MB

7. Selection commands Ordering/3. LIMIT.srt

5.1 kB

7. Selection commands Ordering/3.1 Lecture_16_LIMIT.pdf

162 kB

7. Selection commands Ordering/4. Exercise 7 Sorting.mp4

3.2 MB

7. Selection commands Ordering/4. Exercise 7 Sorting.srt

1.1 kB

8. Alias/1. AS.mp4

26 MB

8. Alias/1. AS.srt

4.9 kB

8. Alias/1.1 Lecture_17_AS.pdf

152 kB

8. Alias/1.2 Lecture_17_AS.pdf

152 kB

9. Aggregate Commands/1. COUNT.mp4

38 MB

9. Aggregate Commands/1. COUNT.srt

6.8 kB

9. Aggregate Commands/1.1 Lecture_18_count.pdf

158 kB

9. Aggregate Commands/2. SUM.mp4

21 MB

9. Aggregate Commands/2. SUM.srt

3.8 kB

9. Aggregate Commands/2.1 Lecture_19_SUM.pdf

163 kB

9. Aggregate Commands/3. AVERAGE.mp4

18 MB

9. Aggregate Commands/3. AVERAGE.srt

3.5 kB

9. Aggregate Commands/3.1 Lecture_20_AVG.pdf

158 kB

9. Aggregate Commands/4. MIN & MAX.mp4

32 MB

9. Aggregate Commands/4. MIN & MAX.srt

4.8 kB

9. Aggregate Commands/4.1 Lecture_21_MIN&MAX.pdf

164 kB

9. Aggregate Commands/5. Exercise 8 Aggregate functions.mp4

6.4 MB

9. Aggregate Commands/5. Exercise 8 Aggregate functions.srt

2.0 kB

9. Aggregate Commands/6. Quiz.html

198 B

Download Paid Udemy Courses For Free.url

116 B

GetFreeCourses.Co.url

116 B