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