• Урок 1. 00:04:15
    What is PostgreSQL All About?
  • Урок 2. 00:05:14
    Database Design
  • Урок 3. 00:04:45
    Creating Tables
  • Урок 4. 00:03:33
    Analyzing CREATE TABLE
  • Урок 5. 00:04:52
    Inserting Data Into a Table
  • Урок 6. 00:02:09
    Retrieving Data with Select
  • Урок 7. 00:04:40
    Calculated Columns
  • Урок 8. 00:01:00
    Calculating Phone Revenue
  • Урок 9. 00:01:04
    Exercise Solution
  • Урок 10. 00:06:21
    String Operators and Functions
  • Урок 11. 00:03:52
    Filtering Rows with "Where"
  • Урок 12. 00:02:32
    More on the "Where" Keyword
  • Урок 13. 00:05:27
    Compound "Where" Clauses
  • Урок 14. 00:00:38
    A "Where" Exercise Overview
  • Урок 15. 00:00:57
    A "Where" Solution
  • Урок 16. 00:00:38
    "Where" With Lists
  • Урок 17. 00:01:44
    A "Where" With Lists Solution
  • Урок 18. 00:02:07
    Calculations in "Where" Clauses
  • Урок 19. 00:01:53
    Solving Calculations
  • Урок 20. 00:04:19
    Updating Rows
  • Урок 21. 00:03:18
    Deleting Rows
  • Урок 22. 00:01:31
    A Solution for Updating Rows
  • Урок 23. 00:01:19
    Solution for Deleting Rows
  • Урок 24. 00:01:45
    The Plan Moving Forward
  • Урок 25. 00:07:32
    Approaching Database Design
  • Урок 26. 00:06:37
    One-to-Many and Many-to-One Relationships
  • Урок 27. 00:05:44
    One-to-One and Many-to-Many Relationships
  • Урок 28. 00:05:32
    Primary Keys and Foreign Keys
  • Урок 29. 00:08:24
    Understanding Foreign Keys
  • Урок 30. 00:05:50
    Auto-Generated ID's
  • Урок 31. 00:04:40
    Creating Foreign Key Columns
  • Урок 32. 00:06:52
    Running Queries on Associated Data
  • Урок 33. 00:02:09
    Exercise Overview
  • Урок 34. 00:02:11
    Foreign Key Creation Solution
  • Урок 35. 00:05:38
    Foreign Key Constraints Around Insertion
  • Урок 36. 00:05:03
    Constraints Around Deletion
  • Урок 37. 00:04:40
    Testing Deletion Constraints
  • Урок 38. 00:03:00
    Setting Foreign Keys to Null on Delete
  • Урок 39. 00:02:59
    Adding Some Complexity
  • Урок 40. 00:03:25
    Queries with Joins and Aggregations
  • Урок 41. 00:07:43
    Joining Data from Different Tables
  • Урок 42. 00:02:24
    Another Quick Join
  • Урок 43. 00:01:14
    Exercise Overview
  • Урок 44. 00:01:44
    A Joinful Solution
  • Урок 45. 00:05:55
    Alternate Forms of Syntax
  • Урок 46. 00:06:19
    Missing Data in Joins
  • Урок 47. 00:02:24
    Why Wasn't It Included
  • Урок 48. 00:09:30
    Four Kinds of Joins
  • Урок 49. 00:04:17
    Each Join in Practice
  • Урок 50. 00:04:13
    Does Order Matter?
  • Урок 51. 00:00:56
    Exercise Overview
  • Урок 52. 00:03:01
    Two Possible Solutions
  • Урок 53. 00:06:48
    Where with Join
  • Урок 54. 00:08:34
    Three Way Joins
  • Урок 55. 00:05:01
    A Bit of Practice
  • Урок 56. 00:02:54
    Exercise Solution
  • Урок 57. 00:02:12
    Aggregating and Grouping
  • Урок 58. 00:05:32
    Picturing Group By
  • Урок 59. 00:03:01
    Aggregate Functions
  • Урок 60. 00:04:50
    Combining Group By and Aggregates
  • Урок 61. 00:02:38
    A Gotcha with Count
  • Урок 62. 00:03:12
    Visualizing More Grouping
  • Урок 63. 00:00:41
    Exercise Overview
  • Урок 64. 00:01:22
    Grouping Solution
  • Урок 65. 00:00:43
    Adding a Layer of Difficulty
  • Урок 66. 00:01:29
    Solution
  • Урок 67. 00:04:45
    Filtering Groups with Having
  • Урок 68. 00:02:38
    Having In Action
  • Урок 69. 00:06:51
    More on Having!
  • Урок 70. 00:03:38
    A Having Exercise Overview
  • Урок 71. 00:02:34
    A Quick Solution
  • Урок 72. 00:02:36
    Investigating This Dataset
  • Урок 73. 00:01:21
    Some Group By Practice
  • Урок 74. 00:02:27
    Group By Review Solution
  • Урок 75. 00:02:15
    Remember Joins?
  • Урок 76. 00:01:27
    Of Course You Remember!
  • Урок 77. 00:02:16
    The Basics of Sorting
  • Урок 78. 00:02:42
    Two Variations on Sorting
  • Урок 79. 00:06:42
    Offset and Limit
  • Урок 80. 00:00:27
    Exercise Overview
  • Урок 81. 00:01:22
    Exercise Solution
  • Урок 82. 00:05:46
    Handling Sets with Union
  • Урок 83. 00:03:47
    A Few Notes on Union
  • Урок 84. 00:03:25
    Commonalities with Intersect
  • Урок 85. 00:05:52
    Removing Commonalities with Except
  • Урок 86. 00:01:28
    Union Exercise Overview
  • Урок 87. 00:01:28
    Exercise Solution
  • Урок 88. 00:05:51
    What's a Subquery?
  • Урок 89. 00:04:49
    Thinking About the Structure of Data
  • Урок 90. 00:05:44
    Subqueries in a Select
  • Урок 91. 00:01:06
    Exercise Overview
  • Урок 92. 00:01:20
    Select Solution
  • Урок 93. 00:08:02
    Subqueries in a From
  • Урок 94. 00:02:47
    From Subqueries that Return a Value
  • Урок 95. 00:09:01
    Example of a Subquery in a From
  • Урок 96. 00:01:17
    Exercise Overview
  • Урок 97. 00:02:01
    Exercise Solution
  • Урок 98. 00:04:55
    Subqueries in a Join Clause
  • Урок 99. 00:08:16
    More Useful - Subqueries with Where
  • Урок 100. 00:05:38
    Data Structure with Where Subqueries
  • Урок 101. 00:00:58
    Exercise Overview
  • Урок 102. 00:02:07
    Exercise Solution
  • Урок 103. 00:04:12
    The Not In Operator with a List
  • Урок 104. 00:06:24
    A New Where Operator
  • Урок 105. 00:05:24
    Finally Some!
  • Урок 106. 00:00:28
    Exercise Overview
  • Урок 107. 00:01:35
    A Quick Solution
  • Урок 108. 00:16:47
    Probably Too Much About Correlated Subqueries
  • Урок 109. 00:08:58
    More on Correlated Subqueries
  • Урок 110. 00:03:31
    A Select Without a From?
  • Урок 111. 00:00:46
    Exercise Overview
  • Урок 112. 00:01:21
    Exercise Solution
  • Урок 113. 00:04:16
    Selecting Distinct Values
  • Урок 114. 00:00:31
    Exercise Overview
  • Урок 115. 00:00:41
    A Distinct Solution
  • Урок 116. 00:03:22
    The Greatest Value in a List
  • Урок 117. 00:02:02
    And the Least Value in a List!
  • Урок 118. 00:04:15
    The Case Keyword
  • Урок 119. 00:05:50
    PostgreSQL Installation on macOS
  • Урок 120. 00:04:58
    PGAdmin Setup on macOS
  • Урок 121. 00:03:58
    Postgres installation on Windows
  • Урок 122. 00:04:05
    What'd We Just Do?
  • Урок 123. 00:04:12
    Data Types
  • Урок 124. 00:02:03
    Fast Rules on Numeric Data Types
  • Урок 125. 00:09:24
    More on Number Data Types
  • Урок 126. 00:04:45
    Reminder on Character Types
  • Урок 127. 00:02:30
    Boolean Data Types
  • Урок 128. 00:05:33
    Times, Dates, and Timestamps
  • Урок 129. 00:05:48
    Really Awesome Intervals
  • Урок 130. 00:04:15
    Thinking About Validation
  • Урок 131. 00:07:23
    Creating and Viewing Tables in PGAdmin
  • Урок 132. 00:06:28
    Applying a Null Constraint
  • Урок 133. 00:04:12
    Solving a Gotcha with Null Constraints
  • Урок 134. 00:03:15
    Default Column Values
  • Урок 135. 00:05:38
    Applying a Unique Constraint to One column
  • Урок 136. 00:03:42
    Multi-Column Uniqueness
  • Урок 137. 00:04:01
    Adding a Validation Check
  • Урок 138. 00:05:07
    Checks Over Multiple Columns
  • Урок 139. 00:05:49
    So Where Are We Applying Validation?
  • Урок 140. 00:03:15
    Approaching More Complicated Designs
  • Урок 141. 00:06:10
    Using a SQL Design Tool
  • Урок 142. 00:07:06
    A Config-based Schema Designer
  • Урок 143. 00:02:17
    Here's the Plan
  • Урок 144. 00:06:58
    Rebuilding Some Schema
  • Урок 145. 00:04:38
    Requirements of a Like System
  • Урок 146. 00:03:01
    How Not to Design a Like System
  • Урок 147. 00:05:07
    Designing a Like System
  • Урок 148. 00:01:36
    Making a Reaction System Instead
  • Урок 149. 00:06:01
    Polymorphic Associations
  • Урок 150. 00:07:01
    Polymorphic Association Alternative Implementation
  • Урок 151. 00:03:41
    The Simplest Alternative
  • Урок 152. 00:04:23
    So Which Approach?
  • Урок 153. 00:06:14
    Additional Features Around Posts
  • Урок 154. 00:01:41
    Adding Captions and Locations
  • Урок 155. 00:07:31
    Photo Mentions vs Caption Mentions
  • Урок 156. 00:07:12
    Considerations on Photo Tags vs Caption Tags
  • Урок 157. 00:05:04
    Update For Tags
  • Урок 158. 00:07:37
    Designing a Hashtag System
  • Урок 159. 00:03:39
    Tables for Hashtags
  • Урок 160. 00:04:08
    Including the Hashtag Table
  • Урок 161. 00:06:05
    A Few More User Columns
  • Урок 162. 00:03:47
    Why No Number of Followers or Posts?
  • Урок 163. 00:05:53
    Designing a Follower System
  • Урок 164. 00:01:46
    Back to Postgres
  • Урок 165. 00:13:07
    Creating Tables with Checks
  • Урок 166. 00:08:36
    Posts Creation
  • Урок 167. 00:02:18
    Comments Creation
  • Урок 168. 00:06:56
    Likes Creation
  • Урок 169. 00:05:32
    Photo Tags and Caption Tags
  • Урок 170. 00:06:31
    Creating Hashtags, Hashtag Posts, and Followers
  • Урок 171. 00:04:08
    Adding Some Data
  • Урок 172. 00:04:27
    Restoring from Scratch
  • Урок 173. 00:01:42
    Highest User ID's Exercise
  • Урок 174. 00:01:11
    Solution for User ID's
  • Урок 175. 00:01:06
    Posts by a Particular User
  • Урок 176. 00:01:58
    Solving for Posts by User
  • Урок 177. 00:00:51
    Likes Per User
  • Урок 178. 00:01:42
    Solution for Likes Per User
  • Урок 179. 00:02:04
    Thinking About Performance
  • Урок 180. 00:05:54
    Where Does Postgres Store Data?
  • Урок 181. 00:03:39
    Heaps, Blocks, and Tuples
  • Урок 182. 00:04:22
    Block Data Layout
  • Урок 183. 00:32:07
    Heap File Layout
  • Урок 184. 00:04:11
    Full Table Scans
  • Урок 185. 00:02:25
    What's an Index
  • Урок 186. 00:08:02
    How an Index Works
  • Урок 187. 00:04:01
    Creating an Index
  • Урок 188. 00:05:31
    Benchmarking Queries
  • Урок 189. 00:05:12
    Downsides of Indexes
  • Урок 190. 00:01:36
    Index Types
  • Урок 191. 00:03:40
    Automatically Generated Indexes
  • Урок 192. 00:32:10
    Behind the Scenes of Indexes
  • Урок 193. 00:05:00
    The Query Processing Pipeline
  • Урок 194. 00:05:28
    Explain and Explain Analyze
  • Урок 195. 00:09:03
    Solving an Explain Mystery
  • Урок 196. 00:12:03
    Developing an Intuitive Understanding of Cost
  • Урок 197. 00:06:24
    Calculating Cost by Hand
  • Урок 198. 00:07:21
    A Touch More on Costs
  • Урок 199. 00:05:37
    Startup vs Total Costs
  • Урок 200. 00:01:50
    Costs Flow Up
  • Урок 201. 00:08:00
    Use My Index!
  • Урок 202. 00:01:54
    Common Table Expressions
  • Урок 203. 00:03:55
    A Quick Solution
  • Урок 204. 00:03:52
    So What's a CTE?
  • Урок 205. 00:03:20
    Recursive CTE's
  • Урок 206. 00:10:26
    Recursive CTE's Step by Step
  • Урок 207. 00:04:36
    Why Use Recursive CTE's?
  • Урок 208. 00:08:07
    Writing the Query
  • Урок 209. 00:09:52
    Walking Through Recursion
  • Урок 210. 00:06:20
    Most Popular Users
  • Урок 211. 00:03:53
    A Possible Solution for Merging Tables
  • Урок 212. 00:05:39
    Creating a View
  • Урок 213. 00:03:21
    When to Use a View?
  • Урок 214. 00:02:28
    Deleting and Changing Views
  • Урок 215. 00:02:20
    Materialized Views
  • Урок 216. 00:04:11
    Grouping by Week
  • Урок 217. 00:04:32
    Reminder on Left Joins
  • Урок 218. 00:09:23
    Writing a Slow Query
  • Урок 219. 00:06:41
    Creating and Refreshing Materialized Views
  • Урок 220. 00:04:05
    What are Transactions Used For?
  • Урок 221. 00:02:01
    Some Sample Data
  • Урок 222. 00:09:49
    Opening and Closing Transactions
  • Урок 223. 00:04:05
    Transaction Cleanup on Crash
  • Урок 224. 00:01:46
    Closing Aborted Transactions
  • Урок 225. 00:17:22
    A Story on Migrations
  • Урок 226. 00:05:03
    Migration Files
  • Урок 227. 00:02:53
    Issues Solved by Migrations
  • Урок 228. 00:04:41
    A Few Notes on Migrations Libraries
  • Урок 229. 00:02:55
    Project Creation
  • Урок 230. 00:07:15
    Generating and Writing Migrations
  • Урок 231. 00:07:19
    Applying and Reverting Migrations
  • Урок 232. 00:03:40
    Generating and Applying a Second Migration
  • Урок 233. 00:04:11
    Schema vs Data Migrations
  • Урок 234. 00:09:11
    Dangers Around Data Migrations
  • Урок 235. 00:05:32
    Properly Running Data and Schema Migrations
  • Урок 236. 00:04:42
    Creating a Posts Table
  • Урок 237. 00:14:59
    A Small Web Server
  • Урок 238. 00:04:12
    Adding the Loc Column
  • Урок 239. 00:04:14
    Writing Values to Both Columns
  • Урок 240. 00:13:46
    Transaction Locks
  • Урок 241. 00:04:22
    Updating Values
  • Урок 242. 00:04:16
    Updating the App Server
  • Урок 243. 00:03:03
    Dropping the Last Columns
  • Урок 244. 00:00:54
    Section Goal
  • Урок 245. 00:01:35
    Initial Setup
  • Урок 246. 00:05:04
    One Fast Migration
  • Урок 247. 00:04:56
    Building the Users Router
  • Урок 248. 00:06:35
    Understanding Connection Pools
  • Урок 249. 00:07:00
    Validating Connection Credentials
  • Урок 250. 00:01:59
    Query and Close
  • Урок 251. 00:03:41
    The Repository Pattern
  • Урок 252. 00:08:25
    Creating a Repository
  • Урок 253. 00:03:53
    Accessing the API
  • Урок 254. 00:04:23
    Casing Issues
  • Урок 255. 00:06:37
    Fixing Casing
  • Урок 256. 00:05:29
    Finding Particular Users
  • Урок 257. 00:06:44
    SQL Injection Exploits
  • Урок 258. 00:07:53
    Handling SQL Injection with Prepared Statements
  • Урок 259. 00:07:36
    Preventing SQL Injection
  • Урок 260. 00:02:53
    Reminder on Post Requests
  • Урок 261. 00:04:16
    Inserting Users
  • Урок 262. 00:04:39
    Handling Updates
  • Урок 263. 00:04:08
    And, Finally, Delete
  • Урок 264. 00:02:49
    A Note on Testing
  • Урок 265. 00:07:08
    Assertions Around User Count
  • Урок 266. 00:05:04
    Connecting to a DB For Tests
  • Урок 267. 00:02:47
    Disconnecting After Tests
  • Урок 268. 00:04:43
    Multi-DB Setup
  • Урок 269. 00:04:47
    Assumptions Around Content
  • Урок 270. 00:04:51
    Issues with Parallel Tests
  • Урок 271. 00:04:12
    Isolation with Schemas
  • Урок 272. 00:05:25
    Creating and Accessing Schemas
  • Урок 273. 00:05:50
    Controlling Schema Access with Search Paths
  • Урок 274. 00:04:05
    Routing Schema Access
  • Урок 275. 00:04:45
    Strategy for Isolation
  • Урок 276. 00:11:51
    Programmatic Schema Creation
  • Урок 277. 00:04:23
    Escaping Identifiers
  • Урок 278. 00:05:21
    Test Helpers
  • Урок 279. 00:05:59
    Cleaning up Schemas and Roles
  • Урок 280. 00:03:34
    Finally... Parallel Tests!
Этот материал находится в платной подписке. Оформи премиум подписку и смотри SQL and PostgreSQL: The Complete Developer's Guide, а также все другие курсы, прямо сейчас!
Премиум