| 文件 | 大小 |
|---|
| Lesson 1. Course Overview.mp4 | 52.84 MB |
| Lesson 10. [EXERCISES] WHERE Clause and Operators.mp4 | 19.26 MB |
| Lesson 11. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 | 21.24 MB |
| Lesson 12. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 | 25.01 MB |
| Lesson 13. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 | 23.88 MB |
| Lesson 14. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 | 15.55 MB |
| Lesson 15. Understanding Grouping.mp4 | 8.91 MB |
| Lesson 16. GROUP BY & HAVING Clauses.mp4 | 25.88 MB |
| Lesson 17. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 | 25.90 MB |
| Lesson 18. Aliasing Sources of Data.mp4 | 9.39 MB |
| Lesson 19. Introducing Subqueries.mp4 | 23.89 MB |
| Lesson 2. What is a Database.mp4 | 15.49 MB |
| Lesson 20. Subqueries Continued + [EXERCISES].mp4 | 29.73 MB |
| Lesson 21. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 | 32.96 MB |
| Lesson 22. [EXERCISES] More Practice with Subqueries.mp4 | 22.47 MB |
| Lesson 23. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 | 33.08 MB |
| Lesson 24. Transposing Data using the CASE Clause + [EXERCISES].mp4 | 30.19 MB |
| Lesson 25. Understanding Correlated Subqueries.mp4 | 32.05 MB |
| Lesson 26. [EXERCISES] Correlated Subqueries Continued.mp4 | 26.11 MB |
| Lesson 27. Introducing Table Joins.mp4 | 25.61 MB |
| Lesson 28. INNER and OUTER Joins + [EXERCISES].mp4 | 40.67 MB |
| Lesson 29. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 | 20.97 MB |
| Lesson 3. Install Postgres Database on Mac.mp4 | 12.55 MB |
| Lesson 30. Cartesian Product with the CROSS JOIN.mp4 | 11.57 MB |
| Lesson 31. [EXERCISES] Joins and Subqueries Continued.mp4 | 27.37 MB |
| Lesson 32. Creating Views vs. Inline Views.mp4 | 80.43 MB |
| Lesson 33. Window Functions using the OVER() Clause.mp4 | 29.86 MB |
| Lesson 34. Ordering Data in Window Frames.mp4 | 34.77 MB |
| Lesson 35. RANK, FIRST_VALUE and NTILE Functions.mp4 | 111.25 MB |
| Lesson 36. LEAD and LAG Functions.mp4 | 63.16 MB |
| Lesson 37. Working with Rollups and Cubes.mp4 | 111.96 MB |
| Lesson 4. Install Postgres on Windows.mp4 | 71.59 MB |
| Lesson 5. Create Table and Insert Statements.mp4 | 43.25 MB |
| Lesson 6. Prepare the Database.mp4 | 39.94 MB |
| Lesson 7. Introducing the SELECT Statement.mp4 | 32.79 MB |
| Lesson 8. Filter Data Using the WHERE Clause + AND & OR.mp4 | 40.42 MB |
| Lesson 9. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 | 30.12 MB |
| Materials.zip | 269.59 kB |
| [FreeCourseLab.com].url | 126.00 B |
-