Удален по просьбе правообладателя
  1. Урок 1.00:11:58
    Introduction
  2. Урок 2.00:08:14
    SQL Setup with Docker
  3. Урок 3.00:14:12
    SQL Overview & Creating a Database
  4. Урок 4.00:09:55
    Creating & Populating a Table
  5. Урок 5.00:10:36
    Altering a Table & Postgres Data Types
  6. Урок 6.00:12:28
    Inserting Data and Managing Conflicts
  7. Урок 7.00:07:33
    Updating & Deleting Data
  8. Урок 8.00:15:57
    Selecting, Paginating, & Using Where Clauses
  9. Урок 9.00:08:44
    Using LIKE, ILIKE, & SQL Functions
  10. Урок 10.00:09:10
    node-postgres & SQL Injection
  11. Урок 11.00:08:12
    Ingredients API Exercise
  12. Урок 12.00:13:58
    Ingredients API Solution
  13. Урок 13.00:11:46
    Understanding Relationships & Joins
  14. Урок 14.00:06:36
    Left, Right, & Outer Joins
  15. Урок 15.00:03:45
    Natural & Cross Joins
  16. Урок 16.00:06:35
    Foreign Keys & Managing References
  17. Урок 17.00:13:04
    Many-to-Many Relationships
  18. Урок 18.00:03:52
    Using the CHECK Constraint
  19. Урок 19.00:08:50
    Using the DISTINCT Statement
  20. Урок 20.00:04:00
    Recipes Exercise
  21. Урок 21.00:14:18
    Recipes Solution
  22. Урок 22.00:10:40
    JSON vs. JSONB
  23. Урок 23.00:10:26
    Adding JSONB to Recipes Table
  24. Урок 24.00:04:46
    When to Use JSONB
  25. Урок 25.00:05:10
    Understanding Aggregation
  26. Урок 26.00:07:08
    Filtering Aggregates with HAVING
  27. Урок 27.00:13:59
    Storing Queries with Functions
  28. Урок 28.00:07:44
    Functions vs. Procedures
  29. Урок 29.00:09:00
    Calling Functions with Triggers
  30. Урок 30.00:06:37
    The Movie Database Setup
  31. Урок 31.00:04:24
    The Movie Database Exercise
  32. Урок 32.00:02:53
    The Movie Database Solution: Most Money
  33. Урок 33.00:06:02
    The Movie Database Solution: Keanu Reeves
  34. Урок 34.00:10:43
    The Movie Database Solution: Most Revenue
  35. Урок 35.00:03:31
    The Movie Database Solution: Most Keywords
  36. Урок 36.00:05:04
    The Movie Database Solution: Most Movies
  37. Урок 37.00:07:32
    Setup pgAdmin
  38. Урок 38.00:12:58
    Analyzing Queries with EXPLAIN
  39. Урок 39.00:05:37
    Identifying what to Index
  40. Урок 40.00:09:20
    Creating an Index
  41. Урок 41.00:10:04
    Using a GIN Index
  42. Урок 42.00:05:38
    Creating a Partial Index
  43. Урок 43.00:05:51
    Indexing a Derivative Value
  44. Урок 44.00:09:16
    Creating Views & Inserting Data
  45. Урок 45.00:06:36
    Joining Between Views
  46. Урок 46.00:08:38
    Optimizing Queries with Materialized Views
  47. Урок 47.00:02:57
    Indexing Materialized Views
  48. Урок 48.00:04:53
    Using Subqueries
  49. Урок 49.00:05:50
    Creating an Array from a Subquery
  50. Урок 50.00:13:30
    Transactions
  51. Урок 51.00:08:40
    Window Functions
  52. Урок 52.00:05:58
    Self Join
  53. Урок 53.00:03:36
    Wrapping Up