[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developers Guide

磁力链接/BT种子名称

[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developers Guide

磁力链接/BT种子简介

种子哈希：544a0911c985f10fc0171663fe086177c3b67276
文件大小： 8.06G
已经下载：9025次
下载速度：极快
收录时间：2024-01-09
最近下载：2025-01-03

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:544A0911C985F10FC0171663FE086177C3B67276
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 暗网禁地 91短视频 TikTok成人版 PornHub 草榴社区 乱伦社区 少女初夜 萝莉岛

最近搜索

文件列表

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

随机展示

相关说明

本站不存储任何资源内容，只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符)，并提供查询服务，是一个完全合法的搜索引擎系统。 网站不提供种子下载服务，用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责，请用户注意甄别！
>