FreeCourseSite com Udemy - SQL and PostgreSQL The Complete Developer's Guide

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