Это пробный урок. Оформите подписку, чтобы получить доступ ко всем материалам курса. Премиум

  1. Урок 1. 00:02:26
    Course Introduction
  2. Урок 2. 00:03:10
    What is a Database?
  3. Урок 3. 00:04:12
    Relational Databases and SQL
  4. Урок 4. 00:05:17
    Installing PostgreSQL for Mac
  5. Урок 5. 00:07:52
    Installing PostgreSQL for Windows
  6. Урок 6. 00:01:17
    Section Introduction
  7. Урок 7. 00:04:03
    Database Tables
  8. Урок 8. 00:07:45
    Data Types Explained
  9. Урок 9. 00:04:16
    Primary Keys and Foreign Keys
  10. Урок 10. 00:04:29
    Unique, Not Null and Check Constraints
  11. Урок 11. 00:09:37
    Creating Our First Table
  12. Урок 12. 00:05:22
    Creating the Actors Table
  13. Урок 13. 00:05:30
    Creating a Table with a Foreign Key
  14. Урок 14. 00:06:06
    Creating the Movie Revenues Table
  15. Урок 15. 00:04:24
    Creating a Junction Table
  16. Урок 16. 00:07:34
    Modifying Tables Part 1: Adding Columns
  17. Урок 17. 00:04:12
    Modifying Tables Part 2: Changing a Columns Data Type
  18. Урок 18. 00:02:45
    Deleting Tables from a Database
  19. Урок 19. 00:01:12
    Challenge: Data Definition Language
  20. Урок 20. 00:06:26
    Solution: Data Definition Language
  21. Урок 21. 00:01:02
    Section Summary
  22. Урок 22. 00:00:41
    Section Introduction
  23. Урок 23. 00:09:13
    Inserting Data into a Table
  24. Урок 24. 00:07:23
    Updating Data in a Table
  25. Урок 25. 00:03:48
    Deleting Data from a Table
  26. Урок 26. 00:07:14
    Inserting Data into Our Movie Data Database
  27. Урок 27. 00:01:18
    Challenge: Data Manipulation Language
  28. Урок 28. 00:09:16
    Solution: Data Manipulation Language
  29. Урок 29. 00:00:40
    Section Summary
  30. Урок 30. 00:01:38
    Section Introduction
  31. Урок 31. 00:03:10
    Select Queries
  32. Урок 32. 00:06:06
    Where Clauses
  33. Урок 33. 00:07:35
    Logical Operators
  34. Урок 34. 00:01:02
    Challenge 1: Select Queries
  35. Урок 35. 00:04:20
    Solution 1: Select Queries
  36. Урок 36. 00:05:48
    In, Not In
  37. Урок 37. 00:07:30
    Like
  38. Урок 38. 00:07:33
    Between
  39. Урок 39. 00:01:07
    Challenge 2: Select Queries
  40. Урок 40. 00:04:55
    Solution 2: Select Queries
  41. Урок 41. 00:08:39
    Order By
  42. Урок 42. 00:04:40
    Limiting the Number of Results
  43. Урок 43. 00:03:59
    Fetch
  44. Урок 44. 00:03:51
    Distinct Values
  45. Урок 45. 00:00:45
    Challenge 3: Select Queries
  46. Урок 46. 00:04:02
    Solution 3: Select Queries
  47. Урок 47. 00:05:12
    Null Values
  48. Урок 48. 00:05:11
    Setting a Column Name Alias
  49. Урок 49. 00:06:45
    Concatenation
  50. Урок 50. 00:00:45
    Challenge 4: Select Queries
  51. Урок 51. 00:04:52
    Solution 4: Select Queries
  52. Урок 52. 00:01:12
    Section Summary
  53. Урок 53. 00:00:57
    Section Introduction
  54. Урок 54. 00:01:57
    Aggregate Functions Explained
  55. Урок 55. 00:04:08
    Count Aggregate Functions
  56. Урок 56. 00:04:01
    Sum Aggregate Function
  57. Урок 57. 00:05:30
    Min and Max Aggregate Functions
  58. Урок 58. 00:02:45
    Average Aggregate Functions
  59. Урок 59. 00:01:06
    Challenge 1: Aggregate Functions
  60. Урок 60. 00:04:24
    Solution 1: Aggregate Functions
  61. Урок 61. 00:11:27
    Grouping Data
  62. Урок 62. 00:04:52
    Having Clauses
  63. Урок 63. 00:00:47
    Challenge 2: Aggregate Functions
  64. Урок 64. 00:04:43
    Solution 2: Aggregate Functions
  65. Урок 65. 00:07:57
    Mathematical Operators
  66. Урок 66. 00:00:58
    Section Summary
  67. Урок 67. 00:00:55
    Section Introduction
  68. Урок 68. 00:01:32
    What Are Database Relationships?
  69. Урок 69. 00:03:28
    One to One Relationships
  70. Урок 70. 00:04:01
    One to Many Relationships
  71. Урок 71. 00:04:36
    Many to Many Relationships
  72. Урок 72. 00:02:28
    (Optional) Challenge: Database Relationships
  73. Урок 73. 00:05:22
    Solution: Database Relationships
  74. Урок 74. 00:00:42
    Section Summary
  75. Урок 75. 00:01:10
    Section Introduction
  76. Урок 76. 00:10:08
    SQL Joins Explained
  77. Урок 77. 00:11:29
    Inner Joins Part 1
  78. Урок 78. 00:05:31
    Inner Joins Part 2
  79. Урок 79. 00:04:35
    Inner Joins Part 3
  80. Урок 80. 00:01:09
    Challenge 1: Joins
  81. Урок 81. 00:07:23
    Solution 1: Joins
  82. Урок 82. 00:05:56
    Left Joins
  83. Урок 83. 00:03:24
    Right Joins
  84. Урок 84. 00:03:33
    Full Joins
  85. Урок 85. 00:00:39
    Challenge 2: Joins
  86. Урок 86. 00:05:28
    Solutions 2: Joins
  87. Урок 87. 00:11:34
    Joining More Than Two Tables
  88. Урок 88. 00:01:07
    Challenge 3: Joins
  89. Урок 89. 00:08:47
    Solution 3: Joins
  90. Урок 90. 00:06:10
    Union
  91. Урок 91. 00:03:49
    Union All
  92. Урок 92. 00:00:43
    Challenge 4: Joins
  93. Урок 93. 00:04:46
    Solution 4: Joins
  94. Урок 94. 00:03:45
    Intersect
  95. Урок 95. 00:04:08
    Except
  96. Урок 96. 00:00:43
    Challenge 5: Joins
  97. Урок 97. 00:03:59
    Solution 5: Joins
  98. Урок 98. 00:01:03
    Section Summary
  99. Урок 99. 00:00:48
    Section Introduction
  100. Урок 100. 00:05:04
    Subqueries Explained
  101. Урок 101. 00:08:16
    Uncorrelated Subqueries Part 1
  102. Урок 102. 00:06:02
    Uncorrelated Subqueries Part 2
  103. Урок 103. 00:01:30
    Challenge 1: Subqueries
  104. Урок 104. 00:08:55
    Solution 1: Subqueries
  105. Урок 105. 00:07:20
    Correlated Subqueries
  106. Урок 106. 00:01:13
    Challenge 2: Subqueries
  107. Урок 107. 00:07:42
    Solution 2: Subqueries
  108. Урок 108. 00:00:59
    Summary
  109. Урок 109. 00:01:35
    Section Introduction
  110. Урок 110. 00:04:03
    Cloning a Database
  111. Урок 111. 00:06:20
    Upper and Lower String Functions
  112. Урок 112. 00:04:09
    Initcap Function
  113. Урок 113. 00:08:44
    Left and Right String Functions
  114. Урок 114. 00:02:18
    Reverse Function
  115. Урок 115. 00:01:20
    Challenge 1: String Functions
  116. Урок 116. 00:11:55
    Solution 1: String Functions
  117. Урок 117. 00:05:17
    Substring Function
  118. Урок 118. 00:09:05
    Replace Function
  119. Урок 119. 00:07:21
    Split Part Function
  120. Урок 120. 00:05:41
    Using the Cast Operator to Apply String Functions to Non-String Data Types
  121. Урок 121. 00:00:54
    Challenge 2: String Functions
  122. Урок 122. 00:06:53
    Solution 2: String Functions
  123. Урок 123. 00:01:05
    Summary