Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
[CourseClub.Me].url |
122B |
[CourseClub.Me].url |
122B |
[CourseClub.Me].url |
122B |
[CourseClub.Me].url |
122B |
[CourseClub.Me].url |
122B |
[GigaCourse.Com].url |
49B |
[GigaCourse.Com].url |
49B |
[GigaCourse.Com].url |
49B |
[GigaCourse.Com].url |
49B |
[GigaCourse.Com].url |
49B |
100 - Example of a Subquery in a From.mp4 |
53.51MB |
100 - Example of a Subquery in a From English.srt |
13.74KB |
101 - Exercise Overview.mp4 |
3.40MB |
101 - Exercise Overview English.srt |
1.87KB |
102 - Exercise Solution.mp4 |
10.37MB |
102 - Exercise Solution English.srt |
2.86KB |
103 - Subqueries in a Join Clause.mp4 |
16.55MB |
103 - Subqueries in a Join Clause English.srt |
6.84KB |
104 - More Useful Subqueries with Where.mp4 |
36.66MB |
104 - More Useful Subqueries with Where English.srt |
13.70KB |
105 - Data Structure with Where Subqueries.mp4 |
44.04MB |
105 - Data Structure with Where Subqueries English.srt |
8.97KB |
106 - Exercise Overview.mp4 |
2.71MB |
106 - Exercise Overview English.srt |
1.58KB |
107 - Exercise Solution.mp4 |
6.25MB |
107 - Exercise Solution English.srt |
3.11KB |
108 - The Not In Operator with a List.mp4 |
38.59MB |
108 - The Not In Operator with a List English.srt |
6.46KB |
109 - A New Where Operator.mp4 |
38.71MB |
109 - A New Where Operator English.srt |
9.69KB |
10 - Calculating Phone Revenue.mp4 |
37.26MB |
10 - Calculating Phone Revenue English.srt |
1.57KB |
110 - Finally Some.mp4 |
31.96MB |
110 - Finally Some English.srt |
8.28KB |
111 - Exercise Overview.mp4 |
1.23MB |
111 - Exercise Overview English.srt |
767B |
112 - A Quick Solution.mp4 |
4.37MB |
112 - A Quick Solution English.srt |
2.47KB |
113 - Probably Too Much About Correlated Subqueries.mp4 |
107.00MB |
113 - Probably Too Much About Correlated Subqueries English.srt |
25.29KB |
114 - More on Correlated Subqueries.mp4 |
44.16MB |
114 - More on Correlated Subqueries English.srt |
13.13KB |
115 - A Select Without a From.mp4 |
9.09MB |
115 - A Select Without a From English.srt |
5.33KB |
116 - Exercise Overview.mp4 |
1.95MB |
116 - Exercise Overview English.srt |
1.22KB |
117 - Exercise Solution.mp4 |
3.57MB |
117 - Exercise Solution English.srt |
1.76KB |
118 - Selecting Distinct Values.mp4 |
12.46MB |
118 - Selecting Distinct Values English.srt |
6.51KB |
119 - Exercise Overview.mp4 |
1.30MB |
119 - Exercise Overview English.srt |
906B |
11 - Exercise Solution.mp4 |
27.92MB |
11 - Exercise Solution English.srt |
1.62KB |
12 - 012-sql.sql |
404B |
120 - A Distinct Solution.mp4 |
1.90MB |
120 - A Distinct Solution English.srt |
964B |
121 - The Greatest Value in a List.mp4 |
11.77MB |
121 - The Greatest Value in a List English.srt |
5.07KB |
122 - And the Least Value in a List.mp4 |
5.55MB |
122 - And the Least Value in a List English.srt |
3.04KB |
123 - The Case Keyword.mp4 |
19.04MB |
123 - The Case Keyword English.srt |
6.72KB |
124 - PostgreSQL Installation on macOS.mp4 |
21.13MB |
124 - PostgreSQL Installation on macOS English.srt |
9.97KB |
125 - PGAdmin Setup on macOS.mp4 |
36.92MB |
125 - PGAdmin Setup on macOS English.srt |
7.76KB |
126 - Postgres installation on Windows.mp4 |
23.31MB |
126 - Postgres installation on Windows English.srt |
6.61KB |
127 - Whatd We Just Do.mp4 |
19.32MB |
127 - Whatd We Just Do English.srt |
6.54KB |
128 - Data Types.mp4 |
30.53MB |
128 - Data Types English.srt |
7.18KB |
129 - Fast Rules on Numeric Data Types.mp4 |
18.90MB |
129 - Fast Rules on Numeric Data Types English.srt |
3.60KB |
12 - String Operators and Functions.mp4 |
65.10MB |
12 - String Operators and Functions English.srt |
9.90KB |
13 - 013-sql.sql |
48B |
130 - More on Number Data Types.mp4 |
48.14MB |
130 - More on Number Data Types English.srt |
14.78KB |
131 - Reminder on Character Types.mp4 |
29.90MB |
131 - Reminder on Character Types English.srt |
7.54KB |
132 - Boolean Data Types.mp4 |
8.20MB |
132 - Boolean Data Types English.srt |
3.89KB |
133 - Times Dates and Timestamps.mp4 |
21.27MB |
133 - Times Dates and Timestamps English.srt |
8.41KB |
134 - Really Awesome Intervals.mp4 |
19.50MB |
134 - Really Awesome Intervals English.srt |
9.08KB |
135 - Thinking About Validation.mp4 |
34.64MB |
135 - Thinking About Validation English.srt |
6.86KB |
136 - Creating and Viewing Tables in PGAdmin.mp4 |
28.09MB |
136 - Creating and Viewing Tables in PGAdmin English.srt |
11.56KB |
137 - Applying a Null Constraint.mp4 |
21.08MB |
137 - Applying a Null Constraint English.srt |
10.26KB |
138 - Solving a Gotcha with Null Constraints.mp4 |
13.72MB |
138 - Solving a Gotcha with Null Constraints English.srt |
6.48KB |
139 - Default Column Values.mp4 |
22.47MB |
139 - Default Column Values English.srt |
5.33KB |
13 - Filtering Rows with Where.mp4 |
12.26MB |
13 - Filtering Rows with Where English.srt |
5.78KB |
140 - Applying a Unique Constraint to One column.mp4 |
43.13MB |
140 - Applying a Unique Constraint to One column English.srt |
8.88KB |
141 - MultiColumn Uniqueness.mp4 |
30.06MB |
141 - MultiColumn Uniqueness English.srt |
5.23KB |
142 - Adding a Validation Check.mp4 |
18.21MB |
142 - Adding a Validation Check English.srt |
6.14KB |
143 - Checks Over Multiple Columns.mp4 |
17.21MB |
143 - Checks Over Multiple Columns English.srt |
7.65KB |
144 - So Where Are We Applying Validation.mp4 |
22.04MB |
144 - So Where Are We Applying Validation English.srt |
9.90KB |
145 - Approaching More Complicated Designs.mp4 |
11.21MB |
145 - Approaching More Complicated Designs English.srt |
5.50KB |
146 - Using a SQL Design Tool.mp4 |
47.29MB |
146 - Using a SQL Design Tool English.srt |
9.94KB |
147 - A Configbased Schema Designer.mp4 |
28.69MB |
147 - A Configbased Schema Designer English.srt |
11.84KB |
148 - Heres the Plan.mp4 |
9.63MB |
148 - Heres the Plan English.srt |
4.27KB |
149 - 005-design.dbml |
455B |
149 - Rebuilding Some Schema.mp4 |
20.94MB |
149 - Rebuilding Some Schema English.srt |
10.63KB |
14 - More on the Where Keyword.mp4 |
9.45MB |
14 - More on the Where Keyword English.srt |
3.86KB |
150 - Requirements of a Like System.mp4 |
26.11MB |
150 - Requirements of a Like System English.srt |
7.74KB |
151 - How Not to Design a Like System.mp4 |
16.22MB |
151 - How Not to Design a Like System English.srt |
4.85KB |
152 - Designing a Like System.mp4 |
26.14MB |
152 - Designing a Like System English.srt |
8.29KB |
153 - Making a Reaction System Instead.mp4 |
6.39MB |
153 - Making a Reaction System Instead English.srt |
2.54KB |
154 - Polymorphic Associations.mp4 |
52.60MB |
154 - Polymorphic Associations English.srt |
9.66KB |
155 - Polymorphic Association Alternative Implementation.mp4 |
63.84MB |
155 - Polymorphic Association Alternative Implementation English.srt |
10.93KB |
156 - The Simplest Alternative.mp4 |
26.94MB |
156 - The Simplest Alternative English.srt |
6.13KB |
157 - So Which Approach.mp4 |
16.02MB |
157 - So Which Approach English.srt |
7.04KB |
158 - Additional Features Around Posts.mp4 |
95.79MB |
158 - Additional Features Around Posts English.srt |
10.05KB |
159 - Adding Captions and Locations.mp4 |
8.53MB |
159 - Adding Captions and Locations English.srt |
2.63KB |
15 - Compound Where Clauses.mp4 |
18.98MB |
15 - Compound Where Clauses English.srt |
7.62KB |
160 - Photo Mentions vs Caption Mentions.mp4 |
73.41MB |
160 - Photo Mentions vs Caption Mentions English.srt |
12.68KB |
161 - Considerations on Photo Tags vs Caption Tags.mp4 |
67.08MB |
161 - Considerations on Photo Tags vs Caption Tags English.srt |
11.65KB |
162 - Update For Tags.mp4 |
23.42MB |
162 - Update For Tags English.srt |
7.41KB |
163 - Designing a Hashtag System.mp4 |
98.12MB |
163 - Designing a Hashtag System English.srt |
11.96KB |
164 - Tables for Hashtags.mp4 |
14.45MB |
164 - Tables for Hashtags English.srt |
5.81KB |
165 - Including the Hashtag Table.mp4 |
18.04MB |
165 - Including the Hashtag Table English.srt |
5.94KB |
166 - A Few More User Columns.mp4 |
27.66MB |
166 - A Few More User Columns English.srt |
9.83KB |
167 - Why No Number of Followers or Posts.mp4 |
17.10MB |
167 - Why No Number of Followers or Posts English.srt |
6.07KB |
168 - Designing a Follower System.mp4 |
26.49MB |
168 - Designing a Follower System English.srt |
9.23KB |
169 - Back to Postgres.mp4 |
6.84MB |
169 - Back to Postgres English.srt |
3.29KB |
16 - A Where Exercise Overview.mp4 |
1.72MB |
16 - A Where Exercise Overview English.srt |
992B |
170 - 002-db.sql |
375B |
170 - Creating Tables with Checks.mp4 |
60.56MB |
170 - Creating Tables with Checks English.srt |
21.02KB |
171 - 003-db.sql |
791B |
171 - Posts Creation.mp4 |
36.16MB |
171 - Posts Creation English.srt |
12.77KB |
172 - 004-db.sql |
1.11KB |
172 - Comments Creation.mp4 |
7.17MB |
172 - Comments Creation English.srt |
3.48KB |
173 - 005-db.sql |
1.55KB |
173 - Likes Creation.mp4 |
23.87MB |
173 - Likes Creation English.srt |
10.02KB |
174 - 006-db.sql |
2.19KB |
174 - Photo Tags and Caption Tags.mp4 |
41.35MB |
174 - Photo Tags and Caption Tags English.srt |
8.29KB |
175 - 007-db.sql |
2.84KB |
175 - Creating Hashtags Hashtag Posts and Followers.mp4 |
19.85MB |
175 - Creating Hashtags Hashtag Posts and Followers English.srt |
9.09KB |
176 - ig.sql |
23.51MB |
176 - Quick Note About Adding Some Data.html |
251B |
177 - Adding Some Data.mp4 |
16.95MB |
177 - Adding Some Data English.srt |
6.64KB |
178 - Restoring from Scratch.mp4 |
21.23MB |
178 - Restoring from Scratch English.srt |
7.01KB |
179 - Highest User IDs Exercise.mp4 |
7.14MB |
179 - Highest User IDs Exercise English.srt |
3.11KB |
17 - A Where Solution.mp4 |
2.54MB |
17 - A Where Solution English.srt |
1.36KB |
180 - Solution for User IDs.mp4 |
4.64MB |
180 - Solution for User IDs English.srt |
1.84KB |
181 - Posts by a Particular User.mp4 |
4.81MB |
181 - Posts by a Particular User English.srt |
1.77KB |
182 - Solving for Posts by User.mp4 |
9.39MB |
182 - Solving for Posts by User English.srt |
2.83KB |
183 - Likes Per User.mp4 |
3.59MB |
183 - Likes Per User English.srt |
1.34KB |
184 - Solution for Likes Per User.mp4 |
6.60MB |
184 - Solution for Likes Per User English.srt |
2.49KB |
185 - Thinking About Performance.mp4 |
9.24MB |
185 - Thinking About Performance English.srt |
3.68KB |
186 - Where Does Postgres Store Data.mp4 |
37.02MB |
186 - Where Does Postgres Store Data English.srt |
8.88KB |
187 - Heaps Blocks and Tuples.mp4 |
22.73MB |
187 - Heaps Blocks and Tuples English.srt |
5.78KB |
188 - Block Data Layout.mp4 |
17.24MB |
188 - Block Data Layout English.srt |
6.93KB |
189 - Heap File Layout.mp4 |
597.17MB |
189 - Heap File Layout English.srt |
49.73KB |
18 - Where With Lists.mp4 |
46.05MB |
18 - Where With Lists English.srt |
1.06KB |
190 - Full Table Scans.mp4 |
37.18MB |
190 - Full Table Scans English.srt |
6.52KB |
191 - Whats an Index.mp4 |
10.10MB |
191 - Whats an Index English.srt |
4.01KB |
192 - How an Index Works.mp4 |
69.31MB |
192 - How an Index Works English.srt |
12.34KB |
193 - Creating an Index.mp4 |
13.11MB |
193 - Creating an Index English.srt |
6.26KB |
194 - Benchmarking Queries.mp4 |
22.58MB |
194 - Benchmarking Queries English.srt |
8.53KB |
195 - Downsides of Indexes.mp4 |
31.82MB |
195 - Downsides of Indexes English.srt |
8.25KB |
196 - Index Types.mp4 |
6.46MB |
196 - Index Types English.srt |
2.58KB |
197 - Automatically Generated Indexes.mp4 |
19.74MB |
197 - Automatically Generated Indexes English.srt |
5.75KB |
198 - Behind the Scenes of Indexes.mp4 |
398.75MB |
198 - Behind the Scenes of Indexes English.srt |
48.94KB |
199 - The Query Processing Pipeline.mp4 |
25.73MB |
199 - The Query Processing Pipeline English.srt |
8.17KB |
19 - A Where With Lists Solution.mp4 |
4.96MB |
19 - A Where With Lists Solution English.srt |
2.37KB |
1 - Join Our Community.html |
318B |
200 - Explain and Explain Analyze.mp4 |
42.83MB |
200 - Explain and Explain Analyze English.srt |
8.35KB |
201 - Solving an Explain Mystery.mp4 |
79.79MB |
201 - Solving an Explain Mystery English.srt |
14.03KB |
202 - Developing an Intuitive Understanding of Cost.mp4 |
102.89MB |
202 - Developing an Intuitive Understanding of Cost English.srt |
20.44KB |
203 - Calculating Cost by Hand.mp4 |
51.25MB |
203 - Calculating Cost by Hand English.srt |
10.11KB |
204 - A Touch More on Costs.mp4 |
95.40MB |
204 - A Touch More on Costs English.srt |
11.49KB |
205 - Startup vs Total Costs.mp4 |
44.70MB |
205 - Startup vs Total Costs English.srt |
9.12KB |
206 - Costs Flow Up.mp4 |
10.10MB |
206 - Costs Flow Up English.srt |
3.12KB |
207 - Use My Index.mp4 |
39.40MB |
207 - Use My Index English.srt |
12.79KB |
208 - Common Table Expressions.mp4 |
11.19MB |
208 - Common Table Expressions English.srt |
2.97KB |
209 - A Quick Solution.mp4 |
13.16MB |
209 - A Quick Solution English.srt |
5.65KB |
20 - Calculations in Where Clauses.mp4 |
4.68MB |
20 - Calculations in Where Clauses English.srt |
3.09KB |
210 - So Whats a CTE.mp4 |
33.50MB |
210 - So Whats a CTE English.srt |
5.79KB |
211 - Recursive CTEs.mp4 |
11.90MB |
211 - Recursive CTEs English.srt |
5.06KB |
212 - Recursive CTEs Step by Step.mp4 |
62.89MB |
212 - Recursive CTEs Step by Step English.srt |
15.57KB |
213 - Why Use Recursive CTEs.mp4 |
43.14MB |
213 - Why Use Recursive CTEs English.srt |
7.81KB |
214 - Writing the Query.mp4 |
36.56MB |
214 - Writing the Query English.srt |
11.92KB |
215 - Walking Through Recursion.mp4 |
109.41MB |
215 - Walking Through Recursion English.srt |
15.04KB |
216 - Most Popular Users.mp4 |
24.81MB |
216 - Most Popular Users English.srt |
9.86KB |
217 - A Possible Solution for Merging Tables.mp4 |
35.67MB |
217 - A Possible Solution for Merging Tables English.srt |
6.23KB |
218 - Creating a View.mp4 |
33.33MB |
218 - Creating a View English.srt |
8.51KB |
219 - When to Use a View.mp4 |
21.21MB |
219 - When to Use a View English.srt |
4.99KB |
21 - Solving Calculations.mp4 |
5.91MB |
21 - Solving Calculations English.srt |
3.05KB |
220 - Deleting and Changing Views.mp4 |
12.51MB |
220 - Deleting and Changing Views English.srt |
3.71KB |
221 - Materialized Views.mp4 |
8.38MB |
221 - Materialized Views English.srt |
3.87KB |
222 - Grouping by Week.mp4 |
34.40MB |
222 - Grouping by Week English.srt |
6.39KB |
223 - Reminder on Left Joins.mp4 |
15.51MB |
223 - Reminder on Left Joins English.srt |
6.91KB |
224 - Writing a Slow Query.mp4 |
55.08MB |
224 - Writing a Slow Query English.srt |
14.00KB |
225 - Creating and Refreshing Materialized Views.mp4 |
36.10MB |
225 - Creating and Refreshing Materialized Views English.srt |
10.02KB |
226 - What are Transactions Used For.mp4 |
22.54MB |
226 - What are Transactions Used For English.srt |
6.42KB |
227 - Some Sample Data.mp4 |
5.44MB |
227 - Some Sample Data English.srt |
3.16KB |
228 - Opening and Closing Transactions.mp4 |
65.33MB |
228 - Opening and Closing Transactions English.srt |
15.17KB |
229 - Transaction Cleanup on Crash.mp4 |
32.89MB |
229 - Transaction Cleanup on Crash English.srt |
6.14KB |
22 - Updating Rows.mp4 |
32.97MB |
22 - Updating Rows English.srt |
6.47KB |
230 - Closing Aborted Transactions.mp4 |
7.47MB |
230 - Closing Aborted Transactions English.srt |
2.75KB |
231 - A Story on Migrations.mp4 |
139.70MB |
231 - A Story on Migrations English.srt |
27.93KB |
232 - Migration Files.mp4 |
44.16MB |
232 - Migration Files English.srt |
7.53KB |
233 - Issues Solved by Migrations.mp4 |
10.00MB |
233 - Issues Solved by Migrations English.srt |
4.51KB |
234 - A Few Notes on Migrations Libraries.mp4 |
34.19MB |
234 - A Few Notes on Migrations Libraries English.srt |
7.82KB |
235 - A Note About Node Installation.html |
264B |
236 - Project Creation.mp4 |
9.91MB |
236 - Project Creation English.srt |
4.52KB |
237 - Generating and Writing Migrations.mp4 |
45.64MB |
237 - Generating and Writing Migrations English.srt |
10.50KB |
238 - Applying and Reverting Migrations.mp4 |
68.14MB |
238 - Applying and Reverting Migrations English.srt |
11.21KB |
239 - Generating and Applying a Second Migration.mp4 |
16.63MB |
239 - Generating and Applying a Second Migration English.srt |
5.19KB |
23 - Deleting Rows.mp4 |
11.18MB |
23 - Deleting Rows English.srt |
5.03KB |
240 - Schema vs Data Migrations.mp4 |
20.28MB |
240 - Schema vs Data Migrations English.srt |
6.42KB |
241 - Dangers Around Data Migrations.mp4 |
70.00MB |
241 - Dangers Around Data Migrations English.srt |
14.53KB |
242 - Properly Running Data and Schema Migrations.mp4 |
19.73MB |
242 - Properly Running Data and Schema Migrations English.srt |
8.88KB |
243 - Creating a Posts Table.mp4 |
21.59MB |
243 - Creating a Posts Table English.srt |
6.87KB |
244 - 005-index.js |
1.32KB |
244 - A Small Web Server.mp4 |
62.26MB |
244 - A Small Web Server English.srt |
21.00KB |
245 - Web Server Setup Instructions.html |
1.02KB |
246 - Adding the Loc Column.mp4 |
21.55MB |
246 - Adding the Loc Column English.srt |
6.07KB |
247 - Writing Values to Both Columns.mp4 |
16.26MB |
247 - Writing Values to Both Columns English.srt |
6.49KB |
248 - Transaction Locks.mp4 |
96.42MB |
248 - Transaction Locks English.srt |
22.30KB |
249 - Updating Values.mp4 |
15.27MB |
249 - Updating Values English.srt |
6.46KB |
24 - A Solution for Updating Rows.mp4 |
4.94MB |
24 - A Solution for Updating Rows English.srt |
2.20KB |
250 - 01-lng-lat-to-loc.js |
364B |
250 - Migrations Setup Instructions.html |
925B |
251 - Updating the App Server.mp4 |
13.23MB |
251 - Updating the App Server English.srt |
6.61KB |
252 - Dropping the Last Columns.mp4 |
11.61MB |
252 - Dropping the Last Columns English.srt |
4.82KB |
253 - Section Goal.mp4 |
2.62MB |
253 - Section Goal English.srt |
1.52KB |
254 - Initial Setup.mp4 |
2.23MB |
254 - Initial Setup English.srt |
2.53KB |
255 - One Fast Migration.mp4 |
24.43MB |
255 - One Fast Migration English.srt |
7.32KB |
256 - 005-access-social-repo.zip |
61.31KB |
256 - Building the Users Router.mp4 |
29.61MB |
256 - Building the Users Router English.srt |
6.79KB |
257 - Understanding Connection Pools.mp4 |
22.93MB |
257 - Understanding Connection Pools English.srt |
10.63KB |
258 - Validating Connection Credentials.mp4 |
44.74MB |
258 - Validating Connection Credentials English.srt |
10.64KB |
259 - 008-access.zip |
62.00KB |
259 - Query and Close.mp4 |
5.90MB |
259 - Query and Close English.srt |
3.12KB |
25 - Solution for Deleting Rows.mp4 |
4.00MB |
25 - Solution for Deleting Rows English.srt |
2.02KB |
260 - The Repository Pattern.mp4 |
17.88MB |
260 - The Repository Pattern English.srt |
5.69KB |
261 - 010-access.zip |
62.58KB |
261 - Creating a Repository.mp4 |
24.78MB |
261 - Creating a Repository English.srt |
12.67KB |
262 - Accessing the API.mp4 |
23.55MB |
262 - Accessing the API English.srt |
6.43KB |
263 - Casing Issues.mp4 |
18.55MB |
263 - Casing Issues English.srt |
7.05KB |
264 - Fixing Casing.mp4 |
49.74MB |
264 - Fixing Casing English.srt |
9.58KB |
265 - Finding Particular Users.mp4 |
18.16MB |
265 - Finding Particular Users English.srt |
8.20KB |
266 - SQL Injection Exploits.mp4 |
30.46MB |
266 - SQL Injection Exploits English.srt |
10.83KB |
267 - Handling SQL Injection with Prepared Statements.mp4 |
38.15MB |
267 - Handling SQL Injection with Prepared Statements English.srt |
12.81KB |
268 - Preventing SQL Injection.mp4 |
34.29MB |
268 - Preventing SQL Injection English.srt |
11.60KB |
269 - Reminder on Post Requests.mp4 |
14.40MB |
269 - Reminder on Post Requests English.srt |
4.18KB |
26 - The Plan Moving Forward.mp4 |
10.75MB |
26 - The Plan Moving Forward English.srt |
2.79KB |
270 - 019-access.zip |
63.56KB |
270 - Inserting Users.mp4 |
15.25MB |
270 - Inserting Users English.srt |
6.29KB |
271 - Handling Updates.mp4 |
16.66MB |
271 - Handling Updates English.srt |
6.82KB |
272 - 021-access.zip |
63.66KB |
272 - And Finally Delete.mp4 |
18.24MB |
272 - And Finally Delete English.srt |
6.32KB |
273 - A Note on Testing.mp4 |
7.64MB |
273 - A Note on Testing English.srt |
4.97KB |
274 - Assertions Around User Count.mp4 |
42.34MB |
274 - Assertions Around User Count English.srt |
10.62KB |
275 - 024-access.zip |
64.50KB |
275 - Connecting to a DB For Tests.mp4 |
54.23MB |
275 - Connecting to a DB For Tests English.srt |
8.21KB |
276 - 025-access.zip |
64.51KB |
276 - Disconnecting After Tests.mp4 |
12.86MB |
276 - Disconnecting After Tests English.srt |
4.60KB |
277 - 026-access.zip |
64.52KB |
277 - MultiDB Setup.mp4 |
21.85MB |
277 - MultiDB Setup English.srt |
7.52KB |
278 - 027-access.zip |
64.52KB |
278 - Assumptions Around Content.mp4 |
33.12MB |
278 - Assumptions Around Content English.srt |
8.25KB |
279 - 028-access.zip |
65.77KB |
279 - Issues with Parallel Tests.mp4 |
35.76MB |
279 - Issues with Parallel Tests English.srt |
7.96KB |
27 - Approaching Database Design.mp4 |
81.98MB |
27 - Approaching Database Design English.srt |
12.07KB |
280 - Isolation with Schemas.mp4 |
27.40MB |
280 - Isolation with Schemas English.srt |
6.57KB |
281 - Creating and Accessing Schemas.mp4 |
19.38MB |
281 - Creating and Accessing Schemas English.srt |
8.04KB |
282 - Controlling Schema Access with Search Paths.mp4 |
30.95MB |
282 - Controlling Schema Access with Search Paths English.srt |
8.78KB |
283 - Routing Schema Access.mp4 |
41.12MB |
283 - Routing Schema Access English.srt |
6.61KB |
284 - Strategy for Isolation.mp4 |
17.57MB |
284 - Strategy for Isolation English.srt |
7.20KB |
285 - 034-access.zip |
66.14KB |
285 - Programmatic Schema Creation.mp4 |
65.75MB |
285 - Programmatic Schema Creation English.srt |
18.23KB |
286 - 035-access.zip |
66.14KB |
286 - Escaping Identifiers.mp4 |
25.53MB |
286 - Escaping Identifiers English.srt |
6.42KB |
287 - 036-access.zip |
66.48KB |
287 - Test Helpers.mp4 |
43.34MB |
287 - Test Helpers English.srt |
7.97KB |
288 - 037-access.zip |
66.59KB |
288 - Cleaning up Schemas and Roles.mp4 |
31.28MB |
288 - Cleaning up Schemas and Roles English.srt |
8.20KB |
289 - Finally Parallel Tests Final Lecture.mp4 |
18.57MB |
289 - Finally Parallel Tests Final Lecture English.srt |
5.30KB |
28 - OnetoMany and ManytoOne Relationships.mp4 |
41.31MB |
28 - OnetoMany and ManytoOne Relationships English.srt |
10.06KB |
290 - Bonus.html |
3.39KB |
29 - OnetoOne and ManytoMany Relationships.mp4 |
24.58MB |
29 - OnetoOne and ManytoMany Relationships English.srt |
8.75KB |
2 - Course Resources.html |
1.25KB |
2 - diagrams.zip |
7.72MB |
30 - Primary Keys and Foreign Keys.mp4 |
29.57MB |
30 - Primary Keys and Foreign Keys English.srt |
7.89KB |
31 - Understanding Foreign Keys.mp4 |
63.35MB |
31 - Understanding Foreign Keys English.srt |
12.96KB |
32 - 007-tables.sql |
194B |
32 - 007-tables-cumulative.sql |
172B |
32 - AutoGenerated IDs.mp4 |
22.97MB |
32 - AutoGenerated IDs English.srt |
8.95KB |
33 - 008-tables.sql |
197B |
33 - 008-tables-cumulative.sql |
348B |
33 - Creating Foreign Key Columns.mp4 |
18.32MB |
33 - Creating Foreign Key Columns English.srt |
7.48KB |
34 - 009-tables.sql |
326B |
34 - 009-tables-cumulative.sql |
536B |
34 - Running Queries on Associated Data.mp4 |
38.22MB |
34 - Running Queries on Associated Data English.srt |
10.35KB |
35 - Exercise Overview.mp4 |
8.25MB |
35 - Exercise Overview English.srt |
3.41KB |
36 - Foreign Key Creation Solution.mp4 |
8.35MB |
36 - Foreign Key Creation Solution English.srt |
3.04KB |
37 - 012-tables.sql |
199B |
37 - 012-tables-cumulative.sql |
600B |
37 - Foreign Key Constraints Around Insertion.mp4 |
22.15MB |
37 - Foreign Key Constraints Around Insertion English.srt |
8.76KB |
38 - Constraints Around Deletion.mp4 |
40.54MB |
38 - Constraints Around Deletion English.srt |
7.68KB |
39 - Commands Youll Need for the Next Video.html |
691B |
3 - What is PostgreSQL All About.mp4 |
21.75MB |
3 - What is PostgreSQL All About English.srt |
7.45KB |
40 - 014-tables.sql |
469B |
40 - 014-tables-cumulative.sql |
994B |
40 - Testing Deletion Constraints.mp4 |
19.27MB |
40 - Testing Deletion Constraints English.srt |
6.76KB |
41 - 015-tables.sql |
340B |
41 - 015-tables-cumulative.sql |
1.28KB |
41 - Setting Foreign Keys to Null on Delete.mp4 |
12.60MB |
41 - Setting Foreign Keys to Null on Delete English.srt |
4.42KB |
42 - Adding Some Complexity.mp4 |
9.96MB |
42 - Adding Some Complexity English.srt |
4.79KB |
43 - Adding Some Data.html |
7.66KB |
44 - Queries with Joins and Aggregations.mp4 |
27.86MB |
44 - Queries with Joins and Aggregations English.srt |
5.20KB |
45 - Joining Data from Different Tables.mp4 |
36.80MB |
45 - Joining Data from Different Tables English.srt |
11.85KB |
46 - Another Quick Join.mp4 |
8.62MB |
46 - Another Quick Join English.srt |
3.24KB |
47 - Exercise Overview.mp4 |
4.85MB |
47 - Exercise Overview English.srt |
1.79KB |
48 - A Joinful Solution.mp4 |
5.27MB |
48 - A Joinful Solution English.srt |
2.57KB |
49 - Alternate Forms of Syntax.mp4 |
24.96MB |
49 - Alternate Forms of Syntax English.srt |
9.37KB |
4 - Database Design.mp4 |
35.37MB |
4 - Database Design English.srt |
8.20KB |
50 - 007-joins-cumulative.sql |
7.54KB |
5 - 003-sql.sql |
104B |
50 - Missing Data in Joins.mp4 |
29.27MB |
50 - Missing Data in Joins English.srt |
9.82KB |
51 - Why Wasnt It Included.mp4 |
24.58MB |
51 - Why Wasnt It Included English.srt |
3.79KB |
52 - 009-joins-cheatsheet.pdf |
190.52KB |
52 - Four Kinds of Joins.mp4 |
124.86MB |
52 - Four Kinds of Joins English.srt |
14.83KB |
53 - 010-sql-cumulative.sql |
7.59KB |
53 - Each Join in Practice.mp4 |
40.60MB |
53 - Each Join in Practice English.srt |
6.30KB |
54 - Does Order Matter.mp4 |
61.33MB |
54 - Does Order Matter English.srt |
6.44KB |
55 - Exercise Overview.mp4 |
2.23MB |
55 - Exercise Overview English.srt |
1.47KB |
56 - Two Possible Solutions.mp4 |
16.51MB |
56 - Two Possible Solutions English.srt |
4.75KB |
57 - Where with Join.mp4 |
31.03MB |
57 - Where with Join English.srt |
10.33KB |
58 - Three Way Joins.mp4 |
49.71MB |
58 - Three Way Joins English.srt |
12.24KB |
59 - A Bit of Practice.mp4 |
17.87MB |
59 - A Bit of Practice English.srt |
7.70KB |
5 - Creating Tables.mp4 |
18.61MB |
5 - Creating Tables English.srt |
7.71KB |
60 - Exercise Solution.mp4 |
7.67MB |
60 - Exercise Solution English.srt |
4.00KB |
61 - Aggregating and Grouping.mp4 |
7.90MB |
61 - Aggregating and Grouping English.srt |
3.56KB |
62 - Picturing Group By.mp4 |
29.43MB |
62 - Picturing Group By English.srt |
8.29KB |
63 - Aggregate Functions.mp4 |
11.58MB |
63 - Aggregate Functions English.srt |
4.54KB |
64 - Combining Group By and Aggregates.mp4 |
15.13MB |
64 - Combining Group By and Aggregates English.srt |
7.24KB |
65 - A Gotcha with Count.mp4 |
5.46MB |
65 - A Gotcha with Count English.srt |
4.17KB |
66 - Visualizing More Grouping.mp4 |
9.72MB |
66 - Visualizing More Grouping English.srt |
4.60KB |
67 - Exercise Overview.mp4 |
1.66MB |
67 - Exercise Overview English.srt |
1.15KB |
68 - Grouping Solution.mp4 |
3.15MB |
68 - Grouping Solution English.srt |
2.17KB |
69 - Adding a Layer of Difficulty.mp4 |
1.79MB |
69 - Adding a Layer of Difficulty English.srt |
1.11KB |
6 - Analyzing CREATE TABLE.mp4 |
17.67MB |
6 - Analyzing CREATE TABLE English.srt |
5.51KB |
7 - 005-sql.sql |
278B |
7 - 005-sql-cumulative.sql |
384B |
70 - Solution.mp4 |
3.68MB |
70 - Solution English.srt |
2.20KB |
71 - Filtering Groups with Having.mp4 |
36.97MB |
71 - Filtering Groups with Having English.srt |
7.76KB |
72 - Having In Action.mp4 |
6.86MB |
72 - Having In Action English.srt |
3.98KB |
73 - More on Having.mp4 |
28.46MB |
73 - More on Having English.srt |
10.49KB |
74 - A Having Exercise Overview.mp4 |
12.79MB |
74 - A Having Exercise Overview English.srt |
5.51KB |
75 - A Quick Solution.mp4 |
7.30MB |
75 - A Quick Solution English.srt |
3.80KB |
76 - A New Dataset.html |
17.84KB |
77 - 001-sq-data.sql |
15.82KB |
77 - Investigating This Dataset.mp4 |
8.00MB |
77 - Investigating This Dataset English.srt |
4.11KB |
78 - Some Group By Practice.mp4 |
3.10MB |
78 - Some Group By Practice English.srt |
2.03KB |
79 - Group By Review Solution.mp4 |
7.92MB |
79 - Group By Review Solution English.srt |
3.53KB |
7 - Inserting Data Into a Table.mp4 |
18.07MB |
7 - Inserting Data Into a Table English.srt |
7.59KB |
80 - Remember Joins.mp4 |
9.30MB |
80 - Remember Joins English.srt |
3.56KB |
81 - Of Course You Remember.mp4 |
4.42MB |
81 - Of Course You Remember English.srt |
2.12KB |
82 - The Basics of Sorting.mp4 |
6.73MB |
82 - The Basics of Sorting English.srt |
3.61KB |
83 - Two Variations on Sorting.mp4 |
9.46MB |
83 - Two Variations on Sorting English.srt |
4.14KB |
84 - Offset and Limit.mp4 |
19.43MB |
84 - Offset and Limit English.srt |
10.47KB |
85 - Exercise Overview.mp4 |
1.08MB |
85 - Exercise Overview English.srt |
716B |
86 - Exercise Solution.mp4 |
3.33MB |
86 - Exercise Solution English.srt |
2.06KB |
87 - Handling Sets with Union.mp4 |
19.51MB |
87 - Handling Sets with Union English.srt |
8.78KB |
88 - A Few Notes on Union.mp4 |
16.54MB |
88 - A Few Notes on Union English.srt |
5.69KB |
89 - Commonalities with Intersect.mp4 |
15.42MB |
89 - Commonalities with Intersect English.srt |
5.05KB |
8 - Retrieving Data with Select.mp4 |
6.02MB |
8 - Retrieving Data with Select English.srt |
3.30KB |
90 - Removing Commonalities with Except.mp4 |
20.44MB |
90 - Removing Commonalities with Except English.srt |
9.49KB |
91 - Union Exercise Overview.mp4 |
4.23MB |
91 - Union Exercise Overview English.srt |
2.25KB |
92 - Exercise Solution.mp4 |
4.72MB |
92 - Exercise Solution English.srt |
2.08KB |
93 - Whats a Subquery.mp4 |
30.54MB |
93 - Whats a Subquery English.srt |
8.90KB |
94 - Thinking About the Structure of Data.mp4 |
23.64MB |
94 - Thinking About the Structure of Data English.srt |
7.58KB |
95 - Subqueries in a Select.mp4 |
22.54MB |
95 - Subqueries in a Select English.srt |
8.53KB |
96 - Exercise Overview.mp4 |
3.05MB |
96 - Exercise Overview English.srt |
1.74KB |
97 - Select Solution.mp4 |
3.80MB |
97 - Select Solution English.srt |
1.82KB |
98 - Subqueries in a From.mp4 |
44.45MB |
98 - Subqueries in a From English.srt |
12.01KB |
99 - From Subqueries that Return a Value.mp4 |
9.08MB |
99 - From Subqueries that Return a Value English.srt |
4.34KB |
9 - Calculated Columns.mp4 |
15.22MB |
9 - Calculated Columns English.srt |
7.35KB |