|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| [CourseClub.Me].url |
122б |
| [CourseClub.Me].url |
122б |
| [CourseClub.Me].url |
122б |
| [CourseClub.Me].url |
122б |
| [CourseClub.Me].url |
122б |
| [GigaCourse.Com].url |
49б |
| [GigaCourse.Com].url |
49б |
| [GigaCourse.Com].url |
49б |
| [GigaCourse.Com].url |
49б |
| [GigaCourse.Com].url |
49б |
| 100 - Example of a Subquery in a From.mp4 |
53.51Мб |
| 100 - Example of a Subquery in a From English.srt |
13.74Кб |
| 101 - Exercise Overview.mp4 |
3.40Мб |
| 101 - Exercise Overview English.srt |
1.87Кб |
| 102 - Exercise Solution.mp4 |
10.37Мб |
| 102 - Exercise Solution English.srt |
2.86Кб |
| 103 - Subqueries in a Join Clause.mp4 |
16.55Мб |
| 103 - Subqueries in a Join Clause English.srt |
6.84Кб |
| 104 - More Useful Subqueries with Where.mp4 |
36.66Мб |
| 104 - More Useful Subqueries with Where English.srt |
13.70Кб |
| 105 - Data Structure with Where Subqueries.mp4 |
44.04Мб |
| 105 - Data Structure with Where Subqueries English.srt |
8.97Кб |
| 106 - Exercise Overview.mp4 |
2.71Мб |
| 106 - Exercise Overview English.srt |
1.58Кб |
| 107 - Exercise Solution.mp4 |
6.25Мб |
| 107 - Exercise Solution English.srt |
3.11Кб |
| 108 - The Not In Operator with a List.mp4 |
38.59Мб |
| 108 - The Not In Operator with a List English.srt |
6.46Кб |
| 109 - A New Where Operator.mp4 |
38.71Мб |
| 109 - A New Where Operator English.srt |
9.69Кб |
| 10 - Calculating Phone Revenue.mp4 |
37.26Мб |
| 10 - Calculating Phone Revenue English.srt |
1.57Кб |
| 110 - Finally Some.mp4 |
31.96Мб |
| 110 - Finally Some English.srt |
8.28Кб |
| 111 - Exercise Overview.mp4 |
1.23Мб |
| 111 - Exercise Overview English.srt |
767б |
| 112 - A Quick Solution.mp4 |
4.37Мб |
| 112 - A Quick Solution English.srt |
2.47Кб |
| 113 - Probably Too Much About Correlated Subqueries.mp4 |
107.00Мб |
| 113 - Probably Too Much About Correlated Subqueries English.srt |
25.29Кб |
| 114 - More on Correlated Subqueries.mp4 |
44.16Мб |
| 114 - More on Correlated Subqueries English.srt |
13.13Кб |
| 115 - A Select Without a From.mp4 |
9.09Мб |
| 115 - A Select Without a From English.srt |
5.33Кб |
| 116 - Exercise Overview.mp4 |
1.95Мб |
| 116 - Exercise Overview English.srt |
1.22Кб |
| 117 - Exercise Solution.mp4 |
3.57Мб |
| 117 - Exercise Solution English.srt |
1.76Кб |
| 118 - Selecting Distinct Values.mp4 |
12.46Мб |
| 118 - Selecting Distinct Values English.srt |
6.51Кб |
| 119 - Exercise Overview.mp4 |
1.30Мб |
| 119 - Exercise Overview English.srt |
906б |
| 11 - Exercise Solution.mp4 |
27.92Мб |
| 11 - Exercise Solution English.srt |
1.62Кб |
| 12 - 012-sql.sql |
404б |
| 120 - A Distinct Solution.mp4 |
1.90Мб |
| 120 - A Distinct Solution English.srt |
964б |
| 121 - The Greatest Value in a List.mp4 |
11.77Мб |
| 121 - The Greatest Value in a List English.srt |
5.07Кб |
| 122 - And the Least Value in a List.mp4 |
5.55Мб |
| 122 - And the Least Value in a List English.srt |
3.04Кб |
| 123 - The Case Keyword.mp4 |
19.04Мб |
| 123 - The Case Keyword English.srt |
6.72Кб |
| 124 - PostgreSQL Installation on macOS.mp4 |
21.13Мб |
| 124 - PostgreSQL Installation on macOS English.srt |
9.97Кб |
| 125 - PGAdmin Setup on macOS.mp4 |
36.92Мб |
| 125 - PGAdmin Setup on macOS English.srt |
7.76Кб |
| 126 - Postgres installation on Windows.mp4 |
23.31Мб |
| 126 - Postgres installation on Windows English.srt |
6.61Кб |
| 127 - Whatd We Just Do.mp4 |
19.32Мб |
| 127 - Whatd We Just Do English.srt |
6.54Кб |
| 128 - Data Types.mp4 |
30.53Мб |
| 128 - Data Types English.srt |
7.18Кб |
| 129 - Fast Rules on Numeric Data Types.mp4 |
18.90Мб |
| 129 - Fast Rules on Numeric Data Types English.srt |
3.60Кб |
| 12 - String Operators and Functions.mp4 |
65.10Мб |
| 12 - String Operators and Functions English.srt |
9.90Кб |
| 13 - 013-sql.sql |
48б |
| 130 - More on Number Data Types.mp4 |
48.14Мб |
| 130 - More on Number Data Types English.srt |
14.78Кб |
| 131 - Reminder on Character Types.mp4 |
29.90Мб |
| 131 - Reminder on Character Types English.srt |
7.54Кб |
| 132 - Boolean Data Types.mp4 |
8.20Мб |
| 132 - Boolean Data Types English.srt |
3.89Кб |
| 133 - Times Dates and Timestamps.mp4 |
21.27Мб |
| 133 - Times Dates and Timestamps English.srt |
8.41Кб |
| 134 - Really Awesome Intervals.mp4 |
19.50Мб |
| 134 - Really Awesome Intervals English.srt |
9.08Кб |
| 135 - Thinking About Validation.mp4 |
34.64Мб |
| 135 - Thinking About Validation English.srt |
6.86Кб |
| 136 - Creating and Viewing Tables in PGAdmin.mp4 |
28.09Мб |
| 136 - Creating and Viewing Tables in PGAdmin English.srt |
11.56Кб |
| 137 - Applying a Null Constraint.mp4 |
21.08Мб |
| 137 - Applying a Null Constraint English.srt |
10.26Кб |
| 138 - Solving a Gotcha with Null Constraints.mp4 |
13.72Мб |
| 138 - Solving a Gotcha with Null Constraints English.srt |
6.48Кб |
| 139 - Default Column Values.mp4 |
22.47Мб |
| 139 - Default Column Values English.srt |
5.33Кб |
| 13 - Filtering Rows with Where.mp4 |
12.26Мб |
| 13 - Filtering Rows with Where English.srt |
5.78Кб |
| 140 - Applying a Unique Constraint to One column.mp4 |
43.13Мб |
| 140 - Applying a Unique Constraint to One column English.srt |
8.88Кб |
| 141 - MultiColumn Uniqueness.mp4 |
30.06Мб |
| 141 - MultiColumn Uniqueness English.srt |
5.23Кб |
| 142 - Adding a Validation Check.mp4 |
18.21Мб |
| 142 - Adding a Validation Check English.srt |
6.14Кб |
| 143 - Checks Over Multiple Columns.mp4 |
17.21Мб |
| 143 - Checks Over Multiple Columns English.srt |
7.65Кб |
| 144 - So Where Are We Applying Validation.mp4 |
22.04Мб |
| 144 - So Where Are We Applying Validation English.srt |
9.90Кб |
| 145 - Approaching More Complicated Designs.mp4 |
11.21Мб |
| 145 - Approaching More Complicated Designs English.srt |
5.50Кб |
| 146 - Using a SQL Design Tool.mp4 |
47.29Мб |
| 146 - Using a SQL Design Tool English.srt |
9.94Кб |
| 147 - A Configbased Schema Designer.mp4 |
28.69Мб |
| 147 - A Configbased Schema Designer English.srt |
11.84Кб |
| 148 - Heres the Plan.mp4 |
9.63Мб |
| 148 - Heres the Plan English.srt |
4.27Кб |
| 149 - 005-design.dbml |
455б |
| 149 - Rebuilding Some Schema.mp4 |
20.94Мб |
| 149 - Rebuilding Some Schema English.srt |
10.63Кб |
| 14 - More on the Where Keyword.mp4 |
9.45Мб |
| 14 - More on the Where Keyword English.srt |
3.86Кб |
| 150 - Requirements of a Like System.mp4 |
26.11Мб |
| 150 - Requirements of a Like System English.srt |
7.74Кб |
| 151 - How Not to Design a Like System.mp4 |
16.22Мб |
| 151 - How Not to Design a Like System English.srt |
4.85Кб |
| 152 - Designing a Like System.mp4 |
26.14Мб |
| 152 - Designing a Like System English.srt |
8.29Кб |
| 153 - Making a Reaction System Instead.mp4 |
6.39Мб |
| 153 - Making a Reaction System Instead English.srt |
2.54Кб |
| 154 - Polymorphic Associations.mp4 |
52.60Мб |
| 154 - Polymorphic Associations English.srt |
9.66Кб |
| 155 - Polymorphic Association Alternative Implementation.mp4 |
63.84Мб |
| 155 - Polymorphic Association Alternative Implementation English.srt |
10.93Кб |
| 156 - The Simplest Alternative.mp4 |
26.94Мб |
| 156 - The Simplest Alternative English.srt |
6.13Кб |
| 157 - So Which Approach.mp4 |
16.02Мб |
| 157 - So Which Approach English.srt |
7.04Кб |
| 158 - Additional Features Around Posts.mp4 |
95.79Мб |
| 158 - Additional Features Around Posts English.srt |
10.05Кб |
| 159 - Adding Captions and Locations.mp4 |
8.53Мб |
| 159 - Adding Captions and Locations English.srt |
2.63Кб |
| 15 - Compound Where Clauses.mp4 |
18.98Мб |
| 15 - Compound Where Clauses English.srt |
7.62Кб |
| 160 - Photo Mentions vs Caption Mentions.mp4 |
73.41Мб |
| 160 - Photo Mentions vs Caption Mentions English.srt |
12.68Кб |
| 161 - Considerations on Photo Tags vs Caption Tags.mp4 |
67.08Мб |
| 161 - Considerations on Photo Tags vs Caption Tags English.srt |
11.65Кб |
| 162 - Update For Tags.mp4 |
23.42Мб |
| 162 - Update For Tags English.srt |
7.41Кб |
| 163 - Designing a Hashtag System.mp4 |
98.12Мб |
| 163 - Designing a Hashtag System English.srt |
11.96Кб |
| 164 - Tables for Hashtags.mp4 |
14.45Мб |
| 164 - Tables for Hashtags English.srt |
5.81Кб |
| 165 - Including the Hashtag Table.mp4 |
18.04Мб |
| 165 - Including the Hashtag Table English.srt |
5.94Кб |
| 166 - A Few More User Columns.mp4 |
27.66Мб |
| 166 - A Few More User Columns English.srt |
9.83Кб |
| 167 - Why No Number of Followers or Posts.mp4 |
17.10Мб |
| 167 - Why No Number of Followers or Posts English.srt |
6.07Кб |
| 168 - Designing a Follower System.mp4 |
26.49Мб |
| 168 - Designing a Follower System English.srt |
9.23Кб |
| 169 - Back to Postgres.mp4 |
6.84Мб |
| 169 - Back to Postgres English.srt |
3.29Кб |
| 16 - A Where Exercise Overview.mp4 |
1.72Мб |
| 16 - A Where Exercise Overview English.srt |
992б |
| 170 - 002-db.sql |
375б |
| 170 - Creating Tables with Checks.mp4 |
60.56Мб |
| 170 - Creating Tables with Checks English.srt |
21.02Кб |
| 171 - 003-db.sql |
791б |
| 171 - Posts Creation.mp4 |
36.16Мб |
| 171 - Posts Creation English.srt |
12.77Кб |
| 172 - 004-db.sql |
1.11Кб |
| 172 - Comments Creation.mp4 |
7.17Мб |
| 172 - Comments Creation English.srt |
3.48Кб |
| 173 - 005-db.sql |
1.55Кб |
| 173 - Likes Creation.mp4 |
23.87Мб |
| 173 - Likes Creation English.srt |
10.02Кб |
| 174 - 006-db.sql |
2.19Кб |
| 174 - Photo Tags and Caption Tags.mp4 |
41.35Мб |
| 174 - Photo Tags and Caption Tags English.srt |
8.29Кб |
| 175 - 007-db.sql |
2.84Кб |
| 175 - Creating Hashtags Hashtag Posts and Followers.mp4 |
19.85Мб |
| 175 - Creating Hashtags Hashtag Posts and Followers English.srt |
9.09Кб |
| 176 - ig.sql |
23.51Мб |
| 176 - Quick Note About Adding Some Data.html |
251б |
| 177 - Adding Some Data.mp4 |
16.95Мб |
| 177 - Adding Some Data English.srt |
6.64Кб |
| 178 - Restoring from Scratch.mp4 |
21.23Мб |
| 178 - Restoring from Scratch English.srt |
7.01Кб |
| 179 - Highest User IDs Exercise.mp4 |
7.14Мб |
| 179 - Highest User IDs Exercise English.srt |
3.11Кб |
| 17 - A Where Solution.mp4 |
2.54Мб |
| 17 - A Where Solution English.srt |
1.36Кб |
| 180 - Solution for User IDs.mp4 |
4.64Мб |
| 180 - Solution for User IDs English.srt |
1.84Кб |
| 181 - Posts by a Particular User.mp4 |
4.81Мб |
| 181 - Posts by a Particular User English.srt |
1.77Кб |
| 182 - Solving for Posts by User.mp4 |
9.39Мб |
| 182 - Solving for Posts by User English.srt |
2.83Кб |
| 183 - Likes Per User.mp4 |
3.59Мб |
| 183 - Likes Per User English.srt |
1.34Кб |
| 184 - Solution for Likes Per User.mp4 |
6.60Мб |
| 184 - Solution for Likes Per User English.srt |
2.49Кб |
| 185 - Thinking About Performance.mp4 |
9.24Мб |
| 185 - Thinking About Performance English.srt |
3.68Кб |
| 186 - Where Does Postgres Store Data.mp4 |
37.02Мб |
| 186 - Where Does Postgres Store Data English.srt |
8.88Кб |
| 187 - Heaps Blocks and Tuples.mp4 |
22.73Мб |
| 187 - Heaps Blocks and Tuples English.srt |
5.78Кб |
| 188 - Block Data Layout.mp4 |
17.24Мб |
| 188 - Block Data Layout English.srt |
6.93Кб |
| 189 - Heap File Layout.mp4 |
597.17Мб |
| 189 - Heap File Layout English.srt |
49.73Кб |
| 18 - Where With Lists.mp4 |
46.05Мб |
| 18 - Where With Lists English.srt |
1.06Кб |
| 190 - Full Table Scans.mp4 |
37.18Мб |
| 190 - Full Table Scans English.srt |
6.52Кб |
| 191 - Whats an Index.mp4 |
10.10Мб |
| 191 - Whats an Index English.srt |
4.01Кб |
| 192 - How an Index Works.mp4 |
69.31Мб |
| 192 - How an Index Works English.srt |
12.34Кб |
| 193 - Creating an Index.mp4 |
13.11Мб |
| 193 - Creating an Index English.srt |
6.26Кб |
| 194 - Benchmarking Queries.mp4 |
22.58Мб |
| 194 - Benchmarking Queries English.srt |
8.53Кб |
| 195 - Downsides of Indexes.mp4 |
31.82Мб |
| 195 - Downsides of Indexes English.srt |
8.25Кб |
| 196 - Index Types.mp4 |
6.46Мб |
| 196 - Index Types English.srt |
2.58Кб |
| 197 - Automatically Generated Indexes.mp4 |
19.74Мб |
| 197 - Automatically Generated Indexes English.srt |
5.75Кб |
| 198 - Behind the Scenes of Indexes.mp4 |
398.75Мб |
| 198 - Behind the Scenes of Indexes English.srt |
48.94Кб |
| 199 - The Query Processing Pipeline.mp4 |
25.73Мб |
| 199 - The Query Processing Pipeline English.srt |
8.17Кб |
| 19 - A Where With Lists Solution.mp4 |
4.96Мб |
| 19 - A Where With Lists Solution English.srt |
2.37Кб |
| 1 - Join Our Community.html |
318б |
| 200 - Explain and Explain Analyze.mp4 |
42.83Мб |
| 200 - Explain and Explain Analyze English.srt |
8.35Кб |
| 201 - Solving an Explain Mystery.mp4 |
79.79Мб |
| 201 - Solving an Explain Mystery English.srt |
14.03Кб |
| 202 - Developing an Intuitive Understanding of Cost.mp4 |
102.89Мб |
| 202 - Developing an Intuitive Understanding of Cost English.srt |
20.44Кб |
| 203 - Calculating Cost by Hand.mp4 |
51.25Мб |
| 203 - Calculating Cost by Hand English.srt |
10.11Кб |
| 204 - A Touch More on Costs.mp4 |
95.40Мб |
| 204 - A Touch More on Costs English.srt |
11.49Кб |
| 205 - Startup vs Total Costs.mp4 |
44.70Мб |
| 205 - Startup vs Total Costs English.srt |
9.12Кб |
| 206 - Costs Flow Up.mp4 |
10.10Мб |
| 206 - Costs Flow Up English.srt |
3.12Кб |
| 207 - Use My Index.mp4 |
39.40Мб |
| 207 - Use My Index English.srt |
12.79Кб |
| 208 - Common Table Expressions.mp4 |
11.19Мб |
| 208 - Common Table Expressions English.srt |
2.97Кб |
| 209 - A Quick Solution.mp4 |
13.16Мб |
| 209 - A Quick Solution English.srt |
5.65Кб |
| 20 - Calculations in Where Clauses.mp4 |
4.68Мб |
| 20 - Calculations in Where Clauses English.srt |
3.09Кб |
| 210 - So Whats a CTE.mp4 |
33.50Мб |
| 210 - So Whats a CTE English.srt |
5.79Кб |
| 211 - Recursive CTEs.mp4 |
11.90Мб |
| 211 - Recursive CTEs English.srt |
5.06Кб |
| 212 - Recursive CTEs Step by Step.mp4 |
62.89Мб |
| 212 - Recursive CTEs Step by Step English.srt |
15.57Кб |
| 213 - Why Use Recursive CTEs.mp4 |
43.14Мб |
| 213 - Why Use Recursive CTEs English.srt |
7.81Кб |
| 214 - Writing the Query.mp4 |
36.56Мб |
| 214 - Writing the Query English.srt |
11.92Кб |
| 215 - Walking Through Recursion.mp4 |
109.41Мб |
| 215 - Walking Through Recursion English.srt |
15.04Кб |
| 216 - Most Popular Users.mp4 |
24.81Мб |
| 216 - Most Popular Users English.srt |
9.86Кб |
| 217 - A Possible Solution for Merging Tables.mp4 |
35.67Мб |
| 217 - A Possible Solution for Merging Tables English.srt |
6.23Кб |
| 218 - Creating a View.mp4 |
33.33Мб |
| 218 - Creating a View English.srt |
8.51Кб |
| 219 - When to Use a View.mp4 |
21.21Мб |
| 219 - When to Use a View English.srt |
4.99Кб |
| 21 - Solving Calculations.mp4 |
5.91Мб |
| 21 - Solving Calculations English.srt |
3.05Кб |
| 220 - Deleting and Changing Views.mp4 |
12.51Мб |
| 220 - Deleting and Changing Views English.srt |
3.71Кб |
| 221 - Materialized Views.mp4 |
8.38Мб |
| 221 - Materialized Views English.srt |
3.87Кб |
| 222 - Grouping by Week.mp4 |
34.40Мб |
| 222 - Grouping by Week English.srt |
6.39Кб |
| 223 - Reminder on Left Joins.mp4 |
15.51Мб |
| 223 - Reminder on Left Joins English.srt |
6.91Кб |
| 224 - Writing a Slow Query.mp4 |
55.08Мб |
| 224 - Writing a Slow Query English.srt |
14.00Кб |
| 225 - Creating and Refreshing Materialized Views.mp4 |
36.10Мб |
| 225 - Creating and Refreshing Materialized Views English.srt |
10.02Кб |
| 226 - What are Transactions Used For.mp4 |
22.54Мб |
| 226 - What are Transactions Used For English.srt |
6.42Кб |
| 227 - Some Sample Data.mp4 |
5.44Мб |
| 227 - Some Sample Data English.srt |
3.16Кб |
| 228 - Opening and Closing Transactions.mp4 |
65.33Мб |
| 228 - Opening and Closing Transactions English.srt |
15.17Кб |
| 229 - Transaction Cleanup on Crash.mp4 |
32.89Мб |
| 229 - Transaction Cleanup on Crash English.srt |
6.14Кб |
| 22 - Updating Rows.mp4 |
32.97Мб |
| 22 - Updating Rows English.srt |
6.47Кб |
| 230 - Closing Aborted Transactions.mp4 |
7.47Мб |
| 230 - Closing Aborted Transactions English.srt |
2.75Кб |
| 231 - A Story on Migrations.mp4 |
139.70Мб |
| 231 - A Story on Migrations English.srt |
27.93Кб |
| 232 - Migration Files.mp4 |
44.16Мб |
| 232 - Migration Files English.srt |
7.53Кб |
| 233 - Issues Solved by Migrations.mp4 |
10.00Мб |
| 233 - Issues Solved by Migrations English.srt |
4.51Кб |
| 234 - A Few Notes on Migrations Libraries.mp4 |
34.19Мб |
| 234 - A Few Notes on Migrations Libraries English.srt |
7.82Кб |
| 235 - A Note About Node Installation.html |
264б |
| 236 - Project Creation.mp4 |
9.91Мб |
| 236 - Project Creation English.srt |
4.52Кб |
| 237 - Generating and Writing Migrations.mp4 |
45.64Мб |
| 237 - Generating and Writing Migrations English.srt |
10.50Кб |
| 238 - Applying and Reverting Migrations.mp4 |
68.14Мб |
| 238 - Applying and Reverting Migrations English.srt |
11.21Кб |
| 239 - Generating and Applying a Second Migration.mp4 |
16.63Мб |
| 239 - Generating and Applying a Second Migration English.srt |
5.19Кб |
| 23 - Deleting Rows.mp4 |
11.18Мб |
| 23 - Deleting Rows English.srt |
5.03Кб |
| 240 - Schema vs Data Migrations.mp4 |
20.28Мб |
| 240 - Schema vs Data Migrations English.srt |
6.42Кб |
| 241 - Dangers Around Data Migrations.mp4 |
70.00Мб |
| 241 - Dangers Around Data Migrations English.srt |
14.53Кб |
| 242 - Properly Running Data and Schema Migrations.mp4 |
19.73Мб |
| 242 - Properly Running Data and Schema Migrations English.srt |
8.88Кб |
| 243 - Creating a Posts Table.mp4 |
21.59Мб |
| 243 - Creating a Posts Table English.srt |
6.87Кб |
| 244 - 005-index.js |
1.32Кб |
| 244 - A Small Web Server.mp4 |
62.26Мб |
| 244 - A Small Web Server English.srt |
21.00Кб |
| 245 - Web Server Setup Instructions.html |
1.02Кб |
| 246 - Adding the Loc Column.mp4 |
21.55Мб |
| 246 - Adding the Loc Column English.srt |
6.07Кб |
| 247 - Writing Values to Both Columns.mp4 |
16.26Мб |
| 247 - Writing Values to Both Columns English.srt |
6.49Кб |
| 248 - Transaction Locks.mp4 |
96.42Мб |
| 248 - Transaction Locks English.srt |
22.30Кб |
| 249 - Updating Values.mp4 |
15.27Мб |
| 249 - Updating Values English.srt |
6.46Кб |
| 24 - A Solution for Updating Rows.mp4 |
4.94Мб |
| 24 - A Solution for Updating Rows English.srt |
2.20Кб |
| 250 - 01-lng-lat-to-loc.js |
364б |
| 250 - Migrations Setup Instructions.html |
925б |
| 251 - Updating the App Server.mp4 |
13.23Мб |
| 251 - Updating the App Server English.srt |
6.61Кб |
| 252 - Dropping the Last Columns.mp4 |
11.61Мб |
| 252 - Dropping the Last Columns English.srt |
4.82Кб |
| 253 - Section Goal.mp4 |
2.62Мб |
| 253 - Section Goal English.srt |
1.52Кб |
| 254 - Initial Setup.mp4 |
2.23Мб |
| 254 - Initial Setup English.srt |
2.53Кб |
| 255 - One Fast Migration.mp4 |
24.43Мб |
| 255 - One Fast Migration English.srt |
7.32Кб |
| 256 - 005-access-social-repo.zip |
61.31Кб |
| 256 - Building the Users Router.mp4 |
29.61Мб |
| 256 - Building the Users Router English.srt |
6.79Кб |
| 257 - Understanding Connection Pools.mp4 |
22.93Мб |
| 257 - Understanding Connection Pools English.srt |
10.63Кб |
| 258 - Validating Connection Credentials.mp4 |
44.74Мб |
| 258 - Validating Connection Credentials English.srt |
10.64Кб |
| 259 - 008-access.zip |
62.00Кб |
| 259 - Query and Close.mp4 |
5.90Мб |
| 259 - Query and Close English.srt |
3.12Кб |
| 25 - Solution for Deleting Rows.mp4 |
4.00Мб |
| 25 - Solution for Deleting Rows English.srt |
2.02Кб |
| 260 - The Repository Pattern.mp4 |
17.88Мб |
| 260 - The Repository Pattern English.srt |
5.69Кб |
| 261 - 010-access.zip |
62.58Кб |
| 261 - Creating a Repository.mp4 |
24.78Мб |
| 261 - Creating a Repository English.srt |
12.67Кб |
| 262 - Accessing the API.mp4 |
23.55Мб |
| 262 - Accessing the API English.srt |
6.43Кб |
| 263 - Casing Issues.mp4 |
18.55Мб |
| 263 - Casing Issues English.srt |
7.05Кб |
| 264 - Fixing Casing.mp4 |
49.74Мб |
| 264 - Fixing Casing English.srt |
9.58Кб |
| 265 - Finding Particular Users.mp4 |
18.16Мб |
| 265 - Finding Particular Users English.srt |
8.20Кб |
| 266 - SQL Injection Exploits.mp4 |
30.46Мб |
| 266 - SQL Injection Exploits English.srt |
10.83Кб |
| 267 - Handling SQL Injection with Prepared Statements.mp4 |
38.15Мб |
| 267 - Handling SQL Injection with Prepared Statements English.srt |
12.81Кб |
| 268 - Preventing SQL Injection.mp4 |
34.29Мб |
| 268 - Preventing SQL Injection English.srt |
11.60Кб |
| 269 - Reminder on Post Requests.mp4 |
14.40Мб |
| 269 - Reminder on Post Requests English.srt |
4.18Кб |
| 26 - The Plan Moving Forward.mp4 |
10.75Мб |
| 26 - The Plan Moving Forward English.srt |
2.79Кб |
| 270 - 019-access.zip |
63.56Кб |
| 270 - Inserting Users.mp4 |
15.25Мб |
| 270 - Inserting Users English.srt |
6.29Кб |
| 271 - Handling Updates.mp4 |
16.66Мб |
| 271 - Handling Updates English.srt |
6.82Кб |
| 272 - 021-access.zip |
63.66Кб |
| 272 - And Finally Delete.mp4 |
18.24Мб |
| 272 - And Finally Delete English.srt |
6.32Кб |
| 273 - A Note on Testing.mp4 |
7.64Мб |
| 273 - A Note on Testing English.srt |
4.97Кб |
| 274 - Assertions Around User Count.mp4 |
42.34Мб |
| 274 - Assertions Around User Count English.srt |
10.62Кб |
| 275 - 024-access.zip |
64.50Кб |
| 275 - Connecting to a DB For Tests.mp4 |
54.23Мб |
| 275 - Connecting to a DB For Tests English.srt |
8.21Кб |
| 276 - 025-access.zip |
64.51Кб |
| 276 - Disconnecting After Tests.mp4 |
12.86Мб |
| 276 - Disconnecting After Tests English.srt |
4.60Кб |
| 277 - 026-access.zip |
64.52Кб |
| 277 - MultiDB Setup.mp4 |
21.85Мб |
| 277 - MultiDB Setup English.srt |
7.52Кб |
| 278 - 027-access.zip |
64.52Кб |
| 278 - Assumptions Around Content.mp4 |
33.12Мб |
| 278 - Assumptions Around Content English.srt |
8.25Кб |
| 279 - 028-access.zip |
65.77Кб |
| 279 - Issues with Parallel Tests.mp4 |
35.76Мб |
| 279 - Issues with Parallel Tests English.srt |
7.96Кб |
| 27 - Approaching Database Design.mp4 |
81.98Мб |
| 27 - Approaching Database Design English.srt |
12.07Кб |
| 280 - Isolation with Schemas.mp4 |
27.40Мб |
| 280 - Isolation with Schemas English.srt |
6.57Кб |
| 281 - Creating and Accessing Schemas.mp4 |
19.38Мб |
| 281 - Creating and Accessing Schemas English.srt |
8.04Кб |
| 282 - Controlling Schema Access with Search Paths.mp4 |
30.95Мб |
| 282 - Controlling Schema Access with Search Paths English.srt |
8.78Кб |
| 283 - Routing Schema Access.mp4 |
41.12Мб |
| 283 - Routing Schema Access English.srt |
6.61Кб |
| 284 - Strategy for Isolation.mp4 |
17.57Мб |
| 284 - Strategy for Isolation English.srt |
7.20Кб |
| 285 - 034-access.zip |
66.14Кб |
| 285 - Programmatic Schema Creation.mp4 |
65.75Мб |
| 285 - Programmatic Schema Creation English.srt |
18.23Кб |
| 286 - 035-access.zip |
66.14Кб |
| 286 - Escaping Identifiers.mp4 |
25.53Мб |
| 286 - Escaping Identifiers English.srt |
6.42Кб |
| 287 - 036-access.zip |
66.48Кб |
| 287 - Test Helpers.mp4 |
43.34Мб |
| 287 - Test Helpers English.srt |
7.97Кб |
| 288 - 037-access.zip |
66.59Кб |
| 288 - Cleaning up Schemas and Roles.mp4 |
31.28Мб |
| 288 - Cleaning up Schemas and Roles English.srt |
8.20Кб |
| 289 - Finally Parallel Tests Final Lecture.mp4 |
18.57Мб |
| 289 - Finally Parallel Tests Final Lecture English.srt |
5.30Кб |
| 28 - OnetoMany and ManytoOne Relationships.mp4 |
41.31Мб |
| 28 - OnetoMany and ManytoOne Relationships English.srt |
10.06Кб |
| 290 - Bonus.html |
3.39Кб |
| 29 - OnetoOne and ManytoMany Relationships.mp4 |
24.58Мб |
| 29 - OnetoOne and ManytoMany Relationships English.srt |
8.75Кб |
| 2 - Course Resources.html |
1.25Кб |
| 2 - diagrams.zip |
7.72Мб |
| 30 - Primary Keys and Foreign Keys.mp4 |
29.57Мб |
| 30 - Primary Keys and Foreign Keys English.srt |
7.89Кб |
| 31 - Understanding Foreign Keys.mp4 |
63.35Мб |
| 31 - Understanding Foreign Keys English.srt |
12.96Кб |
| 32 - 007-tables.sql |
194б |
| 32 - 007-tables-cumulative.sql |
172б |
| 32 - AutoGenerated IDs.mp4 |
22.97Мб |
| 32 - AutoGenerated IDs English.srt |
8.95Кб |
| 33 - 008-tables.sql |
197б |
| 33 - 008-tables-cumulative.sql |
348б |
| 33 - Creating Foreign Key Columns.mp4 |
18.32Мб |
| 33 - Creating Foreign Key Columns English.srt |
7.48Кб |
| 34 - 009-tables.sql |
326б |
| 34 - 009-tables-cumulative.sql |
536б |
| 34 - Running Queries on Associated Data.mp4 |
38.22Мб |
| 34 - Running Queries on Associated Data English.srt |
10.35Кб |
| 35 - Exercise Overview.mp4 |
8.25Мб |
| 35 - Exercise Overview English.srt |
3.41Кб |
| 36 - Foreign Key Creation Solution.mp4 |
8.35Мб |
| 36 - Foreign Key Creation Solution English.srt |
3.04Кб |
| 37 - 012-tables.sql |
199б |
| 37 - 012-tables-cumulative.sql |
600б |
| 37 - Foreign Key Constraints Around Insertion.mp4 |
22.15Мб |
| 37 - Foreign Key Constraints Around Insertion English.srt |
8.76Кб |
| 38 - Constraints Around Deletion.mp4 |
40.54Мб |
| 38 - Constraints Around Deletion English.srt |
7.68Кб |
| 39 - Commands Youll Need for the Next Video.html |
691б |
| 3 - What is PostgreSQL All About.mp4 |
21.75Мб |
| 3 - What is PostgreSQL All About English.srt |
7.45Кб |
| 40 - 014-tables.sql |
469б |
| 40 - 014-tables-cumulative.sql |
994б |
| 40 - Testing Deletion Constraints.mp4 |
19.27Мб |
| 40 - Testing Deletion Constraints English.srt |
6.76Кб |
| 41 - 015-tables.sql |
340б |
| 41 - 015-tables-cumulative.sql |
1.28Кб |
| 41 - Setting Foreign Keys to Null on Delete.mp4 |
12.60Мб |
| 41 - Setting Foreign Keys to Null on Delete English.srt |
4.42Кб |
| 42 - Adding Some Complexity.mp4 |
9.96Мб |
| 42 - Adding Some Complexity English.srt |
4.79Кб |
| 43 - Adding Some Data.html |
7.66Кб |
| 44 - Queries with Joins and Aggregations.mp4 |
27.86Мб |
| 44 - Queries with Joins and Aggregations English.srt |
5.20Кб |
| 45 - Joining Data from Different Tables.mp4 |
36.80Мб |
| 45 - Joining Data from Different Tables English.srt |
11.85Кб |
| 46 - Another Quick Join.mp4 |
8.62Мб |
| 46 - Another Quick Join English.srt |
3.24Кб |
| 47 - Exercise Overview.mp4 |
4.85Мб |
| 47 - Exercise Overview English.srt |
1.79Кб |
| 48 - A Joinful Solution.mp4 |
5.27Мб |
| 48 - A Joinful Solution English.srt |
2.57Кб |
| 49 - Alternate Forms of Syntax.mp4 |
24.96Мб |
| 49 - Alternate Forms of Syntax English.srt |
9.37Кб |
| 4 - Database Design.mp4 |
35.37Мб |
| 4 - Database Design English.srt |
8.20Кб |
| 50 - 007-joins-cumulative.sql |
7.54Кб |
| 5 - 003-sql.sql |
104б |
| 50 - Missing Data in Joins.mp4 |
29.27Мб |
| 50 - Missing Data in Joins English.srt |
9.82Кб |
| 51 - Why Wasnt It Included.mp4 |
24.58Мб |
| 51 - Why Wasnt It Included English.srt |
3.79Кб |
| 52 - 009-joins-cheatsheet.pdf |
190.52Кб |
| 52 - Four Kinds of Joins.mp4 |
124.86Мб |
| 52 - Four Kinds of Joins English.srt |
14.83Кб |
| 53 - 010-sql-cumulative.sql |
7.59Кб |
| 53 - Each Join in Practice.mp4 |
40.60Мб |
| 53 - Each Join in Practice English.srt |
6.30Кб |
| 54 - Does Order Matter.mp4 |
61.33Мб |
| 54 - Does Order Matter English.srt |
6.44Кб |
| 55 - Exercise Overview.mp4 |
2.23Мб |
| 55 - Exercise Overview English.srt |
1.47Кб |
| 56 - Two Possible Solutions.mp4 |
16.51Мб |
| 56 - Two Possible Solutions English.srt |
4.75Кб |
| 57 - Where with Join.mp4 |
31.03Мб |
| 57 - Where with Join English.srt |
10.33Кб |
| 58 - Three Way Joins.mp4 |
49.71Мб |
| 58 - Three Way Joins English.srt |
12.24Кб |
| 59 - A Bit of Practice.mp4 |
17.87Мб |
| 59 - A Bit of Practice English.srt |
7.70Кб |
| 5 - Creating Tables.mp4 |
18.61Мб |
| 5 - Creating Tables English.srt |
7.71Кб |
| 60 - Exercise Solution.mp4 |
7.67Мб |
| 60 - Exercise Solution English.srt |
4.00Кб |
| 61 - Aggregating and Grouping.mp4 |
7.90Мб |
| 61 - Aggregating and Grouping English.srt |
3.56Кб |
| 62 - Picturing Group By.mp4 |
29.43Мб |
| 62 - Picturing Group By English.srt |
8.29Кб |
| 63 - Aggregate Functions.mp4 |
11.58Мб |
| 63 - Aggregate Functions English.srt |
4.54Кб |
| 64 - Combining Group By and Aggregates.mp4 |
15.13Мб |
| 64 - Combining Group By and Aggregates English.srt |
7.24Кб |
| 65 - A Gotcha with Count.mp4 |
5.46Мб |
| 65 - A Gotcha with Count English.srt |
4.17Кб |
| 66 - Visualizing More Grouping.mp4 |
9.72Мб |
| 66 - Visualizing More Grouping English.srt |
4.60Кб |
| 67 - Exercise Overview.mp4 |
1.66Мб |
| 67 - Exercise Overview English.srt |
1.15Кб |
| 68 - Grouping Solution.mp4 |
3.15Мб |
| 68 - Grouping Solution English.srt |
2.17Кб |
| 69 - Adding a Layer of Difficulty.mp4 |
1.79Мб |
| 69 - Adding a Layer of Difficulty English.srt |
1.11Кб |
| 6 - Analyzing CREATE TABLE.mp4 |
17.67Мб |
| 6 - Analyzing CREATE TABLE English.srt |
5.51Кб |
| 7 - 005-sql.sql |
278б |
| 7 - 005-sql-cumulative.sql |
384б |
| 70 - Solution.mp4 |
3.68Мб |
| 70 - Solution English.srt |
2.20Кб |
| 71 - Filtering Groups with Having.mp4 |
36.97Мб |
| 71 - Filtering Groups with Having English.srt |
7.76Кб |
| 72 - Having In Action.mp4 |
6.86Мб |
| 72 - Having In Action English.srt |
3.98Кб |
| 73 - More on Having.mp4 |
28.46Мб |
| 73 - More on Having English.srt |
10.49Кб |
| 74 - A Having Exercise Overview.mp4 |
12.79Мб |
| 74 - A Having Exercise Overview English.srt |
5.51Кб |
| 75 - A Quick Solution.mp4 |
7.30Мб |
| 75 - A Quick Solution English.srt |
3.80Кб |
| 76 - A New Dataset.html |
17.84Кб |
| 77 - 001-sq-data.sql |
15.82Кб |
| 77 - Investigating This Dataset.mp4 |
8.00Мб |
| 77 - Investigating This Dataset English.srt |
4.11Кб |
| 78 - Some Group By Practice.mp4 |
3.10Мб |
| 78 - Some Group By Practice English.srt |
2.03Кб |
| 79 - Group By Review Solution.mp4 |
7.92Мб |
| 79 - Group By Review Solution English.srt |
3.53Кб |
| 7 - Inserting Data Into a Table.mp4 |
18.07Мб |
| 7 - Inserting Data Into a Table English.srt |
7.59Кб |
| 80 - Remember Joins.mp4 |
9.30Мб |
| 80 - Remember Joins English.srt |
3.56Кб |
| 81 - Of Course You Remember.mp4 |
4.42Мб |
| 81 - Of Course You Remember English.srt |
2.12Кб |
| 82 - The Basics of Sorting.mp4 |
6.73Мб |
| 82 - The Basics of Sorting English.srt |
3.61Кб |
| 83 - Two Variations on Sorting.mp4 |
9.46Мб |
| 83 - Two Variations on Sorting English.srt |
4.14Кб |
| 84 - Offset and Limit.mp4 |
19.43Мб |
| 84 - Offset and Limit English.srt |
10.47Кб |
| 85 - Exercise Overview.mp4 |
1.08Мб |
| 85 - Exercise Overview English.srt |
716б |
| 86 - Exercise Solution.mp4 |
3.33Мб |
| 86 - Exercise Solution English.srt |
2.06Кб |
| 87 - Handling Sets with Union.mp4 |
19.51Мб |
| 87 - Handling Sets with Union English.srt |
8.78Кб |
| 88 - A Few Notes on Union.mp4 |
16.54Мб |
| 88 - A Few Notes on Union English.srt |
5.69Кб |
| 89 - Commonalities with Intersect.mp4 |
15.42Мб |
| 89 - Commonalities with Intersect English.srt |
5.05Кб |
| 8 - Retrieving Data with Select.mp4 |
6.02Мб |
| 8 - Retrieving Data with Select English.srt |
3.30Кб |
| 90 - Removing Commonalities with Except.mp4 |
20.44Мб |
| 90 - Removing Commonalities with Except English.srt |
9.49Кб |
| 91 - Union Exercise Overview.mp4 |
4.23Мб |
| 91 - Union Exercise Overview English.srt |
2.25Кб |
| 92 - Exercise Solution.mp4 |
4.72Мб |
| 92 - Exercise Solution English.srt |
2.08Кб |
| 93 - Whats a Subquery.mp4 |
30.54Мб |
| 93 - Whats a Subquery English.srt |
8.90Кб |
| 94 - Thinking About the Structure of Data.mp4 |
23.64Мб |
| 94 - Thinking About the Structure of Data English.srt |
7.58Кб |
| 95 - Subqueries in a Select.mp4 |
22.54Мб |
| 95 - Subqueries in a Select English.srt |
8.53Кб |
| 96 - Exercise Overview.mp4 |
3.05Мб |
| 96 - Exercise Overview English.srt |
1.74Кб |
| 97 - Select Solution.mp4 |
3.80Мб |
| 97 - Select Solution English.srt |
1.82Кб |
| 98 - Subqueries in a From.mp4 |
44.45Мб |
| 98 - Subqueries in a From English.srt |
12.01Кб |
| 99 - From Subqueries that Return a Value.mp4 |
9.08Мб |
| 99 - From Subqueries that Return a Value English.srt |
4.34Кб |
| 9 - Calculated Columns.mp4 |
15.22Мб |
| 9 - Calculated Columns English.srt |
7.35Кб |