Удален по просьбе правообладателя
  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