Удален по просьбе правообладателя
  • Урок 1. 00:11:58
    Introduction
  • Урок 2. 00:08:14
    SQL Setup with Docker
  • Урок 3. 00:14:12
    SQL Overview & Creating a Database
  • Урок 4. 00:09:55
    Creating & Populating a Table
  • Урок 5. 00:10:36
    Altering a Table & Postgres Data Types
  • Урок 6. 00:12:28
    Inserting Data and Managing Conflicts
  • Урок 7. 00:07:33
    Updating & Deleting Data
  • Урок 8. 00:15:57
    Selecting, Paginating, & Using Where Clauses
  • Урок 9. 00:08:44
    Using LIKE, ILIKE, & SQL Functions
  • Урок 10. 00:09:10
    node-postgres & SQL Injection
  • Урок 11. 00:08:12
    Ingredients API Exercise
  • Урок 12. 00:13:58
    Ingredients API Solution
  • Урок 13. 00:11:46
    Understanding Relationships & Joins
  • Урок 14. 00:06:36
    Left, Right, & Outer Joins
  • Урок 15. 00:03:45
    Natural & Cross Joins
  • Урок 16. 00:06:35
    Foreign Keys & Managing References
  • Урок 17. 00:13:04
    Many-to-Many Relationships
  • Урок 18. 00:03:52
    Using the CHECK Constraint
  • Урок 19. 00:08:50
    Using the DISTINCT Statement
  • Урок 20. 00:04:00
    Recipes Exercise
  • Урок 21. 00:14:18
    Recipes Solution
  • Урок 22. 00:10:40
    JSON vs. JSONB
  • Урок 23. 00:10:26
    Adding JSONB to Recipes Table
  • Урок 24. 00:04:46
    When to Use JSONB
  • Урок 25. 00:05:10
    Understanding Aggregation
  • Урок 26. 00:07:08
    Filtering Aggregates with HAVING
  • Урок 27. 00:13:59
    Storing Queries with Functions
  • Урок 28. 00:07:44
    Functions vs. Procedures
  • Урок 29. 00:09:00
    Calling Functions with Triggers
  • Урок 30. 00:06:37
    The Movie Database Setup
  • Урок 31. 00:04:24
    The Movie Database Exercise
  • Урок 32. 00:02:53
    The Movie Database Solution: Most Money
  • Урок 33. 00:06:02
    The Movie Database Solution: Keanu Reeves
  • Урок 34. 00:10:43
    The Movie Database Solution: Most Revenue
  • Урок 35. 00:03:31
    The Movie Database Solution: Most Keywords
  • Урок 36. 00:05:04
    The Movie Database Solution: Most Movies
  • Урок 37. 00:07:32
    Setup pgAdmin
  • Урок 38. 00:12:58
    Analyzing Queries with EXPLAIN
  • Урок 39. 00:05:37
    Identifying what to Index
  • Урок 40. 00:09:20
    Creating an Index
  • Урок 41. 00:10:04
    Using a GIN Index
  • Урок 42. 00:05:38
    Creating a Partial Index
  • Урок 43. 00:05:51
    Indexing a Derivative Value
  • Урок 44. 00:09:16
    Creating Views & Inserting Data
  • Урок 45. 00:06:36
    Joining Between Views
  • Урок 46. 00:08:38
    Optimizing Queries with Materialized Views
  • Урок 47. 00:02:57
    Indexing Materialized Views
  • Урок 48. 00:04:53
    Using Subqueries
  • Урок 49. 00:05:50
    Creating an Array from a Subquery
  • Урок 50. 00:13:30
    Transactions
  • Урок 51. 00:08:40
    Window Functions
  • Урок 52. 00:05:58
    Self Join
  • Урок 53. 00:03:36
    Wrapping Up