[FreeCourseLab.com] Udemy - Master SQL For Data Science

• [FreeCourseLab.com] Udemy - Master SQL For Data Science
• Lesson 1. Course Overview.mp4 52.8 MB
• Lesson 10. [EXERCISES] WHERE Clause and Operators.mp4 19.3 MB
• Lesson 11. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 21.2 MB
• Lesson 12. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 25 MB
• Lesson 13. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 23.9 MB
• Lesson 14. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 15.6 MB
• Lesson 15. Understanding Grouping.mp4 8.9 MB
• Lesson 16. GROUP BY & HAVING Clauses.mp4 25.9 MB
• Lesson 17. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 25.9 MB
• Lesson 18. Aliasing Sources of Data.mp4 9.4 MB
• Lesson 19. Introducing Subqueries.mp4 23.9 MB
• Lesson 2. What is a Database.mp4 15.5 MB
• Lesson 20. Subqueries Continued + [EXERCISES].mp4 29.7 MB
• Lesson 21. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 33 MB
• Lesson 22. [EXERCISES] More Practice with Subqueries.mp4 22.5 MB
• Lesson 23. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 33.1 MB
• Lesson 24. Transposing Data using the CASE Clause + [EXERCISES].mp4 30.2 MB
• Lesson 25. Understanding Correlated Subqueries.mp4 32.1 MB
• Lesson 26. [EXERCISES] Correlated Subqueries Continued.mp4 26.1 MB
• Lesson 27. Introducing Table Joins.mp4 25.6 MB
• Lesson 28. INNER and OUTER Joins + [EXERCISES].mp4 40.7 MB
• Lesson 29. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 21 MB
• Lesson 3. Install Postgres Database on Mac.mp4 12.5 MB
• Lesson 30. Cartesian Product with the CROSS JOIN.mp4 11.6 MB
• Lesson 31. [EXERCISES] Joins and Subqueries Continued.mp4 27.4 MB
• Lesson 32. Creating Views vs. Inline Views.mp4 80.4 MB
• Lesson 33. Window Functions using the OVER() Clause.mp4 29.9 MB
• Lesson 34. Ordering Data in Window Frames.mp4 34.8 MB
• Lesson 35. RANK, FIRST_VALUE and NTILE Functions.mp4 111.3 MB
• Lesson 36. LEAD and LAG Functions.mp4 63.2 MB
• Lesson 37. Working with Rollups and Cubes.mp4 112 MB
• Lesson 4. Install Postgres on Windows.mp4 71.6 MB
• Lesson 5. Create Table and Insert Statements.mp4 43.2 MB
• Lesson 6. Prepare the Database.mp4 39.9 MB
• Lesson 7. Introducing the SELECT Statement.mp4 32.8 MB
• Lesson 8. Filter Data Using the WHERE Clause + AND & OR.mp4 40.4 MB
• Lesson 9. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 30.1 MB
• Materials.zip 269.6 KB

No comments yet.