GigaCourse Com Udemy SQL and PostgreSQL The Complete Developers Guide

GigaCourse Com Udemy SQL and PostgreSQL The Complete Developers Guide

Name	[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developers Guide	DOWNLOAD Copy Link
Total Size	8.7 GB
Total Files	626
Last Seen	2024-07-08 23:41
Hash	544A0911C985F10FC0171663FE086177C3B67276

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1 - Simple But Powerful SQL Statements/
1 - Join Our Community.html	0.3 KB
10 - Calculating Phone Revenue English.srt	1.6 KB
10 - Calculating Phone Revenue.mp4	39.1 MB
11 - Exercise Solution English.srt	1.7 KB
11 - Exercise Solution.mp4	29.3 MB
12 - 012-sql.sql	0.4 KB
12 - String Operators and Functions English.srt	10.1 KB
12 - String Operators and Functions.mp4	68.3 MB
2 - Course Resources.html	1.3 KB
2 - diagrams.zip	8.1 MB
3 - What is PostgreSQL All About English.srt	7.6 KB
3 - What is PostgreSQL All About.mp4	22.8 MB
4 - Database Design English.srt	8.4 KB
4 - Database Design.mp4	37.1 MB
5 - 003-sql.sql	0.1 KB
5 - Creating Tables English.srt	7.9 KB
5 - Creating Tables.mp4	19.5 MB
6 - Analyzing CREATE TABLE English.srt	5.6 KB
6 - Analyzing CREATE TABLE.mp4	18.5 MB
7 - 005-sql-cumulative.sql	0.4 KB
7 - 005-sql.sql	0.3 KB
7 - Inserting Data Into a Table English.srt	7.8 KB
7 - Inserting Data Into a Table.mp4	18.9 MB
8 - Retrieving Data with Select English.srt	3.4 KB
8 - Retrieving Data with Select.mp4	6.3 MB
9 - Calculated Columns English.srt	7.5 KB
9 - Calculated Columns.mp4	16.0 MB
/10 - Selecting Distinct Records/
118 - Selecting Distinct Values English.srt	6.7 KB
118 - Selecting Distinct Values.mp4	13.1 MB
119 - Exercise Overview English.srt	0.9 KB
119 - Exercise Overview.mp4	1.4 MB
120 - A Distinct Solution English.srt	1.0 KB
120 - A Distinct Solution.mp4	2.0 MB
/11 - Utility Operators Keywords and Functions/
121 - The Greatest Value in a List English.srt	5.2 KB
121 - The Greatest Value in a List.mp4	12.3 MB
122 - And the Least Value in a List English.srt	3.1 KB
122 - And the Least Value in a List.mp4	5.8 MB
123 - The Case Keyword English.srt	6.9 KB
123 - The Case Keyword.mp4	20.0 MB
/12 - Local PostgreSQL Installation/
124 - PostgreSQL Installation on macOS English.srt	10.2 KB
124 - PostgreSQL Installation on macOS.mp4	22.2 MB
125 - PGAdmin Setup on macOS English.srt	7.9 KB
125 - PGAdmin Setup on macOS.mp4	38.7 MB
126 - Postgres installation on Windows English.srt	6.8 KB
126 - Postgres installation on Windows.mp4	24.4 MB
/13 - PostgreSQL Complex Datatypes/
127 - Whatd We Just Do English.srt	6.7 KB
127 - Whatd We Just Do.mp4	20.3 MB
128 - Data Types English.srt	7.4 KB
128 - Data Types.mp4	32.0 MB
129 - Fast Rules on Numeric Data Types English.srt	3.7 KB
129 - Fast Rules on Numeric Data Types.mp4	19.8 MB
130 - More on Number Data Types English.srt	15.1 KB
130 - More on Number Data Types.mp4	50.5 MB
131 - Reminder on Character Types English.srt	7.7 KB
131 - Reminder on Character Types.mp4	31.4 MB
132 - Boolean Data Types English.srt	4.0 KB
132 - Boolean Data Types.mp4	8.6 MB
133 - Times Dates and Timestamps English.srt	8.6 KB
133 - Times Dates and Timestamps.mp4	22.3 MB
134 - Really Awesome Intervals English.srt	9.3 KB
134 - Really Awesome Intervals.mp4	20.4 MB
/14 - DatabaseSide Validation and Constraints/
135 - Thinking About Validation English.srt	7.0 KB
135 - Thinking About Validation.mp4	36.3 MB
136 - Creating and Viewing Tables in PGAdmin English.srt	11.8 KB
136 - Creating and Viewing Tables in PGAdmin.mp4	29.5 MB
137 - Applying a Null Constraint English.srt	10.5 KB
137 - Applying a Null Constraint.mp4	22.1 MB
138 - Solving a Gotcha with Null Constraints English.srt	6.6 KB
138 - Solving a Gotcha with Null Constraints.mp4	14.4 MB
139 - Default Column Values English.srt	5.5 KB
139 - Default Column Values.mp4	23.6 MB
140 - Applying a Unique Constraint to One column English.srt	9.1 KB
140 - Applying a Unique Constraint to One column.mp4	45.2 MB
141 - MultiColumn Uniqueness English.srt	5.4 KB
141 - MultiColumn Uniqueness.mp4	31.5 MB
142 - Adding a Validation Check English.srt	6.3 KB
142 - Adding a Validation Check.mp4	19.1 MB
143 - Checks Over Multiple Columns English.srt	7.8 KB
143 - Checks Over Multiple Columns.mp4	18.0 MB
144 - So Where Are We Applying Validation English.srt	10.1 KB
144 - So Where Are We Applying Validation.mp4	23.1 MB
/15 - Database Structure Design Patterns/
145 - Approaching More Complicated Designs English.srt	5.6 KB
145 - Approaching More Complicated Designs.mp4	11.8 MB
146 - Using a SQL Design Tool English.srt	10.2 KB
146 - Using a SQL Design Tool.mp4	49.6 MB
147 - A Configbased Schema Designer English.srt	12.1 KB
147 - A Configbased Schema Designer.mp4	30.1 MB
148 - Heres the Plan English.srt	4.4 KB
148 - Heres the Plan.mp4	10.1 MB
149 - 005-design.dbml	0.5 KB
149 - Rebuilding Some Schema English.srt	10.9 KB
149 - Rebuilding Some Schema.mp4	22.0 MB
/16 - How to Build a Like System/
150 - Requirements of a Like System English.srt	7.9 KB
150 - Requirements of a Like System.mp4	27.4 MB
151 - How Not to Design a Like System English.srt	5.0 KB
151 - How Not to Design a Like System.mp4	17.0 MB
152 - Designing a Like System English.srt	8.5 KB
152 - Designing a Like System.mp4	27.4 MB
153 - Making a Reaction System Instead English.srt	2.6 KB
153 - Making a Reaction System Instead.mp4	6.7 MB
154 - Polymorphic Associations English.srt	9.9 KB
154 - Polymorphic Associations.mp4	55.2 MB
155 - Polymorphic Association Alternative Implementation English.srt	11.2 KB
155 - Polymorphic Association Alternative Implementation.mp4	66.9 MB
156 - The Simplest Alternative English.srt	6.3 KB
156 - The Simplest Alternative.mp4	28.2 MB
157 - So Which Approach English.srt	7.2 KB
157 - So Which Approach.mp4	16.8 MB
/17 - How to Build a Mention System/
158 - Additional Features Around Posts English.srt	10.3 KB
158 - Additional Features Around Posts.mp4	100.4 MB
159 - Adding Captions and Locations English.srt	2.7 KB
159 - Adding Captions and Locations.mp4	8.9 MB
160 - Photo Mentions vs Caption Mentions English.srt	13.0 KB
160 - Photo Mentions vs Caption Mentions.mp4	77.0 MB
161 - Considerations on Photo Tags vs Caption Tags English.srt	11.9 KB
161 - Considerations on Photo Tags vs Caption Tags.mp4	70.3 MB
162 - Update For Tags English.srt	7.6 KB
162 - Update For Tags.mp4	24.6 MB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/18 - How to Build a Hashtag System/
163 - Designing a Hashtag System English.srt	12.2 KB
163 - Designing a Hashtag System.mp4	102.9 MB
164 - Tables for Hashtags English.srt	5.9 KB
164 - Tables for Hashtags.mp4	15.2 MB
165 - Including the Hashtag Table English.srt	6.1 KB
165 - Including the Hashtag Table.mp4	18.9 MB
166 - A Few More User Columns English.srt	10.1 KB
166 - A Few More User Columns.mp4	29.0 MB
167 - Why No Number of Followers or Posts English.srt	6.2 KB
167 - Why No Number of Followers or Posts.mp4	17.9 MB
/19 - How to Design a Follower System/
168 - Designing a Follower System English.srt	9.4 KB
168 - Designing a Follower System.mp4	27.8 MB
/2 - Filtering Records/
13 - 013-sql.sql	0.0 KB
13 - Filtering Rows with Where English.srt	5.9 KB
13 - Filtering Rows with Where.mp4	12.9 MB
14 - More on the Where Keyword English.srt	4.0 KB
14 - More on the Where Keyword.mp4	9.9 MB
15 - Compound Where Clauses English.srt	7.8 KB
15 - Compound Where Clauses.mp4	19.9 MB
16 - A Where Exercise Overview English.srt	1.0 KB
16 - A Where Exercise Overview.mp4	1.8 MB
17 - A Where Solution English.srt	1.4 KB
17 - A Where Solution.mp4	2.7 MB
18 - Where With Lists English.srt	1.1 KB
18 - Where With Lists.mp4	48.3 MB
19 - A Where With Lists Solution English.srt	2.4 KB
19 - A Where With Lists Solution.mp4	5.2 MB
20 - Calculations in Where Clauses English.srt	3.2 KB
20 - Calculations in Where Clauses.mp4	4.9 MB
21 - Solving Calculations English.srt	3.1 KB
21 - Solving Calculations.mp4	6.2 MB
22 - Updating Rows English.srt	6.6 KB
22 - Updating Rows.mp4	34.6 MB
23 - Deleting Rows English.srt	5.1 KB
23 - Deleting Rows.mp4	11.7 MB
24 - A Solution for Updating Rows English.srt	2.3 KB
24 - A Solution for Updating Rows.mp4	5.2 MB
25 - Solution for Deleting Rows English.srt	2.1 KB
25 - Solution for Deleting Rows.mp4	4.2 MB
/20 - Implementing Database Design Patterns/
169 - Back to Postgres English.srt	3.4 KB
169 - Back to Postgres.mp4	7.2 MB
170 - 002-db.sql	0.4 KB
170 - Creating Tables with Checks English.srt	21.5 KB
170 - Creating Tables with Checks.mp4	63.5 MB
171 - 003-db.sql	0.8 KB
171 - Posts Creation English.srt	13.1 KB
171 - Posts Creation.mp4	37.9 MB
172 - 004-db.sql	1.1 KB
172 - Comments Creation English.srt	3.6 KB
172 - Comments Creation.mp4	7.5 MB
173 - 005-db.sql	1.6 KB
173 - Likes Creation English.srt	10.3 KB
173 - Likes Creation.mp4	25.0 MB
174 - 006-db.sql	2.2 KB
174 - Photo Tags and Caption Tags English.srt	8.5 KB
174 - Photo Tags and Caption Tags.mp4	43.4 MB
175 - 007-db.sql	2.9 KB
175 - Creating Hashtags Hashtag Posts and Followers English.srt	9.3 KB
175 - Creating Hashtags Hashtag Posts and Followers.mp4	20.8 MB
/21 - Approaching and Writing Complex Queries/
176 - Quick Note About Adding Some Data.html	0.3 KB
176 - ig.sql	24.7 MB
177 - Adding Some Data English.srt	6.8 KB
177 - Adding Some Data.mp4	17.8 MB
178 - Restoring from Scratch English.srt	7.2 KB
178 - Restoring from Scratch.mp4	22.3 MB
179 - Highest User IDs Exercise English.srt	3.2 KB
179 - Highest User IDs Exercise.mp4	7.5 MB
180 - Solution for User IDs English.srt	1.9 KB
180 - Solution for User IDs.mp4	4.9 MB
181 - Posts by a Particular User English.srt	1.8 KB
181 - Posts by a Particular User.mp4	5.0 MB
182 - Solving for Posts by User English.srt	2.9 KB
182 - Solving for Posts by User.mp4	9.8 MB
183 - Likes Per User English.srt	1.4 KB
183 - Likes Per User.mp4	3.8 MB
184 - Solution for Likes Per User English.srt	2.6 KB
184 - Solution for Likes Per User.mp4	6.9 MB
/22 - Understanding the Internals of PostgreSQL/
185 - Thinking About Performance English.srt	3.8 KB
185 - Thinking About Performance.mp4	9.7 MB
186 - Where Does Postgres Store Data English.srt	9.1 KB
186 - Where Does Postgres Store Data.mp4	38.8 MB
187 - Heaps Blocks and Tuples English.srt	5.9 KB
187 - Heaps Blocks and Tuples.mp4	23.8 MB
188 - Block Data Layout English.srt	7.1 KB
188 - Block Data Layout.mp4	18.1 MB
189 - Heap File Layout English.srt	50.9 KB
189 - Heap File Layout.mp4	626.2 MB
/23 - A Look at Indexes for Performance/
190 - Full Table Scans English.srt	6.7 KB
190 - Full Table Scans.mp4	39.0 MB
191 - Whats an Index English.srt	4.1 KB
191 - Whats an Index.mp4	10.6 MB
192 - How an Index Works English.srt	12.6 KB
192 - How an Index Works.mp4	72.7 MB
193 - Creating an Index English.srt	6.4 KB
193 - Creating an Index.mp4	13.8 MB
194 - Benchmarking Queries English.srt	8.7 KB
194 - Benchmarking Queries.mp4	23.7 MB
195 - Downsides of Indexes English.srt	8.4 KB
195 - Downsides of Indexes.mp4	33.4 MB
196 - Index Types English.srt	2.6 KB
196 - Index Types.mp4	6.8 MB
197 - Automatically Generated Indexes English.srt	5.9 KB
197 - Automatically Generated Indexes.mp4	20.7 MB
198 - Behind the Scenes of Indexes English.srt	50.1 KB
198 - Behind the Scenes of Indexes.mp4	418.1 MB
/24 - Basic Query Tuning/
199 - The Query Processing Pipeline English.srt	8.4 KB
199 - The Query Processing Pipeline.mp4	27.0 MB
200 - Explain and Explain Analyze English.srt	8.6 KB
200 - Explain and Explain Analyze.mp4	44.9 MB
201 - Solving an Explain Mystery English.srt	14.4 KB
201 - Solving an Explain Mystery.mp4	83.7 MB
/25 - Advanced Query Tuning/
202 - Developing an Intuitive Understanding of Cost English.srt	20.9 KB
202 - Developing an Intuitive Understanding of Cost.mp4	107.9 MB
203 - Calculating Cost by Hand English.srt	10.4 KB
203 - Calculating Cost by Hand.mp4	53.7 MB
204 - A Touch More on Costs English.srt	11.8 KB
204 - A Touch More on Costs.mp4	100.0 MB
205 - Startup vs Total Costs English.srt	9.3 KB
205 - Startup vs Total Costs.mp4	46.9 MB
206 - Costs Flow Up English.srt	3.2 KB
206 - Costs Flow Up.mp4	10.6 MB
207 - Use My Index English.srt	13.1 KB
207 - Use My Index.mp4	41.3 MB
/26 - Simple Common Table Expressions/
208 - Common Table Expressions English.srt	3.0 KB
208 - Common Table Expressions.mp4	11.7 MB
209 - A Quick Solution English.srt	5.8 KB
209 - A Quick Solution.mp4	13.8 MB
210 - So Whats a CTE English.srt	5.9 KB
210 - So Whats a CTE.mp4	35.1 MB
/27 - Recursive Common Table Expressions/
211 - Recursive CTEs English.srt	5.2 KB
211 - Recursive CTEs.mp4	12.5 MB
212 - Recursive CTEs Step by Step English.srt	15.9 KB
212 - Recursive CTEs Step by Step.mp4	65.9 MB
213 - Why Use Recursive CTEs English.srt	8.0 KB
213 - Why Use Recursive CTEs.mp4	45.2 MB
214 - Writing the Query English.srt	12.2 KB
214 - Writing the Query.mp4	38.3 MB
215 - Walking Through Recursion English.srt	15.4 KB
215 - Walking Through Recursion.mp4	114.7 MB
/28 - Simplifying Queries with Views/
216 - Most Popular Users English.srt	10.1 KB
216 - Most Popular Users.mp4	26.0 MB
217 - A Possible Solution for Merging Tables English.srt	6.4 KB
217 - A Possible Solution for Merging Tables.mp4	37.4 MB
218 - Creating a View English.srt	8.7 KB
218 - Creating a View.mp4	35.0 MB
219 - When to Use a View English.srt	5.1 KB
219 - When to Use a View.mp4	22.2 MB
220 - Deleting and Changing Views English.srt	3.8 KB
220 - Deleting and Changing Views.mp4	13.1 MB
/29 - Optimizing Queries with Materialized Views/
221 - Materialized Views English.srt	4.0 KB
221 - Materialized Views.mp4	8.8 MB
222 - Grouping by Week English.srt	6.5 KB
222 - Grouping by Week.mp4	36.1 MB
223 - Reminder on Left Joins English.srt	7.1 KB
223 - Reminder on Left Joins.mp4	16.3 MB
224 - Writing a Slow Query English.srt	14.3 KB
224 - Writing a Slow Query.mp4	57.8 MB
225 - Creating and Refreshing Materialized Views English.srt	10.3 KB
225 - Creating and Refreshing Materialized Views.mp4	37.9 MB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/3 - Working with Tables/
26 - The Plan Moving Forward English.srt	2.9 KB
26 - The Plan Moving Forward.mp4	11.3 MB
27 - Approaching Database Design English.srt	12.4 KB
27 - Approaching Database Design.mp4	86.0 MB
28 - OnetoMany and ManytoOne Relationships English.srt	10.3 KB
28 - OnetoMany and ManytoOne Relationships.mp4	43.3 MB
29 - OnetoOne and ManytoMany Relationships English.srt	9.0 KB
29 - OnetoOne and ManytoMany Relationships.mp4	25.8 MB
30 - Primary Keys and Foreign Keys English.srt	8.1 KB
30 - Primary Keys and Foreign Keys.mp4	31.0 MB
31 - Understanding Foreign Keys English.srt	13.3 KB
31 - Understanding Foreign Keys.mp4	66.4 MB
32 - 007-tables-cumulative.sql	0.2 KB
32 - 007-tables.sql	0.2 KB
32 - AutoGenerated IDs English.srt	9.2 KB
32 - AutoGenerated IDs.mp4	24.1 MB
33 - 008-tables-cumulative.sql	0.3 KB
33 - 008-tables.sql	0.2 KB
33 - Creating Foreign Key Columns English.srt	7.7 KB
33 - Creating Foreign Key Columns.mp4	19.2 MB
34 - 009-tables-cumulative.sql	0.5 KB
34 - 009-tables.sql	0.3 KB
34 - Running Queries on Associated Data English.srt	10.6 KB
34 - Running Queries on Associated Data.mp4	40.1 MB
35 - Exercise Overview English.srt	3.5 KB
35 - Exercise Overview.mp4	8.7 MB
36 - Foreign Key Creation Solution English.srt	3.1 KB
36 - Foreign Key Creation Solution.mp4	8.8 MB
37 - 012-tables-cumulative.sql	0.6 KB
37 - 012-tables.sql	0.2 KB
37 - Foreign Key Constraints Around Insertion English.srt	9.0 KB
37 - Foreign Key Constraints Around Insertion.mp4	23.2 MB
38 - Constraints Around Deletion English.srt	7.9 KB
38 - Constraints Around Deletion.mp4	42.5 MB
39 - Commands Youll Need for the Next Video.html	0.7 KB
40 - 014-tables-cumulative.sql	1.0 KB
40 - 014-tables.sql	0.5 KB
40 - Testing Deletion Constraints English.srt	6.9 KB
40 - Testing Deletion Constraints.mp4	20.2 MB
41 - 015-tables-cumulative.sql	1.3 KB
41 - 015-tables.sql	0.3 KB
41 - Setting Foreign Keys to Null on Delete English.srt	4.5 KB
41 - Setting Foreign Keys to Null on Delete.mp4	13.2 MB
42 - Adding Some Complexity English.srt	4.9 KB
42 - Adding Some Complexity.mp4	10.4 MB
/30 - Handling Concurrency and Reversibility with Transactions/
226 - What are Transactions Used For English.srt	6.6 KB
226 - What are Transactions Used For.mp4	23.6 MB
227 - Some Sample Data English.srt	3.2 KB
227 - Some Sample Data.mp4	5.7 MB
228 - Opening and Closing Transactions English.srt	15.5 KB
228 - Opening and Closing Transactions.mp4	68.5 MB
229 - Transaction Cleanup on Crash English.srt	6.3 KB
229 - Transaction Cleanup on Crash.mp4	34.5 MB
230 - Closing Aborted Transactions English.srt	2.8 KB
230 - Closing Aborted Transactions.mp4	7.8 MB
/31 - Managing Database Design with Schema Migrations/
231 - A Story on Migrations English.srt	28.6 KB
231 - A Story on Migrations.mp4	146.5 MB
232 - Migration Files English.srt	7.7 KB
232 - Migration Files.mp4	46.3 MB
233 - Issues Solved by Migrations English.srt	4.6 KB
233 - Issues Solved by Migrations.mp4	10.5 MB
234 - A Few Notes on Migrations Libraries English.srt	8.0 KB
234 - A Few Notes on Migrations Libraries.mp4	35.8 MB
235 - A Note About Node Installation.html	0.3 KB
236 - Project Creation English.srt	4.6 KB
236 - Project Creation.mp4	10.4 MB
237 - Generating and Writing Migrations English.srt	10.8 KB
237 - Generating and Writing Migrations.mp4	47.9 MB
238 - Applying and Reverting Migrations English.srt	11.5 KB
238 - Applying and Reverting Migrations.mp4	71.4 MB
239 - Generating and Applying a Second Migration English.srt	5.3 KB
239 - Generating and Applying a Second Migration.mp4	17.4 MB
/32 - Schema vs Data Migrations/
240 - Schema vs Data Migrations English.srt	6.6 KB
240 - Schema vs Data Migrations.mp4	21.3 MB
241 - Dangers Around Data Migrations English.srt	14.9 KB
241 - Dangers Around Data Migrations.mp4	73.4 MB
242 - Properly Running Data and Schema Migrations English.srt	9.1 KB
242 - Properly Running Data and Schema Migrations.mp4	20.7 MB
243 - Creating a Posts Table English.srt	7.0 KB
243 - Creating a Posts Table.mp4	22.6 MB
244 - 005-index.js	1.3 KB
244 - A Small Web Server English.srt	21.5 KB
244 - A Small Web Server.mp4	65.3 MB
245 - Web Server Setup Instructions.html	1.0 KB
246 - Adding the Loc Column English.srt	6.2 KB
246 - Adding the Loc Column.mp4	22.6 MB
247 - Writing Values to Both Columns English.srt	6.6 KB
247 - Writing Values to Both Columns.mp4	17.1 MB
248 - Transaction Locks English.srt	22.8 KB
248 - Transaction Locks.mp4	101.1 MB
249 - Updating Values English.srt	6.6 KB
249 - Updating Values.mp4	16.0 MB
250 - 01-lng-lat-to-loc.js	0.4 KB
250 - Migrations Setup Instructions.html	0.9 KB
251 - Updating the App Server English.srt	6.8 KB
251 - Updating the App Server.mp4	13.9 MB
252 - Dropping the Last Columns English.srt	4.9 KB
252 - Dropping the Last Columns.mp4	12.2 MB
/33 - Accessing PostgreSQL From APIs/
253 - Section Goal English.srt	1.6 KB
253 - Section Goal.mp4	2.7 MB
254 - Initial Setup English.srt	2.6 KB
254 - Initial Setup.mp4	2.3 MB
255 - One Fast Migration English.srt	7.5 KB
255 - One Fast Migration.mp4	25.6 MB
256 - 005-access-social-repo.zip	62.8 KB
256 - Building the Users Router English.srt	7.0 KB
256 - Building the Users Router.mp4	31.0 MB
257 - Understanding Connection Pools English.srt	10.9 KB
257 - Understanding Connection Pools.mp4	24.0 MB
258 - Validating Connection Credentials English.srt	10.9 KB
258 - Validating Connection Credentials.mp4	46.9 MB
259 - 008-access.zip	63.5 KB
259 - Query and Close English.srt	3.2 KB
259 - Query and Close.mp4	6.2 MB
/34 - Data Access Pattern Repositories/
260 - The Repository Pattern English.srt	5.8 KB
260 - The Repository Pattern.mp4	18.7 MB
261 - 010-access.zip	64.1 KB
261 - Creating a Repository English.srt	13.0 KB
261 - Creating a Repository.mp4	26.0 MB
262 - Accessing the API English.srt	6.6 KB
262 - Accessing the API.mp4	24.7 MB
263 - Casing Issues English.srt	7.2 KB
263 - Casing Issues.mp4	19.5 MB
264 - Fixing Casing English.srt	9.8 KB
264 - Fixing Casing.mp4	52.2 MB
265 - Finding Particular Users English.srt	8.4 KB
265 - Finding Particular Users.mp4	19.0 MB
/35 - Security Around PostgreSQL/
266 - SQL Injection Exploits English.srt	11.1 KB
266 - SQL Injection Exploits.mp4	31.9 MB
267 - Handling SQL Injection with Prepared Statements English.srt	13.1 KB
267 - Handling SQL Injection with Prepared Statements.mp4	40.0 MB
268 - Preventing SQL Injection English.srt	11.9 KB
268 - Preventing SQL Injection.mp4	36.0 MB
269 - Reminder on Post Requests English.srt	4.3 KB
269 - Reminder on Post Requests.mp4	15.1 MB
270 - 019-access.zip	65.1 KB
270 - Inserting Users English.srt	6.4 KB
270 - Inserting Users.mp4	16.0 MB
271 - Handling Updates English.srt	7.0 KB
271 - Handling Updates.mp4	17.5 MB
272 - 021-access.zip	65.2 KB
272 - And Finally Delete English.srt	6.5 KB
272 - And Finally Delete.mp4	19.1 MB
/36 - Fast Parallel Testing/
273 - A Note on Testing English.srt	5.1 KB
273 - A Note on Testing.mp4	8.0 MB
274 - Assertions Around User Count English.srt	10.9 KB
274 - Assertions Around User Count.mp4	44.4 MB
275 - 024-access.zip	66.0 KB
275 - Connecting to a DB For Tests English.srt	8.4 KB
275 - Connecting to a DB For Tests.mp4	56.9 MB
276 - 025-access.zip	66.1 KB
276 - Disconnecting After Tests English.srt	4.7 KB
276 - Disconnecting After Tests.mp4	13.5 MB
277 - 026-access.zip	66.1 KB
277 - MultiDB Setup English.srt	7.7 KB
277 - MultiDB Setup.mp4	22.9 MB
278 - 027-access.zip	66.1 KB
278 - Assumptions Around Content English.srt	8.4 KB
278 - Assumptions Around Content.mp4	34.7 MB
279 - 028-access.zip	67.4 KB
279 - Issues with Parallel Tests English.srt	8.1 KB
279 - Issues with Parallel Tests.mp4	37.5 MB
280 - Isolation with Schemas English.srt	6.7 KB
280 - Isolation with Schemas.mp4	28.7 MB
281 - Creating and Accessing Schemas English.srt	8.2 KB
281 - Creating and Accessing Schemas.mp4	20.3 MB
282 - Controlling Schema Access with Search Paths English.srt	9.0 KB
282 - Controlling Schema Access with Search Paths.mp4	32.4 MB
283 - Routing Schema Access English.srt	6.8 KB
283 - Routing Schema Access.mp4	43.1 MB
284 - Strategy for Isolation English.srt	7.4 KB
284 - Strategy for Isolation.mp4	18.4 MB
285 - 034-access.zip	67.7 KB
285 - Programmatic Schema Creation English.srt	18.7 KB
285 - Programmatic Schema Creation.mp4	68.9 MB
286 - 035-access.zip	67.7 KB
286 - Escaping Identifiers English.srt	6.6 KB
286 - Escaping Identifiers.mp4	26.8 MB
287 - 036-access.zip	68.1 KB
287 - Test Helpers English.srt	8.2 KB
287 - Test Helpers.mp4	45.5 MB
288 - 037-access.zip	68.2 KB
288 - Cleaning up Schemas and Roles English.srt	8.4 KB
288 - Cleaning up Schemas and Roles.mp4	32.8 MB
289 - Finally Parallel Tests Final Lecture English.srt	5.4 KB
289 - Finally Parallel Tests Final Lecture.mp4	19.5 MB
/37 - Bonus/
290 - Bonus.html	3.5 KB
/4 - Relating Records with Joins/
43 - Adding Some Data.html	7.8 KB
44 - Queries with Joins and Aggregations English.srt	5.3 KB
44 - Queries with Joins and Aggregations.mp4	29.2 MB
45 - Joining Data from Different Tables English.srt	12.1 KB
45 - Joining Data from Different Tables.mp4	38.6 MB
46 - Another Quick Join English.srt	3.3 KB
46 - Another Quick Join.mp4	9.0 MB
47 - Exercise Overview English.srt	1.8 KB
47 - Exercise Overview.mp4	5.1 MB
48 - A Joinful Solution English.srt	2.6 KB
48 - A Joinful Solution.mp4	5.5 MB
49 - Alternate Forms of Syntax English.srt	9.6 KB
49 - Alternate Forms of Syntax.mp4	26.2 MB
50 - 007-joins-cumulative.sql	7.7 KB
50 - Missing Data in Joins English.srt	10.1 KB
50 - Missing Data in Joins.mp4	30.7 MB
51 - Why Wasnt It Included English.srt	3.9 KB
51 - Why Wasnt It Included.mp4	25.8 MB
52 - 009-joins-cheatsheet.pdf	195.1 KB
52 - Four Kinds of Joins English.srt	15.2 KB
52 - Four Kinds of Joins.mp4	130.9 MB
53 - 010-sql-cumulative.sql	7.8 KB
53 - Each Join in Practice English.srt	6.4 KB
53 - Each Join in Practice.mp4	42.6 MB
54 - Does Order Matter English.srt	6.6 KB
54 - Does Order Matter.mp4	64.3 MB
55 - Exercise Overview English.srt	1.5 KB
55 - Exercise Overview.mp4	2.3 MB
56 - Two Possible Solutions English.srt	4.9 KB
56 - Two Possible Solutions.mp4	17.3 MB
57 - Where with Join English.srt	10.6 KB
57 - Where with Join.mp4	32.5 MB
58 - Three Way Joins English.srt	12.5 KB
58 - Three Way Joins.mp4	52.1 MB
59 - A Bit of Practice English.srt	7.9 KB
59 - A Bit of Practice.mp4	18.7 MB
60 - Exercise Solution English.srt	4.1 KB
60 - Exercise Solution.mp4	8.0 MB
/5 - Aggregation of Records/
61 - Aggregating and Grouping English.srt	3.6 KB
61 - Aggregating and Grouping.mp4	8.3 MB
62 - Picturing Group By English.srt	8.5 KB
62 - Picturing Group By.mp4	30.9 MB
63 - Aggregate Functions English.srt	4.7 KB
63 - Aggregate Functions.mp4	12.1 MB
64 - Combining Group By and Aggregates English.srt	7.4 KB
64 - Combining Group By and Aggregates.mp4	15.9 MB
65 - A Gotcha with Count English.srt	4.3 KB
65 - A Gotcha with Count.mp4	5.7 MB
66 - Visualizing More Grouping English.srt	4.7 KB
66 - Visualizing More Grouping.mp4	10.2 MB
67 - Exercise Overview English.srt	1.2 KB
67 - Exercise Overview.mp4	1.7 MB
68 - Grouping Solution English.srt	2.2 KB
68 - Grouping Solution.mp4	3.3 MB
69 - Adding a Layer of Difficulty English.srt	1.1 KB
69 - Adding a Layer of Difficulty.mp4	1.9 MB
70 - Solution English.srt	2.3 KB
70 - Solution.mp4	3.9 MB
71 - Filtering Groups with Having English.srt	8.0 KB
71 - Filtering Groups with Having.mp4	38.8 MB
72 - Having In Action English.srt	4.1 KB
72 - Having In Action.mp4	7.2 MB
73 - More on Having English.srt	10.7 KB
73 - More on Having.mp4	29.8 MB
74 - A Having Exercise Overview English.srt	5.6 KB
74 - A Having Exercise Overview.mp4	13.4 MB
75 - A Quick Solution English.srt	3.9 KB
75 - A Quick Solution.mp4	7.7 MB
/6 - Working with Large Datasets/
76 - A New Dataset.html	18.3 KB
77 - 001-sq-data.sql	16.2 KB
77 - Investigating This Dataset English.srt	4.2 KB
77 - Investigating This Dataset.mp4	8.4 MB
78 - Some Group By Practice English.srt	2.1 KB
78 - Some Group By Practice.mp4	3.3 MB
79 - Group By Review Solution English.srt	3.6 KB
79 - Group By Review Solution.mp4	8.3 MB
80 - Remember Joins English.srt	3.6 KB
80 - Remember Joins.mp4	9.8 MB
81 - Of Course You Remember English.srt	2.2 KB
81 - Of Course You Remember.mp4	4.6 MB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/7 - Sorting Records/
82 - The Basics of Sorting English.srt	3.7 KB
82 - The Basics of Sorting.mp4	7.1 MB
83 - Two Variations on Sorting English.srt	4.2 KB
83 - Two Variations on Sorting.mp4	9.9 MB
84 - Offset and Limit English.srt	10.7 KB
84 - Offset and Limit.mp4	20.4 MB
85 - Exercise Overview English.srt	0.7 KB
85 - Exercise Overview.mp4	1.1 MB
86 - Exercise Solution English.srt	2.1 KB
86 - Exercise Solution.mp4	3.5 MB
/8 - Unions and Intersections with Sets/
87 - Handling Sets with Union English.srt	9.0 KB
87 - Handling Sets with Union.mp4	20.5 MB
88 - A Few Notes on Union English.srt	5.8 KB
88 - A Few Notes on Union.mp4	17.3 MB
89 - Commonalities with Intersect English.srt	5.2 KB
89 - Commonalities with Intersect.mp4	16.2 MB
90 - Removing Commonalities with Except English.srt	9.7 KB
90 - Removing Commonalities with Except.mp4	21.4 MB
91 - Union Exercise Overview English.srt	2.3 KB
91 - Union Exercise Overview.mp4	4.4 MB
92 - Exercise Solution English.srt	2.1 KB
92 - Exercise Solution.mp4	4.9 MB
/9 - Assembling Queries with SubQueries/
100 - Example of a Subquery in a From English.srt	14.1 KB
100 - Example of a Subquery in a From.mp4	56.1 MB
101 - Exercise Overview English.srt	1.9 KB
101 - Exercise Overview.mp4	3.6 MB
102 - Exercise Solution English.srt	2.9 KB
102 - Exercise Solution.mp4	10.9 MB
103 - Subqueries in a Join Clause English.srt	7.0 KB
103 - Subqueries in a Join Clause.mp4	17.4 MB
104 - More Useful Subqueries with Where English.srt	14.0 KB
104 - More Useful Subqueries with Where.mp4	38.4 MB
105 - Data Structure with Where Subqueries English.srt	9.2 KB
105 - Data Structure with Where Subqueries.mp4	46.2 MB
106 - Exercise Overview English.srt	1.6 KB
106 - Exercise Overview.mp4	2.8 MB
107 - Exercise Solution English.srt	3.2 KB
107 - Exercise Solution.mp4	6.5 MB
108 - The Not In Operator with a List English.srt	6.6 KB
108 - The Not In Operator with a List.mp4	40.5 MB
109 - A New Where Operator English.srt	9.9 KB
109 - A New Where Operator.mp4	40.6 MB
110 - Finally Some English.srt	8.5 KB
110 - Finally Some.mp4	33.5 MB
111 - Exercise Overview English.srt	0.8 KB
111 - Exercise Overview.mp4	1.3 MB
112 - A Quick Solution English.srt	2.5 KB
112 - A Quick Solution.mp4	4.6 MB
113 - Probably Too Much About Correlated Subqueries English.srt	25.9 KB
113 - Probably Too Much About Correlated Subqueries.mp4	112.2 MB
114 - More on Correlated Subqueries English.srt	13.4 KB
114 - More on Correlated Subqueries.mp4	46.3 MB
115 - A Select Without a From English.srt	5.5 KB
115 - A Select Without a From.mp4	9.5 MB
116 - Exercise Overview English.srt	1.3 KB
116 - Exercise Overview.mp4	2.0 MB
117 - Exercise Solution English.srt	1.8 KB
117 - Exercise Solution.mp4	3.7 MB
93 - Whats a Subquery English.srt	9.1 KB
93 - Whats a Subquery.mp4	32.0 MB
94 - Thinking About the Structure of Data English.srt	7.8 KB
94 - Thinking About the Structure of Data.mp4	24.8 MB
95 - Subqueries in a Select English.srt	8.7 KB
95 - Subqueries in a Select.mp4	23.6 MB
96 - Exercise Overview English.srt	1.8 KB
96 - Exercise Overview.mp4	3.2 MB
97 - Select Solution English.srt	1.9 KB
97 - Select Solution.mp4	4.0 MB
98 - Subqueries in a From English.srt	12.3 KB
98 - Subqueries in a From.mp4	46.6 MB
99 - From Subqueries that Return a Value English.srt	4.4 KB
99 - From Subqueries that Return a Value.mp4	9.5 MB
/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
Total files 626