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