:Search:

Udemy SQL and PostgreSQL The Complete Developer s Guide Giga Course

Torrent:
Info Hash: 544A0911C985F10FC0171663FE086177C3B67276
Similar Posts:
Uploader: CourseClub
Source: 1 Logo 1337x
Downloads: 558
Type: Tutorials
Language: English
Category: Other
Size: 8.1 GB
Added: Oct. 22, 2023, 6:50 a.m.
Peers: Seeders: 5, Leechers: 2 (Last updated: 10 months, 4 weeks ago)
Tracker Data:
Tracker Seeders Leechers Completed
udp://open.stealth.si:80/announce 0 0 18
udp://exodus.desync.com:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.cyberia.is:6969/announce 0 0 2
udp://tracker.opentrackr.org:1337/announce 4 1 489
udp://tracker.torrent.eu.org:451/announce 0 0 0
udp://explodie.org:6969/announce 0 0 0
udp://tracker.birkenwald.de:6969/announce 0 1 0
udp://tracker.moeking.me:6969/announce (Failed to scrape UDP tracker) 0 0 0
udp://ipv4.tracker.harry.lu:80/announce (Failed to scrape UDP tracker) 0 0 0
udp://tracker.tiny-vps.com:6969/announce 1 0 49
udp://tracker.therarbg.to:6969/announce 0 0 0
Files:
  1. [CourseClub.Me].url 122 bytes
  2. [GigaCourse.Com].url 49 bytes
  3. 1 - Join Our Community.html 318 bytes
  4. 10 - Calculating Phone Revenue English.srt 1.6 KB
  5. 10 - Calculating Phone Revenue.mp4 37.3 MB
  6. 11 - Exercise Solution English.srt 1.6 KB
  7. 11 - Exercise Solution.mp4 27.9 MB
  8. 12 - 012-sql.sql 404 bytes
  9. 12 - String Operators and Functions English.srt 9.9 KB
  10. 12 - String Operators and Functions.mp4 65.1 MB
  11. 2 - Course Resources.html 1.2 KB
  12. 2 - diagrams.zip 7.7 MB
  13. 3 - What is PostgreSQL All About English.srt 7.4 KB
  14. 3 - What is PostgreSQL All About.mp4 21.7 MB
  15. 4 - Database Design English.srt 8.2 KB
  16. 4 - Database Design.mp4 35.4 MB
  17. 5 - 003-sql.sql 104 bytes
  18. 5 - Creating Tables English.srt 7.7 KB
  19. 5 - Creating Tables.mp4 18.6 MB
  20. 6 - Analyzing CREATE TABLE English.srt 5.5 KB
  21. 6 - Analyzing CREATE TABLE.mp4 17.7 MB
  22. 7 - 005-sql-cumulative.sql 384 bytes
  23. 7 - 005-sql.sql 278 bytes
  24. 7 - Inserting Data Into a Table English.srt 7.6 KB
  25. 7 - Inserting Data Into a Table.mp4 18.1 MB
  26. 8 - Retrieving Data with Select English.srt 3.3 KB
  27. 8 - Retrieving Data with Select.mp4 6.0 MB
  28. 9 - Calculated Columns English.srt 7.3 KB
  29. 9 - Calculated Columns.mp4 15.2 MB
  30. 118 - Selecting Distinct Values English.srt 6.5 KB
  31. 118 - Selecting Distinct Values.mp4 12.5 MB
  32. 119 - Exercise Overview English.srt 906 bytes
  33. 119 - Exercise Overview.mp4 1.3 MB
  34. 120 - A Distinct Solution English.srt 964 bytes
  35. 120 - A Distinct Solution.mp4 1.9 MB
  36. 121 - The Greatest Value in a List English.srt 5.1 KB
  37. 121 - The Greatest Value in a List.mp4 11.8 MB
  38. 122 - And the Least Value in a List English.srt 3.0 KB
  39. 122 - And the Least Value in a List.mp4 5.5 MB
  40. 123 - The Case Keyword English.srt 6.7 KB
  41. 123 - The Case Keyword.mp4 19.0 MB
  42. 124 - PostgreSQL Installation on macOS English.srt 10.0 KB
  43. 124 - PostgreSQL Installation on macOS.mp4 21.1 MB
  44. 125 - PGAdmin Setup on macOS English.srt 7.8 KB
  45. 125 - PGAdmin Setup on macOS.mp4 36.9 MB
  46. 126 - Postgres installation on Windows English.srt 6.6 KB
  47. 126 - Postgres installation on Windows.mp4 23.3 MB
  48. 127 - Whatd We Just Do English.srt 6.5 KB
  49. 127 - Whatd We Just Do.mp4 19.3 MB
  50. 128 - Data Types English.srt 7.2 KB
  51. 128 - Data Types.mp4 30.5 MB
  52. 129 - Fast Rules on Numeric Data Types English.srt 3.6 KB
  53. 129 - Fast Rules on Numeric Data Types.mp4 18.9 MB
  54. 130 - More on Number Data Types English.srt 14.8 KB
  55. 130 - More on Number Data Types.mp4 48.1 MB
  56. 131 - Reminder on Character Types English.srt 7.5 KB
  57. 131 - Reminder on Character Types.mp4 29.9 MB
  58. 132 - Boolean Data Types English.srt 3.9 KB
  59. 132 - Boolean Data Types.mp4 8.2 MB
  60. 133 - Times Dates and Timestamps English.srt 8.4 KB
  61. 133 - Times Dates and Timestamps.mp4 21.3 MB
  62. 134 - Really Awesome Intervals English.srt 9.1 KB
  63. 134 - Really Awesome Intervals.mp4 19.5 MB
  64. 135 - Thinking About Validation English.srt 6.9 KB
  65. 135 - Thinking About Validation.mp4 34.6 MB
  66. 136 - Creating and Viewing Tables in PGAdmin English.srt 11.6 KB
  67. 136 - Creating and Viewing Tables in PGAdmin.mp4 28.1 MB
  68. 137 - Applying a Null Constraint English.srt 10.3 KB
  69. 137 - Applying a Null Constraint.mp4 21.1 MB
  70. 138 - Solving a Gotcha with Null Constraints English.srt 6.5 KB
  71. 138 - Solving a Gotcha with Null Constraints.mp4 13.7 MB
  72. 139 - Default Column Values English.srt 5.3 KB
  73. 139 - Default Column Values.mp4 22.5 MB
  74. 140 - Applying a Unique Constraint to One column English.srt 8.9 KB
  75. 140 - Applying a Unique Constraint to One column.mp4 43.1 MB
  76. 141 - MultiColumn Uniqueness English.srt 5.2 KB
  77. 141 - MultiColumn Uniqueness.mp4 30.1 MB
  78. 142 - Adding a Validation Check English.srt 6.1 KB
  79. 142 - Adding a Validation Check.mp4 18.2 MB
  80. 143 - Checks Over Multiple Columns English.srt 7.6 KB
  81. 143 - Checks Over Multiple Columns.mp4 17.2 MB
  82. 144 - So Where Are We Applying Validation English.srt 9.9 KB
  83. 144 - So Where Are We Applying Validation.mp4 22.0 MB
  84. 145 - Approaching More Complicated Designs English.srt 5.5 KB
  85. 145 - Approaching More Complicated Designs.mp4 11.2 MB
  86. 146 - Using a SQL Design Tool English.srt 9.9 KB
  87. 146 - Using a SQL Design Tool.mp4 47.3 MB
  88. 147 - A Configbased Schema Designer English.srt 11.8 KB
  89. 147 - A Configbased Schema Designer.mp4 28.7 MB
  90. 148 - Heres the Plan English.srt 4.3 KB
  91. 148 - Heres the Plan.mp4 9.6 MB
  92. 149 - 005-design.dbml 455 bytes
  93. 149 - Rebuilding Some Schema English.srt 10.6 KB
  94. 149 - Rebuilding Some Schema.mp4 20.9 MB
  95. 150 - Requirements of a Like System English.srt 7.7 KB
  96. 150 - Requirements of a Like System.mp4 26.1 MB
  97. 151 - How Not to Design a Like System English.srt 4.8 KB
  98. 151 - How Not to Design a Like System.mp4 16.2 MB
  99. 152 - Designing a Like System English.srt 8.3 KB
  100. 152 - Designing a Like System.mp4 26.1 MB
  101. 153 - Making a Reaction System Instead English.srt 2.5 KB
  102. 153 - Making a Reaction System Instead.mp4 6.4 MB
  103. 154 - Polymorphic Associations English.srt 9.7 KB
  104. 154 - Polymorphic Associations.mp4 52.6 MB
  105. 155 - Polymorphic Association Alternative Implementation English.srt 10.9 KB
  106. 155 - Polymorphic Association Alternative Implementation.mp4 63.8 MB
  107. 156 - The Simplest Alternative English.srt 6.1 KB
  108. 156 - The Simplest Alternative.mp4 26.9 MB
  109. 157 - So Which Approach English.srt 7.0 KB
  110. 157 - So Which Approach.mp4 16.0 MB
  111. 158 - Additional Features Around Posts English.srt 10.1 KB
  112. 158 - Additional Features Around Posts.mp4 95.8 MB
  113. 159 - Adding Captions and Locations English.srt 2.6 KB
  114. 159 - Adding Captions and Locations.mp4 8.5 MB
  115. 160 - Photo Mentions vs Caption Mentions English.srt 12.7 KB
  116. 160 - Photo Mentions vs Caption Mentions.mp4 73.4 MB
  117. 161 - Considerations on Photo Tags vs Caption Tags English.srt 11.7 KB
  118. 161 - Considerations on Photo Tags vs Caption Tags.mp4 67.1 MB
  119. 162 - Update For Tags English.srt 7.4 KB
  120. 162 - Update For Tags.mp4 23.4 MB
  121. [CourseClub.Me].url 122 bytes
  122. [GigaCourse.Com].url 49 bytes
  123. 163 - Designing a Hashtag System English.srt 12.0 KB
  124. 163 - Designing a Hashtag System.mp4 98.1 MB
  125. 164 - Tables for Hashtags English.srt 5.8 KB
  126. 164 - Tables for Hashtags.mp4 14.5 MB
  127. 165 - Including the Hashtag Table English.srt 5.9 KB
  128. 165 - Including the Hashtag Table.mp4 18.0 MB
  129. 166 - A Few More User Columns English.srt 9.8 KB
  130. 166 - A Few More User Columns.mp4 27.7 MB
  131. 167 - Why No Number of Followers or Posts English.srt 6.1 KB
  132. 167 - Why No Number of Followers or Posts.mp4 17.1 MB
  133. 168 - Designing a Follower System English.srt 9.2 KB
  134. 168 - Designing a Follower System.mp4 26.5 MB
  135. 13 - 013-sql.sql 48 bytes
  136. 13 - Filtering Rows with Where English.srt 5.8 KB
  137. 13 - Filtering Rows with Where.mp4 12.3 MB
  138. 14 - More on the Where Keyword English.srt 3.9 KB
  139. 14 - More on the Where Keyword.mp4 9.4 MB
  140. 15 - Compound Where Clauses English.srt 7.6 KB
  141. 15 - Compound Where Clauses.mp4 19.0 MB
  142. 16 - A Where Exercise Overview English.srt 992 bytes
  143. 16 - A Where Exercise Overview.mp4 1.7 MB
  144. 17 - A Where Solution English.srt 1.4 KB
  145. 17 - A Where Solution.mp4 2.5 MB
  146. 18 - Where With Lists English.srt 1.1 KB
  147. 18 - Where With Lists.mp4 46.1 MB
  148. 19 - A Where With Lists Solution English.srt 2.4 KB
  149. 19 - A Where With Lists Solution.mp4 5.0 MB
  150. 20 - Calculations in Where Clauses English.srt 3.1 KB
  151. 20 - Calculations in Where Clauses.mp4 4.7 MB
  152. 21 - Solving Calculations English.srt 3.0 KB
  153. 21 - Solving Calculations.mp4 5.9 MB
  154. 22 - Updating Rows English.srt 6.5 KB
  155. 22 - Updating Rows.mp4 33.0 MB
  156. 23 - Deleting Rows English.srt 5.0 KB
  157. 23 - Deleting Rows.mp4 11.2 MB
  158. 24 - A Solution for Updating Rows English.srt 2.2 KB
  159. 24 - A Solution for Updating Rows.mp4 4.9 MB
  160. 25 - Solution for Deleting Rows English.srt 2.0 KB
  161. 25 - Solution for Deleting Rows.mp4 4.0 MB
  162. 169 - Back to Postgres English.srt 3.3 KB
  163. 169 - Back to Postgres.mp4 6.8 MB
  164. 170 - 002-db.sql 375 bytes
  165. 170 - Creating Tables with Checks English.srt 21.0 KB
  166. 170 - Creating Tables with Checks.mp4 60.6 MB
  167. 171 - 003-db.sql 791 bytes
  168. 171 - Posts Creation English.srt 12.8 KB
  169. 171 - Posts Creation.mp4 36.2 MB
  170. 172 - 004-db.sql 1.1 KB
  171. 172 - Comments Creation English.srt 3.5 KB
  172. 172 - Comments Creation.mp4 7.2 MB
  173. 173 - 005-db.sql 1.5 KB
  174. 173 - Likes Creation English.srt 10.0 KB
  175. 173 - Likes Creation.mp4 23.9 MB
  176. 174 - 006-db.sql 2.2 KB
  177. 174 - Photo Tags and Caption Tags English.srt 8.3 KB
  178. 174 - Photo Tags and Caption Tags.mp4 41.3 MB
  179. 175 - 007-db.sql 2.8 KB
  180. 175 - Creating Hashtags Hashtag Posts and Followers English.srt 9.1 KB
  181. 175 - Creating Hashtags Hashtag Posts and Followers.mp4 19.8 MB
  182. 176 - Quick Note About Adding Some Data.html 251 bytes
  183. 176 - ig.sql 23.5 MB
  184. 177 - Adding Some Data English.srt 6.6 KB
  185. 177 - Adding Some Data.mp4 16.9 MB
  186. 178 - Restoring from Scratch English.srt 7.0 KB
  187. 178 - Restoring from Scratch.mp4 21.2 MB
  188. 179 - Highest User IDs Exercise English.srt 3.1 KB
  189. 179 - Highest User IDs Exercise.mp4 7.1 MB
  190. 180 - Solution for User IDs English.srt 1.8 KB
  191. 180 - Solution for User IDs.mp4 4.6 MB
  192. 181 - Posts by a Particular User English.srt 1.8 KB
  193. 181 - Posts by a Particular User.mp4 4.8 MB
  194. 182 - Solving for Posts by User English.srt 2.8 KB
  195. 182 - Solving for Posts by User.mp4 9.4 MB
  196. 183 - Likes Per User English.srt 1.3 KB
  197. 183 - Likes Per User.mp4 3.6 MB
  198. 184 - Solution for Likes Per User English.srt 2.5 KB
  199. 184 - Solution for Likes Per User.mp4 6.6 MB
  200. 185 - Thinking About Performance English.srt 3.7 KB
  201. 185 - Thinking About Performance.mp4 9.2 MB
  202. 186 - Where Does Postgres Store Data English.srt 8.9 KB
  203. 186 - Where Does Postgres Store Data.mp4 37.0 MB
  204. 187 - Heaps Blocks and Tuples English.srt 5.8 KB
  205. 187 - Heaps Blocks and Tuples.mp4 22.7 MB
  206. 188 - Block Data Layout English.srt 6.9 KB
  207. 188 - Block Data Layout.mp4 17.2 MB
  208. 189 - Heap File Layout English.srt 49.7 KB
  209. 189 - Heap File Layout.mp4 597.2 MB
  210. 190 - Full Table Scans English.srt 6.5 KB
  211. 190 - Full Table Scans.mp4 37.2 MB
  212. 191 - Whats an Index English.srt 4.0 KB
  213. 191 - Whats an Index.mp4 10.1 MB
  214. 192 - How an Index Works English.srt 12.3 KB
  215. 192 - How an Index Works.mp4 69.3 MB
  216. 193 - Creating an Index English.srt 6.3 KB
  217. 193 - Creating an Index.mp4 13.1 MB
  218. 194 - Benchmarking Queries English.srt 8.5 KB
  219. 194 - Benchmarking Queries.mp4 22.6 MB
  220. 195 - Downsides of Indexes English.srt 8.2 KB
  221. 195 - Downsides of Indexes.mp4 31.8 MB
  222. 196 - Index Types English.srt 2.6 KB
  223. 196 - Index Types.mp4 6.5 MB
  224. 197 - Automatically Generated Indexes English.srt 5.8 KB
  225. 197 - Automatically Generated Indexes.mp4 19.7 MB
  226. 198 - Behind the Scenes of Indexes English.srt 48.9 KB
  227. 198 - Behind the Scenes of Indexes.mp4 398.8 MB
  228. 199 - The Query Processing Pipeline English.srt 8.2 KB
  229. 199 - The Query Processing Pipeline.mp4 25.7 MB
  230. 200 - Explain and Explain Analyze English.srt 8.4 KB
  231. 200 - Explain and Explain Analyze.mp4 42.8 MB
  232. 201 - Solving an Explain Mystery English.srt 14.0 KB
  233. 201 - Solving an Explain Mystery.mp4 79.8 MB
  234. 202 - Developing an Intuitive Understanding of Cost English.srt 20.4 KB
  235. 202 - Developing an Intuitive Understanding of Cost.mp4 102.9 MB
  236. 203 - Calculating Cost by Hand English.srt 10.1 KB
  237. 203 - Calculating Cost by Hand.mp4 51.2 MB
  238. 204 - A Touch More on Costs English.srt 11.5 KB
  239. 204 - A Touch More on Costs.mp4 95.4 MB
  240. 205 - Startup vs Total Costs English.srt 9.1 KB
  241. 205 - Startup vs Total Costs.mp4 44.7 MB
  242. 206 - Costs Flow Up English.srt 3.1 KB
  243. 206 - Costs Flow Up.mp4 10.1 MB
  244. 207 - Use My Index English.srt 12.8 KB
  245. 207 - Use My Index.mp4 39.4 MB
  246. 208 - Common Table Expressions English.srt 3.0 KB
  247. 208 - Common Table Expressions.mp4 11.2 MB
  248. 209 - A Quick Solution English.srt 5.6 KB
  249. 209 - A Quick Solution.mp4 13.2 MB
  250. 210 - So Whats a CTE English.srt 5.8 KB
  251. 210 - So Whats a CTE.mp4 33.5 MB
  252. 211 - Recursive CTEs English.srt 5.1 KB
  253. 211 - Recursive CTEs.mp4 11.9 MB
  254. 212 - Recursive CTEs Step by Step English.srt 15.6 KB
  255. 212 - Recursive CTEs Step by Step.mp4 62.9 MB
  256. 213 - Why Use Recursive CTEs English.srt 7.8 KB
  257. 213 - Why Use Recursive CTEs.mp4 43.1 MB
  258. 214 - Writing the Query English.srt 11.9 KB
  259. 214 - Writing the Query.mp4 36.6 MB
  260. 215 - Walking Through Recursion English.srt 15.0 KB
  261. 215 - Walking Through Recursion.mp4 109.4 MB
  262. 216 - Most Popular Users English.srt 9.9 KB
  263. 216 - Most Popular Users.mp4 24.8 MB
  264. 217 - A Possible Solution for Merging Tables English.srt 6.2 KB
  265. 217 - A Possible Solution for Merging Tables.mp4 35.7 MB
  266. 218 - Creating a View English.srt 8.5 KB
  267. 218 - Creating a View.mp4 33.3 MB
  268. 219 - When to Use a View English.srt 5.0 KB
  269. 219 - When to Use a View.mp4 21.2 MB
  270. 220 - Deleting and Changing Views English.srt 3.7 KB
  271. 220 - Deleting and Changing Views.mp4 12.5 MB
  272. 221 - Materialized Views English.srt 3.9 KB
  273. 221 - Materialized Views.mp4 8.4 MB
  274. 222 - Grouping by Week English.srt 6.4 KB
  275. 222 - Grouping by Week.mp4 34.4 MB
  276. 223 - Reminder on Left Joins English.srt 6.9 KB
  277. 223 - Reminder on Left Joins.mp4 15.5 MB
  278. 224 - Writing a Slow Query English.srt 14.0 KB
  279. 224 - Writing a Slow Query.mp4 55.1 MB
  280. 225 - Creating and Refreshing Materialized Views English.srt 10.0 KB
  281. 225 - Creating and Refreshing Materialized Views.mp4 36.1 MB
  282. [CourseClub.Me].url 122 bytes
  283. [GigaCourse.Com].url 49 bytes
  284. 26 - The Plan Moving Forward English.srt 2.8 KB
  285. 26 - The Plan Moving Forward.mp4 10.7 MB
  286. 27 - Approaching Database Design English.srt 12.1 KB
  287. 27 - Approaching Database Design.mp4 82.0 MB
  288. 28 - OnetoMany and ManytoOne Relationships English.srt 10.1 KB
  289. 28 - OnetoMany and ManytoOne Relationships.mp4 41.3 MB
  290. 29 - OnetoOne and ManytoMany Relationships English.srt 8.8 KB
  291. 29 - OnetoOne and ManytoMany Relationships.mp4 24.6 MB
  292. 30 - Primary Keys and Foreign Keys English.srt 7.9 KB
  293. 30 - Primary Keys and Foreign Keys.mp4 29.6 MB
  294. 31 - Understanding Foreign Keys English.srt 13.0 KB
  295. 31 - Understanding Foreign Keys.mp4 63.3 MB
  296. 32 - 007-tables-cumulative.sql 172 bytes
  297. 32 - 007-tables.sql 194 bytes
  298. 32 - AutoGenerated IDs English.srt 8.9 KB
  299. 32 - AutoGenerated IDs.mp4 23.0 MB
  300. 33 - 008-tables-cumulative.sql 348 bytes
  301. 33 - 008-tables.sql 197 bytes
  302. 33 - Creating Foreign Key Columns English.srt 7.5 KB
  303. 33 - Creating Foreign Key Columns.mp4 18.3 MB
  304. 34 - 009-tables-cumulative.sql 536 bytes
  305. 34 - 009-tables.sql 326 bytes
  306. 34 - Running Queries on Associated Data English.srt 10.3 KB
  307. 34 - Running Queries on Associated Data.mp4 38.2 MB
  308. 35 - Exercise Overview English.srt 3.4 KB
  309. 35 - Exercise Overview.mp4 8.3 MB
  310. 36 - Foreign Key Creation Solution English.srt 3.0 KB
  311. 36 - Foreign Key Creation Solution.mp4 8.4 MB
  312. 37 - 012-tables-cumulative.sql 600 bytes
  313. 37 - 012-tables.sql 199 bytes
  314. 37 - Foreign Key Constraints Around Insertion English.srt 8.8 KB
  315. 37 - Foreign Key Constraints Around Insertion.mp4 22.2 MB
  316. 38 - Constraints Around Deletion English.srt 7.7 KB
  317. 38 - Constraints Around Deletion.mp4 40.5 MB
  318. 39 - Commands Youll Need for the Next Video.html 691 bytes
  319. 40 - 014-tables-cumulative.sql 994 bytes
  320. 40 - 014-tables.sql 469 bytes
  321. 40 - Testing Deletion Constraints English.srt 6.8 KB
  322. 40 - Testing Deletion Constraints.mp4 19.3 MB
  323. 41 - 015-tables-cumulative.sql 1.3 KB
  324. 41 - 015-tables.sql 340 bytes
  325. 41 - Setting Foreign Keys to Null on Delete English.srt 4.4 KB
  326. 41 - Setting Foreign Keys to Null on Delete.mp4 12.6 MB
  327. 42 - Adding Some Complexity English.srt 4.8 KB
  328. 42 - Adding Some Complexity.mp4 10.0 MB
  329. 226 - What are Transactions Used For English.srt 6.4 KB
  330. 226 - What are Transactions Used For.mp4 22.5 MB
  331. 227 - Some Sample Data English.srt 3.2 KB
  332. 227 - Some Sample Data.mp4 5.4 MB
  333. 228 - Opening and Closing Transactions English.srt 15.2 KB
  334. 228 - Opening and Closing Transactions.mp4 65.3 MB
  335. 229 - Transaction Cleanup on Crash English.srt 6.1 KB
  336. 229 - Transaction Cleanup on Crash.mp4 32.9 MB
  337. 230 - Closing Aborted Transactions English.srt 2.8 KB
  338. 230 - Closing Aborted Transactions.mp4 7.5 MB
  339. 231 - A Story on Migrations English.srt 27.9 KB
  340. 231 - A Story on Migrations.mp4 139.7 MB
  341. 232 - Migration Files English.srt 7.5 KB
  342. 232 - Migration Files.mp4 44.2 MB
  343. 233 - Issues Solved by Migrations English.srt 4.5 KB
  344. 233 - Issues Solved by Migrations.mp4 10.0 MB
  345. 234 - A Few Notes on Migrations Libraries English.srt 7.8 KB
  346. 234 - A Few Notes on Migrations Libraries.mp4 34.2 MB
  347. 235 - A Note About Node Installation.html 264 bytes
  348. 236 - Project Creation English.srt 4.5 KB
  349. 236 - Project Creation.mp4 9.9 MB
  350. 237 - Generating and Writing Migrations English.srt 10.5 KB
  351. 237 - Generating and Writing Migrations.mp4 45.6 MB
  352. 238 - Applying and Reverting Migrations English.srt 11.2 KB
  353. 238 - Applying and Reverting Migrations.mp4 68.1 MB
  354. 239 - Generating and Applying a Second Migration English.srt 5.2 KB
  355. 239 - Generating and Applying a Second Migration.mp4 16.6 MB
  356. 240 - Schema vs Data Migrations English.srt 6.4 KB
  357. 240 - Schema vs Data Migrations.mp4 20.3 MB
  358. 241 - Dangers Around Data Migrations English.srt 14.5 KB
  359. 241 - Dangers Around Data Migrations.mp4 70.0 MB
  360. 242 - Properly Running Data and Schema Migrations English.srt 8.9 KB
  361. 242 - Properly Running Data and Schema Migrations.mp4 19.7 MB
  362. 243 - Creating a Posts Table English.srt 6.9 KB
  363. 243 - Creating a Posts Table.mp4 21.6 MB
  364. 244 - 005-index.js 1.3 KB
  365. 244 - A Small Web Server English.srt 21.0 KB
  366. 244 - A Small Web Server.mp4 62.3 MB
  367. 245 - Web Server Setup Instructions.html 1.0 KB
  368. 246 - Adding the Loc Column English.srt 6.1 KB
  369. 246 - Adding the Loc Column.mp4 21.6 MB
  370. 247 - Writing Values to Both Columns English.srt 6.5 KB
  371. 247 - Writing Values to Both Columns.mp4 16.3 MB
  372. 248 - Transaction Locks English.srt 22.3 KB
  373. 248 - Transaction Locks.mp4 96.4 MB
  374. 249 - Updating Values English.srt 6.5 KB
  375. 249 - Updating Values.mp4 15.3 MB
  376. 250 - 01-lng-lat-to-loc.js 364 bytes
  377. 250 - Migrations Setup Instructions.html 925 bytes
  378. 251 - Updating the App Server English.srt 6.6 KB
  379. 251 - Updating the App Server.mp4 13.2 MB
  380. 252 - Dropping the Last Columns English.srt 4.8 KB
  381. 252 - Dropping the Last Columns.mp4 11.6 MB
  382. 253 - Section Goal English.srt 1.5 KB
  383. 253 - Section Goal.mp4 2.6 MB
  384. 254 - Initial Setup English.srt 2.5 KB
  385. 254 - Initial Setup.mp4 2.2 MB
  386. 255 - One Fast Migration English.srt 7.3 KB
  387. 255 - One Fast Migration.mp4 24.4 MB
  388. 256 - 005-access-social-repo.zip 61.3 KB
  389. 256 - Building the Users Router English.srt 6.8 KB
  390. 256 - Building the Users Router.mp4 29.6 MB
  391. 257 - Understanding Connection Pools English.srt 10.6 KB
  392. 257 - Understanding Connection Pools.mp4 22.9 MB
  393. 258 - Validating Connection Credentials English.srt 10.6 KB
  394. 258 - Validating Connection Credentials.mp4 44.7 MB
  395. 259 - 008-access.zip 62.0 KB
  396. 259 - Query and Close English.srt 3.1 KB
  397. 259 - Query and Close.mp4 5.9 MB
  398. 260 - The Repository Pattern English.srt 5.7 KB
  399. 260 - The Repository Pattern.mp4 17.9 MB
  400. 261 - 010-access.zip 62.6 KB
  401. 261 - Creating a Repository English.srt 12.7 KB
  402. 261 - Creating a Repository.mp4 24.8 MB
  403. 262 - Accessing the API English.srt 6.4 KB
  404. 262 - Accessing the API.mp4 23.6 MB
  405. 263 - Casing Issues English.srt 7.1 KB
  406. 263 - Casing Issues.mp4 18.6 MB
  407. 264 - Fixing Casing English.srt 9.6 KB
  408. 264 - Fixing Casing.mp4 49.7 MB
  409. 265 - Finding Particular Users English.srt 8.2 KB
  410. 265 - Finding Particular Users.mp4 18.2 MB
  411. 266 - SQL Injection Exploits English.srt 10.8 KB
  412. 266 - SQL Injection Exploits.mp4 30.5 MB
  413. 267 - Handling SQL Injection with Prepared Statements English.srt 12.8 KB
  414. 267 - Handling SQL Injection with Prepared Statements.mp4 38.1 MB
  415. 268 - Preventing SQL Injection English.srt 11.6 KB
  416. 268 - Preventing SQL Injection.mp4 34.3 MB
  417. 269 - Reminder on Post Requests English.srt 4.2 KB
  418. 269 - Reminder on Post Requests.mp4 14.4 MB
  419. 270 - 019-access.zip 63.6 KB
  420. 270 - Inserting Users English.srt 6.3 KB
  421. 270 - Inserting Users.mp4 15.3 MB
  422. 271 - Handling Updates English.srt 6.8 KB
  423. 271 - Handling Updates.mp4 16.7 MB
  424. 272 - 021-access.zip 63.7 KB
  425. 272 - And Finally Delete English.srt 6.3 KB
  426. 272 - And Finally Delete.mp4 18.2 MB
  427. 273 - A Note on Testing English.srt 5.0 KB
  428. 273 - A Note on Testing.mp4 7.6 MB
  429. 274 - Assertions Around User Count English.srt 10.6 KB
  430. 274 - Assertions Around User Count.mp4 42.3 MB
  431. 275 - 024-access.zip 64.5 KB
  432. 275 - Connecting to a DB For Tests English.srt 8.2 KB
  433. 275 - Connecting to a DB For Tests.mp4 54.2 MB
  434. 276 - 025-access.zip 64.5 KB
  435. 276 - Disconnecting After Tests English.srt 4.6 KB
  436. 276 - Disconnecting After Tests.mp4 12.9 MB
  437. 277 - 026-access.zip 64.5 KB
  438. 277 - MultiDB Setup English.srt 7.5 KB
  439. 277 - MultiDB Setup.mp4 21.9 MB
  440. 278 - 027-access.zip 64.5 KB
  441. 278 - Assumptions Around Content English.srt 8.2 KB
  442. 278 - Assumptions Around Content.mp4 33.1 MB
  443. 279 - 028-access.zip 65.8 KB
  444. 279 - Issues with Parallel Tests English.srt 8.0 KB
  445. 279 - Issues with Parallel Tests.mp4 35.8 MB
  446. 280 - Isolation with Schemas English.srt 6.6 KB
  447. 280 - Isolation with Schemas.mp4 27.4 MB
  448. 281 - Creating and Accessing Schemas English.srt 8.0 KB
  449. 281 - Creating and Accessing Schemas.mp4 19.4 MB
  450. 282 - Controlling Schema Access with Search Paths English.srt 8.8 KB
  451. 282 - Controlling Schema Access with Search Paths.mp4 30.9 MB
  452. 283 - Routing Schema Access English.srt 6.6 KB
  453. 283 - Routing Schema Access.mp4 41.1 MB
  454. 284 - Strategy for Isolation English.srt 7.2 KB
  455. 284 - Strategy for Isolation.mp4 17.6 MB
  456. 285 - 034-access.zip 66.1 KB
  457. 285 - Programmatic Schema Creation English.srt 18.2 KB
  458. 285 - Programmatic Schema Creation.mp4 65.8 MB
  459. 286 - 035-access.zip 66.1 KB
  460. 286 - Escaping Identifiers English.srt 6.4 KB
  461. 286 - Escaping Identifiers.mp4 25.5 MB
  462. 287 - 036-access.zip 66.5 KB
  463. 287 - Test Helpers English.srt 8.0 KB
  464. 287 - Test Helpers.mp4 43.3 MB
  465. 288 - 037-access.zip 66.6 KB
  466. 288 - Cleaning up Schemas and Roles English.srt 8.2 KB
  467. 288 - Cleaning up Schemas and Roles.mp4 31.3 MB
  468. 289 - Finally Parallel Tests Final Lecture English.srt 5.3 KB
  469. 289 - Finally Parallel Tests Final Lecture.mp4 18.6 MB
  470. 290 - Bonus.html 3.4 KB
  471. 43 - Adding Some Data.html 7.7 KB
  472. 44 - Queries with Joins and Aggregations English.srt 5.2 KB
  473. 44 - Queries with Joins and Aggregations.mp4 27.9 MB
  474. 45 - Joining Data from Different Tables English.srt 11.9 KB
  475. 45 - Joining Data from Different Tables.mp4 36.8 MB
  476. 46 - Another Quick Join English.srt 3.2 KB
  477. 46 - Another Quick Join.mp4 8.6 MB
  478. 47 - Exercise Overview English.srt 1.8 KB
  479. 47 - Exercise Overview.mp4 4.8 MB
  480. 48 - A Joinful Solution English.srt 2.6 KB
  481. 48 - A Joinful Solution.mp4 5.3 MB
  482. 49 - Alternate Forms of Syntax English.srt 9.4 KB
  483. 49 - Alternate Forms of Syntax.mp4 25.0 MB
  484. 50 - 007-joins-cumulative.sql 7.5 KB
  485. 50 - Missing Data in Joins English.srt 9.8 KB
  486. 50 - Missing Data in Joins.mp4 29.3 MB
  487. 51 - Why Wasnt It Included English.srt 3.8 KB
  488. 51 - Why Wasnt It Included.mp4 24.6 MB
  489. 52 - 009-joins-cheatsheet.pdf 190.5 KB
  490. 52 - Four Kinds of Joins English.srt 14.8 KB
  491. 52 - Four Kinds of Joins.mp4 124.9 MB
  492. 53 - 010-sql-cumulative.sql 7.6 KB
  493. 53 - Each Join in Practice English.srt 6.3 KB
  494. 53 - Each Join in Practice.mp4 40.6 MB
  495. 54 - Does Order Matter English.srt 6.4 KB
  496. 54 - Does Order Matter.mp4 61.3 MB
  497. 55 - Exercise Overview English.srt 1.5 KB
  498. 55 - Exercise Overview.mp4 2.2 MB
  499. 56 - Two Possible Solutions English.srt 4.7 KB
  500. 56 - Two Possible Solutions.mp4 16.5 MB
  501. 57 - Where with Join English.srt 10.3 KB
  502. 57 - Where with Join.mp4 31.0 MB
  503. 58 - Three Way Joins English.srt 12.2 KB
  504. 58 - Three Way Joins.mp4 49.7 MB
  505. 59 - A Bit of Practice English.srt 7.7 KB
  506. 59 - A Bit of Practice.mp4 17.9 MB
  507. 60 - Exercise Solution English.srt 4.0 KB
  508. 60 - Exercise Solution.mp4 7.7 MB
  509. 61 - Aggregating and Grouping English.srt 3.6 KB
  510. 61 - Aggregating and Grouping.mp4 7.9 MB
  511. 62 - Picturing Group By English.srt 8.3 KB
  512. 62 - Picturing Group By.mp4 29.4 MB
  513. 63 - Aggregate Functions English.srt 4.5 KB
  514. 63 - Aggregate Functions.mp4 11.6 MB
  515. 64 - Combining Group By and Aggregates English.srt 7.2 KB
  516. 64 - Combining Group By and Aggregates.mp4 15.1 MB
  517. 65 - A Gotcha with Count English.srt 4.2 KB
  518. 65 - A Gotcha with Count.mp4 5.5 MB
  519. 66 - Visualizing More Grouping English.srt 4.6 KB
  520. 66 - Visualizing More Grouping.mp4 9.7 MB
  521. 67 - Exercise Overview English.srt 1.2 KB
  522. 67 - Exercise Overview.mp4 1.7 MB
  523. 68 - Grouping Solution English.srt 2.2 KB
  524. 68 - Grouping Solution.mp4 3.1 MB
  525. 69 - Adding a Layer of Difficulty English.srt 1.1 KB
  526. 69 - Adding a Layer of Difficulty.mp4 1.8 MB
  527. 70 - Solution English.srt 2.2 KB
  528. 70 - Solution.mp4 3.7 MB
  529. 71 - Filtering Groups with Having English.srt 7.8 KB
  530. 71 - Filtering Groups with Having.mp4 37.0 MB
  531. 72 - Having In Action English.srt 4.0 KB
  532. 72 - Having In Action.mp4 6.9 MB
  533. 73 - More on Having English.srt 10.5 KB
  534. 73 - More on Having.mp4 28.5 MB
  535. 74 - A Having Exercise Overview English.srt 5.5 KB
  536. 74 - A Having Exercise Overview.mp4 12.8 MB
  537. 75 - A Quick Solution English.srt 3.8 KB
  538. 75 - A Quick Solution.mp4 7.3 MB
  539. 76 - A New Dataset.html 17.8 KB
  540. 77 - 001-sq-data.sql 15.8 KB
  541. 77 - Investigating This Dataset English.srt 4.1 KB
  542. 77 - Investigating This Dataset.mp4 8.0 MB
  543. 78 - Some Group By Practice English.srt 2.0 KB
  544. 78 - Some Group By Practice.mp4 3.1 MB
  545. 79 - Group By Review Solution English.srt 3.5 KB
  546. 79 - Group By Review Solution.mp4 7.9 MB
  547. 80 - Remember Joins English.srt 3.6 KB
  548. 80 - Remember Joins.mp4 9.3 MB
  549. 81 - Of Course You Remember English.srt 2.1 KB
  550. 81 - Of Course You Remember.mp4 4.4 MB
  551. [CourseClub.Me].url 122 bytes
  552. [GigaCourse.Com].url 49 bytes
  553. 82 - The Basics of Sorting English.srt 3.6 KB
  554. 82 - The Basics of Sorting.mp4 6.7 MB
  555. 83 - Two Variations on Sorting English.srt 4.1 KB
  556. 83 - Two Variations on Sorting.mp4 9.5 MB
  557. 84 - Offset and Limit English.srt 10.5 KB
  558. 84 - Offset and Limit.mp4 19.4 MB
  559. 85 - Exercise Overview English.srt 716 bytes
  560. 85 - Exercise Overview.mp4 1.1 MB
  561. 86 - Exercise Solution English.srt 2.1 KB
  562. 86 - Exercise Solution.mp4 3.3 MB
  563. 87 - Handling Sets with Union English.srt 8.8 KB
  564. 87 - Handling Sets with Union.mp4 19.5 MB
  565. 88 - A Few Notes on Union English.srt 5.7 KB
  566. 88 - A Few Notes on Union.mp4 16.5 MB
  567. 89 - Commonalities with Intersect English.srt 5.0 KB
  568. 89 - Commonalities with Intersect.mp4 15.4 MB
  569. 90 - Removing Commonalities with Except English.srt 9.5 KB
  570. 90 - Removing Commonalities with Except.mp4 20.4 MB
  571. 91 - Union Exercise Overview English.srt 2.3 KB
  572. 91 - Union Exercise Overview.mp4 4.2 MB
  573. 92 - Exercise Solution English.srt 2.1 KB
  574. 92 - Exercise Solution.mp4 4.7 MB
  575. 100 - Example of a Subquery in a From English.srt 13.7 KB
  576. 100 - Example of a Subquery in a From.mp4 53.5 MB
  577. 101 - Exercise Overview English.srt 1.9 KB
  578. 101 - Exercise Overview.mp4 3.4 MB
  579. 102 - Exercise Solution English.srt 2.9 KB
  580. 102 - Exercise Solution.mp4 10.4 MB
  581. 103 - Subqueries in a Join Clause English.srt 6.8 KB
  582. 103 - Subqueries in a Join Clause.mp4 16.6 MB
  583. 104 - More Useful Subqueries with Where English.srt 13.7 KB
  584. 104 - More Useful Subqueries with Where.mp4 36.7 MB
  585. 105 - Data Structure with Where Subqueries English.srt 9.0 KB
  586. 105 - Data Structure with Where Subqueries.mp4 44.0 MB
  587. 106 - Exercise Overview English.srt 1.6 KB
  588. 106 - Exercise Overview.mp4 2.7 MB
  589. 107 - Exercise Solution English.srt 3.1 KB
  590. 107 - Exercise Solution.mp4 6.2 MB
  591. 108 - The Not In Operator with a List English.srt 6.5 KB
  592. 108 - The Not In Operator with a List.mp4 38.6 MB
  593. 109 - A New Where Operator English.srt 9.7 KB
  594. 109 - A New Where Operator.mp4 38.7 MB
  595. 110 - Finally Some English.srt 8.3 KB
  596. 110 - Finally Some.mp4 32.0 MB
  597. 111 - Exercise Overview English.srt 767 bytes
  598. 111 - Exercise Overview.mp4 1.2 MB
  599. 112 - A Quick Solution English.srt 2.5 KB
  600. 112 - A Quick Solution.mp4 4.4 MB
  601. 113 - Probably Too Much About Correlated Subqueries English.srt 25.3 KB
  602. 113 - Probably Too Much About Correlated Subqueries.mp4 107.0 MB
  603. 114 - More on Correlated Subqueries English.srt 13.1 KB
  604. 114 - More on Correlated Subqueries.mp4 44.2 MB
  605. 115 - A Select Without a From English.srt 5.3 KB
  606. 115 - A Select Without a From.mp4 9.1 MB
  607. 116 - Exercise Overview English.srt 1.2 KB
  608. 116 - Exercise Overview.mp4 2.0 MB
  609. 117 - Exercise Solution English.srt 1.8 KB
  610. 117 - Exercise Solution.mp4 3.6 MB
  611. 93 - Whats a Subquery English.srt 8.9 KB
  612. 93 - Whats a Subquery.mp4 30.5 MB
  613. 94 - Thinking About the Structure of Data English.srt 7.6 KB
  614. 94 - Thinking About the Structure of Data.mp4 23.6 MB
  615. 95 - Subqueries in a Select English.srt 8.5 KB
  616. 95 - Subqueries in a Select.mp4 22.5 MB
  617. 96 - Exercise Overview English.srt 1.7 KB
  618. 96 - Exercise Overview.mp4 3.1 MB
  619. 97 - Select Solution English.srt 1.8 KB
  620. 97 - Select Solution.mp4 3.8 MB
  621. 98 - Subqueries in a From English.srt 12.0 KB
  622. 98 - Subqueries in a From.mp4 44.5 MB
  623. 99 - From Subqueries that Return a Value English.srt 4.3 KB
  624. 99 - From Subqueries that Return a Value.mp4 9.1 MB
  625. [CourseClub.Me].url 122 bytes
  626. [GigaCourse.Com].url 49 bytes

Discussion