GigaCourse Com Udemy - SQL and PostgreSQL The Complete Developers Guide

1. 1 - Simple But Powerful SQL Statements/10 - Calculating Phone Revenue.mp437.26MB
2. 1 - Simple But Powerful SQL Statements/11 - Exercise Solution.mp427.92MB
3. 1 - Simple But Powerful SQL Statements/12 - String Operators and Functions.mp465.1MB
4. 1 - Simple But Powerful SQL Statements/3 - What is PostgreSQL All About.mp421.75MB
5. 1 - Simple But Powerful SQL Statements/4 - Database Design.mp435.37MB
6. 1 - Simple But Powerful SQL Statements/5 - Creating Tables.mp418.61MB
7. 1 - Simple But Powerful SQL Statements/6 - Analyzing CREATE TABLE.mp417.67MB
8. 1 - Simple But Powerful SQL Statements/7 - Inserting Data Into a Table.mp418.07MB
9. 1 - Simple But Powerful SQL Statements/8 - Retrieving Data with Select.mp46.02MB
10. 1 - Simple But Powerful SQL Statements/9 - Calculated Columns.mp415.22MB
11. 10 - Selecting Distinct Records/118 - Selecting Distinct Values.mp412.46MB
12. 10 - Selecting Distinct Records/119 - Exercise Overview.mp41.3MB
13. 10 - Selecting Distinct Records/120 - A Distinct Solution.mp41.9MB
14. 11 - Utility Operators Keywords and Functions/121 - The Greatest Value in a List.mp411.77MB
15. 11 - Utility Operators Keywords and Functions/122 - And the Least Value in a List.mp45.55MB
16. 11 - Utility Operators Keywords and Functions/123 - The Case Keyword.mp419.04MB
17. 12 - Local PostgreSQL Installation/124 - PostgreSQL Installation on macOS.mp421.13MB
18. 12 - Local PostgreSQL Installation/125 - PGAdmin Setup on macOS.mp436.92MB
19. 12 - Local PostgreSQL Installation/126 - Postgres installation on Windows.mp423.31MB
20. 13 - PostgreSQL Complex Datatypes/127 - Whatd We Just Do.mp419.32MB
21. 13 - PostgreSQL Complex Datatypes/128 - Data Types.mp430.53MB
22. 13 - PostgreSQL Complex Datatypes/129 - Fast Rules on Numeric Data Types.mp418.9MB
23. 13 - PostgreSQL Complex Datatypes/130 - More on Number Data Types.mp448.14MB
24. 13 - PostgreSQL Complex Datatypes/131 - Reminder on Character Types.mp429.9MB
25. 13 - PostgreSQL Complex Datatypes/132 - Boolean Data Types.mp48.2MB
26. 13 - PostgreSQL Complex Datatypes/133 - Times Dates and Timestamps.mp421.27MB
27. 13 - PostgreSQL Complex Datatypes/134 - Really Awesome Intervals.mp419.5MB
28. 14 - DatabaseSide Validation and Constraints/135 - Thinking About Validation.mp434.64MB
29. 14 - DatabaseSide Validation and Constraints/136 - Creating and Viewing Tables in PGAdmin.mp428.09MB
30. 14 - DatabaseSide Validation and Constraints/137 - Applying a Null Constraint.mp421.08MB
31. 14 - DatabaseSide Validation and Constraints/138 - Solving a Gotcha with Null Constraints.mp413.72MB
32. 14 - DatabaseSide Validation and Constraints/139 - Default Column Values.mp422.47MB
33. 14 - DatabaseSide Validation and Constraints/140 - Applying a Unique Constraint to One column.mp443.13MB
34. 14 - DatabaseSide Validation and Constraints/141 - MultiColumn Uniqueness.mp430.06MB
35. 14 - DatabaseSide Validation and Constraints/142 - Adding a Validation Check.mp418.21MB
36. 14 - DatabaseSide Validation and Constraints/143 - Checks Over Multiple Columns.mp417.21MB
37. 14 - DatabaseSide Validation and Constraints/144 - So Where Are We Applying Validation.mp422.04MB
38. 15 - Database Structure Design Patterns/145 - Approaching More Complicated Designs.mp411.21MB
39. 15 - Database Structure Design Patterns/146 - Using a SQL Design Tool.mp447.29MB
40. 15 - Database Structure Design Patterns/147 - A Configbased Schema Designer.mp428.69MB
41. 15 - Database Structure Design Patterns/148 - Heres the Plan.mp49.63MB
42. 15 - Database Structure Design Patterns/149 - Rebuilding Some Schema.mp420.94MB
43. 16 - How to Build a Like System/150 - Requirements of a Like System.mp426.11MB
44. 16 - How to Build a Like System/151 - How Not to Design a Like System.mp416.22MB
45. 16 - How to Build a Like System/152 - Designing a Like System.mp426.14MB
46. 16 - How to Build a Like System/153 - Making a Reaction System Instead.mp46.39MB
47. 16 - How to Build a Like System/154 - Polymorphic Associations.mp452.6MB
48. 16 - How to Build a Like System/155 - Polymorphic Association Alternative Implementation.mp463.84MB
49. 16 - How to Build a Like System/156 - The Simplest Alternative.mp426.94MB
50. 16 - How to Build a Like System/157 - So Which Approach.mp416.02MB
51. 17 - How to Build a Mention System/158 - Additional Features Around Posts.mp495.79MB
52. 17 - How to Build a Mention System/159 - Adding Captions and Locations.mp48.53MB
53. 17 - How to Build a Mention System/160 - Photo Mentions vs Caption Mentions.mp473.41MB
54. 17 - How to Build a Mention System/161 - Considerations on Photo Tags vs Caption Tags.mp467.08MB
55. 17 - How to Build a Mention System/162 - Update For Tags.mp423.42MB
56. 18 - How to Build a Hashtag System/163 - Designing a Hashtag System.mp498.12MB
57. 18 - How to Build a Hashtag System/164 - Tables for Hashtags.mp414.45MB
58. 18 - How to Build a Hashtag System/165 - Including the Hashtag Table.mp418.04MB
59. 18 - How to Build a Hashtag System/166 - A Few More User Columns.mp427.66MB
60. 18 - How to Build a Hashtag System/167 - Why No Number of Followers or Posts.mp417.1MB
61. 19 - How to Design a Follower System/168 - Designing a Follower System.mp426.49MB
62. 2 - Filtering Records/13 - Filtering Rows with Where.mp412.26MB
63. 2 - Filtering Records/14 - More on the Where Keyword.mp49.45MB
64. 2 - Filtering Records/15 - Compound Where Clauses.mp418.98MB
65. 2 - Filtering Records/16 - A Where Exercise Overview.mp41.72MB
66. 2 - Filtering Records/17 - A Where Solution.mp42.54MB
67. 2 - Filtering Records/18 - Where With Lists.mp446.05MB
68. 2 - Filtering Records/19 - A Where With Lists Solution.mp44.96MB
69. 2 - Filtering Records/20 - Calculations in Where Clauses.mp44.68MB
70. 2 - Filtering Records/21 - Solving Calculations.mp45.91MB
71. 2 - Filtering Records/22 - Updating Rows.mp432.97MB
72. 2 - Filtering Records/23 - Deleting Rows.mp411.18MB
73. 2 - Filtering Records/24 - A Solution for Updating Rows.mp44.94MB
74. 2 - Filtering Records/25 - Solution for Deleting Rows.mp44MB
75. 20 - Implementing Database Design Patterns/169 - Back to Postgres.mp46.84MB
76. 20 - Implementing Database Design Patterns/170 - Creating Tables with Checks.mp460.56MB
77. 20 - Implementing Database Design Patterns/171 - Posts Creation.mp436.16MB
78. 20 - Implementing Database Design Patterns/172 - Comments Creation.mp47.17MB
79. 20 - Implementing Database Design Patterns/173 - Likes Creation.mp423.87MB
80. 20 - Implementing Database Design Patterns/174 - Photo Tags and Caption Tags.mp441.35MB
81. 20 - Implementing Database Design Patterns/175 - Creating Hashtags Hashtag Posts and Followers.mp419.85MB
82. 21 - Approaching and Writing Complex Queries/177 - Adding Some Data.mp416.95MB
83. 21 - Approaching and Writing Complex Queries/178 - Restoring from Scratch.mp421.23MB
84. 21 - Approaching and Writing Complex Queries/179 - Highest User IDs Exercise.mp47.14MB
85. 21 - Approaching and Writing Complex Queries/180 - Solution for User IDs.mp44.64MB
86. 21 - Approaching and Writing Complex Queries/181 - Posts by a Particular User.mp44.81MB
87. 21 - Approaching and Writing Complex Queries/182 - Solving for Posts by User.mp49.39MB
88. 21 - Approaching and Writing Complex Queries/183 - Likes Per User.mp43.59MB
89. 21 - Approaching and Writing Complex Queries/184 - Solution for Likes Per User.mp46.6MB
90. 22 - Understanding the Internals of PostgreSQL/185 - Thinking About Performance.mp49.24MB
91. 22 - Understanding the Internals of PostgreSQL/186 - Where Does Postgres Store Data.mp437.02MB
92. 22 - Understanding the Internals of PostgreSQL/187 - Heaps Blocks and Tuples.mp422.73MB
93. 22 - Understanding the Internals of PostgreSQL/188 - Block Data Layout.mp417.24MB
94. 22 - Understanding the Internals of PostgreSQL/189 - Heap File Layout.mp4597.17MB
95. 23 - A Look at Indexes for Performance/190 - Full Table Scans.mp437.18MB
96. 23 - A Look at Indexes for Performance/191 - Whats an Index.mp410.1MB
97. 23 - A Look at Indexes for Performance/192 - How an Index Works.mp469.31MB
98. 23 - A Look at Indexes for Performance/193 - Creating an Index.mp413.11MB
99. 23 - A Look at Indexes for Performance/194 - Benchmarking Queries.mp422.58MB
100. 23 - A Look at Indexes for Performance/195 - Downsides of Indexes.mp431.82MB
101. 23 - A Look at Indexes for Performance/196 - Index Types.mp46.46MB
102. 23 - A Look at Indexes for Performance/197 - Automatically Generated Indexes.mp419.74MB
103. 23 - A Look at Indexes for Performance/198 - Behind the Scenes of Indexes.mp4398.75MB
104. 24 - Basic Query Tuning/199 - The Query Processing Pipeline.mp425.73MB
105. 24 - Basic Query Tuning/200 - Explain and Explain Analyze.mp442.83MB
106. 24 - Basic Query Tuning/201 - Solving an Explain Mystery.mp479.79MB
107. 25 - Advanced Query Tuning/202 - Developing an Intuitive Understanding of Cost.mp4102.89MB
108. 25 - Advanced Query Tuning/203 - Calculating Cost by Hand.mp451.25MB
109. 25 - Advanced Query Tuning/204 - A Touch More on Costs.mp495.4MB
110. 25 - Advanced Query Tuning/205 - Startup vs Total Costs.mp444.7MB
111. 25 - Advanced Query Tuning/206 - Costs Flow Up.mp410.1MB
112. 25 - Advanced Query Tuning/207 - Use My Index.mp439.4MB
113. 26 - Simple Common Table Expressions/208 - Common Table Expressions.mp411.19MB
114. 26 - Simple Common Table Expressions/209 - A Quick Solution.mp413.16MB
115. 26 - Simple Common Table Expressions/210 - So Whats a CTE.mp433.5MB
116. 27 - Recursive Common Table Expressions/211 - Recursive CTEs.mp411.9MB
117. 27 - Recursive Common Table Expressions/212 - Recursive CTEs Step by Step.mp462.89MB
118. 27 - Recursive Common Table Expressions/213 - Why Use Recursive CTEs.mp443.14MB
119. 27 - Recursive Common Table Expressions/214 - Writing the Query.mp436.56MB
120. 27 - Recursive Common Table Expressions/215 - Walking Through Recursion.mp4109.41MB
121. 28 - Simplifying Queries with Views/216 - Most Popular Users.mp424.81MB
122. 28 - Simplifying Queries with Views/217 - A Possible Solution for Merging Tables.mp435.67MB
123. 28 - Simplifying Queries with Views/218 - Creating a View.mp433.33MB
124. 28 - Simplifying Queries with Views/219 - When to Use a View.mp421.21MB
125. 28 - Simplifying Queries with Views/220 - Deleting and Changing Views.mp412.51MB
126. 29 - Optimizing Queries with Materialized Views/221 - Materialized Views.mp48.38MB
127. 29 - Optimizing Queries with Materialized Views/222 - Grouping by Week.mp434.4MB
128. 29 - Optimizing Queries with Materialized Views/223 - Reminder on Left Joins.mp415.51MB
129. 29 - Optimizing Queries with Materialized Views/224 - Writing a Slow Query.mp455.08MB
130. 29 - Optimizing Queries with Materialized Views/225 - Creating and Refreshing Materialized Views.mp436.1MB
131. 3 - Working with Tables/26 - The Plan Moving Forward.mp410.75MB
132. 3 - Working with Tables/27 - Approaching Database Design.mp481.98MB
133. 3 - Working with Tables/28 - OnetoMany and ManytoOne Relationships.mp441.31MB
134. 3 - Working with Tables/29 - OnetoOne and ManytoMany Relationships.mp424.58MB
135. 3 - Working with Tables/30 - Primary Keys and Foreign Keys.mp429.57MB
136. 3 - Working with Tables/31 - Understanding Foreign Keys.mp463.35MB
137. 3 - Working with Tables/32 - AutoGenerated IDs.mp422.97MB
138. 3 - Working with Tables/33 - Creating Foreign Key Columns.mp418.32MB
139. 3 - Working with Tables/34 - Running Queries on Associated Data.mp438.22MB
140. 3 - Working with Tables/35 - Exercise Overview.mp48.25MB
141. 3 - Working with Tables/36 - Foreign Key Creation Solution.mp48.35MB
142. 3 - Working with Tables/37 - Foreign Key Constraints Around Insertion.mp422.15MB
143. 3 - Working with Tables/38 - Constraints Around Deletion.mp440.54MB
144. 3 - Working with Tables/40 - Testing Deletion Constraints.mp419.27MB
145. 3 - Working with Tables/41 - Setting Foreign Keys to Null on Delete.mp412.6MB
146. 3 - Working with Tables/42 - Adding Some Complexity.mp49.96MB
147. 30 - Handling Concurrency and Reversibility with Transactions/226 - What are Transactions Used For.mp422.54MB
148. 30 - Handling Concurrency and Reversibility with Transactions/227 - Some Sample Data.mp45.44MB
149. 30 - Handling Concurrency and Reversibility with Transactions/228 - Opening and Closing Transactions.mp465.33MB
150. 30 - Handling Concurrency and Reversibility with Transactions/229 - Transaction Cleanup on Crash.mp432.89MB
151. 30 - Handling Concurrency and Reversibility with Transactions/230 - Closing Aborted Transactions.mp47.47MB
152. 31 - Managing Database Design with Schema Migrations/231 - A Story on Migrations.mp4139.7MB
153. 31 - Managing Database Design with Schema Migrations/232 - Migration Files.mp444.16MB
154. 31 - Managing Database Design with Schema Migrations/233 - Issues Solved by Migrations.mp410MB
155. 31 - Managing Database Design with Schema Migrations/234 - A Few Notes on Migrations Libraries.mp434.19MB
156. 31 - Managing Database Design with Schema Migrations/236 - Project Creation.mp49.91MB
157. 31 - Managing Database Design with Schema Migrations/237 - Generating and Writing Migrations.mp445.64MB
158. 31 - Managing Database Design with Schema Migrations/238 - Applying and Reverting Migrations.mp468.14MB
159. 31 - Managing Database Design with Schema Migrations/239 - Generating and Applying a Second Migration.mp416.63MB
160. 32 - Schema vs Data Migrations/240 - Schema vs Data Migrations.mp420.28MB
161. 32 - Schema vs Data Migrations/241 - Dangers Around Data Migrations.mp470MB
162. 32 - Schema vs Data Migrations/242 - Properly Running Data and Schema Migrations.mp419.73MB
163. 32 - Schema vs Data Migrations/243 - Creating a Posts Table.mp421.59MB
164. 32 - Schema vs Data Migrations/244 - A Small Web Server.mp462.26MB
165. 32 - Schema vs Data Migrations/246 - Adding the Loc Column.mp421.55MB
166. 32 - Schema vs Data Migrations/247 - Writing Values to Both Columns.mp416.26MB
167. 32 - Schema vs Data Migrations/248 - Transaction Locks.mp496.42MB
168. 32 - Schema vs Data Migrations/249 - Updating Values.mp415.27MB
169. 32 - Schema vs Data Migrations/251 - Updating the App Server.mp413.23MB
170. 32 - Schema vs Data Migrations/252 - Dropping the Last Columns.mp411.61MB
171. 33 - Accessing PostgreSQL From APIs/253 - Section Goal.mp42.62MB
172. 33 - Accessing PostgreSQL From APIs/254 - Initial Setup.mp42.23MB
173. 33 - Accessing PostgreSQL From APIs/255 - One Fast Migration.mp424.43MB
174. 33 - Accessing PostgreSQL From APIs/256 - Building the Users Router.mp429.61MB
175. 33 - Accessing PostgreSQL From APIs/257 - Understanding Connection Pools.mp422.93MB
176. 33 - Accessing PostgreSQL From APIs/258 - Validating Connection Credentials.mp444.74MB
177. 33 - Accessing PostgreSQL From APIs/259 - Query and Close.mp45.9MB
178. 34 - Data Access Pattern Repositories/260 - The Repository Pattern.mp417.88MB
179. 34 - Data Access Pattern Repositories/261 - Creating a Repository.mp424.78MB
180. 34 - Data Access Pattern Repositories/262 - Accessing the API.mp423.55MB
181. 34 - Data Access Pattern Repositories/263 - Casing Issues.mp418.55MB
182. 34 - Data Access Pattern Repositories/264 - Fixing Casing.mp449.74MB
183. 34 - Data Access Pattern Repositories/265 - Finding Particular Users.mp418.16MB
184. 35 - Security Around PostgreSQL/266 - SQL Injection Exploits.mp430.46MB
185. 35 - Security Around PostgreSQL/267 - Handling SQL Injection with Prepared Statements.mp438.15MB
186. 35 - Security Around PostgreSQL/268 - Preventing SQL Injection.mp434.29MB
187. 35 - Security Around PostgreSQL/269 - Reminder on Post Requests.mp414.4MB
188. 35 - Security Around PostgreSQL/270 - Inserting Users.mp415.25MB
189. 35 - Security Around PostgreSQL/271 - Handling Updates.mp416.66MB
190. 35 - Security Around PostgreSQL/272 - And Finally Delete.mp418.24MB
191. 36 - Fast Parallel Testing/273 - A Note on Testing.mp47.64MB
192. 36 - Fast Parallel Testing/274 - Assertions Around User Count.mp442.34MB
193. 36 - Fast Parallel Testing/275 - Connecting to a DB For Tests.mp454.23MB
194. 36 - Fast Parallel Testing/276 - Disconnecting After Tests.mp412.86MB
195. 36 - Fast Parallel Testing/277 - MultiDB Setup.mp421.85MB
196. 36 - Fast Parallel Testing/278 - Assumptions Around Content.mp433.12MB
197. 36 - Fast Parallel Testing/279 - Issues with Parallel Tests.mp435.76MB
198. 36 - Fast Parallel Testing/280 - Isolation with Schemas.mp427.4MB
199. 36 - Fast Parallel Testing/281 - Creating and Accessing Schemas.mp419.38MB
200. 36 - Fast Parallel Testing/282 - Controlling Schema Access with Search Paths.mp430.95MB
201. 36 - Fast Parallel Testing/283 - Routing Schema Access.mp441.12MB
202. 36 - Fast Parallel Testing/284 - Strategy for Isolation.mp417.57MB
203. 36 - Fast Parallel Testing/285 - Programmatic Schema Creation.mp465.75MB
204. 36 - Fast Parallel Testing/286 - Escaping Identifiers.mp425.53MB
205. 36 - Fast Parallel Testing/287 - Test Helpers.mp443.34MB
206. 36 - Fast Parallel Testing/288 - Cleaning up Schemas and Roles.mp431.28MB
207. 36 - Fast Parallel Testing/289 - Finally Parallel Tests Final Lecture.mp418.57MB
208. 4 - Relating Records with Joins/44 - Queries with Joins and Aggregations.mp427.86MB
209. 4 - Relating Records with Joins/45 - Joining Data from Different Tables.mp436.8MB
210. 4 - Relating Records with Joins/46 - Another Quick Join.mp48.62MB
211. 4 - Relating Records with Joins/47 - Exercise Overview.mp44.85MB
212. 4 - Relating Records with Joins/48 - A Joinful Solution.mp45.27MB
213. 4 - Relating Records with Joins/49 - Alternate Forms of Syntax.mp424.96MB
214. 4 - Relating Records with Joins/50 - Missing Data in Joins.mp429.27MB
215. 4 - Relating Records with Joins/51 - Why Wasnt It Included.mp424.58MB
216. 4 - Relating Records with Joins/52 - Four Kinds of Joins.mp4124.86MB
217. 4 - Relating Records with Joins/53 - Each Join in Practice.mp440.6MB
218. 4 - Relating Records with Joins/54 - Does Order Matter.mp461.33MB
219. 4 - Relating Records with Joins/55 - Exercise Overview.mp42.23MB
220. 4 - Relating Records with Joins/56 - Two Possible Solutions.mp416.51MB
221. 4 - Relating Records with Joins/57 - Where with Join.mp431.03MB
222. 4 - Relating Records with Joins/58 - Three Way Joins.mp449.71MB
223. 4 - Relating Records with Joins/59 - A Bit of Practice.mp417.87MB
224. 4 - Relating Records with Joins/60 - Exercise Solution.mp47.67MB
225. 5 - Aggregation of Records/61 - Aggregating and Grouping.mp47.9MB
226. 5 - Aggregation of Records/62 - Picturing Group By.mp429.43MB
227. 5 - Aggregation of Records/63 - Aggregate Functions.mp411.58MB
228. 5 - Aggregation of Records/64 - Combining Group By and Aggregates.mp415.13MB
229. 5 - Aggregation of Records/65 - A Gotcha with Count.mp45.46MB
230. 5 - Aggregation of Records/66 - Visualizing More Grouping.mp49.72MB
231. 5 - Aggregation of Records/67 - Exercise Overview.mp41.66MB
232. 5 - Aggregation of Records/68 - Grouping Solution.mp43.15MB
233. 5 - Aggregation of Records/69 - Adding a Layer of Difficulty.mp41.79MB
234. 5 - Aggregation of Records/70 - Solution.mp43.68MB
235. 5 - Aggregation of Records/71 - Filtering Groups with Having.mp436.97MB
236. 5 - Aggregation of Records/72 - Having In Action.mp46.86MB
237. 5 - Aggregation of Records/73 - More on Having.mp428.46MB
238. 5 - Aggregation of Records/74 - A Having Exercise Overview.mp412.79MB
239. 5 - Aggregation of Records/75 - A Quick Solution.mp47.3MB
240. 6 - Working with Large Datasets/77 - Investigating This Dataset.mp48MB
241. 6 - Working with Large Datasets/78 - Some Group By Practice.mp43.1MB
242. 6 - Working with Large Datasets/79 - Group By Review Solution.mp47.92MB
243. 6 - Working with Large Datasets/80 - Remember Joins.mp49.3MB
244. 6 - Working with Large Datasets/81 - Of Course You Remember.mp44.42MB
245. 7 - Sorting Records/82 - The Basics of Sorting.mp46.73MB
246. 7 - Sorting Records/83 - Two Variations on Sorting.mp49.46MB
247. 7 - Sorting Records/84 - Offset and Limit.mp419.43MB
248. 7 - Sorting Records/85 - Exercise Overview.mp41.08MB
249. 7 - Sorting Records/86 - Exercise Solution.mp43.33MB
250. 8 - Unions and Intersections with Sets/87 - Handling Sets with Union.mp419.51MB
251. 8 - Unions and Intersections with Sets/88 - A Few Notes on Union.mp416.54MB
252. 8 - Unions and Intersections with Sets/89 - Commonalities with Intersect.mp415.42MB
253. 8 - Unions and Intersections with Sets/90 - Removing Commonalities with Except.mp420.44MB
254. 8 - Unions and Intersections with Sets/91 - Union Exercise Overview.mp44.23MB
255. 8 - Unions and Intersections with Sets/92 - Exercise Solution.mp44.72MB
256. 9 - Assembling Queries with SubQueries/100 - Example of a Subquery in a From.mp453.51MB
257. 9 - Assembling Queries with SubQueries/101 - Exercise Overview.mp43.4MB
258. 9 - Assembling Queries with SubQueries/102 - Exercise Solution.mp410.37MB
259. 9 - Assembling Queries with SubQueries/103 - Subqueries in a Join Clause.mp416.55MB
260. 9 - Assembling Queries with SubQueries/104 - More Useful Subqueries with Where.mp436.66MB
261. 9 - Assembling Queries with SubQueries/105 - Data Structure with Where Subqueries.mp444.04MB
262. 9 - Assembling Queries with SubQueries/106 - Exercise Overview.mp42.71MB
263. 9 - Assembling Queries with SubQueries/107 - Exercise Solution.mp46.25MB
264. 9 - Assembling Queries with SubQueries/108 - The Not In Operator with a List.mp438.59MB
265. 9 - Assembling Queries with SubQueries/109 - A New Where Operator.mp438.71MB
266. 9 - Assembling Queries with SubQueries/110 - Finally Some.mp431.96MB
267. 9 - Assembling Queries with SubQueries/111 - Exercise Overview.mp41.23MB
268. 9 - Assembling Queries with SubQueries/112 - A Quick Solution.mp44.37MB
269. 9 - Assembling Queries with SubQueries/113 - Probably Too Much About Correlated Subqueries.mp4107MB
270. 9 - Assembling Queries with SubQueries/114 - More on Correlated Subqueries.mp444.16MB
271. 9 - Assembling Queries with SubQueries/115 - A Select Without a From.mp49.09MB
272. 9 - Assembling Queries with SubQueries/116 - Exercise Overview.mp41.95MB
273. 9 - Assembling Queries with SubQueries/117 - Exercise Solution.mp43.57MB
274. 9 - Assembling Queries with SubQueries/93 - Whats a Subquery.mp430.54MB
275. 9 - Assembling Queries with SubQueries/94 - Thinking About the Structure of Data.mp423.64MB
276. 9 - Assembling Queries with SubQueries/95 - Subqueries in a Select.mp422.54MB
277. 9 - Assembling Queries with SubQueries/96 - Exercise Overview.mp43.05MB
278. 9 - Assembling Queries with SubQueries/97 - Select Solution.mp43.8MB
279. 9 - Assembling Queries with SubQueries/98 - Subqueries in a From.mp444.45MB
280. 9 - Assembling Queries with SubQueries/99 - From Subqueries that Return a Value.mp49.08MB