Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Master SQL For Data Science, а также все другие курсы, прямо сейчас!
Купить сейчас
  • Урок 1. 00:04:46
    Course Overview
  • Урок 2. 00:10:04
    What is a Database
  • Урок 3. 00:07:25
    Install Postgres Database on Mac
  • Урок 4. 00:07:23
    Install Postgres on Windows
  • Урок 5. 00:21:58
    Create Table and Insert Statements
  • Урок 6. 00:14:19
    Prepare the Database
  • Урок 7. 00:18:13
    Introducing the SELECT Statement
  • Урок 8. 00:23:34
    Filter Data Using the WHERE Clause + AND & OR
  • Урок 9. 00:14:56
    Filtering Operators - IN, NOT IN, IS NULL, BETWEEN
  • Урок 10. 00:11:36
    [EXERCISES]: WHERE Clause and Operators
  • Урок 11. 00:11:55
    Using ORDER BY, LIMIT, DISTINCT and Renaming Columns
  • Урок 12. 00:15:57
    UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation
  • Урок 13. 00:16:09
    String Functions: SUBSTRING(), REPLACE(), POSITION() and COALESCE()
  • Урок 14. 00:10:21
    Grouping Functions: MIN(), MAX(), AVG(), SUM(), COUNT()
  • Урок 15. 00:06:29
    Understanding Grouping
  • Урок 16. 00:17:23
    GROUP BY & HAVING Clauses
  • Урок 17. 00:16:28
    [EXERCISES]: Using GROUP BY and HAVING Clauses
  • Урок 18. 00:06:21
    Aliasing Sources of Data
  • Урок 19. 00:14:10
    Introducing Subqueries
  • Урок 20. 00:18:35
    Subqueries Continued + [EXERCISES]
  • Урок 21. 00:19:41
    Subqueries with ANY and ALL Operators + [EXERCISES]
  • Урок 22. 00:15:30
    [EXERCISES]: More Practice with Subqueries
  • Урок 23. 00:20:54
    Conditional Expressions Using CASE Clause + [EXERCISES]
  • Урок 24. 00:17:48
    Transposing Data using the CASE Clause + [EXERCISES]
  • Урок 25. 00:21:17
    Understanding Correlated Subqueries
  • Урок 26. 00:16:08
    [EXERCISES]: Correlated Subqueries Continued
  • Урок 27. 00:16:30
    Introducing Table Joins
  • Урок 28. 00:25:44
    INNER and OUTER Joins + [EXERCISES]
  • Урок 29. 00:14:23
    Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES]
  • Урок 30. 00:07:05
    Cartesian Product with the CROSS JOIN
  • Урок 31. 00:17:28
    [EXERCISES]: Joins and Subqueries Continued
  • Урок 32. 00:08:40
    Creating Views vs. Inline Views
  • Урок 33. 00:18:33
    Window Functions using the OVER() Clause
  • Урок 34. 00:21:18
    Ordering Data in Window Frames
  • Урок 35. 00:12:01
    RANK, FIRST_VALUE and NTILE Functions
  • Урок 36. 00:07:43
    LEAD and LAG Functions
  • Урок 37. 00:11:42
    Working with Rollups and Cubes