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