Site NEWS just posted! Please click here to check it out!

Udemy SQL and PostgreSQL The Complete Developer s Guide Giga Course

Torrent Info
Category Other
Added Sunday 22nd October 2023 06:50:44 AM (3 years ago)
Size8.1 GB
Peers5 Peers (5 Seeders and 0 leechers) update
Downloaded558 times
UploaderCourseClub  Thank You  (0) Report Torrent 00/0
CommentsNone
Uploader Comments
None
Tags English
Seeders5
Leechers0
Torrent Screenshots

There are no images posted for this torrent.

NFO
No NFO was added for this torrent.
Torrent Files (626)
FilenameSize
[CourseClub.Me].url122 bytes
[GigaCourse.Com].url49 bytes
1 - Join Our Community.html318 bytes
10 - Calculating Phone Revenue English.srt1.6 KB
10 - Calculating Phone Revenue.mp437.3 MB
11 - Exercise Solution English.srt1.6 KB
11 - Exercise Solution.mp427.9 MB
12 - 012-sql.sql404 bytes
12 - String Operators and Functions English.srt9.9 KB
12 - String Operators and Functions.mp465.1 MB
2 - Course Resources.html1.2 KB
2 - diagrams.zip7.7 MB
3 - What is PostgreSQL All About English.srt7.4 KB
3 - What is PostgreSQL All About.mp421.7 MB
4 - Database Design English.srt8.2 KB
4 - Database Design.mp435.4 MB
5 - 003-sql.sql104 bytes
5 - Creating Tables English.srt7.7 KB
5 - Creating Tables.mp418.6 MB
6 - Analyzing CREATE TABLE English.srt5.5 KB
6 - Analyzing CREATE TABLE.mp417.7 MB
7 - 005-sql-cumulative.sql384 bytes
7 - 005-sql.sql278 bytes
7 - Inserting Data Into a Table English.srt7.6 KB
7 - Inserting Data Into a Table.mp418.1 MB
8 - Retrieving Data with Select English.srt3.3 KB
8 - Retrieving Data with Select.mp46.0 MB
9 - Calculated Columns English.srt7.3 KB
9 - Calculated Columns.mp415.2 MB
118 - Selecting Distinct Values English.srt6.5 KB
118 - Selecting Distinct Values.mp412.5 MB
119 - Exercise Overview English.srt906 bytes
119 - Exercise Overview.mp41.3 MB
120 - A Distinct Solution English.srt964 bytes
120 - A Distinct Solution.mp41.9 MB
121 - The Greatest Value in a List English.srt5.1 KB
121 - The Greatest Value in a List.mp411.8 MB
122 - And the Least Value in a List English.srt3.0 KB
122 - And the Least Value in a List.mp45.5 MB
123 - The Case Keyword English.srt6.7 KB
123 - The Case Keyword.mp419.0 MB
124 - PostgreSQL Installation on macOS English.srt10.0 KB
124 - PostgreSQL Installation on macOS.mp421.1 MB
125 - PGAdmin Setup on macOS English.srt7.8 KB
125 - PGAdmin Setup on macOS.mp436.9 MB
126 - Postgres installation on Windows English.srt6.6 KB
126 - Postgres installation on Windows.mp423.3 MB
127 - Whatd We Just Do English.srt6.5 KB
127 - Whatd We Just Do.mp419.3 MB
128 - Data Types English.srt7.2 KB
128 - Data Types.mp430.5 MB
129 - Fast Rules on Numeric Data Types English.srt3.6 KB
129 - Fast Rules on Numeric Data Types.mp418.9 MB
130 - More on Number Data Types English.srt14.8 KB
130 - More on Number Data Types.mp448.1 MB
131 - Reminder on Character Types English.srt7.5 KB
131 - Reminder on Character Types.mp429.9 MB
132 - Boolean Data Types English.srt3.9 KB
132 - Boolean Data Types.mp48.2 MB
133 - Times Dates and Timestamps English.srt8.4 KB
133 - Times Dates and Timestamps.mp421.3 MB
134 - Really Awesome Intervals English.srt9.1 KB
134 - Really Awesome Intervals.mp419.5 MB
135 - Thinking About Validation English.srt6.9 KB
135 - Thinking About Validation.mp434.6 MB
136 - Creating and Viewing Tables in PGAdmin English.srt11.6 KB
136 - Creating and Viewing Tables in PGAdmin.mp428.1 MB
137 - Applying a Null Constraint English.srt10.3 KB
137 - Applying a Null Constraint.mp421.1 MB
138 - Solving a Gotcha with Null Constraints English.srt6.5 KB
138 - Solving a Gotcha with Null Constraints.mp413.7 MB
139 - Default Column Values English.srt5.3 KB
139 - Default Column Values.mp422.5 MB
140 - Applying a Unique Constraint to One column English.srt8.9 KB
140 - Applying a Unique Constraint to One column.mp443.1 MB
141 - MultiColumn Uniqueness English.srt5.2 KB
141 - MultiColumn Uniqueness.mp430.1 MB
142 - Adding a Validation Check English.srt6.1 KB
142 - Adding a Validation Check.mp418.2 MB
143 - Checks Over Multiple Columns English.srt7.6 KB
143 - Checks Over Multiple Columns.mp417.2 MB
144 - So Where Are We Applying Validation English.srt9.9 KB
144 - So Where Are We Applying Validation.mp422.0 MB
145 - Approaching More Complicated Designs English.srt5.5 KB
145 - Approaching More Complicated Designs.mp411.2 MB
146 - Using a SQL Design Tool English.srt9.9 KB
146 - Using a SQL Design Tool.mp447.3 MB
147 - A Configbased Schema Designer English.srt11.8 KB
147 - A Configbased Schema Designer.mp428.7 MB
148 - Heres the Plan English.srt4.3 KB
148 - Heres the Plan.mp49.6 MB
149 - 005-design.dbml455 bytes
149 - Rebuilding Some Schema English.srt10.6 KB
149 - Rebuilding Some Schema.mp420.9 MB
150 - Requirements of a Like System English.srt7.7 KB
150 - Requirements of a Like System.mp426.1 MB
151 - How Not to Design a Like System English.srt4.8 KB
151 - How Not to Design a Like System.mp416.2 MB
152 - Designing a Like System English.srt8.3 KB
152 - Designing a Like System.mp426.1 MB
153 - Making a Reaction System Instead English.srt2.5 KB
153 - Making a Reaction System Instead.mp46.4 MB
154 - Polymorphic Associations English.srt9.7 KB
154 - Polymorphic Associations.mp452.6 MB
155 - Polymorphic Association Alternative Implementation English.srt10.9 KB
155 - Polymorphic Association Alternative Implementation.mp463.8 MB
156 - The Simplest Alternative English.srt6.1 KB
156 - The Simplest Alternative.mp426.9 MB
157 - So Which Approach English.srt7.0 KB
157 - So Which Approach.mp416.0 MB
158 - Additional Features Around Posts English.srt10.1 KB
158 - Additional Features Around Posts.mp495.8 MB
159 - Adding Captions and Locations English.srt2.6 KB
159 - Adding Captions and Locations.mp48.5 MB
160 - Photo Mentions vs Caption Mentions English.srt12.7 KB
160 - Photo Mentions vs Caption Mentions.mp473.4 MB
161 - Considerations on Photo Tags vs Caption Tags English.srt11.7 KB
161 - Considerations on Photo Tags vs Caption Tags.mp467.1 MB
162 - Update For Tags English.srt7.4 KB
162 - Update For Tags.mp423.4 MB
[CourseClub.Me].url122 bytes
[GigaCourse.Com].url49 bytes
163 - Designing a Hashtag System English.srt12.0 KB
163 - Designing a Hashtag System.mp498.1 MB
164 - Tables for Hashtags English.srt5.8 KB
164 - Tables for Hashtags.mp414.5 MB
165 - Including the Hashtag Table English.srt5.9 KB
165 - Including the Hashtag Table.mp418.0 MB
166 - A Few More User Columns English.srt9.8 KB
166 - A Few More User Columns.mp427.7 MB
167 - Why No Number of Followers or Posts English.srt6.1 KB
167 - Why No Number of Followers or Posts.mp417.1 MB
168 - Designing a Follower System English.srt9.2 KB
168 - Designing a Follower System.mp426.5 MB
13 - 013-sql.sql48 bytes
13 - Filtering Rows with Where English.srt5.8 KB
13 - Filtering Rows with Where.mp412.3 MB
14 - More on the Where Keyword English.srt3.9 KB
14 - More on the Where Keyword.mp49.4 MB
15 - Compound Where Clauses English.srt7.6 KB
15 - Compound Where Clauses.mp419.0 MB
16 - A Where Exercise Overview English.srt992 bytes
16 - A Where Exercise Overview.mp41.7 MB
17 - A Where Solution English.srt1.4 KB
17 - A Where Solution.mp42.5 MB
18 - Where With Lists English.srt1.1 KB
18 - Where With Lists.mp446.1 MB
19 - A Where With Lists Solution English.srt2.4 KB
19 - A Where With Lists Solution.mp45.0 MB
20 - Calculations in Where Clauses English.srt3.1 KB
20 - Calculations in Where Clauses.mp44.7 MB
21 - Solving Calculations English.srt3.0 KB
21 - Solving Calculations.mp45.9 MB
22 - Updating Rows English.srt6.5 KB
22 - Updating Rows.mp433.0 MB
23 - Deleting Rows English.srt5.0 KB
23 - Deleting Rows.mp411.2 MB
24 - A Solution for Updating Rows English.srt2.2 KB
24 - A Solution for Updating Rows.mp44.9 MB
25 - Solution for Deleting Rows English.srt2.0 KB
25 - Solution for Deleting Rows.mp44.0 MB
169 - Back to Postgres English.srt3.3 KB
169 - Back to Postgres.mp46.8 MB
170 - 002-db.sql375 bytes
170 - Creating Tables with Checks English.srt21.0 KB
170 - Creating Tables with Checks.mp460.6 MB
171 - 003-db.sql791 bytes
171 - Posts Creation English.srt12.8 KB
171 - Posts Creation.mp436.2 MB
172 - 004-db.sql1.1 KB
172 - Comments Creation English.srt3.5 KB
172 - Comments Creation.mp47.2 MB
173 - 005-db.sql1.5 KB
173 - Likes Creation English.srt10.0 KB
173 - Likes Creation.mp423.9 MB
174 - 006-db.sql2.2 KB
174 - Photo Tags and Caption Tags English.srt8.3 KB
174 - Photo Tags and Caption Tags.mp441.3 MB
175 - 007-db.sql2.8 KB
175 - Creating Hashtags Hashtag Posts and Followers English.srt9.1 KB
175 - Creating Hashtags Hashtag Posts and Followers.mp419.8 MB
176 - Quick Note About Adding Some Data.html251 bytes
176 - ig.sql23.5 MB
177 - Adding Some Data English.srt6.6 KB
177 - Adding Some Data.mp416.9 MB
178 - Restoring from Scratch English.srt7.0 KB
178 - Restoring from Scratch.mp421.2 MB
179 - Highest User IDs Exercise English.srt3.1 KB
179 - Highest User IDs Exercise.mp47.1 MB
180 - Solution for User IDs English.srt1.8 KB
180 - Solution for User IDs.mp44.6 MB
181 - Posts by a Particular User English.srt1.8 KB
181 - Posts by a Particular User.mp44.8 MB
182 - Solving for Posts by User English.srt2.8 KB
182 - Solving for Posts by User.mp49.4 MB
183 - Likes Per User English.srt1.3 KB
183 - Likes Per User.mp43.6 MB
184 - Solution for Likes Per User English.srt2.5 KB
184 - Solution for Likes Per User.mp46.6 MB
185 - Thinking About Performance English.srt3.7 KB
185 - Thinking About Performance.mp49.2 MB
186 - Where Does Postgres Store Data English.srt8.9 KB
186 - Where Does Postgres Store Data.mp437.0 MB
187 - Heaps Blocks and Tuples English.srt5.8 KB
187 - Heaps Blocks and Tuples.mp422.7 MB
188 - Block Data Layout English.srt6.9 KB
188 - Block Data Layout.mp417.2 MB
189 - Heap File Layout English.srt49.7 KB
189 - Heap File Layout.mp4597.2 MB
190 - Full Table Scans English.srt6.5 KB
190 - Full Table Scans.mp437.2 MB
191 - Whats an Index English.srt4.0 KB
191 - Whats an Index.mp410.1 MB
192 - How an Index Works English.srt12.3 KB
192 - How an Index Works.mp469.3 MB
193 - Creating an Index English.srt6.3 KB
193 - Creating an Index.mp413.1 MB
194 - Benchmarking Queries English.srt8.5 KB
194 - Benchmarking Queries.mp422.6 MB
195 - Downsides of Indexes English.srt8.2 KB
195 - Downsides of Indexes.mp431.8 MB
196 - Index Types English.srt2.6 KB
196 - Index Types.mp46.5 MB
197 - Automatically Generated Indexes English.srt5.8 KB
197 - Automatically Generated Indexes.mp419.7 MB
198 - Behind the Scenes of Indexes English.srt48.9 KB
198 - Behind the Scenes of Indexes.mp4398.8 MB
199 - The Query Processing Pipeline English.srt8.2 KB
199 - The Query Processing Pipeline.mp425.7 MB
200 - Explain and Explain Analyze English.srt8.4 KB
200 - Explain and Explain Analyze.mp442.8 MB
201 - Solving an Explain Mystery English.srt14.0 KB
201 - Solving an Explain Mystery.mp479.8 MB
202 - Developing an Intuitive Understanding of Cost English.srt20.4 KB
202 - Developing an Intuitive Understanding of Cost.mp4102.9 MB
203 - Calculating Cost by Hand English.srt10.1 KB
203 - Calculating Cost by Hand.mp451.2 MB
204 - A Touch More on Costs English.srt11.5 KB
204 - A Touch More on Costs.mp495.4 MB
205 - Startup vs Total Costs English.srt9.1 KB
205 - Startup vs Total Costs.mp444.7 MB
206 - Costs Flow Up English.srt3.1 KB
206 - Costs Flow Up.mp410.1 MB
207 - Use My Index English.srt12.8 KB
207 - Use My Index.mp439.4 MB
208 - Common Table Expressions English.srt3.0 KB
208 - Common Table Expressions.mp411.2 MB
209 - A Quick Solution English.srt5.6 KB
209 - A Quick Solution.mp413.2 MB
210 - So Whats a CTE English.srt5.8 KB
210 - So Whats a CTE.mp433.5 MB
211 - Recursive CTEs English.srt5.1 KB
211 - Recursive CTEs.mp411.9 MB
212 - Recursive CTEs Step by Step English.srt15.6 KB
212 - Recursive CTEs Step by Step.mp462.9 MB
213 - Why Use Recursive CTEs English.srt7.8 KB
213 - Why Use Recursive CTEs.mp443.1 MB
214 - Writing the Query English.srt11.9 KB
214 - Writing the Query.mp436.6 MB
215 - Walking Through Recursion English.srt15.0 KB
215 - Walking Through Recursion.mp4109.4 MB
216 - Most Popular Users English.srt9.9 KB
216 - Most Popular Users.mp424.8 MB
217 - A Possible Solution for Merging Tables English.srt6.2 KB
217 - A Possible Solution for Merging Tables.mp435.7 MB
218 - Creating a View English.srt8.5 KB
218 - Creating a View.mp433.3 MB
219 - When to Use a View English.srt5.0 KB
219 - When to Use a View.mp421.2 MB
220 - Deleting and Changing Views English.srt3.7 KB
220 - Deleting and Changing Views.mp412.5 MB
221 - Materialized Views English.srt3.9 KB
221 - Materialized Views.mp48.4 MB
222 - Grouping by Week English.srt6.4 KB
222 - Grouping by Week.mp434.4 MB
223 - Reminder on Left Joins English.srt6.9 KB
223 - Reminder on Left Joins.mp415.5 MB
224 - Writing a Slow Query English.srt14.0 KB
224 - Writing a Slow Query.mp455.1 MB
225 - Creating and Refreshing Materialized Views English.srt10.0 KB
225 - Creating and Refreshing Materialized Views.mp436.1 MB
[CourseClub.Me].url122 bytes
[GigaCourse.Com].url49 bytes
26 - The Plan Moving Forward English.srt2.8 KB
26 - The Plan Moving Forward.mp410.7 MB
27 - Approaching Database Design English.srt12.1 KB
27 - Approaching Database Design.mp482.0 MB
28 - OnetoMany and ManytoOne Relationships English.srt10.1 KB
28 - OnetoMany and ManytoOne Relationships.mp441.3 MB
29 - OnetoOne and ManytoMany Relationships English.srt8.8 KB
29 - OnetoOne and ManytoMany Relationships.mp424.6 MB
30 - Primary Keys and Foreign Keys English.srt7.9 KB
30 - Primary Keys and Foreign Keys.mp429.6 MB
31 - Understanding Foreign Keys English.srt13.0 KB
31 - Understanding Foreign Keys.mp463.3 MB
32 - 007-tables-cumulative.sql172 bytes
32 - 007-tables.sql194 bytes
32 - AutoGenerated IDs English.srt8.9 KB
32 - AutoGenerated IDs.mp423.0 MB
33 - 008-tables-cumulative.sql348 bytes
33 - 008-tables.sql197 bytes
33 - Creating Foreign Key Columns English.srt7.5 KB
33 - Creating Foreign Key Columns.mp418.3 MB
34 - 009-tables-cumulative.sql536 bytes
34 - 009-tables.sql326 bytes
34 - Running Queries on Associated Data English.srt10.3 KB
34 - Running Queries on Associated Data.mp438.2 MB
35 - Exercise Overview English.srt3.4 KB
35 - Exercise Overview.mp48.3 MB
36 - Foreign Key Creation Solution English.srt3.0 KB
36 - Foreign Key Creation Solution.mp48.4 MB
37 - 012-tables-cumulative.sql600 bytes
37 - 012-tables.sql199 bytes
37 - Foreign Key Constraints Around Insertion English.srt8.8 KB
37 - Foreign Key Constraints Around Insertion.mp422.2 MB
38 - Constraints Around Deletion English.srt7.7 KB
38 - Constraints Around Deletion.mp440.5 MB
39 - Commands Youll Need for the Next Video.html691 bytes
40 - 014-tables-cumulative.sql994 bytes
40 - 014-tables.sql469 bytes
40 - Testing Deletion Constraints English.srt6.8 KB
40 - Testing Deletion Constraints.mp419.3 MB
41 - 015-tables-cumulative.sql1.3 KB
41 - 015-tables.sql340 bytes
41 - Setting Foreign Keys to Null on Delete English.srt4.4 KB
41 - Setting Foreign Keys to Null on Delete.mp412.6 MB
42 - Adding Some Complexity English.srt4.8 KB
42 - Adding Some Complexity.mp410.0 MB
226 - What are Transactions Used For English.srt6.4 KB
226 - What are Transactions Used For.mp422.5 MB
227 - Some Sample Data English.srt3.2 KB
227 - Some Sample Data.mp45.4 MB
228 - Opening and Closing Transactions English.srt15.2 KB
228 - Opening and Closing Transactions.mp465.3 MB
229 - Transaction Cleanup on Crash English.srt6.1 KB
229 - Transaction Cleanup on Crash.mp432.9 MB
230 - Closing Aborted Transactions English.srt2.8 KB
230 - Closing Aborted Transactions.mp47.5 MB
231 - A Story on Migrations English.srt27.9 KB
231 - A Story on Migrations.mp4139.7 MB
232 - Migration Files English.srt7.5 KB
232 - Migration Files.mp444.2 MB
233 - Issues Solved by Migrations English.srt4.5 KB
233 - Issues Solved by Migrations.mp410.0 MB
234 - A Few Notes on Migrations Libraries English.srt7.8 KB
234 - A Few Notes on Migrations Libraries.mp434.2 MB
235 - A Note About Node Installation.html264 bytes
236 - Project Creation English.srt4.5 KB
236 - Project Creation.mp49.9 MB
237 - Generating and Writing Migrations English.srt10.5 KB
237 - Generating and Writing Migrations.mp445.6 MB
238 - Applying and Reverting Migrations English.srt11.2 KB
238 - Applying and Reverting Migrations.mp468.1 MB
239 - Generating and Applying a Second Migration English.srt5.2 KB
239 - Generating and Applying a Second Migration.mp416.6 MB
240 - Schema vs Data Migrations English.srt6.4 KB
240 - Schema vs Data Migrations.mp420.3 MB
241 - Dangers Around Data Migrations English.srt14.5 KB
241 - Dangers Around Data Migrations.mp470.0 MB
242 - Properly Running Data and Schema Migrations English.srt8.9 KB
242 - Properly Running Data and Schema Migrations.mp419.7 MB
243 - Creating a Posts Table English.srt6.9 KB
243 - Creating a Posts Table.mp421.6 MB
244 - 005-index.js1.3 KB
244 - A Small Web Server English.srt21.0 KB
244 - A Small Web Server.mp462.3 MB
245 - Web Server Setup Instructions.html1.0 KB
246 - Adding the Loc Column English.srt6.1 KB
246 - Adding the Loc Column.mp421.6 MB
247 - Writing Values to Both Columns English.srt6.5 KB
247 - Writing Values to Both Columns.mp416.3 MB
248 - Transaction Locks English.srt22.3 KB
248 - Transaction Locks.mp496.4 MB
249 - Updating Values English.srt6.5 KB
249 - Updating Values.mp415.3 MB
250 - 01-lng-lat-to-loc.js364 bytes
250 - Migrations Setup Instructions.html925 bytes
251 - Updating the App Server English.srt6.6 KB
251 - Updating the App Server.mp413.2 MB
252 - Dropping the Last Columns English.srt4.8 KB
252 - Dropping the Last Columns.mp411.6 MB
253 - Section Goal English.srt1.5 KB
253 - Section Goal.mp42.6 MB
254 - Initial Setup English.srt2.5 KB
254 - Initial Setup.mp42.2 MB
255 - One Fast Migration English.srt7.3 KB
255 - One Fast Migration.mp424.4 MB
256 - 005-access-social-repo.zip61.3 KB
256 - Building the Users Router English.srt6.8 KB
256 - Building the Users Router.mp429.6 MB
257 - Understanding Connection Pools English.srt10.6 KB
257 - Understanding Connection Pools.mp422.9 MB
258 - Validating Connection Credentials English.srt10.6 KB
258 - Validating Connection Credentials.mp444.7 MB
259 - 008-access.zip62.0 KB
259 - Query and Close English.srt3.1 KB
259 - Query and Close.mp45.9 MB
260 - The Repository Pattern English.srt5.7 KB
260 - The Repository Pattern.mp417.9 MB
261 - 010-access.zip62.6 KB
261 - Creating a Repository English.srt12.7 KB
261 - Creating a Repository.mp424.8 MB
262 - Accessing the API English.srt6.4 KB
262 - Accessing the API.mp423.6 MB
263 - Casing Issues English.srt7.1 KB
263 - Casing Issues.mp418.6 MB
264 - Fixing Casing English.srt9.6 KB
264 - Fixing Casing.mp449.7 MB
265 - Finding Particular Users English.srt8.2 KB
265 - Finding Particular Users.mp418.2 MB
266 - SQL Injection Exploits English.srt10.8 KB
266 - SQL Injection Exploits.mp430.5 MB
267 - Handling SQL Injection with Prepared Statements English.srt12.8 KB
267 - Handling SQL Injection with Prepared Statements.mp438.1 MB
268 - Preventing SQL Injection English.srt11.6 KB
268 - Preventing SQL Injection.mp434.3 MB
269 - Reminder on Post Requests English.srt4.2 KB
269 - Reminder on Post Requests.mp414.4 MB
270 - 019-access.zip63.6 KB
270 - Inserting Users English.srt6.3 KB
270 - Inserting Users.mp415.3 MB
271 - Handling Updates English.srt6.8 KB
271 - Handling Updates.mp416.7 MB
272 - 021-access.zip63.7 KB
272 - And Finally Delete English.srt6.3 KB
272 - And Finally Delete.mp418.2 MB
273 - A Note on Testing English.srt5.0 KB
273 - A Note on Testing.mp47.6 MB
274 - Assertions Around User Count English.srt10.6 KB
274 - Assertions Around User Count.mp442.3 MB
275 - 024-access.zip64.5 KB
275 - Connecting to a DB For Tests English.srt8.2 KB
275 - Connecting to a DB For Tests.mp454.2 MB
276 - 025-access.zip64.5 KB
276 - Disconnecting After Tests English.srt4.6 KB
276 - Disconnecting After Tests.mp412.9 MB
277 - 026-access.zip64.5 KB
277 - MultiDB Setup English.srt7.5 KB
277 - MultiDB Setup.mp421.9 MB
278 - 027-access.zip64.5 KB
278 - Assumptions Around Content English.srt8.2 KB
278 - Assumptions Around Content.mp433.1 MB
279 - 028-access.zip65.8 KB
279 - Issues with Parallel Tests English.srt8.0 KB
279 - Issues with Parallel Tests.mp435.8 MB
280 - Isolation with Schemas English.srt6.6 KB
280 - Isolation with Schemas.mp427.4 MB
281 - Creating and Accessing Schemas English.srt8.0 KB
281 - Creating and Accessing Schemas.mp419.4 MB
282 - Controlling Schema Access with Search Paths English.srt8.8 KB
282 - Controlling Schema Access with Search Paths.mp430.9 MB
283 - Routing Schema Access English.srt6.6 KB
283 - Routing Schema Access.mp441.1 MB
284 - Strategy for Isolation English.srt7.2 KB
284 - Strategy for Isolation.mp417.6 MB
285 - 034-access.zip66.1 KB
285 - Programmatic Schema Creation English.srt18.2 KB
285 - Programmatic Schema Creation.mp465.8 MB
286 - 035-access.zip66.1 KB
286 - Escaping Identifiers English.srt6.4 KB
286 - Escaping Identifiers.mp425.5 MB
287 - 036-access.zip66.5 KB
287 - Test Helpers English.srt8.0 KB
287 - Test Helpers.mp443.3 MB
288 - 037-access.zip66.6 KB
288 - Cleaning up Schemas and Roles English.srt8.2 KB
288 - Cleaning up Schemas and Roles.mp431.3 MB
289 - Finally Parallel Tests Final Lecture English.srt5.3 KB
289 - Finally Parallel Tests Final Lecture.mp418.6 MB
290 - Bonus.html3.4 KB
43 - Adding Some Data.html7.7 KB
44 - Queries with Joins and Aggregations English.srt5.2 KB
44 - Queries with Joins and Aggregations.mp427.9 MB
45 - Joining Data from Different Tables English.srt11.9 KB
45 - Joining Data from Different Tables.mp436.8 MB
46 - Another Quick Join English.srt3.2 KB
46 - Another Quick Join.mp48.6 MB
47 - Exercise Overview English.srt1.8 KB
47 - Exercise Overview.mp44.8 MB
48 - A Joinful Solution English.srt2.6 KB
48 - A Joinful Solution.mp45.3 MB
49 - Alternate Forms of Syntax English.srt9.4 KB
49 - Alternate Forms of Syntax.mp425.0 MB
50 - 007-joins-cumulative.sql7.5 KB
50 - Missing Data in Joins English.srt9.8 KB
50 - Missing Data in Joins.mp429.3 MB
51 - Why Wasnt It Included English.srt3.8 KB
51 - Why Wasnt It Included.mp424.6 MB
52 - 009-joins-cheatsheet.pdf190.5 KB
52 - Four Kinds of Joins English.srt14.8 KB
52 - Four Kinds of Joins.mp4124.9 MB
53 - 010-sql-cumulative.sql7.6 KB
53 - Each Join in Practice English.srt6.3 KB
53 - Each Join in Practice.mp440.6 MB
54 - Does Order Matter English.srt6.4 KB
54 - Does Order Matter.mp461.3 MB
55 - Exercise Overview English.srt1.5 KB
55 - Exercise Overview.mp42.2 MB
56 - Two Possible Solutions English.srt4.7 KB
56 - Two Possible Solutions.mp416.5 MB
57 - Where with Join English.srt10.3 KB
57 - Where with Join.mp431.0 MB
58 - Three Way Joins English.srt12.2 KB
58 - Three Way Joins.mp449.7 MB
59 - A Bit of Practice English.srt7.7 KB
59 - A Bit of Practice.mp417.9 MB
60 - Exercise Solution English.srt4.0 KB
60 - Exercise Solution.mp47.7 MB
61 - Aggregating and Grouping English.srt3.6 KB
61 - Aggregating and Grouping.mp47.9 MB
62 - Picturing Group By English.srt8.3 KB
62 - Picturing Group By.mp429.4 MB
63 - Aggregate Functions English.srt4.5 KB
63 - Aggregate Functions.mp411.6 MB
64 - Combining Group By and Aggregates English.srt7.2 KB
64 - Combining Group By and Aggregates.mp415.1 MB
65 - A Gotcha with Count English.srt4.2 KB
65 - A Gotcha with Count.mp45.5 MB
66 - Visualizing More Grouping English.srt4.6 KB
66 - Visualizing More Grouping.mp49.7 MB
67 - Exercise Overview English.srt1.2 KB
67 - Exercise Overview.mp41.7 MB
68 - Grouping Solution English.srt2.2 KB
68 - Grouping Solution.mp43.1 MB
69 - Adding a Layer of Difficulty English.srt1.1 KB
69 - Adding a Layer of Difficulty.mp41.8 MB
70 - Solution English.srt2.2 KB
70 - Solution.mp43.7 MB
71 - Filtering Groups with Having English.srt7.8 KB
71 - Filtering Groups with Having.mp437.0 MB
72 - Having In Action English.srt4.0 KB
72 - Having In Action.mp46.9 MB
73 - More on Having English.srt10.5 KB
73 - More on Having.mp428.5 MB
74 - A Having Exercise Overview English.srt5.5 KB
74 - A Having Exercise Overview.mp412.8 MB
75 - A Quick Solution English.srt3.8 KB
75 - A Quick Solution.mp47.3 MB
76 - A New Dataset.html17.8 KB
77 - 001-sq-data.sql15.8 KB
77 - Investigating This Dataset English.srt4.1 KB
77 - Investigating This Dataset.mp48.0 MB
78 - Some Group By Practice English.srt2.0 KB
78 - Some Group By Practice.mp43.1 MB
79 - Group By Review Solution English.srt3.5 KB
79 - Group By Review Solution.mp47.9 MB
80 - Remember Joins English.srt3.6 KB
80 - Remember Joins.mp49.3 MB
81 - Of Course You Remember English.srt2.1 KB
81 - Of Course You Remember.mp44.4 MB
[CourseClub.Me].url122 bytes
[GigaCourse.Com].url49 bytes
82 - The Basics of Sorting English.srt3.6 KB
82 - The Basics of Sorting.mp46.7 MB
83 - Two Variations on Sorting English.srt4.1 KB
83 - Two Variations on Sorting.mp49.5 MB
84 - Offset and Limit English.srt10.5 KB
84 - Offset and Limit.mp419.4 MB
85 - Exercise Overview English.srt716 bytes
85 - Exercise Overview.mp41.1 MB
86 - Exercise Solution English.srt2.1 KB
86 - Exercise Solution.mp43.3 MB
87 - Handling Sets with Union English.srt8.8 KB
87 - Handling Sets with Union.mp419.5 MB
88 - A Few Notes on Union English.srt5.7 KB
88 - A Few Notes on Union.mp416.5 MB
89 - Commonalities with Intersect English.srt5.0 KB
89 - Commonalities with Intersect.mp415.4 MB
90 - Removing Commonalities with Except English.srt9.5 KB
90 - Removing Commonalities with Except.mp420.4 MB
91 - Union Exercise Overview English.srt2.3 KB
91 - Union Exercise Overview.mp44.2 MB
92 - Exercise Solution English.srt2.1 KB
92 - Exercise Solution.mp44.7 MB
100 - Example of a Subquery in a From English.srt13.7 KB
100 - Example of a Subquery in a From.mp453.5 MB
101 - Exercise Overview English.srt1.9 KB
101 - Exercise Overview.mp43.4 MB
102 - Exercise Solution English.srt2.9 KB
102 - Exercise Solution.mp410.4 MB
103 - Subqueries in a Join Clause English.srt6.8 KB
103 - Subqueries in a Join Clause.mp416.6 MB
104 - More Useful Subqueries with Where English.srt13.7 KB
104 - More Useful Subqueries with Where.mp436.7 MB
105 - Data Structure with Where Subqueries English.srt9.0 KB
105 - Data Structure with Where Subqueries.mp444.0 MB
106 - Exercise Overview English.srt1.6 KB
106 - Exercise Overview.mp42.7 MB
107 - Exercise Solution English.srt3.1 KB
107 - Exercise Solution.mp46.2 MB
108 - The Not In Operator with a List English.srt6.5 KB
108 - The Not In Operator with a List.mp438.6 MB
109 - A New Where Operator English.srt9.7 KB
109 - A New Where Operator.mp438.7 MB
110 - Finally Some English.srt8.3 KB
110 - Finally Some.mp432.0 MB
111 - Exercise Overview English.srt767 bytes
111 - Exercise Overview.mp41.2 MB
112 - A Quick Solution English.srt2.5 KB
112 - A Quick Solution.mp44.4 MB
113 - Probably Too Much About Correlated Subqueries English.srt25.3 KB
113 - Probably Too Much About Correlated Subqueries.mp4107.0 MB
114 - More on Correlated Subqueries English.srt13.1 KB
114 - More on Correlated Subqueries.mp444.2 MB
115 - A Select Without a From English.srt5.3 KB
115 - A Select Without a From.mp49.1 MB
116 - Exercise Overview English.srt1.2 KB
116 - Exercise Overview.mp42.0 MB
117 - Exercise Solution English.srt1.8 KB
117 - Exercise Solution.mp43.6 MB
93 - Whats a Subquery English.srt8.9 KB
93 - Whats a Subquery.mp430.5 MB
94 - Thinking About the Structure of Data English.srt7.6 KB
94 - Thinking About the Structure of Data.mp423.6 MB
95 - Subqueries in a Select English.srt8.5 KB
95 - Subqueries in a Select.mp422.5 MB
96 - Exercise Overview English.srt1.7 KB
96 - Exercise Overview.mp43.1 MB
97 - Select Solution English.srt1.8 KB
97 - Select Solution.mp43.8 MB
98 - Subqueries in a From English.srt12.0 KB
98 - Subqueries in a From.mp444.5 MB
99 - From Subqueries that Return a Value English.srt4.3 KB
99 - From Subqueries that Return a Value.mp49.1 MB
[CourseClub.Me].url122 bytes
[GigaCourse.Com].url49 bytes
Comments