Download Free Download : Udemy - SQL and PostgreSQL The Complete Developer's Guide
mp4 | Video: h264,1920X1080 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:7.83 GB
Files Included :
003 What is PostgreSQL All About.mp4 (15.94 MB)
MP4
004 Database Design.mp4 (49.41 MB)
MP4
005 Creating Tables.mp4 (12.9 MB)
MP4
006 Analyzing CREATE TABLE.mp4 (17.67 MB)
MP4
007 Inserting Data Into a Table.mp4 (18.07 MB)
MP4
008 Retrieving Data with Select.mp4 (6.02 MB)
MP4
009 Calculated Columns.mp4 (15.22 MB)
MP4
010 Calculating Phone Revenue.mp4 (3.36 MB)
MP4
011 Exercise Solution.mp4 (3.15 MB)
MP4
012 String Operators and Functions.mp4 (16.34 MB)
MP4
001 Filtering Rows with Where.mp4 (12.26 MB)
MP4
002 More on the Where Keyword.mp4 (9.45 MB)
MP4
003 Compound Where Clauses.mp4 (18.98 MB)
MP4
004 A Where Exercise Overview.mp4 (1.72 MB)
MP4
005 A Where Solution.mp4 (2.54 MB)
MP4
006 Where With Lists.mp4 (1.59 MB)
MP4
007 A Where With Lists Solution.mp4 (4.96 MB)
MP4
008 Calculations in Where Clauses.mp4 (4.68 MB)
MP4
009 Solving Calculations.mp4 (5.91 MB)
MP4
010 Updating Rows.mp4 (17.3 MB)
MP4
011 Deleting Rows.mp4 (11.18 MB)
MP4
012 A Solution for Updating Rows.mp4 (4.94 MB)
MP4
013 Solution for Deleting Rows.mp4 (4 MB)
MP4
001 The Plan Moving Forward.mp4 (10.75 MB)
MP4
002 Approaching Database Design.mp4 (50.16 MB)
MP4
003 One-to-Many and Many-to-One Relationships.mp4 (41.31 MB)
MP4
004 One-to-One and Many-to-Many Relationships.mp4 (24.58 MB)
MP4
005 Primary Keys and Foreign Keys.mp4 (29.57 MB)
MP4
006 Understanding Foreign Keys.mp4 (63.35 MB)
MP4
007 Auto-Generated ID's.mp4 (22.97 MB)
MP4
008 Creating Foreign Key Columns.mp4 (18.32 MB)
MP4
009 Running Queries on Associated Data.mp4 (38.22 MB)
MP4
010 Exercise Overview.mp4 (8.25 MB)
MP4
011 Foreign Key Creation Solution.mp4 (8.35 MB)
MP4
012 Foreign Key Constraints Around Insertion.mp4 (22.15 MB)
MP4
013 Constraints Around Deletion.mp4 (40.54 MB)
MP4
015 Testing Deletion Constraints.mp4 (19.27 MB)
MP4
016 Setting Foreign Keys to Null on Delete.mp4 (12.6 MB)
MP4
017 Adding Some Complexity.mp4 (9.96 MB)
MP4
002 Queries with Joins and Aggregations.mp4 (27.86 MB)
MP4
003 Joining Data from Different Tables.mp4 (36.8 MB)
MP4
004 Another Quick Join.mp4 (8.62 MB)
MP4
005 Exercise Overview.mp4 (4.85 MB)
MP4
006 A Joinful Solution.mp4 (5.27 MB)
MP4
007 Alternate Forms of Syntax.mp4 (24.96 MB)
MP4
008 Missing Data in Joins.mp4 (29.27 MB)
MP4
009 Why Wasn't It Included.mp4 (24.58 MB)
MP4
010 Four Kinds of Joins.mp4 (124.86 MB)
MP4
011 Each Join in Practice.mp4 (40.6 MB)
MP4
012 Does Order Matter.mp4 (61.33 MB)
MP4
013 Exercise Overview.mp4 (2.23 MB)
MP4
014 Two Possible Solutions.mp4 (16.51 MB)
MP4
015 Where with Join.mp4 (31.03 MB)
MP4
016 Three Way Joins.mp4 (49.71 MB)
MP4
017 A Bit of Practice.mp4 (17.87 MB)
MP4
018 Exercise Solution.mp4 (7.67 MB)
MP4
001 Aggregating and Grouping.mp4 (7.9 MB)
MP4
002 Picturing Group By.mp4 (29.43 MB)
MP4
003 Aggregate Functions.mp4 (11.58 MB)
MP4
004 Combining Group By and Aggregates.mp4 (15.13 MB)
MP4
005 A Gotcha with Count.mp4 (5.46 MB)
MP4
006 Visualizing More Grouping.mp4 (9.72 MB)
MP4
007 Exercise Overview.mp4 (1.66 MB)
MP4
008 Grouping Solution.mp4 (3.15 MB)
MP4
009 Adding a Layer of Difficulty.mp4 (1.79 MB)
MP4
010 Solution.mp4 (3.68 MB)
MP4
011 Filtering Groups with Having.mp4 (36.97 MB)
MP4
012 Having In Action.mp4 (6.86 MB)
MP4
013 More on Having!.mp4 (28.46 MB)
MP4
014 A Having Exercise Overview.mp4 (12.79 MB)
MP4
015 A Quick Solution.mp4 (7.3 MB)
MP4
002 Investigating This Dataset.mp4 (8 MB)
MP4
003 Some Group By Practice.mp4 (3.1 MB)
MP4
004 Group By Review Solution.mp4 (7.92 MB)
MP4
005 Remember Joins.mp4 (9.3 MB)
MP4
006 Of Course You Remember!.mp4 (4.42 MB)
MP4
001 The Basics of Sorting.mp4 (6.73 MB)
MP4
002 Two Variations on Sorting.mp4 (9.46 MB)
MP4
003 Offset and Limit.mp4 (19.43 MB)
MP4
004 Exercise Overview.mp4 (1.08 MB)
MP4
005 Exercise Solution.mp4 (3.33 MB)
MP4
001 Handling Sets with Union.mp4 (19.51 MB)
MP4
002 A Few Notes on Union.mp4 (16.54 MB)
MP4
003 Commonalities with Intersect.mp4 (15.42 MB)
MP4
004 Removing Commonalities with Except.mp4 (20.44 MB)
MP4
005 Union Exercise Overview.mp4 (4.23 MB)
MP4
006 Exercise Solution.mp4 (4.72 MB)
MP4
001 What's a Subquery.mp4 (30.54 MB)
MP4
002 Thinking About the Structure of Data.mp4 (23.64 MB)
MP4
003 Subqueries in a Select.mp4 (22.54 MB)
MP4
004 Exercise Overview.mp4 (3.05 MB)
MP4
005 Select Solution.mp4 (3.8 MB)
MP4
006 Subqueries in a From.mp4 (44.45 MB)
MP4
007 From Subqueries that Return a Value.mp4 (9.08 MB)
MP4
008 Example of a Subquery in a From.mp4 (53.51 MB)
MP4
009 Exercise Overview.mp4 (3.4 MB)
MP4
010 Exercise Solution.mp4 (10.37 MB)
MP4
011 Subqueries in a Join Clause.mp4 (16.55 MB)
MP4
012 More Useful - Subqueries with Where.mp4 (36.66 MB)
MP4
013 Data Structure with Where Subqueries.mp4 (44.04 MB)
MP4
014 Exercise Overview.mp4 (2.71 MB)
MP4
015 Exercise Solution.mp4 (6.25 MB)
MP4
016 The Not In Operator with a List.mp4 (38.59 MB)
MP4
017 A New Where Operator.mp4 (38.71 MB)
MP4
018 Finally Some!.mp4 (31.96 MB)
MP4
019 Exercise Overview.mp4 (1.23 MB)
MP4
020 A Quick Solution.mp4 (4.37 MB)
MP4
021 Probably Too Much About Correlated Subqueries.mp4 (107 MB)
MP4
022 More on Correlated Subqueries.mp4 (44.16 MB)
MP4
023 A Select Without a From.mp4 (9.09 MB)
MP4
024 Exercise Overview.mp4 (1.95 MB)
MP4
025 Exercise Solution.mp4 (3.57 MB)
MP4
001 Selecting Distinct Values.mp4 (12.46 MB)
MP4
002 Exercise Overview.mp4 (1.3 MB)
MP4
003 A Distinct Solution.mp4 (1.9 MB)
MP4
001 The Greatest Value in a List.mp4 (11.77 MB)
MP4
002 And the Least Value in a List!.mp4 (5.55 MB)
MP4
003 The Case Keyword.mp4 (13.32 MB)
MP4
001 PostgreSQL Installation on macOS.mp4 (21.13 MB)
MP4
002 PGAdmin Setup on macOS.mp4 (36.92 MB)
MP4
003 Postgres installation on Windows.mp4 (23.31 MB)
MP4
001 What'd We Just Do.mp4 (19.32 MB)
MP4
002 Data Types.mp4 (30.53 MB)
MP4
003 Fast Rules on Numeric Data Types.mp4 (18.9 MB)
MP4
004 More on Number Data Types.mp4 (48.13 MB)
MP4
005 Reminder on Character Types.mp4 (29.9 MB)
MP4
006 Boolean Data Types.mp4 (8.2 MB)
MP4
007 Times, Dates, and Timestamps.mp4 (21.27 MB)
MP4
008 Really Awesome Intervals.mp4 (19.5 MB)
MP4
001 Thinking About Validation.mp4 (34.64 MB)
MP4
002 Creating and Viewing Tables in PGAdmin.mp4 (28.09 MB)
MP4
003 Applying a Null Constraint.mp4 (21.08 MB)
MP4
004 Solving a Gotcha with Null Constraints.mp4 (13.72 MB)
MP4
005 Default Column Values.mp4 (22.47 MB)
MP4
006 Applying a Unique Constraint to One column.mp4 (43.13 MB)
MP4
007 Multi-Column Uniqueness.mp4 (30.06 MB)
MP4
008 Adding a Validation Check.mp4 (18.21 MB)
MP4
009 Checks Over Multiple Columns.mp4 (17.21 MB)
MP4
010 So Where Are We Applying Validation.mp4 (22.04 MB)
MP4
001 Approaching More Complicated Designs.mp4 (11.21 MB)
MP4
002 Using a SQL Design Tool.mp4 (47.29 MB)
MP4
003 A Config-based Schema Designer.mp4 (28.69 MB)
MP4
004 Here's the Plan.mp4 (9.63 MB)
MP4
005 Rebuilding Some Schema.mp4 (20.94 MB)
MP4
001 Requirements of a Like System.mp4 (26.11 MB)
MP4
002 How Not to Design a Like System.mp4 (16.22 MB)
MP4
003 Designing a Like System.mp4 (26.14 MB)
MP4
004 Making a Reaction System Instead.mp4 (6.39 MB)
MP4
005 Polymorphic Associations.mp4 (52.6 MB)
MP4
006 Polymorphic Association Alternative Implementation.mp4 (63.84 MB)
MP4
007 The Simplest Alternative.mp4 (26.94 MB)
MP4
008 So Which Approach.mp4 (16.02 MB)
MP4
001 Additional Features Around Posts.mp4 (95.79 MB)
MP4
002 Adding Captions and Locations.mp4 (8.53 MB)
MP4
003 Photo Mentions vs Caption Mentions.mp4 (73.41 MB)
MP4
004 Considerations on Photo Tags vs Caption Tags.mp4 (67.08 MB)
MP4
005 Update For Tags.mp4 (23.42 MB)
MP4
001 Designing a Hashtag System.mp4 (98.12 MB)
MP4
002 Tables for Hashtags.mp4 (14.45 MB)
MP4
003 Including the Hashtag Table.mp4 (18.04 MB)
MP4
004 A Few More User Columns.mp4 (27.66 MB)
MP4
005 Why No Number of Followers or Posts.mp4 (17.1 MB)
MP4
001 Designing a Follower System.mp4 (26.49 MB)
MP4
001 Back to Postgres.mp4 (6.84 MB)
MP4
002 Creating Tables with Checks.mp4 (60.56 MB)
MP4
003 Posts Creation.mp4 (36.16 MB)
MP4
004 Comments Creation.mp4 (7.17 MB)
MP4
005 Likes Creation.mp4 (23.87 MB)
MP4
006 Photo Tags and Caption Tags.mp4 (41.35 MB)
MP4
007 Creating Hashtags, Hashtag Posts, and Followers.mp4 (19.85 MB)
MP4
002 Adding Some Data.mp4 (16.95 MB)
MP4
003 Restoring from Scratch.mp4 (21.23 MB)
MP4
004 Highest User ID's Exercise.mp4 (7.14 MB)
MP4
005 Solution for User ID's.mp4 (4.64 MB)
MP4
006 Posts by a Particular User.mp4 (4.81 MB)
MP4
007 Solving for Posts by User.mp4 (9.39 MB)
MP4
008 Likes Per User.mp4 (3.59 MB)
MP4
009 Solution for Likes Per User.mp4 (6.6 MB)
MP4
001 Thinking About Performance.mp4 (9.24 MB)
MP4
002 Where Does Postgres Store Data.mp4 (37.02 MB)
MP4
003 Heaps, Blocks, and Tuples.mp4 (22.73 MB)
MP4
004 Block Data Layout.mp4 (17.24 MB)
MP4
005 Heap File Layout.mp4 (597.17 MB)
MP4
001 Full Table Scans.mp4 (37.18 MB)
MP4
002 What's an Index.mp4 (10.1 MB)
MP4
003 How an Index Works.mp4 (69.31 MB)
MP4
004 Creating an Index.mp4 (13.11 MB)
MP4
005 Benchmarking Queries.mp4 (22.58 MB)
MP4
006 Downsides of Indexes.mp4 (31.82 MB)
MP4
007 Index Types.mp4 (6.46 MB)
MP4
008 Automatically Generated Indexes.mp4 (19.74 MB)
MP4
009 Behind the Scenes of Indexes.mp4 (398.75 MB)
MP4
001 The Query Processing Pipeline.mp4 (25.73 MB)
MP4
002 Explain and Explain Analyze.mp4 (42.83 MB)
MP4
003 Solving an Explain Mystery.mp4 (79.79 MB)
MP4
001 Developing an Intuitive Understanding of Cost.mp4 (102.89 MB)
MP4
002 Calculating Cost by Hand.mp4 (51.25 MB)
MP4
003 A Touch More on Costs.mp4 (95.4 MB)
MP4
004 Startup vs Total Costs.mp4 (44.7 MB)
MP4
005 Costs Flow Up.mp4 (10.1 MB)
MP4
006 Use My Index!.mp4 (39.4 MB)
MP4
001 Common Table Expressions.mp4 (11.19 MB)
MP4
002 A Quick Solution.mp4 (13.16 MB)
MP4
003 So What's a CTE.mp4 (33.5 MB)
MP4
001 Recursive CTE's.mp4 (11.9 MB)
MP4
002 Recursive CTE's Step by Step.mp4 (62.89 MB)
MP4
003 Why Use Recursive CTE's.mp4 (43.14 MB)
MP4
004 Writing the Query.mp4 (36.56 MB)
MP4
005 Walking Through Recursion.mp4 (109.41 MB)
MP4
001 Most Popular Users.mp4 (24.81 MB)
MP4
002 A Possible Solution for Merging Tables.mp4 (35.67 MB)
MP4
003 Creating a View.mp4 (33.33 MB)
MP4
004 When to Use a View.mp4 (21.21 MB)
MP4
005 Deleting and Changing Views.mp4 (12.51 MB)
MP4
001 Materialized Views.mp4 (8.38 MB)
MP4
002 Grouping by Week.mp4 (34.4 MB)
MP4
003 Reminder on Left Joins.mp4 (15.51 MB)
MP4
004 Writing a Slow Query.mp4 (55.08 MB)
MP4
005 Creating and Refreshing Materialized Views.mp4 (36.1 MB)
MP4
001 What are Transactions Used For.mp4 (22.54 MB)
MP4
002 Some Sample Data.mp4 (5.44 MB)
MP4
003 Opening and Closing Transactions.mp4 (65.33 MB)
MP4
004 Transaction Cleanup on Crash.mp4 (32.89 MB)
MP4
005 Closing Aborted Transactions.mp4 (7.47 MB)
MP4
001 A Story on Migrations.mp4 (139.7 MB)
MP4
002 Migration Files.mp4 (44.16 MB)
MP4
003 Issues Solved by Migrations.mp4 (10 MB)
MP4
004 A Few Notes on Migrations Libraries.mp4 (34.19 MB)
MP4
006 Project Creation.mp4 (9.91 MB)
MP4
007 Generating and Writing Migrations.mp4 (45.64 MB)
MP4
008 Applying and Reverting Migrations.mp4 (68.14 MB)
MP4
009 Generating and Applying a Second Migration.mp4 (16.63 MB)
MP4
001 Schema vs Data Migrations.mp4 (20.28 MB)
MP4
002 Dangers Around Data Migrations.mp4 (70 MB)
MP4
003 Properly Running Data and Schema Migrations.mp4 (19.73 MB)
MP4
004 Creating a Posts Table.mp4 (21.59 MB)
MP4
005 A Small Web Server.mp4 (62.26 MB)
MP4
007 Adding the Loc Column.mp4 (21.55 MB)
MP4
008 Writing Values to Both Columns.mp4 (16.26 MB)
MP4
009 Transaction Locks.mp4 (96.42 MB)
MP4
010 Updating Values.mp4 (15.27 MB)
MP4
012 Updating the App Server.mp4 (13.23 MB)
MP4
013 Dropping the Last Columns.mp4 (11.61 MB)
MP4
001 Section Goal.mp4 (2.62 MB)
MP4
002 Initial Setup.mp4 (2.23 MB)
MP4
003 One Fast Migration.mp4 (24.43 MB)
MP4
004 Building the Users Router.mp4 (29.61 MB)
MP4
005 Understanding Connection Pools.mp4 (22.93 MB)
MP4
006 Validating Connection Credentials.mp4 (44.74 MB)
MP4
007 Query and Close.mp4 (5.9 MB)
MP4
001 The Repository Pattern.mp4 (17.88 MB)
MP4
002 Creating a Repository.mp4 (24.78 MB)
MP4
003 Accessing the API.mp4 (23.55 MB)
MP4
004 Casing Issues.mp4 (18.55 MB)
MP4
005 Fixing Casing.mp4 (49.74 MB)
MP4
006 Finding Particular Users.mp4 (18.16 MB)
MP4
001 SQL Injection Exploits.mp4 (30.46 MB)
MP4
002 Handling SQL Injection with Prepared Statements.mp4 (38.15 MB)
MP4
003 Preventing SQL Injection.mp4 (34.29 MB)
MP4
004 Reminder on Post Requests.mp4 (14.4 MB)
MP4
005 Inserting Users.mp4 (15.25 MB)
MP4
006 Handling Updates.mp4 (16.66 MB)
MP4
007 And, Finally, Delete.mp4 (18.24 MB)
MP4
001 A Note on Testing.mp4 (7.64 MB)
MP4
002 Assertions Around User Count.mp4 (42.34 MB)
MP4
003 Connecting to a DB For Tests.mp4 (54.23 MB)
MP4
004 Disconnecting After Tests.mp4 (12.86 MB)
MP4
005 Multi-DB Setup.mp4 (21.85 MB)
MP4
006 Assumptions Around Content.mp4 (33.12 MB)
MP4
007 Issues with Parallel Tests.mp4 (35.76 MB)
MP4
008 Isolation with Schemas.mp4 (27.4 MB)
MP4
009 Creating and Accessing Schemas.mp4 (19.38 MB)
MP4
010 Controlling Schema Access with Search Paths.mp4 (30.95 MB)
MP4
011 Routing Schema Access.mp4 (41.12 MB)
MP4
012 Strategy for Isolation.mp4 (17.57 MB)
MP4
013 Programmatic Schema Creation.mp4 (65.75 MB)
MP4
014 Escaping Identifiers.mp4 (25.53 MB)
MP4
015 Test Helpers.mp4 (43.34 MB)
MP4
016 Cleaning up Schemas and Roles.mp4 (31.28 MB)
MP4
017 Finally Parallel Tests! (Final Lecture).mp4 (18.57 MB)
MP4
MP4
004 Database Design.mp4 (49.41 MB)
MP4
005 Creating Tables.mp4 (12.9 MB)
MP4
006 Analyzing CREATE TABLE.mp4 (17.67 MB)
MP4
007 Inserting Data Into a Table.mp4 (18.07 MB)
MP4
008 Retrieving Data with Select.mp4 (6.02 MB)
MP4
009 Calculated Columns.mp4 (15.22 MB)
MP4
010 Calculating Phone Revenue.mp4 (3.36 MB)
MP4
011 Exercise Solution.mp4 (3.15 MB)
MP4
012 String Operators and Functions.mp4 (16.34 MB)
MP4
001 Filtering Rows with Where.mp4 (12.26 MB)
MP4
002 More on the Where Keyword.mp4 (9.45 MB)
MP4
003 Compound Where Clauses.mp4 (18.98 MB)
MP4
004 A Where Exercise Overview.mp4 (1.72 MB)
MP4
005 A Where Solution.mp4 (2.54 MB)
MP4
006 Where With Lists.mp4 (1.59 MB)
MP4
007 A Where With Lists Solution.mp4 (4.96 MB)
MP4
008 Calculations in Where Clauses.mp4 (4.68 MB)
MP4
009 Solving Calculations.mp4 (5.91 MB)
MP4
010 Updating Rows.mp4 (17.3 MB)
MP4
011 Deleting Rows.mp4 (11.18 MB)
MP4
012 A Solution for Updating Rows.mp4 (4.94 MB)
MP4
013 Solution for Deleting Rows.mp4 (4 MB)
MP4
001 The Plan Moving Forward.mp4 (10.75 MB)
MP4
002 Approaching Database Design.mp4 (50.16 MB)
MP4
003 One-to-Many and Many-to-One Relationships.mp4 (41.31 MB)
MP4
004 One-to-One and Many-to-Many Relationships.mp4 (24.58 MB)
MP4
005 Primary Keys and Foreign Keys.mp4 (29.57 MB)
MP4
006 Understanding Foreign Keys.mp4 (63.35 MB)
MP4
007 Auto-Generated ID's.mp4 (22.97 MB)
MP4
008 Creating Foreign Key Columns.mp4 (18.32 MB)
MP4
009 Running Queries on Associated Data.mp4 (38.22 MB)
MP4
010 Exercise Overview.mp4 (8.25 MB)
MP4
011 Foreign Key Creation Solution.mp4 (8.35 MB)
MP4
012 Foreign Key Constraints Around Insertion.mp4 (22.15 MB)
MP4
013 Constraints Around Deletion.mp4 (40.54 MB)
MP4
015 Testing Deletion Constraints.mp4 (19.27 MB)
MP4
016 Setting Foreign Keys to Null on Delete.mp4 (12.6 MB)
MP4
017 Adding Some Complexity.mp4 (9.96 MB)
MP4
002 Queries with Joins and Aggregations.mp4 (27.86 MB)
MP4
003 Joining Data from Different Tables.mp4 (36.8 MB)
MP4
004 Another Quick Join.mp4 (8.62 MB)
MP4
005 Exercise Overview.mp4 (4.85 MB)
MP4
006 A Joinful Solution.mp4 (5.27 MB)
MP4
007 Alternate Forms of Syntax.mp4 (24.96 MB)
MP4
008 Missing Data in Joins.mp4 (29.27 MB)
MP4
009 Why Wasn't It Included.mp4 (24.58 MB)
MP4
010 Four Kinds of Joins.mp4 (124.86 MB)
MP4
011 Each Join in Practice.mp4 (40.6 MB)
MP4
012 Does Order Matter.mp4 (61.33 MB)
MP4
013 Exercise Overview.mp4 (2.23 MB)
MP4
014 Two Possible Solutions.mp4 (16.51 MB)
MP4
015 Where with Join.mp4 (31.03 MB)
MP4
016 Three Way Joins.mp4 (49.71 MB)
MP4
017 A Bit of Practice.mp4 (17.87 MB)
MP4
018 Exercise Solution.mp4 (7.67 MB)
MP4
001 Aggregating and Grouping.mp4 (7.9 MB)
MP4
002 Picturing Group By.mp4 (29.43 MB)
MP4
003 Aggregate Functions.mp4 (11.58 MB)
MP4
004 Combining Group By and Aggregates.mp4 (15.13 MB)
MP4
005 A Gotcha with Count.mp4 (5.46 MB)
MP4
006 Visualizing More Grouping.mp4 (9.72 MB)
MP4
007 Exercise Overview.mp4 (1.66 MB)
MP4
008 Grouping Solution.mp4 (3.15 MB)
MP4
009 Adding a Layer of Difficulty.mp4 (1.79 MB)
MP4
010 Solution.mp4 (3.68 MB)
MP4
011 Filtering Groups with Having.mp4 (36.97 MB)
MP4
012 Having In Action.mp4 (6.86 MB)
MP4
013 More on Having!.mp4 (28.46 MB)
MP4
014 A Having Exercise Overview.mp4 (12.79 MB)
MP4
015 A Quick Solution.mp4 (7.3 MB)
MP4
002 Investigating This Dataset.mp4 (8 MB)
MP4
003 Some Group By Practice.mp4 (3.1 MB)
MP4
004 Group By Review Solution.mp4 (7.92 MB)
MP4
005 Remember Joins.mp4 (9.3 MB)
MP4
006 Of Course You Remember!.mp4 (4.42 MB)
MP4
001 The Basics of Sorting.mp4 (6.73 MB)
MP4
002 Two Variations on Sorting.mp4 (9.46 MB)
MP4
003 Offset and Limit.mp4 (19.43 MB)
MP4
004 Exercise Overview.mp4 (1.08 MB)
MP4
005 Exercise Solution.mp4 (3.33 MB)
MP4
001 Handling Sets with Union.mp4 (19.51 MB)
MP4
002 A Few Notes on Union.mp4 (16.54 MB)
MP4
003 Commonalities with Intersect.mp4 (15.42 MB)
MP4
004 Removing Commonalities with Except.mp4 (20.44 MB)
MP4
005 Union Exercise Overview.mp4 (4.23 MB)
MP4
006 Exercise Solution.mp4 (4.72 MB)
MP4
001 What's a Subquery.mp4 (30.54 MB)
MP4
002 Thinking About the Structure of Data.mp4 (23.64 MB)
MP4
003 Subqueries in a Select.mp4 (22.54 MB)
MP4
004 Exercise Overview.mp4 (3.05 MB)
MP4
005 Select Solution.mp4 (3.8 MB)
MP4
006 Subqueries in a From.mp4 (44.45 MB)
MP4
007 From Subqueries that Return a Value.mp4 (9.08 MB)
MP4
008 Example of a Subquery in a From.mp4 (53.51 MB)
MP4
009 Exercise Overview.mp4 (3.4 MB)
MP4
010 Exercise Solution.mp4 (10.37 MB)
MP4
011 Subqueries in a Join Clause.mp4 (16.55 MB)
MP4
012 More Useful - Subqueries with Where.mp4 (36.66 MB)
MP4
013 Data Structure with Where Subqueries.mp4 (44.04 MB)
MP4
014 Exercise Overview.mp4 (2.71 MB)
MP4
015 Exercise Solution.mp4 (6.25 MB)
MP4
016 The Not In Operator with a List.mp4 (38.59 MB)
MP4
017 A New Where Operator.mp4 (38.71 MB)
MP4
018 Finally Some!.mp4 (31.96 MB)
MP4
019 Exercise Overview.mp4 (1.23 MB)
MP4
020 A Quick Solution.mp4 (4.37 MB)
MP4
021 Probably Too Much About Correlated Subqueries.mp4 (107 MB)
MP4
022 More on Correlated Subqueries.mp4 (44.16 MB)
MP4
023 A Select Without a From.mp4 (9.09 MB)
MP4
024 Exercise Overview.mp4 (1.95 MB)
MP4
025 Exercise Solution.mp4 (3.57 MB)
MP4
001 Selecting Distinct Values.mp4 (12.46 MB)
MP4
002 Exercise Overview.mp4 (1.3 MB)
MP4
003 A Distinct Solution.mp4 (1.9 MB)
MP4
001 The Greatest Value in a List.mp4 (11.77 MB)
MP4
002 And the Least Value in a List!.mp4 (5.55 MB)
MP4
003 The Case Keyword.mp4 (13.32 MB)
MP4
001 PostgreSQL Installation on macOS.mp4 (21.13 MB)
MP4
002 PGAdmin Setup on macOS.mp4 (36.92 MB)
MP4
003 Postgres installation on Windows.mp4 (23.31 MB)
MP4
001 What'd We Just Do.mp4 (19.32 MB)
MP4
002 Data Types.mp4 (30.53 MB)
MP4
003 Fast Rules on Numeric Data Types.mp4 (18.9 MB)
MP4
004 More on Number Data Types.mp4 (48.13 MB)
MP4
005 Reminder on Character Types.mp4 (29.9 MB)
MP4
006 Boolean Data Types.mp4 (8.2 MB)
MP4
007 Times, Dates, and Timestamps.mp4 (21.27 MB)
MP4
008 Really Awesome Intervals.mp4 (19.5 MB)
MP4
001 Thinking About Validation.mp4 (34.64 MB)
MP4
002 Creating and Viewing Tables in PGAdmin.mp4 (28.09 MB)
MP4
003 Applying a Null Constraint.mp4 (21.08 MB)
MP4
004 Solving a Gotcha with Null Constraints.mp4 (13.72 MB)
MP4
005 Default Column Values.mp4 (22.47 MB)
MP4
006 Applying a Unique Constraint to One column.mp4 (43.13 MB)
MP4
007 Multi-Column Uniqueness.mp4 (30.06 MB)
MP4
008 Adding a Validation Check.mp4 (18.21 MB)
MP4
009 Checks Over Multiple Columns.mp4 (17.21 MB)
MP4
010 So Where Are We Applying Validation.mp4 (22.04 MB)
MP4
001 Approaching More Complicated Designs.mp4 (11.21 MB)
MP4
002 Using a SQL Design Tool.mp4 (47.29 MB)
MP4
003 A Config-based Schema Designer.mp4 (28.69 MB)
MP4
004 Here's the Plan.mp4 (9.63 MB)
MP4
005 Rebuilding Some Schema.mp4 (20.94 MB)
MP4
001 Requirements of a Like System.mp4 (26.11 MB)
MP4
002 How Not to Design a Like System.mp4 (16.22 MB)
MP4
003 Designing a Like System.mp4 (26.14 MB)
MP4
004 Making a Reaction System Instead.mp4 (6.39 MB)
MP4
005 Polymorphic Associations.mp4 (52.6 MB)
MP4
006 Polymorphic Association Alternative Implementation.mp4 (63.84 MB)
MP4
007 The Simplest Alternative.mp4 (26.94 MB)
MP4
008 So Which Approach.mp4 (16.02 MB)
MP4
001 Additional Features Around Posts.mp4 (95.79 MB)
MP4
002 Adding Captions and Locations.mp4 (8.53 MB)
MP4
003 Photo Mentions vs Caption Mentions.mp4 (73.41 MB)
MP4
004 Considerations on Photo Tags vs Caption Tags.mp4 (67.08 MB)
MP4
005 Update For Tags.mp4 (23.42 MB)
MP4
001 Designing a Hashtag System.mp4 (98.12 MB)
MP4
002 Tables for Hashtags.mp4 (14.45 MB)
MP4
003 Including the Hashtag Table.mp4 (18.04 MB)
MP4
004 A Few More User Columns.mp4 (27.66 MB)
MP4
005 Why No Number of Followers or Posts.mp4 (17.1 MB)
MP4
001 Designing a Follower System.mp4 (26.49 MB)
MP4
001 Back to Postgres.mp4 (6.84 MB)
MP4
002 Creating Tables with Checks.mp4 (60.56 MB)
MP4
003 Posts Creation.mp4 (36.16 MB)
MP4
004 Comments Creation.mp4 (7.17 MB)
MP4
005 Likes Creation.mp4 (23.87 MB)
MP4
006 Photo Tags and Caption Tags.mp4 (41.35 MB)
MP4
007 Creating Hashtags, Hashtag Posts, and Followers.mp4 (19.85 MB)
MP4
002 Adding Some Data.mp4 (16.95 MB)
MP4
003 Restoring from Scratch.mp4 (21.23 MB)
MP4
004 Highest User ID's Exercise.mp4 (7.14 MB)
MP4
005 Solution for User ID's.mp4 (4.64 MB)
MP4
006 Posts by a Particular User.mp4 (4.81 MB)
MP4
007 Solving for Posts by User.mp4 (9.39 MB)
MP4
008 Likes Per User.mp4 (3.59 MB)
MP4
009 Solution for Likes Per User.mp4 (6.6 MB)
MP4
001 Thinking About Performance.mp4 (9.24 MB)
MP4
002 Where Does Postgres Store Data.mp4 (37.02 MB)
MP4
003 Heaps, Blocks, and Tuples.mp4 (22.73 MB)
MP4
004 Block Data Layout.mp4 (17.24 MB)
MP4
005 Heap File Layout.mp4 (597.17 MB)
MP4
001 Full Table Scans.mp4 (37.18 MB)
MP4
002 What's an Index.mp4 (10.1 MB)
MP4
003 How an Index Works.mp4 (69.31 MB)
MP4
004 Creating an Index.mp4 (13.11 MB)
MP4
005 Benchmarking Queries.mp4 (22.58 MB)
MP4
006 Downsides of Indexes.mp4 (31.82 MB)
MP4
007 Index Types.mp4 (6.46 MB)
MP4
008 Automatically Generated Indexes.mp4 (19.74 MB)
MP4
009 Behind the Scenes of Indexes.mp4 (398.75 MB)
MP4
001 The Query Processing Pipeline.mp4 (25.73 MB)
MP4
002 Explain and Explain Analyze.mp4 (42.83 MB)
MP4
003 Solving an Explain Mystery.mp4 (79.79 MB)
MP4
001 Developing an Intuitive Understanding of Cost.mp4 (102.89 MB)
MP4
002 Calculating Cost by Hand.mp4 (51.25 MB)
MP4
003 A Touch More on Costs.mp4 (95.4 MB)
MP4
004 Startup vs Total Costs.mp4 (44.7 MB)
MP4
005 Costs Flow Up.mp4 (10.1 MB)
MP4
006 Use My Index!.mp4 (39.4 MB)
MP4
001 Common Table Expressions.mp4 (11.19 MB)
MP4
002 A Quick Solution.mp4 (13.16 MB)
MP4
003 So What's a CTE.mp4 (33.5 MB)
MP4
001 Recursive CTE's.mp4 (11.9 MB)
MP4
002 Recursive CTE's Step by Step.mp4 (62.89 MB)
MP4
003 Why Use Recursive CTE's.mp4 (43.14 MB)
MP4
004 Writing the Query.mp4 (36.56 MB)
MP4
005 Walking Through Recursion.mp4 (109.41 MB)
MP4
001 Most Popular Users.mp4 (24.81 MB)
MP4
002 A Possible Solution for Merging Tables.mp4 (35.67 MB)
MP4
003 Creating a View.mp4 (33.33 MB)
MP4
004 When to Use a View.mp4 (21.21 MB)
MP4
005 Deleting and Changing Views.mp4 (12.51 MB)
MP4
001 Materialized Views.mp4 (8.38 MB)
MP4
002 Grouping by Week.mp4 (34.4 MB)
MP4
003 Reminder on Left Joins.mp4 (15.51 MB)
MP4
004 Writing a Slow Query.mp4 (55.08 MB)
MP4
005 Creating and Refreshing Materialized Views.mp4 (36.1 MB)
MP4
001 What are Transactions Used For.mp4 (22.54 MB)
MP4
002 Some Sample Data.mp4 (5.44 MB)
MP4
003 Opening and Closing Transactions.mp4 (65.33 MB)
MP4
004 Transaction Cleanup on Crash.mp4 (32.89 MB)
MP4
005 Closing Aborted Transactions.mp4 (7.47 MB)
MP4
001 A Story on Migrations.mp4 (139.7 MB)
MP4
002 Migration Files.mp4 (44.16 MB)
MP4
003 Issues Solved by Migrations.mp4 (10 MB)
MP4
004 A Few Notes on Migrations Libraries.mp4 (34.19 MB)
MP4
006 Project Creation.mp4 (9.91 MB)
MP4
007 Generating and Writing Migrations.mp4 (45.64 MB)
MP4
008 Applying and Reverting Migrations.mp4 (68.14 MB)
MP4
009 Generating and Applying a Second Migration.mp4 (16.63 MB)
MP4
001 Schema vs Data Migrations.mp4 (20.28 MB)
MP4
002 Dangers Around Data Migrations.mp4 (70 MB)
MP4
003 Properly Running Data and Schema Migrations.mp4 (19.73 MB)
MP4
004 Creating a Posts Table.mp4 (21.59 MB)
MP4
005 A Small Web Server.mp4 (62.26 MB)
MP4
007 Adding the Loc Column.mp4 (21.55 MB)
MP4
008 Writing Values to Both Columns.mp4 (16.26 MB)
MP4
009 Transaction Locks.mp4 (96.42 MB)
MP4
010 Updating Values.mp4 (15.27 MB)
MP4
012 Updating the App Server.mp4 (13.23 MB)
MP4
013 Dropping the Last Columns.mp4 (11.61 MB)
MP4
001 Section Goal.mp4 (2.62 MB)
MP4
002 Initial Setup.mp4 (2.23 MB)
MP4
003 One Fast Migration.mp4 (24.43 MB)
MP4
004 Building the Users Router.mp4 (29.61 MB)
MP4
005 Understanding Connection Pools.mp4 (22.93 MB)
MP4
006 Validating Connection Credentials.mp4 (44.74 MB)
MP4
007 Query and Close.mp4 (5.9 MB)
MP4
001 The Repository Pattern.mp4 (17.88 MB)
MP4
002 Creating a Repository.mp4 (24.78 MB)
MP4
003 Accessing the API.mp4 (23.55 MB)
MP4
004 Casing Issues.mp4 (18.55 MB)
MP4
005 Fixing Casing.mp4 (49.74 MB)
MP4
006 Finding Particular Users.mp4 (18.16 MB)
MP4
001 SQL Injection Exploits.mp4 (30.46 MB)
MP4
002 Handling SQL Injection with Prepared Statements.mp4 (38.15 MB)
MP4
003 Preventing SQL Injection.mp4 (34.29 MB)
MP4
004 Reminder on Post Requests.mp4 (14.4 MB)
MP4
005 Inserting Users.mp4 (15.25 MB)
MP4
006 Handling Updates.mp4 (16.66 MB)
MP4
007 And, Finally, Delete.mp4 (18.24 MB)
MP4
001 A Note on Testing.mp4 (7.64 MB)
MP4
002 Assertions Around User Count.mp4 (42.34 MB)
MP4
003 Connecting to a DB For Tests.mp4 (54.23 MB)
MP4
004 Disconnecting After Tests.mp4 (12.86 MB)
MP4
005 Multi-DB Setup.mp4 (21.85 MB)
MP4
006 Assumptions Around Content.mp4 (33.12 MB)
MP4
007 Issues with Parallel Tests.mp4 (35.76 MB)
MP4
008 Isolation with Schemas.mp4 (27.4 MB)
MP4
009 Creating and Accessing Schemas.mp4 (19.38 MB)
MP4
010 Controlling Schema Access with Search Paths.mp4 (30.95 MB)
MP4
011 Routing Schema Access.mp4 (41.12 MB)
MP4
012 Strategy for Isolation.mp4 (17.57 MB)
MP4
013 Programmatic Schema Creation.mp4 (65.75 MB)
MP4
014 Escaping Identifiers.mp4 (25.53 MB)
MP4
015 Test Helpers.mp4 (43.34 MB)
MP4
016 Cleaning up Schemas and Roles.mp4 (31.28 MB)
MP4
017 Finally Parallel Tests! (Final Lecture).mp4 (18.57 MB)
MP4
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!