5 GB | 31min 52s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English
Files Included :
FileName :003 What is PostgreSQL All About.mp4 | Size: (21.75 MB)
FileName :004 Database Design.mp4 | Size: (35.37 MB)
FileName :006 Creating Tables.mp4 | Size: (18.61 MB)
FileName :007 Analyzing CREATE TABLE.mp4 | Size: (11.38 MB)
FileName :008 Inserting Data Into a Table.mp4 | Size: (12.12 MB)
FileName :009 Retrieving Data with Select.mp4 | Size: (4.05 MB)
FileName :011 Calculated Columns.mp4 | Size: (10.37 MB)
FileName :012 Calculating Phone Revenue.mp4 | Size: (2.19 MB)
FileName :014 Exercise Solution.mp4 | Size: (2.17 MB)
FileName :015 String Operators and Functions.mp4 | Size: (11.34 MB)
FileName :001 Filtering Rows with Where.mp4 | Size: (8.42 MB)
FileName :002 More on the Where Keyword.mp4 | Size: (6 MB)
FileName :003 Compound Where Clauses.mp4 | Size: (12.76 MB)
FileName :004 A Where Exercise Overview.mp4 | Size: (1.22 MB)
FileName :006 A Where Solution.mp4 | Size: (1.89 MB)
FileName :007 Where With Lists.mp4 | Size: (1.12 MB)
FileName :009 A Where With Lists Solution.mp4 | Size: (3.56 MB)
FileName :010 Calculations in Where Clauses.mp4 | Size: (3.41 MB)
FileName :012 Solving Calculations.mp4 | Size: (4.15 MB)
FileName :013 Updating Rows.mp4 | Size: (11.71 MB)
FileName :014 Deleting Rows.mp4 | Size: (7.51 MB)
FileName :016 A Solution for Updating Rows.mp4 | Size: (3.42 MB)
FileName :018 Solution for Deleting Rows.mp4 | Size: (2.76 MB)
FileName :001 The Plan Moving Forward.mp4 | Size: (7.09 MB)
FileName :002 Approaching Database Design.mp4 | Size: (30.48 MB)
FileName :004 One-to-Many and Many-to-One Relationships.mp4 | Size: (26.25 MB)
FileName :006 One-to-One and Many-to-Many Relationships.mp4 | Size: (15.28 MB)
FileName :008 Primary Keys and Foreign Keys.mp4 | Size: (18.82 MB)
FileName :009 Understanding Foreign Keys.mp4 | Size: (41.56 MB)
FileName :011 Auto-Generated ID's.mp4 | Size: (14.64 MB)
FileName :012 Creating Foreign Key Columns.mp4 | Size: (11.99 MB)
FileName :013 Running Queries on Associated Data.mp4 | Size: (24.51 MB)
FileName :014 Exercise Overview.mp4 | Size: (5.34 MB)
FileName :016 Foreign Key Creation Solution.mp4 | Size: (5.39 MB)
FileName :017 Foreign Key Constraints Around Insertion.mp4 | Size: (14.99 MB)
FileName :018 Constraints Around Deletion.mp4 | Size: (25.98 MB)
FileName :020 Testing Deletion Constraints.mp4 | Size: (12.46 MB)
FileName :021 Setting Foreign Keys to Null on Delete.mp4 | Size: (8.26 MB)
FileName :023 Adding Some Complexity.mp4 | Size: (6.78 MB)
FileName :002 Queries with Joins and Aggregations.mp4 | Size: (17.78 MB)
FileName :003 Joining Data from Different Tables.mp4 | Size: (23.74 MB)
FileName :004 Another Quick Join.mp4 | Size: (5.62 MB)
FileName :005 Exercise Overview.mp4 | Size: (3.09 MB)
FileName :007 A Joinful Solution.mp4 | Size: (3.47 MB)
FileName :008 Alternate Forms of Syntax.mp4 | Size: (16.28 MB)
FileName :009 Missing Data in Joins.mp4 | Size: (19.08 MB)
FileName :010 Why Wasn't It Included.mp4 | Size: (14.99 MB)
FileName :011 Four Kinds of Joins.mp4 | Size: (75.16 MB)
FileName :012 Each Join in Practice.mp4 | Size: (23.44 MB)
FileName :013 Does Order Matter.mp4 | Size: (35.92 MB)
FileName :015 Exercise Overview.mp4 | Size: (1.53 MB)
FileName :017 Two Possible Solutions.mp4 | Size: (10.19 MB)
FileName :018 Where with Join.mp4 | Size: (20.21 MB)
FileName :019 Three Way Joins.mp4 | Size: (32.08 MB)
FileName :020 A Bit of Practice.mp4 | Size: (11.53 MB)
FileName :022 Exercise Solution.mp4 | Size: (5.44 MB)
FileName :001 Aggregating and Grouping.mp4 | Size: (5.34 MB)
FileName :002 Picturing Group By.mp4 | Size: (19.13 MB)
FileName :004 Aggregate Functions.mp4 | Size: (7.62 MB)
FileName :005 Combining Group By and Aggregates.mp4 | Size: (10.24 MB)
FileName :006 A Gotcha with Count.mp4 | Size: (3.99 MB)
FileName :007 Visualizing More Grouping.mp4 | Size: (6.72 MB)
FileName :008 Exercise Overview.mp4 | Size: (1.14 MB)
FileName :010 Grouping Solution.mp4 | Size: (2.23 MB)
FileName :011 Adding a Layer of Difficulty.mp4 | Size: (1.19 MB)
FileName :013 Solution.mp4 | Size: (2.59 MB)
FileName :014 Filtering Groups with Having.mp4 | Size: (23.9 MB)
FileName :015 Having In Action.mp4 | Size: (4.69 MB)
FileName :016 More on Having!.mp4 | Size: (18.57 MB)
FileName :017 A Having Exercise Overview.mp4 | Size: (8.4 MB)
FileName :019 A Quick Solution.mp4 | Size: (5.19 MB)
FileName :002 Investigating This Dataset.mp4 | Size: (5.42 MB)
FileName :003 Some Group By Practice.mp4 | Size: (2.09 MB)
FileName :005 Group By Review Solution.mp4 | Size: (5.32 MB)
FileName :006 Remember Joins.mp4 | Size: (5.97 MB)
FileName :008 Of Course You Remember!.mp4 | Size: (3.02 MB)
FileName :001 The Basics of Sorting.mp4 | Size: (4.64 MB)
FileName :002 Two Variations on Sorting.mp4 | Size: (6.28 MB)
FileName :003 Offset and Limit.mp4 | Size: (13.21 MB)
FileName :004 Exercise Overview.mp4 | Size: (811.13 KB)
FileName :006 Exercise Solution.mp4 | Size: (2.41 MB)
FileName :001 Handling Sets with Union.mp4 | Size: (13 MB)
FileName :002 A Few Notes on Union.mp4 | Size: (10.82 MB)
FileName :003 Commonalities with Intersect.mp4 | Size: (10.13 MB)
FileName :004 Removing Commonalities with Except.mp4 | Size: (13.67 MB)
FileName :005 Union Exercise Overview.mp4 | Size: (2.97 MB)
FileName :007 Exercise Solution.mp4 | Size: (3.25 MB)
FileName :001 What's a Subquery.mp4 | Size: (19.42 MB)
FileName :002 Thinking About the Structure of Data.mp4 | Size: (15.19 MB)
FileName :004 Subqueries in a Select.mp4 | Size: (15.15 MB)
FileName :005 Exercise Overview.mp4 | Size: (2.1 MB)
FileName :007 Select Solution.mp4 | Size: (2.62 MB)
FileName :008 Subqueries in a From.mp4 | Size: (28.32 MB)
FileName :009 From Subqueries that Return a Value.mp4 | Size: (6.11 MB)
FileName :010 Example of a Subquery in a From.mp4 | Size: (34.37 MB)
FileName :011 Exercise Overview.mp4 | Size: (2.4 MB)
FileName :013 Exercise Solution.mp4 | Size: (6.56 MB)
FileName :014 Subqueries in a Join Clause.mp4 | Size: (10.84 MB)
FileName :015 More Useful - Subqueries with Where.mp4 | Size: (23.88 MB)
FileName :016 Data Structure with Where Subqueries.mp4 | Size: (27.68 MB)
FileName :017 Exercise Overview.mp4 | Size: (1.9 MB)
FileName :019 Exercise Solution.mp4 | Size: (4.45 MB)
FileName :020 The Not In Operator with a List.mp4 | Size: (23.45 MB)
FileName :021 A New Where Operator.mp4 | Size: (24.2 MB)
FileName :022 Finally Some!.mp4 | Size: (20.48 MB)
FileName :024 Exercise Overview.mp4 | Size: (853.67 KB)
FileName :026 A Quick Solution.mp4 | Size: (3.06 MB)
FileName :027 Probably Too Much About Correlated Subqueries.mp4 | Size: (66.89 MB)
FileName :028 More on Correlated Subqueries.mp4 | Size: (27.85 MB)
FileName :029 A Select Without a From.mp4 | Size: (6.44 MB)
FileName :030 Exercise Overview.mp4 | Size: (1.37 MB)
FileName :032 Exercise Solution.mp4 | Size: (2.53 MB)
FileName :001 Selecting Distinct Values.mp4 | Size: (8.43 MB)
FileName :002 Exercise Overview.mp4 | Size: (961.13 KB)
FileName :004 A Distinct Solution.mp4 | Size: (1.36 MB)
FileName :001 The Greatest Value in a List.mp4 | Size: (7.87 MB)
FileName :002 And the Least Value in a List!.mp4 | Size: (3.76 MB)
FileName :003 The Case Keyword.mp4 | Size: (19.04 MB)
FileName :001 PostgreSQL Installation on macOS.mp4 | Size: (14.14 MB)
FileName :002 pgAdmin Setup on macOS.mp4 | Size: (11.19 MB)
FileName :003 Postgres installation on Windows.mp4 | Size: (13.77 MB)
FileName :001 What'd We Just Do.mp4 | Size: (12.38 MB)
FileName :002 Data Types.mp4 | Size: (19.71 MB)
FileName :003 Fast Rules on Numeric Data Types.mp4 | Size: (11.96 MB)
FileName :004 More on Number Data Types.mp4 | Size: (30.51 MB)
FileName :005 Reminder on Character Types.mp4 | Size: (19.13 MB)
FileName :006 Boolean Data Types.mp4 | Size: (5.43 MB)
FileName :007 Times, Dates, and Timestamps.mp4 | Size: (14.29 MB)
FileName :008 Really Awesome Intervals.mp4 | Size: (13.48 MB)
FileName :001 Thinking About Validation.mp4 | Size: (22.22 MB)
FileName :002 Creating and Viewing Tables in PGAdmin.mp4 | Size: (18.55 MB)
FileName :003 Applying a Null Constraint.mp4 | Size: (14.08 MB)
FileName :004 Solving a Gotcha with Null Constraints.mp4 | Size: (9.1 MB)
FileName :006 Default Column Values.mp4 | Size: (14.32 MB)
FileName :007 Applying a Unique Constraint to One column.mp4 | Size: (26.77 MB)
FileName :008 Multi-Column Uniqueness.mp4 | Size: (18.37 MB)
FileName :010 Adding a Validation Check.mp4 | Size: (11.7 MB)
FileName :011 Checks Over Multiple Columns.mp4 | Size: (11.57 MB)
FileName :013 So Where Are We Applying Validation.mp4 | Size: (14.54 MB)
FileName :001 Approaching More Complicated Designs.mp4 | Size: (7.66 MB)
FileName :002 Using a SQL Design Tool.mp4 | Size: (32.43 MB)
FileName :003 A Config-based Schema Designer.mp4 | Size: (19.25 MB)
FileName :004 Here's the Plan.mp4 | Size: (5.9 MB)
FileName :005 Rebuilding Some Schema.mp4 | Size: (14.12 MB)
FileName :001 Requirements of a Like System.mp4 | Size: (16.24 MB)
FileName :002 How Not to Design a Like System.mp4 | Size: (10.26 MB)
FileName :003 Designing a Like System.mp4 | Size: (16.81 MB)
FileName :005 Making a Reaction System Instead.mp4 | Size: (4.12 MB)
FileName :006 Polymorphic Associations.mp4 | Size: (33.43 MB)
FileName :007 Polymorphic Association Alternative Implementation.mp4 | Size: (39.49 MB)
FileName :008 The Simplest Alternative.mp4 | Size: (17.4 MB)
FileName :010 So Which Approach.mp4 | Size: (10.46 MB)
FileName :001 Additional Features Around Posts.mp4 | Size: (54.04 MB)
FileName :002 Adding Captions and Locations.mp4 | Size: (5.36 MB)
FileName :003 Photo Mentions vs Caption Mentions.mp4 | Size: (44.21 MB)
FileName :004 Considerations on Photo Tags vs Caption Tags.mp4 | Size: (42.88 MB)
FileName :005 Update For Tags.mp4 | Size: (14.97 MB)
FileName :001 Designing a Hashtag System.mp4 | Size: (60.55 MB)
FileName :002 Tables for Hashtags.mp4 | Size: (10.02 MB)
FileName :003 Including the Hashtag Table.mp4 | Size: (11.58 MB)
FileName :004 A Few More User Columns.mp4 | Size: (16.86 MB)
FileName :005 Why No Number of Followers or Posts.mp4 | Size: (10.44 MB)
FileName :001 Designing a Follower System.mp4 | Size: (17.21 MB)
FileName :001 Back to Postgres.mp4 | Size: (4.42 MB)
FileName :002 Creating Tables with Checks.mp4 | Size: (40.1 MB)
FileName :003 Posts Creation.mp4 | Size: (24.3 MB)
FileName :004 Comments Creation.mp4 | Size: (4.93 MB)
FileName :005 Likes Creation.mp4 | Size: (15.83 MB)
FileName :006 Photo Tags and Caption Tags.mp4 | Size: (25.74 MB)
FileName :007 Creating Hashtags, Hashtag Posts, and Followers.mp4 | Size: (13.66 MB)
FileName :002 Adding Some Data.mp4 | Size: (10.84 MB)
FileName :003 Restoring from Scratch.mp4 | Size: (13.85 MB)
FileName :004 Highest User ID's Exercise.mp4 | Size: (4.74 MB)
FileName :005 Solution for User ID's.mp4 | Size: (2.99 MB)
FileName :006 Posts by a Particular User.mp4 | Size: (2.97 MB)
FileName :007 Solving for Posts by User.mp4 | Size: (5.85 MB)
FileName :008 Likes Per User.mp4 | Size: (2.25 MB)
FileName :009 Solution for Likes Per User.mp4 | Size: (4.37 MB)
FileName :001 Thinking About Performance.mp4 | Size: (6.48 MB)
FileName :002 Where Does Postgres Store Data.mp4 | Size: (22.61 MB)
FileName :003 Heaps, Blocks, and Tuples.mp4 | Size: (15.16 MB)
FileName :005 Block Data Layout.mp4 | Size: (11.75 MB)
FileName :006 Heap File Layout.mp4 | Size: (338.39 MB)
FileName :001 Full Table Scans.mp4 | Size: (23.88 MB)
FileName :002 What's an Index.mp4 | Size: (6.34 MB)
FileName :003 How an Index Works.mp4 | Size: (43.22 MB)
FileName :004 Creating an Index.mp4 | Size: (8.89 MB)
FileName :005 Benchmarking Queries.mp4 | Size: (14.93 MB)
FileName :006 Downsides of Indexes.mp4 | Size: (19.87 MB)
FileName :007 Index Types.mp4 | Size: (4.08 MB)
FileName :008 Automatically Generated Indexes.mp4 | Size: (12.81 MB)
FileName :010 Behind the Scenes of Indexes.mp4 | Size: (238.29 MB)
FileName :001 The Query Processing Pipeline.mp4 | Size: (16.08 MB)
FileName :002 Explain and Explain Analyze.mp4 | Size: (27.15 MB)
FileName :004 Solving an Explain Mystery.mp4 | Size: (49.05 MB)
FileName :001 Developing an Intuitive Understanding of Cost.mp4 | Size: (64.58 MB)
FileName :002 Calculating Cost by Hand.mp4 | Size: (32.19 MB)
FileName :003 A Touch More on Costs.mp4 | Size: (55.34 MB)
FileName :005 Startup vs Total Costs.mp4 | Size: (28.66 MB)
FileName :006 Costs Flow Up.mp4 | Size: (6.35 MB)
FileName :007 Use My Index!.mp4 | Size: (25.95 MB)
FileName :001 Common Table Expressions.mp4 | Size: (7 MB)
FileName :002 A Quick Solution.mp4 | Size: (8.7 MB)
FileName :003 So What's a CTE.mp4 | Size: (20.53 MB)
FileName :001 Recursive CTE's.mp4 | Size: (7.78 MB)
FileName :002 Recursive CTE's Step by Step.mp4 | Size: (40.08 MB)
FileName :003 Why Use Recursive CTE's.mp4 | Size: (27.27 MB)
FileName :004 Writing the Query.mp4 | Size: (23.59 MB)
FileName :005 Walking Through Recursion.mp4 | Size: (65.98 MB)
FileName :001 Most Popular Users.mp4 | Size: (16.57 MB)
FileName :002 A Possible Solution for Merging Tables.mp4 | Size: (22.31 MB)
FileName :003 Creating a View.mp4 | Size: (21.25 MB)
FileName :004 When to Use a View.mp4 | Size: (13.04 MB)
FileName :005 Deleting and Changing Views.mp4 | Size: (7.92 MB)
FileName :001 Materialized Views.mp4 | Size: (5.6 MB)
FileName :002 Grouping by Week.mp4 | Size: (22.12 MB)
FileName :003 Reminder on Left Joins.mp4 | Size: (10.5 MB)
FileName :004 Writing a Slow Query.mp4 | Size: (35.07 MB)
FileName :005 Creating and Refreshing Materialized Views.mp4 | Size: (22.49 MB)
FileName :001 What are Transactions Used For.mp4 | Size: (15.45 MB)
FileName :002 Some Sample Data.mp4 | Size: (3.78 MB)
FileName :003 Opening and Closing Transactions.mp4 | Size: (42.15 MB)
FileName :004 Transaction Cleanup on Crash.mp4 | Size: (20.21 MB)
FileName :005 Closing Aborted Transactions.mp4 | Size: (4.83 MB)
FileName :001 A Story on Migrations.mp4 | Size: (88.61 MB)
FileName :002 Migration Files.mp4 | Size: (28.84 MB)
FileName :003 Issues Solved by Migrations.mp4 | Size: (6.69 MB)
FileName :004 A Few Notes on Migrations Libraries.mp4 | Size: (21.69 MB)
FileName :006 Project Creation.mp4 | Size: (6.23 MB)
FileName :007 Generating and Writing Migrations.mp4 | Size: (28.53 MB)
FileName :008 Applying and Reverting Migrations.mp4 | Size: (40.15 MB)
FileName :009 Generating and Applying a Second Migration.mp4 | Size: (10.78 MB)
FileName :001 Schema vs Data Migrations.mp4 | Size: (13.43 MB)
FileName :002 Dangers Around Data Migrations.mp4 | Size: (44.32 MB)
FileName :003 Properly Running Data and Schema Migrations.mp4 | Size: (13.6 MB)
FileName :004 Creating a Posts Table.mp4 | Size: (14.37 MB)
FileName :005 A Small Web Server.mp4 | Size: (40.67 MB)
FileName :007 Adding the Loc Column.mp4 | Size: (14.2 MB)
FileName :008 Writing Values to Both Columns.mp4 | Size: (10.66 MB)
FileName :009 Transaction Locks.mp4 | Size: (62.64 MB)
FileName :010 Updating Values.mp4 | Size: (10.13 MB)
FileName :012 Updating the App Server.mp4 | Size: (8.8 MB)
FileName :013 Dropping the Last Columns.mp4 | Size: (7.58 MB)
FileName :001 Section Goal.mp4 | Size: (1.96 MB)
FileName :002 Initial Setup.mp4 | Size: (1.71 MB)
FileName :003 One Fast Migration.mp4 | Size: (15.66 MB)
FileName :004 Building the Users Router.mp4 | Size: (18.61 MB)
FileName :005 Understanding Connection Pools.mp4 | Size: (16.03 MB)
FileName :006 Validating Connection Credentials.mp4 | Size: (27.9 MB)
FileName :007 Query and Close.mp4 | Size: (4.04 MB)
FileName :001 The Repository Pattern.mp4 | Size: (11.69 MB)
FileName :002 Creating a Repository.mp4 | Size: (16.66 MB)
FileName :003 Accessing the API.mp4 | Size: (14.68 MB)
FileName :004 Casing Issues.mp4 | Size: (11.97 MB)
FileName :005 Fixing Casing.mp4 | Size: (30.31 MB)
FileName :006 Finding Particular Users.mp4 | Size: (12 MB)
FileName :001 SQL Injection Exploits.mp4 | Size: (20.45 MB)
FileName :002 Handling SQL Injection with Prepared Statements.mp4 | Size: (25.48 MB)
FileName :003 Preventing SQL Injection.mp4 | Size: (22.48 MB)
FileName :004 Reminder on Post Requests.mp4 | Size: (9.24 MB)
FileName :005 Inserting Users.mp4 | Size: (9.98 MB)
FileName :006 Handling Updates.mp4 | Size: (10.78 MB)
FileName :007 And, Finally, Delete.mp4 | Size: (11.52 MB)
FileName :001 A Note on Testing.mp4 | Size: (5.36 MB)
FileName :002 Assertions Around User Count.mp4 | Size: (26.88 MB)
FileName :003 Connecting to a DB For Tests.mp4 | Size: (32 MB)
FileName :004 Disconnecting After Tests.mp4 | Size: (8.24 MB)
FileName :005 Multi-DB Setup.mp4 | Size: (14.14 MB)
FileName :006 Assumptions Around Content.mp4 | Size: (20.64 MB)
FileName :007 Issues with Parallel Tests.mp4 | Size: (22.82 MB)
FileName :008 Isolation with Schemas.mp4 | Size: (18.07 MB)
FileName :009 Creating and Accessing Schemas.mp4 | Size: (12.81 MB)
FileName :010 Controlling Schema Access with Search Paths.mp4 | Size: (20.15 MB)
FileName :011 Routing Schema Access.mp4 | Size: (24.75 MB)
FileName :012 Strategy for Isolation.mp4 | Size: (11.66 MB)
FileName :013 Programmatic Schema Creation.mp4 | Size: (41.17 MB)
FileName :014 Escaping Identifiers.mp4 | Size: (15.94 MB)
FileName :015 Test Helpers.mp4 | Size: (26.41 MB)
FileName :016 Cleaning up Schemas and Roles.mp4 | Size: (19.43 MB)
FileName :017 Finally Parallel Tests! (Final Lecture).mp4 | Size: (11.45 MB)]
Screenshot
https://rapidgator.net/file/e1f993df0067645508b2ca2f2674a7fb/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part1.rar https://rapidgator.net/file/b305b35bb0cd015757fadcc7a4ba0614/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part2.rar https://rapidgator.net/file/0212e2aa36bf26a05136a0cf5852984f/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part3.rar https://rapidgator.net/file/e43ef2a62234691f58367d2bab517dd3/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part4.rar https://rapidgator.net/file/7b04e2cacace3a297ba1eaf87a76ac4c/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part5.rar https://rapidgator.net/file/d1b113d1c5329d0fbb02951e577ddbaf/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part6.rar
NitroFlare
https://nitroflare.com/view/59B2B5789767E3B/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part1.rar https://nitroflare.com/view/AFB331828F40E05/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part2.rar https://nitroflare.com/view/9BD7D357F632CB4/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part3.rar https://nitroflare.com/view/8B961A7B81487C8/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part4.rar https://nitroflare.com/view/00CB9A3B78B43D4/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part5.rar https://nitroflare.com/view/34ADC3FBBC5274B/.SQL.and.PostgreSQL.The.Complete.Developers.Guide.part6.rar
