magnet:?xt=urn:btih:B2E0C657EB287DFD4133F18CB80B69E4D3BA87BF
29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.mp4 205.3 MB28 Window Functions/015 Understanding window frames.mp4 194.1 MB44 Managing PostgreSQL security/009 Row Level Security.mp4 177.6 MB20 PostgreSQL Schemas/005 Schema search path.mp4 162.8 MB30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.mp4 157.5 MB33 Functions with SQL language/009 Function using parameters Part 3.mp4 139.3 MB31 Table Partitions/006 Partition by List.mp4 137.1 MB23 Indexes and Performance Optimization/030 Expression Index.mp4 125.9 MB48 Extended PostgreSQL/001 Create a custom index method.mp4 125.3 MB16 Using DATE_TIME functions/022 date_part function.mp4 125.0 MB27 Grouping sets/002 Subtotals on group sets.mp4 120.2 MB27 Grouping sets/004 Using GROUPING with ROLLUP.mp4 118.0 MB31 Table Partitions/005 Partition by Range.mp4 107.7 MB23 Indexes and Performance Optimization/027 Using organized vs random data.mp4 104.5 MB23 Indexes and Performance Optimization/032 Invalidating an index.mp4 103.7 MB28 Window Functions/002 Analyze Global Trades Data.mp4 101.4 MB37 Using Cursors/010 Using a parametric cursor via function.mp4 96.7 MB06 Filtering Data/009 Using Logical operators.mp4 94.8 MB38 Creating Crosstab Reports/011 Dynamic pivot table columns.mp4 94.7 MB46 PostgreSQL Internals/604 internal - view system administration functions.mp4 93.6 MB12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.mp4 93.3 MB06 Filtering Data/010 Using LIMIT and OFFSET.mp4 93.3 MB06 Filtering Data/014 Using LIKE and ILIKE.mp4 92.3 MB18 Joining Multiple Tables/007 LEFT joins Part 1.mp4 91.5 MB31 Table Partitions/002 When a partition can be used_.mp4 90.6 MB17 Grouping Data/004 Using HAVING.mp4 89.2 MB36 PostgreSQL Triggers/014 Creating an audit trigger.mp4 88.7 MB06 Filtering Data/011 Using FETCH.mp4 87.9 MB45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.mp4 87.6 MB18 Joining Multiple Tables/001 INNER joins.mp4 86.7 MB22 JSON with PostgreSQL/017 Indexing on JSONB.mp4 86.1 MB33 Functions with SQL language/010 Function using parameters Part 4.mp4 84.2 MB47 Managing Tables/001 Using SELECT INTO to create a new table with joins.mp4 84.1 MB28 Window Functions/013 Ordering inside window.mp4 83.1 MB36 PostgreSQL Triggers/015 Creating conditional triggers.mp4 81.8 MB38 Creating Crosstab Reports/012 Interactive client-side pivot.mp4 81.7 MB23 Indexes and Performance Optimization/002 Create an index.mp4 81.6 MB28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4 81.5 MB07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.mp4 81.0 MB46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.mp4 79.6 MB33 Functions with SQL language/007 Function using parameters.mp4 79.2 MB36 PostgreSQL Triggers/022 Creating an audit event trigger.mp4 78.9 MB23 Indexes and Performance Optimization/019 The EXPLAIN statement.mp4 78.4 MB26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.mp4 77.9 MB26 Common Table Expressions (CTE)/002 CTE query examples.mp4 77.2 MB28 Window Functions/021 LEAD and LAG functions.mp4 76.5 MB18 Joining Multiple Tables/020 Append tables with different columns.mp4 74.2 MB44 Managing PostgreSQL security/007 Table Level Security.mp4 73.9 MB44 Managing PostgreSQL security/015 Encrypted data in columns.mp4 73.1 MB34 Functions with PL_pgSQL language/026 Using RETURN NEXT.mp4 73.0 MB06 Filtering Data/012 Using IN, NOT IN.mp4 71.9 MB22 JSON with PostgreSQL/013 Getting information from JSON documents.mp4 71.8 MB15 Aggregate functions/003 MIN and MAX functions.mp4 71.7 MB33 Functions with SQL language/011 Function returning a composite.mp4 71.1 MB34 Functions with PL_pgSQL language/030 Exception with data exception errors.mp4 70.9 MB31 Table Partitions/003 Table inheritance.mp4 69.8 MB25 Fun with subqueries/002 Subqueries with WHERE Clause.mp4 69.2 MB24 All about Views/024 Using materialized view for websites page analysis.mp4 66.8 MB30 Powerful text searches in PostgreSQL/004 Full text search within a table.mp4 66.6 MB21 Exploring array functions/017 Array vs JSONB.mp4 66.4 MB31 Table Partitions/007 Partition by Hash.mp4 66.1 MB31 Table Partitions/009 Multi-level partitioning.mp4 65.4 MB38 Creating Crosstab Reports/013 Handling missing values.mp4 65.3 MB07 PostgreSQL Data types/014 Network Addresses.mp4 65.0 MB38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.mp4 64.9 MB06 Filtering Data/002 AND operator.mp4 64.6 MB15 Aggregate functions/005 Average with AVG function.mp4 64.5 MB06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.mp4 64.4 MB28 Window Functions/016 ROWS and RANGE indicators.mp4 64.3 MB17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.mp4 64.1 MB16 Using DATE_TIME functions/004 Strings to Dates conversions.mp4 64.0 MB18 Joining Multiple Tables/014 Joining multiple tables.mp4 63.9 MB16 Using DATE_TIME functions/006 Formatting Dates.mp4 63.8 MB34 Functions with PL_pgSQL language/016 CASE Statement.mp4 63.8 MB07 PostgreSQL Data types/008 TIME.mp4 63.8 MB16 Using DATE_TIME functions/021 How to handle timezones.mp4 63.6 MB12 Explore PostgreSQL Constraints/003 UNIQUE constraint.mp4 63.2 MB09 Data type conversions/002 Using CAST for data conversions.mp4 62.4 MB23 Indexes and Performance Optimization/023 Index are not free.mp4 61.5 MB47 Managing Tables/012 Recovering unused space with VACUUM.mp4 61.4 MB22 JSON with PostgreSQL/011 Null Values in JSON documents.mp4 61.3 MB47 Managing Tables/011 PostgreSQL autovacuum proces.mp4 60.6 MB16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.mp4 60.6 MB39 Internationalization/001 Global Character Set Support.mp4 60.5 MB38 Creating Crosstab Reports/008 Aggregate over filter.mp4 60.3 MB23 Indexes and Performance Optimization/003 Create unique indexes.mp4 60.1 MB39 Internationalization/002 Client and Server Encoding.mp4 60.0 MB34 Functions with PL_pgSQL language/024 Using RETURN QUERY.mp4 59.7 MB18 Joining Multiple Tables/003 INNER joins with filter data Part 1.mp4 59.7 MB03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.mp4 59.6 MB23 Indexes and Performance Optimization/022 Understanding query cost model.mp4 59.3 MB40 PostgreSQL Transactions/005 Transaction analysis.mp4 59.0 MB23 Indexes and Performance Optimization/029 Partial indexes.mp4 58.5 MB17 Grouping Data/001 Using GROUP BY.mp4 58.5 MB12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.mp4 58.5 MB18 Joining Multiple Tables/017 CROSS Joins.mp4 58.5 MB21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.mp4 58.3 MB33 Functions with SQL language/015 Function as a table source.mp4 58.1 MB24 All about Views/019 Changing materialized view data.mp4 58.0 MB33 Functions with SQL language/012 Function returning multiple rows.mp4 57.9 MB47 Managing Tables/013 Generated Columns.mp4 57.8 MB07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.mp4 57.5 MB24 All about Views/002 Creating a view.mp4 57.2 MB07 PostgreSQL Data types/001 Boolean.mp4 57.2 MB18 Joining Multiple Tables/011 RIGHT joins.mp4 57.1 MB19 Combining queries together/001 Combine results sets with UNION.mp4 57.0 MB28 Window Functions/023 ROW_NUMBER function.mp4 56.4 MB22 JSON with PostgreSQL/006 Update and Delete JSON Data.mp4 55.8 MB36 PostgreSQL Triggers/005 Pros and Cons of triggers.mp4 55.4 MB34 Functions with PL_pgSQL language/023 WHILE loop.mp4 55.0 MB07 PostgreSQL Data types/013 JSON.mp4 54.9 MB30 Powerful text searches in PostgreSQL/002 Introducing tsvector.mp4 54.8 MB25 Fun with subqueries/009 Correlated Queries.mp4 54.3 MB12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.mp4 54.1 MB18 Joining Multiple Tables/009 LEFT joins Part 3.mp4 53.6 MB06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.mp4 53.2 MB07 PostgreSQL Data types/010 UUID.mp4 52.8 MB33 Functions with SQL language/001 Creating our first SQL function.mp4 52.6 MB33 Functions with SQL language/004 Function returning a single value.mp4 52.6 MB18 Joining Multiple Tables/002 INNER joins with USING.mp4 52.6 MB36 PostgreSQL Triggers/010 Modify data at INSERT event.mp4 51.9 MB44 Managing PostgreSQL security/006 Schema Level Security.mp4 51.2 MB46 PostgreSQL Internals/006 View privileges information across tables.mp4 51.1 MB05 Querying Data/003 Adding Aliases to columns in a table.mp4 50.8 MB41 Using Northwind Database/009 Freight analysis.mp4 50.6 MB16 Using DATE_TIME functions/023 date_trunc function.mp4 50.6 MB28 Window Functions/003 Using aggregate functions.mp4 49.9 MB21 Exploring array functions/016 Using Multi-dimensional arrays.mp4 49.9 MB25 Fun with subqueries/004 Subquery with JOINs.mp4 49.7 MB25 Fun with subqueries/012 Using ALL with subquery.mp4 49.6 MB20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.mp4 49.6 MB48 Extended PostgreSQL/002 Create a user-defined aggregate function.mp4 49.4 MB28 Window Functions/034 Comparing with least number.mp4 49.3 MB16 Using DATE_TIME functions/011 Using math operators with dates.mp4 49.0 MB30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.mp4 48.7 MB36 PostgreSQL Triggers/002 What is a trigger.mp4 48.5 MB34 Functions with PL_pgSQL language/017 Searched CASE statement.mp4 48.4 MB38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.mp4 48.3 MB36 PostgreSQL Triggers/008 Data auditing with a trigger.mp4 48.2 MB37 Using Cursors/009 Creating a PL_PGSQL Cursor.mp4 48.0 MB12 Explore PostgreSQL Constraints/002 NOT NULL constraint.mp4 47.6 MB33 Functions with SQL language/017 Function parameters with default values.mp4 47.4 MB15 Aggregate functions/006 Combining Columns using Mathematical operators.mp4 47.3 MB19 Combining queries together/002 UNION with filters and conditions.mp4 46.9 MB16 Using DATE_TIME functions/001 Datetimes data types.mp4 46.4 MB30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.mp4 46.4 MB28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.mp4 46.3 MB24 All about Views/016 What is a Materialized View.mp4 46.2 MB16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.mp4 46.2 MB10 Conversion Functions/001 to_char.mp4 46.1 MB16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.mp4 46.1 MB36 PostgreSQL Triggers/012 Disallow DELETE on a table.mp4 45.5 MB05 Querying Data/005 Using ORDER BY to sort records.mp4 45.4 MB07 PostgreSQL Data types/003 NUMERIC.mp4 45.3 MB08 Modifying Table Structures, Add constraints/003 Add constraints to columns.mp4 45.2 MB30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.mp4 45.0 MB18 Joining Multiple Tables/008 LEFT joins Part 2.mp4 45.0 MB46 PostgreSQL Internals/002 List all database and schemas.mp4 45.0 MB41 Using Northwind Database/014 Late shipped orders by employees.mp4 44.9 MB37 Using Cursors/001 Understanding row by row operations.mp4 44.9 MB47 Managing Tables/003 Import data from CSV files.mp4 44.8 MB37 Using Cursors/005 Opening a cursor.mp4 44.7 MB07 PostgreSQL Data types/004 DECIMALS.mp4 44.6 MB24 All about Views/014 Updatable views using WITH CHECK OPTION.mp4 44.6 MB24 All about Views/007 Connecting multiple tables with a single view.mp4 44.4 MB38 Creating Crosstab Reports/007 Matrix report via a query.mp4 44.3 MB32 Server Programming/001 PostgreSQL as a development platform_.mp4 44.1 MB12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.mp4 44.0 MB23 Indexes and Performance Optimization/013 Index Nodes.mp4 43.9 MB03 Creating and Modifying Tables/007 Install sample data for 'movies' database.mp4 43.0 MB17 Grouping Data/007 Handling NULL values with GROUP BY.mp4 42.8 MB20 PostgreSQL Schemas/007 Duplicate a schema along with all data.mp4 42.8 MB24 All about Views/005 Using filters with views.mp4 42.6 MB38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.mp4 42.6 MB14 String Functions/002 LEFT and RIGHT.mp4 42.4 MB25 Fun with subqueries/011 Using ANY with subquery.mp4 42.4 MB24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 42.2 MB34 Functions with PL_pgSQL language/010 Assigning variables from query.mp4 42.1 MB46 PostgreSQL Internals/003 List all tables and views.mp4 41.9 MB40 PostgreSQL Transactions/001 What is a transaction_.mp4 41.7 MB12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.mp4 41.6 MB29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.mp4 41.5 MB25 Fun with subqueries/010 SELECT.. IN (Subquery).mp4 41.2 MB05 Querying Data/001 Select all data from a table.mp4 41.1 MB23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.mp4 41.1 MB16 Using DATE_TIME functions/018 Date accuracy with EPOCH.mp4 40.7 MB31 Table Partitions/011 ALTERing the partition bounds.mp4 40.4 MB04 Modifying Data in the tables/009 Using UPSERT.mp4 40.3 MB40 PostgreSQL Transactions/003 ACID Database.mp4 40.2 MB41 Using Northwind Database/013 Orders with double entry line items.mp4 40.1 MB28 Window Functions/020 NTILE function.mp4 39.9 MB15 Aggregate functions/001 Counting results via COUNT function.mp4 39.9 MB15 Aggregate functions/002 Sum with SUM function.mp4 39.7 MB24 All about Views/021 Refreshing data in materialize views.mp4 39.6 MB41 Using Northwind Database/018 First order from each country.mp4 39.5 MB18 Joining Multiple Tables/010 LEFT joins Part 4.mp4 39.4 MB37 Using Cursors/006 Using a cursor.mp4 39.3 MB29 Using regular expressions for text patterns/002 Regular expressions notations table.mp4 39.1 MB23 Indexes and Performance Optimization/014 Join Nodes.mp4 38.9 MB16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.mp4 38.9 MB36 PostgreSQL Triggers/023 Prevent schema changes.mp4 38.9 MB21 Exploring array functions/009 Formatting and converting an array.mp4 38.8 MB21 Exploring array functions/005 Array metadata functions.mp4 38.5 MB13 PostgreSQL Sequences/007 Attach a sequence to a table column.mp4 38.3 MB23 Indexes and Performance Optimization/012 Sequential Nodes.mp4 38.3 MB16 Using DATE_TIME functions/010 Date Value Extractors functions.mp4 38.0 MB23 Indexes and Performance Optimization/024 Indexes for sorted output.mp4 37.8 MB20 PostgreSQL Schemas/010 Schemas and Privileges.mp4 37.7 MB26 Common Table Expressions (CTE)/003 Combine CTE with a table.mp4 37.7 MB28 Window Functions/017 Using WINDOW.mp4 37.5 MB36 PostgreSQL Triggers/009 Bind a function to a table with trigger.mp4 37.2 MB18 Joining Multiple Tables/015 Self Joins Part 1.mp4 37.2 MB28 Window Functions/029 ROW_NUMBER() - Pagination technique.mp4 37.0 MB37 Using Cursors/004 Creating a cursor.mp4 37.0 MB21 Exploring array functions/003 Using inclusion operators.mp4 36.7 MB44 Managing PostgreSQL security/008 Column Level Security.mp4 36.7 MB08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.mp4 36.6 MB23 Indexes and Performance Optimization/010 The query optimizer.mp4 36.5 MB34 Functions with PL_pgSQL language/015 Using IF with table data.mp4 36.1 MB12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.mp4 35.9 MB21 Exploring array functions/002 Using comparison operators.mp4 35.9 MB06 Filtering Data/016 Concatenation techniques.mp4 35.7 MB35 Exploring Stored Procedures/002 Create a transactions.mp4 35.7 MB22 JSON with PostgreSQL/002 JSON Syntax.mp4 35.6 MB24 All about Views/001 Introduction to views.mp4 35.5 MB41 Using Northwind Database/017 Customers with multiple orders.mp4 35.5 MB31 Table Partitions/008 DEFAULT Partition.mp4 34.8 MB14 String Functions/004 SPLIT_PART.mp4 34.6 MB34 Functions with PL_pgSQL language/014 Control Structures - IF statement.mp4 34.3 MB33 Functions with SQL language/018 Function based on views.mp4 34.2 MB14 String Functions/009 STRPOS.mp4 34.1 MB31 Table Partitions/014 Determining a field for partition over.mp4 34.1 MB27 Grouping sets/003 Adding subtotal with ROLLUP.mp4 34.1 MB18 Joining Multiple Tables/005 INNER joins with filter data Part 3.mp4 34.1 MB23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.mp4 34.0 MB26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.mp4 34.0 MB34 Functions with PL_pgSQL language/013 How to return query results.mp4 33.9 MB14 String Functions/006 LPAD and RPAD.mp4 33.9 MB12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.mp4 33.9 MB11 User-defined Data Types/013 Update an ENUM data in production server.mp4 33.8 MB06 Filtering Data/004 Combining AND, OR operators.mp4 33.8 MB42 Using Human Resource (hr) database/013 Discard characters from employees email address.mp4 33.7 MB28 Window Functions/014 Sliding dynamic windows.mp4 33.5 MB21 Exploring array functions/001 Constructing arrays and ranges.mp4 33.3 MB40 PostgreSQL Transactions/007 How to fix transactions on crash.mp4 33.3 MB22 JSON with PostgreSQL/005 Create our first table with JSONB data type.mp4 33.3 MB07 PostgreSQL Data types/012 hstore.mp4 33.3 MB13 PostgreSQL Sequences/010 Create an alphanumeric sequence.mp4 33.2 MB31 Table Partitions/012 Partition Indexes.mp4 33.2 MB02 Introduction to PostgreSQL/010 Install northwind database.mp4 33.2 MB47 Managing Tables/010 Tracking table size.mp4 32.9 MB09 Data type conversions/001 What is a data type conversion.mp4 32.7 MB47 Managing Tables/005 Deleting duplicate records.mp4 32.5 MB10 Conversion Functions/004 to_timestamp.mp4 32.4 MB29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.mp4 32.3 MB13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.mp4 31.7 MB47 Managing Tables/004 Export Data to CSV files.mp4 31.6 MB21 Exploring array functions/007 Array modification functions.mp4 31.6 MB36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.mp4 31.5 MB07 PostgreSQL Data types/011 Array.mp4 31.2 MB09 Data type conversions/004 Table data conversion.mp4 31.1 MB23 Indexes and Performance Optimization/033 Rebuilding an index.mp4 30.9 MB24 All about Views/013 An updatable view with CRUD operations.mp4 30.7 MB21 Exploring array functions/006 Array search functions.mp4 30.6 MB29 Using regular expressions for text patterns/003 SIMILAR TO operator.mp4 30.5 MB21 Exploring array functions/012 Query array data.mp4 30.3 MB38 Creating Crosstab Reports/009 Static to dynamic pivots.mp4 30.3 MB22 JSON with PostgreSQL/008 Use json_agg to aggregate data.mp4 30.2 MB11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 30.2 MB33 Functions with SQL language/005 Function returning a single value Part 2.mp4 30.1 MB10 Conversion Functions/003 to_date.mp4 29.9 MB33 Functions with SQL language/008 Function using parameters Part 2.mp4 29.8 MB23 Indexes and Performance Optimization/026 Execution plans depends on input values.mp4 29.8 MB22 JSON with PostgreSQL/007 Create JSON from tables.mp4 29.7 MB02 Introduction to PostgreSQL/009 Install sample stocks market data.mp4 29.7 MB20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).mp4 29.6 MB23 Indexes and Performance Optimization/009 SQL statement execution stages.mp4 29.5 MB47 Managing Tables/009 Database operations and table size.mp4 29.2 MB22 JSON with PostgreSQL/010 Creating a document from data.mp4 29.2 MB46 PostgreSQL Internals/007 Using system Administration functions.mp4 29.2 MB28 Window Functions/011 Partitioning the data.mp4 29.1 MB20 PostgreSQL Schemas/001 What is a Schema_.mp4 28.6 MB14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.mp4 28.6 MB11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.mp4 28.3 MB16 Using DATE_TIME functions/007 Date construction functions.mp4 28.2 MB31 Table Partitions/001 What is a partition.mp4 28.1 MB28 Window Functions/039 Using PARTITION BY for group averages.mp4 28.1 MB16 Using DATE_TIME functions/013 Date _ Time Functions.mp4 28.1 MB20 PostgreSQL Schemas/003 Schema Hierarchy.mp4 28.0 MB31 Table Partitions/010 Partition maintenance.mp4 28.0 MB32 Server Programming/003 Keep the data on the server!.mp4 28.0 MB22 JSON with PostgreSQL/004 Exploring JSON objects.mp4 28.0 MB28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.mp4 28.0 MB20 PostgreSQL Schemas/008 What is a system catalog schema_.mp4 27.7 MB33 Functions with SQL language/006 Function returning a single value Part 3.mp4 27.6 MB35 Exploring Stored Procedures/004 Returning a value.mp4 27.6 MB05 Querying Data/010 Using DISTINCT for selecting distinct values.mp4 27.3 MB07 PostgreSQL Data types/007 DATE.mp4 27.1 MB02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.mp4 27.0 MB07 PostgreSQL Data types/005 Selecting Numbers data types.mp4 26.9 MB35 Exploring Stored Procedures/003 Understanding the use of stored procedures.mp4 26.8 MB44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.mp4 26.8 MB28 Window Functions/031 Calculate difference compared to average.mp4 26.6 MB28 Window Functions/041 Using WITH clause to set ORDER BY values.mp4 26.6 MB28 Window Functions/030 Using OVER() to calculate percentage.mp4 25.9 MB16 Using DATE_TIME functions/003 Time of day formats and inputs.mp4 25.9 MB26 Common Table Expressions (CTE)/001 Introduction to CTEs.mp4 25.9 MB35 Exploring Stored Procedures/001 Functions vs Stored Procedures.mp4 25.8 MB44 Managing PostgreSQL security/013 Inspecting permissions.mp4 25.6 MB23 Indexes and Performance Optimization/016 Hash Index.mp4 25.4 MB43 Exploring Stock Markets Data/002 Select first or last records in a table.mp4 25.4 MB18 Joining Multiple Tables/018 Natural Joins Part 1.mp4 25.2 MB30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.mp4 25.0 MB34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.mp4 24.9 MB29 Using regular expressions for text patterns/001 Text to structured data.mp4 24.8 MB34 Functions with PL_pgSQL language/027 Error and exception handling.mp4 24.7 MB34 Functions with PL_pgSQL language/005 Declaring variables.mp4 24.6 MB21 Exploring array functions/011 Insert data into arrays.mp4 24.6 MB37 Using Cursors/002 Cursors and procedural languages.mp4 24.6 MB34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.mp4 24.6 MB34 Functions with PL_pgSQL language/018 LOOP statement.mp4 24.6 MB36 PostgreSQL Triggers/007 Steps to create a trigger.mp4 24.6 MB41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.mp4 24.5 MB44 Managing PostgreSQL security/005 Database Level Security.mp4 24.5 MB36 PostgreSQL Triggers/016 Disallow data change on primary key.mp4 24.4 MB24 All about Views/006 A view with UNION of multiple tables.mp4 24.4 MB40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.mp4 24.4 MB28 Window Functions/042 DELETE and INSERT in one query using WITH.mp4 24.3 MB34 Functions with PL_pgSQL language/028 Exception - Too many rows.mp4 24.1 MB44 Managing PostgreSQL security/011 Row level policy for application users.mp4 24.1 MB44 Managing PostgreSQL security/002 Instance Level Security.mp4 24.1 MB05 Querying Data/009 Using ORDER BY with NULL values.mp4 24.0 MB10 Conversion Functions/002 to_number.mp4 24.0 MB40 PostgreSQL Transactions/002 How SQL protect database during transaction.mp4 24.0 MB17 Grouping Data/006 HAVING vs WHERE.mp4 23.9 MB23 Indexes and Performance Optimization/011 Optimizer node types.mp4 23.9 MB41 Using Northwind Database/010 Customers with no orders.mp4 23.8 MB36 PostgreSQL Triggers/011 View triggers variables.mp4 23.8 MB34 Functions with PL_pgSQL language/019 FOR Loops.mp4 23.8 MB28 Window Functions/024 Finding Correlations.mp4 23.8 MB31 Table Partitions/015 Sizing the partition.mp4 23.7 MB41 Using Northwind Database/011 Top customers with total orders amount.mp4 23.7 MB33 Functions with SQL language/003 Function returning no values.mp4 23.7 MB18 Joining Multiple Tables/004 INNER joins with filter data Part 2.mp4 23.5 MB28 Window Functions/009 Using FILTER clause.mp4 23.4 MB29 Using regular expressions for text patterns/004 POSIX regular expressions.mp4 23.4 MB19 Combining queries together/005 EXCEPT with tables.mp4 23.3 MB12 Explore PostgreSQL Constraints/004 DEFAULT constraint.mp4 23.3 MB31 Table Partitions/016 Partitioning Advantages.mp4 23.2 MB18 Joining Multiple Tables/013 FULL Joins.mp4 23.2 MB32 Server Programming/002 Procedural languages.mp4 23.1 MB28 Window Functions/008 Query performance check.mp4 22.8 MB03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.mp4 22.7 MB28 Window Functions/004 GROUP BY ROLLUP.mp4 22.7 MB31 Table Partitions/017 Common partitioning mistakes.mp4 22.7 MB46 PostgreSQL Internals/008 Show all running queries.mp4 22.6 MB38 Creating Crosstab Reports/006 Pivoting rows and columns.mp4 22.4 MB21 Exploring array functions/004 Array constructions.mp4 22.3 MB28 Window Functions/033 Using LEAD to compare with next values.mp4 22.3 MB03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.mp4 22.3 MB28 Window Functions/032 Calculating cumulative totals.mp4 22.2 MB28 Window Functions/010 Using Window Functions.mp4 22.1 MB34 Functions with PL_pgSQL language/007 Declaring variables in function.mp4 22.1 MB15 Aggregate functions/004 GREATEST AND LEAST functions.mp4 22.1 MB11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.mp4 22.0 MB28 Window Functions/019 RANK and DENSE_RANK functions.mp4 21.9 MB02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.mp4 21.9 MB22 JSON with PostgreSQL/001 What is JSON_.mp4 21.8 MB28 Window Functions/038 Getting RANK to compute group and global ranks.mp4 21.7 MB03 Creating and Modifying Tables/002 Creating the movie database and a actors table.mp4 21.6 MB36 PostgreSQL Triggers/020 Creating event triggers.mp4 21.5 MB03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.mp4 21.5 MB22 JSON with PostgreSQL/003 JSON and JSONB data types.mp4 21.5 MB18 Joining Multiple Tables/006 INNER joins with different data type columns.mp4 21.5 MB25 Fun with subqueries/013 Subquery using EXISTS.mp4 21.4 MB44 Managing PostgreSQL security/014 Row Level Security Performance.mp4 21.3 MB43 Exploring Stock Markets Data/003 Get first or last record per each group.mp4 21.3 MB23 Indexes and Performance Optimization/005 Size of the table index.mp4 21.3 MB23 Indexes and Performance Optimization/006 List counts of all indexes.mp4 21.1 MB14 String Functions/001 UPPER, LOWER and INITCAP.mp4 21.1 MB42 Using Human Resource (hr) database/002 Quick overview of all tables.mp4 21.1 MB28 Window Functions/006 GROUP BY CUBE.mp4 21.1 MB36 PostgreSQL Triggers/021 Event trigger events and variables.mp4 20.7 MB34 Functions with PL_pgSQL language/021 CONTINUE statement.mp4 20.7 MB38 Creating Crosstab Reports/001 What is a crosstab report.mp4 20.6 MB25 Fun with subqueries/003 Subquery with IN operator.mp4 20.6 MB21 Exploring array functions/010 Using arrays in tables.mp4 20.6 MB28 Window Functions/007 GROUP BY GROUPING SETS.mp4 20.4 MB23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.mp4 20.4 MB26 Common Table Expressions (CTE)/006 Recursive CTEs.mp4 20.0 MB34 Functions with PL_pgSQL language/012 Variables in block and subblock.mp4 20.0 MB34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.mp4 19.9 MB13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.mp4 19.8 MB04 Modifying Data in the tables/005 Update data in a table.mp4 19.8 MB16 Using DATE_TIME functions/017 CURRENT_TIME function.mp4 19.7 MB41 Using Northwind Database/005 Show total order amount for each order.mp4 19.7 MB16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.mp4 19.6 MB24 All about Views/017 Creating a materialized view.mp4 19.5 MB22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.mp4 19.4 MB33 Functions with SQL language/019 Drop a function.mp4 19.4 MB44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.mp4 19.3 MB34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.mp4 19.3 MB04 Modifying Data in the tables/001 Insert a data into table.mp4 19.3 MB21 Exploring array functions/014 Array Dimensions are ignored!.mp4 19.2 MB24 All about Views/003 Rename a view.mp4 19.2 MB23 Indexes and Performance Optimization/001 What is an index_.mp4 19.1 MB28 Window Functions/018 Using WINDOW with ROWS BETWEEN.mp4 19.1 MB06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.mp4 19.0 MB23 Indexes and Performance Optimization/008 SQL Statement execution process.mp4 19.0 MB24 All about Views/022 Why not use a table instead of materialized view_.mp4 18.9 MB31 Table Partitions/013 Partition pruning.mp4 18.9 MB12 Explore PostgreSQL Constraints/001 Introduction to constraints.mp4 18.9 MB13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 18.7 MB46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.mp4 18.6 MB23 Indexes and Performance Optimization/004 List all indexes.mp4 18.6 MB05 Querying Data/008 Using ORDER BY with column name or column number.mp4 18.5 MB12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.mp4 18.4 MB28 Window Functions/005 ROLLUP - Grouping multiple columns.mp4 18.3 MB32 Server Programming/004 Functions vs stored procedures.mp4 18.3 MB11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.mp4 18.2 MB22 JSON with PostgreSQL/009 Build a JSON array.mp4 18.2 MB08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.mp4 18.2 MB11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 18.2 MB25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.mp4 18.2 MB11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.mp4 18.0 MB14 String Functions/012 REPLACE.mp4 18.0 MB34 Functions with PL_pgSQL language/025 Returning a table.mp4 17.9 MB19 Combining queries together/004 INTERSECT with tables.mp4 17.9 MB09 Data type conversions/003 Implicit to Explicit conversions.mp4 17.9 MB41 Using Northwind Database/004 Orders shipped to latin america.mp4 17.9 MB24 All about Views/026 List materialized views with no unique index.mp4 17.9 MB45 PostgreSQL Utilities - psql/014 Turn on query execution time.mp4 17.9 MB14 String Functions/010 SUBSTRING.mp4 17.8 MB22 JSON with PostgreSQL/015 The Containment Operator.mp4 17.8 MB11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.mp4 17.7 MB11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 17.7 MB28 Window Functions/036 Planning tips on using Window Functions.mp4 17.6 MB33 Functions with SQL language/013 Function - order matters!.mp4 17.5 MB33 Functions with SQL language/016 Function parameter modes.mp4 17.5 MB14 String Functions/007 LENGTH.mp4 17.5 MB32 Server Programming/005 User-defined functions.mp4 17.3 MB28 Window Functions/035 Window Function Summary.mp4 17.3 MB23 Indexes and Performance Optimization/028 Try to use index only scan.mp4 17.2 MB16 Using DATE_TIME functions/012 OVERLAPS Operator.mp4 17.0 MB33 Functions with SQL language/002 Introducing dollar quoting.mp4 17.0 MB13 PostgreSQL Sequences/009 Share one sequence between two tables.mp4 16.9 MB45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.mp4 16.8 MB45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.mp4 16.8 MB27 Grouping sets/001 Introduction to summarization.mp4 16.8 MB24 All about Views/023 The downsides of using materialized views.mp4 16.8 MB24 All about Views/012 What is an updatable view_.mp4 16.8 MB21 Exploring array functions/015 Display all array elements.mp4 16.7 MB05 Querying Data/002 Selecting specific columns from a table.mp4 16.7 MB07 PostgreSQL Data types/006 Date_Time data types.mp4 16.7 MB05 Querying Data/007 Using ORDER BY to sort rows by expressions.mp4 16.6 MB45 PostgreSQL Utilities - psql/001 Connect to local or remote database.mp4 16.5 MB06 Filtering Data/003 OR operator.mp4 16.5 MB03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.mp4 16.4 MB24 All about Views/018 Drop a materialized view.mp4 16.4 MB40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.mp4 16.1 MB28 Window Functions/027 ROW_NUMBER() - Find Nth record.mp4 16.0 MB40 PostgreSQL Transactions/006 How to fix aborted transaction.mp4 16.0 MB34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.mp4 15.8 MB18 Joining Multiple Tables/012 RIGHT joins Part 2.mp4 15.8 MB41 Using Northwind Database/007 Total products in each categories.mp4 15.8 MB16 Using DATE_TIME functions/020 View and set timezones.mp4 15.8 MB23 Indexes and Performance Optimization/007 Drop a index.mp4 15.7 MB14 String Functions/008 POSITION.mp4 15.5 MB42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.mp4 15.4 MB33 Functions with SQL language/014 Function returning a table.mp4 15.4 MB11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.mp4 15.2 MB03 Creating and Modifying Tables/003 Creating the directors table.mp4 15.2 MB45 PostgreSQL Utilities - psql/003 List all databases and tables.mp4 15.1 MB06 Filtering Data/005 What goes before and after WHERE clause.mp4 14.9 MB28 Window Functions/040 Using WITH clause to create your own data.mp4 14.9 MB36 PostgreSQL Triggers/017 Use triggers very cautiously.mp4 14.9 MB28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.mp4 14.8 MB36 PostgreSQL Triggers/019 Event triggers usage scenarios.mp4 14.8 MB16 Using DATE_TIME functions/015 AGE function.mp4 14.8 MB45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.mp4 14.8 MB44 Managing PostgreSQL security/004 Use pgAdmin to create roles.mp4 14.7 MB42 Using Human Resource (hr) database/019 Select employees not in range.mp4 14.6 MB19 Combining queries together/003 UNION tables with different number of columns.mp4 14.5 MB11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.mp4 14.4 MB24 All about Views/011 Regular views are dynamic.mp4 14.4 MB42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.mp4 14.4 MB05 Querying Data/006 Using ORDER BY with alias column name.mp4 14.3 MB02 Introduction to PostgreSQL/011 Drop a database.mp4 14.3 MB41 Using Northwind Database/008 List products that needs re-ordering.mp4 14.2 MB37 Using Cursors/003 Steps to create a cursor.mp4 14.2 MB13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 14.2 MB05 Querying Data/004 Using SELECT statement for expressions.mp4 14.1 MB47 Managing Tables/002 Duplicate a table with or without data.mp4 13.9 MB04 Modifying Data in the tables/008 Delete data from a table.mp4 13.8 MB18 Joining Multiple Tables/019 Natural Joins Part 2.mp4 13.8 MB03 Creating and Modifying Tables/005 Creating the movies_revenues table.mp4 13.8 MB04 Modifying Data in the tables/007 Updating all records in a table.mp4 13.8 MB29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.mp4 13.6 MB18 Joining Multiple Tables/016 Self Joins Part 2.mp4 13.6 MB16 Using DATE_TIME functions/002 System Month Date settings.mp4 13.5 MB21 Exploring array functions/013 Modifying array data.mp4 13.4 MB42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.mp4 13.2 MB42 Using Human Resource (hr) database/001 Human Resources Database Structure.mp4 13.1 MB38 Creating Crosstab Reports/004 Orders matters in crosstab reports.mp4 13.1 MB45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.mp4 13.0 MB22 JSON with PostgreSQL/014 The Existence Operator.mp4 13.0 MB42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.mp4 12.8 MB03 Creating and Modifying Tables/001 Movie Database Structure.mp4 12.8 MB45 PostgreSQL Utilities - psql/011 Make table layout funkey!.mp4 12.7 MB31 Table Partitions/004 Partition types.mp4 12.7 MB28 Window Functions/037 Difference between RANK and DENSE_RANK.mp4 12.6 MB24 All about Views/008 Re-arrange columns in a view.mp4 12.6 MB46 PostgreSQL Internals/009 Terminate running and IDLE process.mp4 12.5 MB23 Indexes and Performance Optimization/020 EXPLAIN output options.mp4 12.5 MB46 PostgreSQL Internals/004 List all columns from a table.mp4 12.5 MB44 Managing PostgreSQL security/001 Security concepts and and levels.mp4 12.4 MB36 PostgreSQL Triggers/003 Types of triggers.mp4 12.4 MB24 All about Views/020 How to check if a materialized view is populated or not_.mp4 12.3 MB12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.mp4 12.3 MB32 Server Programming/006 Structure of a function.mp4 12.3 MB23 Indexes and Performance Optimization/031 Adding data while indexing.mp4 12.2 MB02 Introduction to PostgreSQL/004 Creating a Database User.mp4 12.2 MB13 PostgreSQL Sequences/004 Create a sequence using a specific data type.mp4 12.1 MB34 Functions with PL_pgSQL language/009 Copying data types.mp4 12.1 MB42 Using Human Resource (hr) database/021 Update phone_number with your strings.mp4 12.1 MB11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.mp4 11.7 MB36 PostgreSQL Triggers/004 Trigger table.mp4 11.7 MB04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.mp4 11.6 MB46 PostgreSQL Internals/005 View system metadata via system information functions.mp4 11.6 MB28 Window Functions/012 Set data into millions format.mp4 11.5 MB36 PostgreSQL Triggers/006 Trigger key points.mp4 11.5 MB20 PostgreSQL Schemas/004 Move a table to a new schema.mp4 11.4 MB04 Modifying Data in the tables/006 Updating a row and returning the updated row.mp4 11.4 MB34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.mp4 11.3 MB02 Introduction to PostgreSQL/005 Creating a Database.mp4 11.1 MB41 Using Northwind Database/012 Orders with many lines of ordered items.mp4 11.1 MB02 Introduction to PostgreSQL/007 Install sample data files on server.mp4 11.1 MB41 Using Northwind Database/015 Countries with customers or suppliers.mp4 10.7 MB42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.mp4 10.7 MB25 Fun with subqueries/008 A SELECT without a FROM.mp4 10.7 MB34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.mp4 10.5 MB44 Managing PostgreSQL security/012 DROP a policy.mp4 10.5 MB42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.mp4 10.5 MB40 PostgreSQL Transactions/004 Transaction setup.mp4 10.2 MB45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.mp4 10.2 MB03 Creating and Modifying Tables/012 Deleting tables from a database.mp4 10.2 MB04 Modifying Data in the tables/002 Insert multiple records into a table.mp4 10.1 MB06 Filtering Data/006 Execution order with AND, OR operators.mp4 9.8 MB11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 9.8 MB42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.mp4 9.7 MB41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.mp4 9.6 MB41 Using Northwind Database/002 Orders shipping to USA or France.mp4 9.6 MB06 Filtering Data/007 Can we use column aliases with WHERE_.mp4 9.6 MB42 Using Human Resource (hr) database/018 Select employees with particular department id only.mp4 9.4 MB23 Indexes and Performance Optimization/017 BRIN index.mp4 9.4 MB34 Functions with PL_pgSQL language/008 Variable initializing timing.mp4 9.3 MB24 All about Views/010 Add a column in a view.mp4 9.2 MB14 String Functions/011 REPEAT.mp4 9.1 MB42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.mp4 9.1 MB42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.mp4 9.0 MB42 Using Human Resource (hr) database/017 Get unique designations in employees table.mp4 9.0 MB11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.mp4 9.0 MB06 Filtering Data/001 Comparison, Logical and Arithmetic operators.mp4 9.0 MB20 PostgreSQL Schemas/006 Alter a schema ownership.mp4 8.9 MB41 Using Northwind Database/006 First the oldest and latest order date.mp4 8.8 MB42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.mp4 8.8 MB02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.mp4 8.6 MB34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.mp4 8.6 MB11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.mp4 8.5 MB14 String Functions/003 REVERSE.mp4 8.5 MB38 Creating Crosstab Reports/002 Installing the tablefunc extension.mp4 8.2 MB42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.mp4 8.2 MB37 Using Cursors/007 Updating data.mp4 8.0 MB12 Explore PostgreSQL Constraints/011 Drop a constraint.mp4 8.0 MB02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.mp4 7.9 MB04 Modifying Data in the tables/003 Insert a data that had quotes.mp4 7.9 MB36 PostgreSQL Triggers/018 What is an event trigger.mp4 7.8 MB24 All about Views/009 Delete a column in a view.mp4 7.6 MB42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.mp4 7.5 MB23 Indexes and Performance Optimization/018 GIN Index.mp4 7.4 MB25 Fun with subqueries/007 Subquery with an alias.mp4 7.3 MB43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.mp4 7.2 MB42 Using Human Resource (hr) database/010 Using an alias name with columns.mp4 7.1 MB24 All about Views/004 Delete a view.mp4 7.1 MB35 Exploring Stored Procedures/005 Drop a procedure.mp4 7.1 MB45 PostgreSQL Utilities - psql/002 Switch connection to a new database.mp4 7.1 MB46 PostgreSQL Internals/010 How to check live and dead rows in tables.mp4 7.0 MB42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.mp4 7.0 MB34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.mp4 6.7 MB06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 6.6 MB28 Window Functions/001 Introduction to Window Functions.mp4 6.6 MB13 PostgreSQL Sequences/008 List all sequences in a database.mp4 6.3 MB24 All about Views/025 List all materialized views by a SELECT statement.mp4 6.2 MB37 Using Cursors/008 Closing a cursor.mp4 6.1 MB02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.mp4 6.0 MB29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.mp4 6.0 MB13 PostgreSQL Sequences/006 Delete a sequence.mp4 5.9 MB01 Welcome/001 Course Introduction.mp4 5.8 MB17 Grouping Data/003 Order of execution in GROUP BY clause.mp4 5.7 MB42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.mp4 5.5 MB42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.mp4 5.4 MB45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.mp4 5.2 MB12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.mp4 5.1 MB16 Using DATE_TIME functions/016 CURRENT_DATE function.mp4 4.9 MB45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.mp4 4.6 MB17 Grouping Data/005 Order of execution in HAVING clause.mp4 4.3 MB41 Using Northwind Database/001 Using Northwind database.mp4 4.3 MB45 PostgreSQL Utilities - psql/006 Describe a table.mp4 4.1 MB36 PostgreSQL Triggers/024 Dropping a trigger.mp4 4.1 MB42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.mp4 3.0 MB49 Thank You!/003 Thank You!.mp4 2.5 MB
01 Welcome/002 sample_data.zip 1.5 MB02 Introduction to PostgreSQL/010 sample_data.zip 1.5 MB02 Introduction to PostgreSQL/011 sample_data.zip 1.5 MB
30 Powerful text searches in PostgreSQL/385 president_speeches.csv 1.2 MB01 Welcome/002 trades.sql 522.4 kB28 Window Functions/331 trades.sql 522.4 kB01 Welcome/002 northwind.sql 349.7 kB02 Introduction to PostgreSQL/012 northwind.sql 349.7 kB31 Table Partitions/006 Partition by List.en.srt 37.8 kB28 Window Functions/015 Understanding window frames.en.srt 33.9 kB36 PostgreSQL Triggers/014 Creating an audit trigger.en.srt 31.4 kB31 Table Partitions/005 Partition by Range.en.srt 30.9 kB12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.en.srt 30.7 kB18 Joining Multiple Tables/001 INNER joins.en.srt 29.9 kB26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.en.srt 29.8 kB48 Extended PostgreSQL/001 Create a custom index method.en.srt 29.4 kB07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.en.srt 29.1 kB31 Table Partitions/002 When a partition can be used_.en.srt 28.7 kB29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.en.srt 28.6 kB23 Indexes and Performance Optimization/027 Using organized vs random data.en.srt 28.5 kB06 Filtering Data/014 Using LIKE and ILIKE.en.srt 26.2 kB06 Filtering Data/010 Using LIMIT and OFFSET.en.srt 25.6 kB38 Creating Crosstab Reports/011 Dynamic pivot table columns.en.srt 24.9 kB31 Table Partitions/003 Table inheritance.en.srt 24.5 kB06 Filtering Data/009 Using Logical operators.en.srt 24.1 kB26 Common Table Expressions (CTE)/002 CTE query examples.en.srt 23.7 kB40 PostgreSQL Transactions/005 Transaction analysis.en.srt 23.5 kB23 Indexes and Performance Optimization/002 Create an index.en.srt 23.4 kB23 Indexes and Performance Optimization/019 The EXPLAIN statement.en.srt 23.1 kB12 Explore PostgreSQL Constraints/003 UNIQUE constraint.en.srt 22.7 kB23 Indexes and Performance Optimization/030 Expression Index.en.srt 22.7 kB31 Table Partitions/007 Partition by Hash.en.srt 22.7 kB28 Window Functions/021 LEAD and LAG functions.en.srt 22.3 kB30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.en.srt 22.2 kB36 PostgreSQL Triggers/022 Creating an audit event trigger.en.srt 22.1 kB38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.en.srt 22.0 kB27 Grouping sets/004 Using GROUPING with ROLLUP.en.srt 21.8 kB07 PostgreSQL Data types/008 TIME.en.srt 21.6 kB28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.en.srt 21.5 kB21 Exploring array functions/017 Array vs JSONB.en.srt 21.5 kB21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.en.srt 21.5 kB36 PostgreSQL Triggers/015 Creating conditional triggers.en.srt 21.4 kB31 Table Partitions/009 Multi-level partitioning.en.srt 21.2 kB17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.en.srt 21.1 kB44 Managing PostgreSQL security/009 Row Level Security.en.srt 21.1 kB20 PostgreSQL Schemas/005 Schema search path.en.srt 20.9 kB07 PostgreSQL Data types/014 Network Addresses.en.srt 20.9 kB30 Powerful text searches in PostgreSQL/004 Full text search within a table.en.srt 20.9 kB37 Using Cursors/010 Using a parametric cursor via function.en.srt 20.5 kB33 Functions with SQL language/007 Function using parameters.en.srt 20.2 kB33 Functions with SQL language/009 Function using parameters Part 3.en.srt 20.1 kB23 Indexes and Performance Optimization/022 Understanding query cost model.en.srt 20.0 kB07 PostgreSQL Data types/001 Boolean.en.srt 19.9 kB12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.en.srt 19.9 kB34 Functions with PL_pgSQL language/026 Using RETURN NEXT.en.srt 19.8 kB15 Aggregate functions/005 Average with AVG function.en.srt 19.2 kB09 Data type conversions/002 Using CAST for data conversions.en.srt 19.1 kB33 Functions with SQL language/010 Function using parameters Part 4.en.srt 19.0 kB18 Joining Multiple Tables/020 Append tables with different columns.en.srt 18.8 kB25 Fun with subqueries/009 Correlated Queries.en.srt 18.5 kB25 Fun with subqueries/002 Subqueries with WHERE Clause.en.srt 18.5 kB07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.en.srt 18.3 kB33 Functions with SQL language/011 Function returning a composite.en.srt 18.3 kB15 Aggregate functions/003 MIN and MAX functions.en.srt 18.3 kB33 Functions with SQL language/004 Function returning a single value.en.srt 18.2 kB48 Extended PostgreSQL/002 Create a user-defined aggregate function.en.srt 18.1 kB23 Indexes and Performance Optimization/023 Index are not free.en.srt 18.0 kB16 Using DATE_TIME functions/004 Strings to Dates conversions.en.srt 18.0 kB27 Grouping sets/002 Subtotals on group sets.en.srt 18.0 kB22 JSON with PostgreSQL/006 Update and Delete JSON Data.en.srt 17.9 kB22 JSON with PostgreSQL/017 Indexing on JSONB.en.srt 17.9 kB07 PostgreSQL Data types/013 JSON.en.srt 17.8 kB30 Powerful text searches in PostgreSQL/002 Introducing tsvector.en.srt 17.8 kB34 Functions with PL_pgSQL language/023 WHILE loop.en.srt 17.7 kB16 Using DATE_TIME functions/022 date_part function.en.srt 17.4 kB06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.en.srt 17.3 kB47 Managing Tables/001 Using SELECT INTO to create a new table with joins.en.srt 17.3 kB34 Functions with PL_pgSQL language/017 Searched CASE statement.en.srt 17.2 kB21 Exploring array functions/016 Using Multi-dimensional arrays.en.srt 17.0 kB17 Grouping Data/004 Using HAVING.en.srt 17.0 kB36 PostgreSQL Triggers/010 Modify data at INSERT event.en.srt 17.0 kB24 All about Views/024 Using materialized view for websites page analysis.en.srt 16.9 kB39 Internationalization/002 Client and Server Encoding.en.srt 16.9 kB34 Functions with PL_pgSQL language/016 CASE Statement.en.srt 16.9 kB33 Functions with SQL language/017 Function parameters with default values.en.srt 16.8 kB19 Combining queries together/001 Combine results sets with UNION.en.srt 16.8 kB36 PostgreSQL Triggers/005 Pros and Cons of triggers.en.srt 16.8 kB44 Managing PostgreSQL security/006 Schema Level Security.en.srt 16.7 kB36 PostgreSQL Triggers/008 Data auditing with a trigger.en.srt 16.7 kB34 Functions with PL_pgSQL language/024 Using RETURN QUERY.en.srt 16.5 kB16 Using DATE_TIME functions/006 Formatting Dates.en.srt 16.5 kB17 Grouping Data/001 Using GROUP BY.en.srt 16.4 kB07 PostgreSQL Data types/003 NUMERIC.en.srt 16.4 kB24 All about Views/002 Creating a view.en.srt 16.4 kB07 PostgreSQL Data types/004 DECIMALS.en.srt 16.4 kB15 Aggregate functions/006 Combining Columns using Mathematical operators.en.srt 16.3 kB41 Using Northwind Database/014 Late shipped orders by employees.en.srt 16.3 kB28 Window Functions/016 ROWS and RANGE indicators.en.srt 16.2 kB47 Managing Tables/013 Generated Columns.en.srt 16.2 kB38 Creating Crosstab Reports/013 Handling missing values.en.srt 16.1 kB36 PostgreSQL Triggers/012 Disallow DELETE on a table.en.srt 15.9 kB16 Using DATE_TIME functions/021 How to handle timezones.en.srt 15.9 kB36 PostgreSQL Triggers/002 What is a trigger.en.srt 15.9 kB07 PostgreSQL Data types/010 UUID.en.srt 15.8 kB12 Explore PostgreSQL Constraints/002 NOT NULL constraint.en.srt 15.8 kB44 Managing PostgreSQL security/007 Table Level Security.en.srt 15.8 kB33 Functions with SQL language/001 Creating our first SQL function.en.srt 15.8 kB39 Internationalization/001 Global Character Set Support.en.srt 15.7 kB38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.en.srt 15.7 kB16 Using DATE_TIME functions/011 Using math operators with dates.en.srt 15.6 kB41 Using Northwind Database/013 Orders with double entry line items.en.srt 15.6 kB47 Managing Tables/012 Recovering unused space with VACUUM.en.srt 15.5 kB37 Using Cursors/009 Creating a PL_PGSQL Cursor.en.srt 15.3 kB23 Indexes and Performance Optimization/029 Partial indexes.en.srt 15.2 kB16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.en.srt 15.2 kB16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.en.srt 15.1 kB17 Grouping Data/007 Handling NULL values with GROUP BY.en.srt 15.1 kB06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.en.srt 15.0 kB23 Indexes and Performance Optimization/003 Create unique indexes.en.srt 15.0 kB47 Managing Tables/011 PostgreSQL autovacuum proces.en.srt 14.9 kB32 Server Programming/001 PostgreSQL as a development platform_.en.srt 14.9 kB29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.en.srt 14.9 kB18 Joining Multiple Tables/017 CROSS Joins.en.srt 14.8 kB41 Using Northwind Database/009 Freight analysis.en.srt 14.7 kB18 Joining Multiple Tables/011 RIGHT joins.en.srt 14.7 kB23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.en.srt 14.6 kB38 Creating Crosstab Reports/007 Matrix report via a query.en.srt 14.6 kB28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.en.srt 14.6 kB37 Using Cursors/005 Opening a cursor.en.srt 14.4 kB16 Using DATE_TIME functions/001 Datetimes data types.en.srt 14.4 kB19 Combining queries together/002 UNION with filters and conditions.en.srt 14.3 kB04 Modifying Data in the tables/009 Using UPSERT.en.srt 14.3 kB22 JSON with PostgreSQL/002 JSON Syntax.en.srt 14.3 kB33 Functions with SQL language/015 Function as a table source.en.srt 14.3 kB06 Filtering Data/011 Using FETCH.en.srt 14.2 kB46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.en.srt 14.2 kB21 Exploring array functions/009 Formatting and converting an array.en.srt 14.0 kB28 Window Functions/023 ROW_NUMBER function.en.srt 14.0 kB28 Window Functions/020 NTILE function.en.srt 13.8 kB28 Window Functions/017 Using WINDOW.en.srt 13.7 kB28 Window Functions/034 Comparing with least number.en.srt 13.7 kB24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.en.srt 13.5 kB29 Using regular expressions for text patterns/002 Regular expressions notations table.en.srt 13.5 kB24 All about Views/016 What is a Materialized View.en.srt 13.4 kB16 Using DATE_TIME functions/023 date_trunc function.en.srt 13.4 kB18 Joining Multiple Tables/007 LEFT joins Part 1.en.srt 13.4 kB29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.en.srt 13.4 kB16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.en.srt 13.3 kB37 Using Cursors/004 Creating a cursor.en.srt 13.3 kB06 Filtering Data/012 Using IN, NOT IN.en.srt 13.3 kB05 Querying Data/003 Adding Aliases to columns in a table.en.srt 13.3 kB18 Joining Multiple Tables/003 INNER joins with filter data Part 1.en.srt 13.3 kB31 Table Partitions/011 ALTERing the partition bounds.en.srt 13.2 kB46 PostgreSQL Internals/003 List all tables and views.en.srt 13.0 kB36 PostgreSQL Triggers/009 Bind a function to a table with trigger.en.srt 12.9 kB23 Indexes and Performance Optimization/024 Indexes for sorted output.en.srt 12.9 kB40 PostgreSQL Transactions/003 ACID Database.en.srt 12.8 kB14 String Functions/002 LEFT and RIGHT.en.srt 12.8 kB21 Exploring array functions/005 Array metadata functions.en.srt 12.8 kB28 Window Functions/003 Using aggregate functions.en.srt 12.7 kB30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.en.srt 12.7 kB23 Indexes and Performance Optimization/010 The query optimizer.en.srt 12.5 kB34 Functions with PL_pgSQL language/010 Assigning variables from query.en.srt 12.5 kB33 Functions with SQL language/012 Function returning multiple rows.en.srt 12.5 kB25 Fun with subqueries/004 Subquery with JOINs.en.srt 12.5 kB18 Joining Multiple Tables/014 Joining multiple tables.en.srt 12.5 kB12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.en.srt 12.5 kB23 Indexes and Performance Optimization/032 Invalidating an index.en.srt 12.4 kB10 Conversion Functions/001 to_char.en.srt 12.4 kB18 Joining Multiple Tables/002 INNER joins with USING.en.srt 12.2 kB28 Window Functions/013 Ordering inside window.en.srt 12.2 kB46 PostgreSQL Internals/006 View privileges information across tables.en.srt 12.2 kB23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.en.srt 12.1 kB24 All about Views/014 Updatable views using WITH CHECK OPTION.en.srt 12.1 kB44 Managing PostgreSQL security/008 Column Level Security.en.srt 12.0 kB18 Joining Multiple Tables/015 Self Joins Part 1.en.srt 12.0 kB18 Joining Multiple Tables/009 LEFT joins Part 3.en.srt 12.0 kB36 PostgreSQL Triggers/023 Prevent schema changes.en.srt 12.0 kB31 Table Partitions/014 Determining a field for partition over.en.srt 12.0 kB30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.en.srt 11.9 kB12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.en.srt 11.9 kB21 Exploring array functions/002 Using comparison operators.en.srt 11.9 kB15 Aggregate functions/002 Sum with SUM function.en.srt 11.9 kB28 Window Functions/002 Analyze Global Trades Data.en.srt 11.8 kB09 Data type conversions/004 Table data conversion.en.srt 11.8 kB08 Modifying Table Structures, Add constraints/003 Add constraints to columns.en.srt 11.7 kB01 Welcome/002 countries_iso_codes.csv 11.7 kB47 Managing Tables/611 countries_iso_codes.csv 11.7 kB28 Window Functions/014 Sliding dynamic windows.en.srt 11.7 kB40 PostgreSQL Transactions/001 What is a transaction_.en.srt 11.7 kB20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.en.srt 11.7 kB35 Exploring Stored Procedures/002 Create a transactions.en.srt 11.7 kB47 Managing Tables/010 Tracking table size.en.srt 11.6 kB27 Grouping sets/003 Adding subtotal with ROLLUP.en.srt 11.4 kB06 Filtering Data/016 Concatenation techniques.en.srt 11.4 kB21 Exploring array functions/001 Constructing arrays and ranges.en.srt 11.3 kB34 Functions with PL_pgSQL language/014 Control Structures - IF statement.en.srt 11.3 kB22 JSON with PostgreSQL/005 Create our first table with JSONB data type.en.srt 11.3 kB12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.en.srt 11.3 kB25 Fun with subqueries/012 Using ALL with subquery.en.srt 11.3 kB12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.en.srt 11.2 kB38 Creating Crosstab Reports/503 rainfalldata.sql 11.2 kB07 PostgreSQL Data types/012 hstore.en.srt 11.2 kB44 Managing PostgreSQL security/015 Encrypted data in columns.en.srt 11.2 kB20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).en.srt 11.1 kB26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.en.srt 11.1 kB21 Exploring array functions/012 Query array data.en.srt 11.1 kB41 Using Northwind Database/018 First order from each country.en.srt 11.1 kB25 Fun with subqueries/011 Using ANY with subquery.en.srt 11.1 kB47 Managing Tables/005 Deleting duplicate records.en.srt 11.0 kB16 Using DATE_TIME functions/018 Date accuracy with EPOCH.en.srt 11.0 kB31 Table Partitions/012 Partition Indexes.en.srt 11.0 kB06 Filtering Data/002 AND operator.en.srt 11.0 kB23 Indexes and Performance Optimization/013 Index Nodes.en.srt 10.9 kB45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.en.srt 10.9 kB29 Using regular expressions for text patterns/003 SIMILAR TO operator.en.srt 10.9 kB47 Managing Tables/003 Import data from CSV files.en.srt 10.9 kB24 All about Views/007 Connecting multiple tables with a single view.en.srt 10.8 kB23 Indexes and Performance Optimization/033 Rebuilding an index.en.srt 10.8 kB13 PostgreSQL Sequences/007 Attach a sequence to a table column.en.srt 10.8 kB24 All about Views/001 Introduction to views.en.srt 10.7 kB14 String Functions/004 SPLIT_PART.en.srt 10.6 kB41 Using Northwind Database/017 Customers with multiple orders.en.srt 10.6 kB24 All about Views/005 Using filters with views.en.srt 10.6 kB38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.en.srt 10.6 kB07 PostgreSQL Data types/011 Array.en.srt 10.5 kB38 Creating Crosstab Reports/009 Static to dynamic pivots.en.srt 10.5 kB21 Exploring array functions/006 Array search functions.en.srt 10.5 kB22 JSON with PostgreSQL/004 Exploring JSON objects.en.srt 10.4 kB18 Joining Multiple Tables/008 LEFT joins Part 2.en.srt 10.4 kB14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.en.srt 10.4 kB28 Window Functions/036 Planning tips on using Window Functions.en.srt 10.3 kB34 Functions with PL_pgSQL language/030 Exception with data exception errors.en.srt 10.3 kB26 Common Table Expressions (CTE)/003 Combine CTE with a table.en.srt 10.2 kB12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.en.srt 10.1 kB13 PostgreSQL Sequences/010 Create an alphanumeric sequence.en.srt 10.1 kB11 User-defined Data Types/013 Update an ENUM data in production server.en.srt 10.1 kB16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.en.srt 10.1 kB16 Using DATE_TIME functions/007 Date construction functions.en.srt 10.1 kB28 Window Functions/041 Using WITH clause to set ORDER BY values.en.srt 10.1 kB21 Exploring array functions/007 Array modification functions.en.srt 10.1 kB25 Fun with subqueries/010 SELECT.. IN (Subquery).en.srt 10.0 kB23 Indexes and Performance Optimization/026 Execution plans depends on input values.en.srt 10.0 kB08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.en.srt 9.9 kB37 Using Cursors/001 Understanding row by row operations.en.srt 9.9 kB30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.en.srt 9.8 kB20 PostgreSQL Schemas/003 Schema Hierarchy.en.srt 9.8 kB20 PostgreSQL Schemas/010 Schemas and Privileges.en.srt 9.7 kB31 Table Partitions/015 Sizing the partition.en.srt 9.7 kB37 Using Cursors/006 Using a cursor.en.srt 9.6 kB33 Functions with SQL language/018 Function based on views.en.srt 9.6 kB31 Table Partitions/008 DEFAULT Partition.en.srt 9.6 kB23 Indexes and Performance Optimization/014 Join Nodes.en.srt 9.6 kB24 All about Views/021 Refreshing data in materialize views.en.srt 9.5 kB03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.en.srt 9.5 kB16 Using DATE_TIME functions/010 Date Value Extractors functions.en.srt 9.4 kB20 PostgreSQL Schemas/007 Duplicate a schema along with all data.en.srt 9.4 kB12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.en.srt 9.4 kB16 Using DATE_TIME functions/003 Time of day formats and inputs.en.srt 9.4 kB13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.en.srt 9.4 kB20 PostgreSQL Schemas/001 What is a Schema_.en.srt 9.3 kB40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.en.srt 9.3 kB05 Querying Data/005 Using ORDER BY to sort records.en.srt 9.3 kB11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.en.srt 9.3 kB07 PostgreSQL Data types/007 DATE.en.srt 9.3 kB24 All about Views/019 Changing materialized view data.en.srt 9.3 kB22 JSON with PostgreSQL/013 Getting information from JSON documents.en.srt 9.2 kB44 Managing PostgreSQL security/002 Instance Level Security.en.srt 9.2 kB32 Server Programming/003 Keep the data on the server!.en.srt 9.2 kB44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.en.srt 9.1 kB09 Data type conversions/001 What is a data type conversion.en.srt 9.1 kB23 Indexes and Performance Optimization/009 SQL statement execution stages.en.srt 9.1 kB29 Using regular expressions for text patterns/001 Text to structured data.en.srt 9.1 kB28 Window Functions/029 ROW_NUMBER() - Pagination technique.en.srt 9.1 kB38 Creating Crosstab Reports/012 Interactive client-side pivot.en.srt 9.1 kB21 Exploring array functions/011 Insert data into arrays.en.srt 9.1 kB41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.en.srt 9.0 kB05 Querying Data/001 Select all data from a table.en.srt 9.0 kB05 Querying Data/009 Using ORDER BY with NULL values.en.srt 9.0 kB23 Indexes and Performance Optimization/012 Sequential Nodes.en.srt 8.9 kB10 Conversion Functions/002 to_number.en.srt 8.9 kB34 Functions with PL_pgSQL language/019 FOR Loops.en.srt 8.8 kB28 Window Functions/033 Using LEAD to compare with next values.en.srt 8.8 kB28 Window Functions/030 Using OVER() to calculate percentage.en.srt 8.8 kB35 Exploring Stored Procedures/001 Functions vs Stored Procedures.en.srt 8.8 kB28 Window Functions/039 Using PARTITION BY for group averages.en.srt 8.8 kB28 Window Functions/024 Finding Correlations.en.srt 8.8 kB22 JSON with PostgreSQL/010 Creating a document from data.en.srt 8.8 kB47 Managing Tables/009 Database operations and table size.en.srt 8.7 kB28 Window Functions/031 Calculate difference compared to average.en.srt 8.7 kB34 Functions with PL_pgSQL language/018 LOOP statement.en.srt 8.7 kB07 PostgreSQL Data types/005 Selecting Numbers data types.en.srt 8.7 kB02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.en.srt 8.6 kB34 Functions with PL_pgSQL language/005 Declaring variables.en.srt 8.6 kB14 String Functions/006 LPAD and RPAD.en.srt 8.6 kB10 Conversion Functions/003 to_date.en.srt 8.6 kB16 Using DATE_TIME functions/013 Date _ Time Functions.en.srt 8.5 kB36 PostgreSQL Triggers/016 Disallow data change on primary key.en.srt 8.4 kB05 Querying Data/010 Using DISTINCT for selecting distinct values.en.srt 8.4 kB15 Aggregate functions/001 Counting results via COUNT function.en.srt 8.4 kB18 Joining Multiple Tables/010 LEFT joins Part 4.en.srt 8.4 kB34 Functions with PL_pgSQL language/027 Error and exception handling.en.srt 8.3 kB19 Combining queries together/005 EXCEPT with tables.en.srt 8.3 kB32 Server Programming/002 Procedural languages.en.srt 8.3 kB40 PostgreSQL Transactions/007 How to fix transactions on crash.en.srt 8.3 kB18 Joining Multiple Tables/018 Natural Joins Part 1.en.srt 8.3 kB31 Table Partitions/001 What is a partition.en.srt 8.2 kB21 Exploring array functions/004 Array constructions.en.srt 8.2 kB28 Window Functions/032 Calculating cumulative totals.en.srt 8.2 kB26 Common Table Expressions (CTE)/001 Introduction to CTEs.en.srt 8.2 kB02 Introduction to PostgreSQL/010 Install northwind database.en.srt 8.2 kB24 All about Views/013 An updatable view with CRUD operations.en.srt 8.1 kB46 PostgreSQL Internals/007 Using system Administration functions.en.srt 8.1 kB41 Using Northwind Database/010 Customers with no orders.en.srt 8.1 kB11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.en.srt 8.1 kB17 Grouping Data/006 HAVING vs WHERE.en.srt 8.0 kB36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.en.srt 8.0 kB28 Window Functions/042 DELETE and INSERT in one query using WITH.en.srt 8.0 kB40 PostgreSQL Transactions/002 How SQL protect database during transaction.en.srt 8.0 kB34 Functions with PL_pgSQL language/015 Using IF with table data.en.srt 8.0 kB23 Indexes and Performance Optimization/011 Optimizer node types.en.srt 8.0 kB03 Creating and Modifying Tables/007 Install sample data for 'movies' database.en.srt 7.9 kB30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.en.srt 7.9 kB28 Window Functions/004 GROUP BY ROLLUP.en.srt 7.9 kB33 Functions with SQL language/005 Function returning a single value Part 2.en.srt 7.9 kB03 Creating and Modifying Tables/002 Creating the movie database and a actors table.en.srt 7.9 kB28 Window Functions/019 RANK and DENSE_RANK functions.en.srt 7.8 kB28 Window Functions/009 Using FILTER clause.en.srt 7.8 kB44 Managing PostgreSQL security/005 Database Level Security.en.srt 7.8 kB35 Exploring Stored Procedures/003 Understanding the use of stored procedures.en.srt 7.8 kB38 Creating Crosstab Reports/008 Aggregate over filter.en.srt 7.8 kB33 Functions with SQL language/008 Function using parameters Part 2.en.srt 7.7 kB34 Functions with PL_pgSQL language/028 Exception - Too many rows.en.srt 7.7 kB36 PostgreSQL Triggers/011 View triggers variables.en.srt 7.7 kB28 Window Functions/010 Using Window Functions.en.srt 7.7 kB34 Functions with PL_pgSQL language/021 CONTINUE statement.en.srt 7.6 kB03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.en.srt 7.6 kB28 Window Functions/008 Query performance check.en.srt 7.6 kB34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.en.srt 7.6 kB29 Using regular expressions for text patterns/004 POSIX regular expressions.en.srt 7.6 kB22 JSON with PostgreSQL/007 Create JSON from tables.en.srt 7.6 kB36 PostgreSQL Triggers/007 Steps to create a trigger.en.srt 7.6 kB44 Managing PostgreSQL security/011 Row level policy for application users.en.srt 7.5 kB22 JSON with PostgreSQL/008 Use json_agg to aggregate data.en.srt 7.5 kB03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.en.srt 7.5 kB34 Functions with PL_pgSQL language/007 Declaring variables in function.en.srt 7.5 kB14 String Functions/009 STRPOS.en.srt 7.4 kB22 JSON with PostgreSQL/011 Null Values in JSON documents.en.srt 7.4 kB11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.en.srt 7.4 kB28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.en.srt 7.4 kB23 Indexes and Performance Optimization/005 Size of the table index.en.srt 7.4 kB15 Aggregate functions/004 GREATEST AND LEAST functions.en.srt 7.3 kB42 Using Human Resource (hr) database/002 Quick overview of all tables.en.srt 7.3 kB31 Table Partitions/010 Partition maintenance.en.srt 7.3 kB33 Functions with SQL language/003 Function returning no values.en.srt 7.3 kB28 Window Functions/006 GROUP BY CUBE.en.srt 7.3 kB26 Common Table Expressions (CTE)/006 Recursive CTEs.en.srt 7.3 kB37 Using Cursors/002 Cursors and procedural languages.en.srt 7.3 kB31 Table Partitions/017 Common partitioning mistakes.en.srt 7.3 kB10 Conversion Functions/004 to_timestamp.en.srt 7.3 kB42 Using Human Resource (hr) database/013 Discard characters from employees email address.en.srt 7.2 kB31 Table Partitions/016 Partitioning Advantages.en.srt 7.2 kB25 Fun with subqueries/013 Subquery using EXISTS.en.srt 7.2 kB18 Joining Multiple Tables/005 INNER joins with filter data Part 3.en.srt 7.2 kB18 Joining Multiple Tables/013 FULL Joins.en.srt 7.2 kB24 All about Views/006 A view with UNION of multiple tables.en.srt 7.1 kB06 Filtering Data/004 Combining AND, OR operators.en.srt 7.1 kB28 Window Functions/035 Window Function Summary.en.srt 7.0 kB09 Data type conversions/003 Implicit to Explicit conversions.en.srt 7.0 kB33 Functions with SQL language/019 Drop a function.en.srt 7.0 kB34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.en.srt 7.0 kB14 String Functions/001 UPPER, LOWER and INITCAP.en.srt 6.9 kB28 Window Functions/011 Partitioning the data.en.srt 6.9 kB21 Exploring array functions/003 Using inclusion operators.en.srt 6.9 kB18 Joining Multiple Tables/006 INNER joins with different data type columns.en.srt 6.9 kB22 JSON with PostgreSQL/009 Build a JSON array.en.srt 6.8 kB34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.en.srt 6.8 kB03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.en.srt 6.8 kB24 All about Views/017 Creating a materialized view.en.srt 6.8 kB34 Functions with PL_pgSQL language/012 Variables in block and subblock.en.srt 6.8 kB16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.en.srt 6.8 kB41 Using Northwind Database/011 Top customers with total orders amount.en.srt 6.8 kB36 PostgreSQL Triggers/020 Creating event triggers.en.srt 6.8 kB23 Indexes and Performance Optimization/006 List counts of all indexes.en.srt 6.7 kB20 PostgreSQL Schemas/008 What is a system catalog schema_.en.srt 6.7 kB34 Functions with PL_pgSQL language/013 How to return query results.en.srt 6.7 kB28 Window Functions/038 Getting RANK to compute group and global ranks.en.srt 6.6 kB24 All about Views/003 Rename a view.en.srt 6.6 kB25 Fun with subqueries/003 Subquery with IN operator.en.srt 6.6 kB36 PostgreSQL Triggers/021 Event trigger events and variables.en.srt 6.6 kB46 PostgreSQL Internals/008 Show all running queries.en.srt 6.6 kB12 Explore PostgreSQL Constraints/004 DEFAULT constraint.en.srt 6.6 kB19 Combining queries together/004 INTERSECT with tables.en.srt 6.6 kB46 PostgreSQL Internals/002 List all database and schemas.en.srt 6.6 kB13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.en.srt 6.5 kB02 Introduction to PostgreSQL/004 Creating a Database User.en.srt 6.5 kB34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.en.srt 6.5 kB44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.en.srt 6.4 kB21 Exploring array functions/010 Using arrays in tables.en.srt 6.4 kB25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.en.srt 6.4 kB38 Creating Crosstab Reports/006 Pivoting rows and columns.en.srt 6.4 kB21 Exploring array functions/014 Array Dimensions are ignored!.en.srt 6.4 kB24 All about Views/022 Why not use a table instead of materialized view_.en.srt 6.4 kB23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.en.srt 6.3 kB23 Indexes and Performance Optimization/016 Hash Index.en.srt 6.3 kB06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.en.srt 6.3 kB16 Using DATE_TIME functions/012 OVERLAPS Operator.en.srt 6.3 kB23 Indexes and Performance Optimization/008 SQL Statement execution process.en.srt 6.2 kB44 Managing PostgreSQL security/004 Use pgAdmin to create roles.en.srt 6.2 kB23 Indexes and Performance Optimization/028 Try to use index only scan.en.srt 6.2 kB44 Managing PostgreSQL security/001 Security concepts and and levels.en.srt 6.2 kB22 JSON with PostgreSQL/015 The Containment Operator.en.srt 6.2 kB32 Server Programming/004 Functions vs stored procedures.en.srt 6.1 kB46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.en.srt 6.1 kB23 Indexes and Performance Optimization/004 List all indexes.en.srt 6.1 kB22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.en.srt 6.1 kB24 All about Views/026 List materialized views with no unique index.en.srt 6.1 kB14 String Functions/010 SUBSTRING.en.srt 6.1 kB34 Functions with PL_pgSQL language/025 Returning a table.en.srt 6.1 kB04 Modifying Data in the tables/001 Insert a data into table.en.srt 6.0 kB14 String Functions/007 LENGTH.en.srt 6.0 kB45 PostgreSQL Utilities - psql/001 Connect to local or remote database.en.srt 5.9 kB44 Managing PostgreSQL security/014 Row Level Security Performance.en.srt 5.9 kB40 PostgreSQL Transactions/006 How to fix aborted transaction.en.srt 5.9 kB21 Exploring array functions/015 Display all array elements.en.srt 5.8 kB14 String Functions/012 REPLACE.en.srt 5.8 kB31 Table Partitions/013 Partition pruning.en.srt 5.8 kB28 Window Functions/005 ROLLUP - Grouping multiple columns.en.srt 5.8 kB11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.en.srt 5.8 kB23 Indexes and Performance Optimization/001 What is an index_.en.srt 5.8 kB41 Using Northwind Database/007 Total products in each categories.en.srt 5.8 kB33 Functions with SQL language/002 Introducing dollar quoting.en.srt 5.7 kB34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.en.srt 5.7 kB45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.en.srt 5.7 kB45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.en.srt 5.7 kB28 Window Functions/040 Using WITH clause to create your own data.en.srt 5.7 kB16 Using DATE_TIME functions/020 View and set timezones.en.srt 5.6 kB07 PostgreSQL Data types/006 Date_Time data types.en.srt 5.6 kB18 Joining Multiple Tables/004 INNER joins with filter data Part 2.en.srt 5.6 kB40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.en.srt 5.6 kB38 Creating Crosstab Reports/001 What is a crosstab report.en.srt 5.6 kB23 Indexes and Performance Optimization/007 Drop a index.en.srt 5.5 kB28 Window Functions/007 GROUP BY GROUPING SETS.en.srt 5.5 kB35 Exploring Stored Procedures/004 Returning a value.en.srt 5.5 kB28 Window Functions/027 ROW_NUMBER() - Find Nth record.en.srt 5.5 kB13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.en.srt 5.4 kB12 Explore PostgreSQL Constraints/001 Introduction to constraints.en.srt 5.4 kB16 Using DATE_TIME functions/015 AGE function.en.srt 5.4 kB08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.en.srt 5.4 kB03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.en.srt 5.4 kB24 All about Views/012 What is an updatable view_.en.srt 5.4 kB43 Exploring Stock Markets Data/003 Get first or last record per each group.en.srt 5.3 kB45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.en.srt 5.3 kB28 Window Functions/018 Using WINDOW with ROWS BETWEEN.en.srt 5.3 kB05 Querying Data/002 Selecting specific columns from a table.en.srt 5.2 kB22 JSON with PostgreSQL/003 JSON and JSONB data types.en.srt 5.2 kB43 Exploring Stock Markets Data/002 Select first or last records in a table.en.srt 5.2 kB03 Creating and Modifying Tables/001 Movie Database Structure.en.srt 5.2 kB28 Window Functions/001 Introduction to Window Functions.en.srt 5.2 kB13 PostgreSQL Sequences/009 Share one sequence between two tables.en.srt 5.2 kB22 JSON with PostgreSQL/001 What is JSON_.en.srt 5.2 kB16 Using DATE_TIME functions/017 CURRENT_TIME function.en.srt 5.2 kB02 Introduction to PostgreSQL/011 Drop a database.en.srt 5.1 kB42 Using Human Resource (hr) database/019 Select employees not in range.en.srt 5.1 kB42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.en.srt 5.0 kB45 PostgreSQL Utilities - psql/003 List all databases and tables.en.srt 5.0 kB11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.en.srt 5.0 kB14 String Functions/008 POSITION.en.srt 4.9 kB41 Using Northwind Database/008 List products that needs re-ordering.en.srt 4.9 kB27 Grouping sets/001 Introduction to summarization.en.srt 4.9 kB33 Functions with SQL language/006 Function returning a single value Part 3.en.srt 4.9 kB32 Server Programming/005 User-defined functions.en.srt 4.9 kB24 All about Views/008 Re-arrange columns in a view.en.srt 4.8 kB18 Joining Multiple Tables/016 Self Joins Part 2.en.srt 4.8 kB38 Creating Crosstab Reports/004 Orders matters in crosstab reports.en.srt 4.8 kB06 Filtering Data/003 OR operator.en.srt 4.8 kB11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.en.srt 4.8 kB19 Combining queries together/003 UNION tables with different number of columns.en.srt 4.8 kB45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.en.srt 4.7 kB05 Querying Data/008 Using ORDER BY with column name or column number.en.srt 4.7 kB36 PostgreSQL Triggers/017 Use triggers very cautiously.en.srt 4.7 kB42 Using Human Resource (hr) database/001 Human Resources Database Structure.en.srt 4.6 kB05 Querying Data/007 Using ORDER BY to sort rows by expressions.en.srt 4.6 kB16 Using DATE_TIME functions/002 System Month Date settings.en.srt 4.6 kB20 PostgreSQL Schemas/004 Move a table to a new schema.en.srt 4.6 kB11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.en.srt 4.6 kB18 Joining Multiple Tables/012 RIGHT joins Part 2.en.srt 4.6 kB21 Exploring array functions/013 Modifying array data.en.srt 4.6 kB24 All about Views/018 Drop a materialized view.en.srt 4.5 kB23 Indexes and Performance Optimization/031 Adding data while indexing.en.srt 4.5 kB23 Indexes and Performance Optimization/020 EXPLAIN output options.en.srt 4.5 kB22 JSON with PostgreSQL/014 The Existence Operator.en.srt 4.4 kB03 Creating and Modifying Tables/005 Creating the movies_revenues table.en.srt 4.4 kB42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.en.srt 4.4 kB13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.en.srt 4.4 kB41 Using Northwind Database/012 Orders with many lines of ordered items.en.srt 4.4 kB41 Using Northwind Database/015 Countries with customers or suppliers.en.srt 4.3 kB33 Functions with SQL language/013 Function - order matters!.en.srt 4.3 kB33 Functions with SQL language/016 Function parameter modes.en.srt 4.3 kB42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.en.srt 4.3 kB36 PostgreSQL Triggers/019 Event triggers usage scenarios.en.srt 4.3 kB29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.en.srt 4.3 kB04 Modifying Data in the tables/005 Update data in a table.en.srt 4.3 kB24 All about Views/011 Regular views are dynamic.en.srt 4.2 kB24 All about Views/023 The downsides of using materialized views.en.srt 4.2 kB28 Window Functions/037 Difference between RANK and DENSE_RANK.en.srt 4.2 kB04 Modifying Data in the tables/007 Updating all records in a table.en.srt 4.2 kB46 PostgreSQL Internals/004 List all columns from a table.en.srt 4.2 kB03 Creating and Modifying Tables/003 Creating the directors table.en.srt 4.2 kB47 Managing Tables/002 Duplicate a table with or without data.en.srt 4.2 kB41 Using Northwind Database/004 Orders shipped to latin america.en.srt 4.2 kB11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.en.srt 4.1 kB04 Modifying Data in the tables/008 Delete data from a table.en.srt 4.1 kB11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.en.srt 4.1 kB32 Server Programming/006 Structure of a function.en.srt 4.1 kB31 Table Partitions/004 Partition types.en.srt 4.1 kB34 Functions with PL_pgSQL language/009 Copying data types.en.srt 4.1 kB36 PostgreSQL Triggers/006 Trigger key points.en.srt 4.1 kB05 Querying Data/004 Using SELECT statement for expressions.en.srt 4.1 kB37 Using Cursors/003 Steps to create a cursor.en.srt 4.0 kB04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.en.srt 4.0 kB36 PostgreSQL Triggers/004 Trigger table.en.srt 4.0 kB24 All about Views/010 Add a column in a view.en.srt 4.0 kB02 Introduction to PostgreSQL/005 Creating a Database.en.srt 4.0 kB33 Functions with SQL language/014 Function returning a table.en.srt 4.0 kB44 Managing PostgreSQL security/013 Inspecting permissions.en.srt 4.0 kB46 PostgreSQL Internals/009 Terminate running and IDLE process.en.srt 4.0 kB06 Filtering Data/005 What goes before and after WHERE clause.en.srt 3.9 kB46 PostgreSQL Internals/005 View system metadata via system information functions.en.srt 3.9 kB42 Using Human Resource (hr) database/021 Update phone_number with your strings.en.srt 3.9 kB12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.en.srt 3.9 kB28 Window Functions/012 Set data into millions format.en.srt 3.9 kB11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.en.srt 3.8 kB05 Querying Data/006 Using ORDER BY with alias column name.en.srt 3.8 kB40 PostgreSQL Transactions/004 Transaction setup.en.srt 3.8 kB11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.en.srt 3.8 kB47 Managing Tables/004 Export Data to CSV files.en.srt 3.7 kB
21 Exploring array functions/018 Single and Multi-dimensional arrays.html 3.7 kB25 Fun with subqueries/008 A SELECT without a FROM.en.srt 3.7 kB24 All about Views/020 How to check if a materialized view is populated or not_.en.srt 3.7 kB14 String Functions/011 REPEAT.en.srt 3.7 kB34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.en.srt 3.7 kB02 Introduction to PostgreSQL/007 Install sample data files on server.en.srt 3.7 kB45 PostgreSQL Utilities - psql/014 Turn on query execution time.en.srt 3.6 kB36 PostgreSQL Triggers/003 Types of triggers.en.srt 3.6 kB03 Creating and Modifying Tables/012 Deleting tables from a database.en.srt 3.5 kB28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.en.srt 3.5 kB06 Filtering Data/007 Can we use column aliases with WHERE_.en.srt 3.5 kB18 Joining Multiple Tables/019 Natural Joins Part 2.en.srt 3.5 kB42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.en.srt 3.4 kB42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.en.srt 3.4 kB34 Functions with PL_pgSQL language/008 Variable initializing timing.en.srt 3.4 kB11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.en.srt 3.3 kB04 Modifying Data in the tables/002 Insert multiple records into a table.en.srt 3.3 kB14 String Functions/003 REVERSE.en.srt 3.3 kB42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.en.srt 3.2 kB02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.en.srt 3.2 kB44 Managing PostgreSQL security/012 DROP a policy.en.srt 3.2 kB42 Using Human Resource (hr) database/018 Select employees with particular department id only.en.srt 3.2 kB34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.en.srt 3.2 kB02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.en.srt 3.2 kB24 All about Views/009 Delete a column in a view.en.srt 3.2 kB34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.en.srt 3.1 kB02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.en.srt 3.1 kB12 Explore PostgreSQL Constraints/011 Drop a constraint.en.srt 3.1 kB24 All about Views/004 Delete a view.en.srt 3.1 kB02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.en.srt 3.1 kB06 Filtering Data/001 Comparison, Logical and Arithmetic operators.en.srt 3.1 kB42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.en.srt 3.1 kB02 Introduction to PostgreSQL/009 Install sample stocks market data.en.srt 3.0 kB20 PostgreSQL Schemas/006 Alter a schema ownership.en.srt 3.0 kB23 Indexes and Performance Optimization/017 BRIN index.en.srt 3.0 kB04 Modifying Data in the tables/006 Updating a row and returning the updated row.en.srt 3.0 kB42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.en.srt 3.0 kB11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.en.srt 2.9 kB13 PostgreSQL Sequences/004 Create a sequence using a specific data type.en.srt 2.9 kB42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.en.srt 2.9 kB02 Introduction to PostgreSQL/009 sample_data.zip 2.9 kB41 Using Northwind Database/006 First the oldest and latest order date.en.srt 2.9 kB35 Exploring Stored Procedures/005 Drop a procedure.en.srt 2.8 kB25 Fun with subqueries/001 Introduction to subqueries.html 2.8 kB42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.en.srt 2.8 kB45 PostgreSQL Utilities - psql/011 Make table layout funkey!.en.srt 2.8 kB41 Using Northwind Database/002 Orders shipping to USA or France.en.srt 2.8 kB11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.en.srt 2.7 kB38 Creating Crosstab Reports/002 Installing the tablefunc extension.en.srt 2.7 kB45 PostgreSQL Utilities - psql/002 Switch connection to a new database.en.srt 2.7 kB04 Modifying Data in the tables/003 Insert a data that had quotes.en.srt 2.6 kB42 Using Human Resource (hr) database/017 Get unique designations in employees table.en.srt 2.6 kB42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.en.srt 2.5 kB36 PostgreSQL Triggers/018 What is an event trigger.en.srt 2.5 kB41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.en.srt 2.5 kB23 Indexes and Performance Optimization/018 GIN Index.en.srt 2.4 kB37 Using Cursors/007 Updating data.en.srt 2.4 kB45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.en.srt 2.4 kB34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.en.srt 2.4 kB06 Filtering Data/006 Execution order with AND, OR operators.en.srt 2.3 kB46 PostgreSQL Internals/010 How to check live and dead rows in tables.en.srt 2.3 kB42 Using Human Resource (hr) database/010 Using an alias name with columns.en.srt 2.3 kB29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.en.srt 2.2 kB03 Creating and Modifying Tables/008 Create a sample Database _mydata_.html 2.2 kB24 All about Views/025 List all materialized views by a SELECT statement.en.srt 2.2 kB42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.en.srt 2.1 kB37 Using Cursors/008 Closing a cursor.en.srt 2.1 kB12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.en.srt 2.1 kB43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.en.srt 2.1 kB17 Grouping Data/003 Order of execution in GROUP BY clause.en.srt 2.0 kB36 PostgreSQL Triggers/001 Introduction to triggers.html 2.0 kB42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.en.srt 2.0 kB18 Joining Multiple Tables/021 ON versus WHERE.html 2.0 kB25 Fun with subqueries/007 Subquery with an alias.en.srt 2.0 kB16 Using DATE_TIME functions/016 CURRENT_DATE function.en.srt 1.9 kB06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.en.srt 1.9 kB13 PostgreSQL Sequences/006 Delete a sequence.en.srt 1.8 kB25 Fun with subqueries/005 Get total revenues for all 'English' films.html 1.8 kB13 PostgreSQL Sequences/008 List all sequences in a database.en.srt 1.8 kB47 Managing Tables/006 Backup your databases regularly.html 1.8 kB01 Welcome/001 Course Introduction.en.srt 1.8 kB47 Managing Tables/007 Test queries on a test database.html 1.8 kB24 All about Views/027 Quick queries for materialized views.html 1.6 kB42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.en.srt 1.6 kB26 Common Table Expressions (CTE)/004 Get the total revenues for each director.html 1.6 kB47 Managing Tables/008 Not documenting your process_.html 1.6 kB41 Using Northwind Database/001 Using Northwind database.en.srt 1.6 kB22 JSON with PostgreSQL/012 JSON nulls and SQL nulls.html 1.6 kB49 Thank You!/001 Your feedback is very valuable.html 1.5 kB45 PostgreSQL Utilities - psql/006 Describe a table.en.srt 1.5 kB43 Exploring Stock Markets Data/001 Introduction To stock market data.html 1.5 kB42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.en.srt 1.5 kB17 Grouping Data/005 Order of execution in HAVING clause.en.srt 1.5 kB45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.en.srt 1.4 kB36 PostgreSQL Triggers/024 Dropping a trigger.en.srt 1.4 kB01 Welcome/002 Sample Data Files.html 1.3 kB49 Thank You!/002 Upcoming course - Advanced Time Series Analysis.html 1.3 kB45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.en.srt 1.3 kB42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.en.srt 1.1 kB49 Thank You!/003 Thank You!.en.srt 1.0 kB38 Creating Crosstab Reports/509 pivotcode.sql 948 Bytes04 Modifying Data in the tables/026 q_insert data into table.sql 267 Bytes03 Creating and Modifying Tables/017 q_creating the movies table with a foreign key.sql 258 Bytes03 Creating and Modifying Tables/016 q_creating the directors table.sql 227 Bytes04 Modifying Data in the tables/029 q_use RETURNING to get info on added rows.sql 224 Bytes03 Creating and Modifying Tables/018 q_creating the movies_revenues table.sql 216 Bytes34 Functions with PL_pgSQL language/437 q_variable_initialization_timing.sql 192 Bytes03 Creating and Modifying Tables/015 q_creating movies database and actors table.sql 186 Bytes03 Creating and Modifying Tables/019 q_creating a junction table with movies and actors table.sql 184 Bytes04 Modifying Data in the tables/027 q_insert multiple records into a table.sql 137 Bytes03 Creating and Modifying Tables/025 q_deleting tables from a database.sql 119 Bytes04 Modifying Data in the tables/028 q_insert a data that had quotes.sql 93 Bytes
1953 THE DESERT RATS DD 2.0 EN.FR.ES. CC.EN.... 11.5 GB 2001 Conspiracy BluRay 720p Sub.CZE.EN 1980 THE SEA... 14.6 GB 1980 THE SEA WOLVES 1980 DD 2.0 EN. CC.EN. Sub.EN.FR.... 11.5 GB 1964 Walt Disney Those Calloways DVD EN.FR. CC.EN.... 10.1 GB SPARTACUS 1960 BluRay 1080p DTS-HD MA 5.1 EN.FR.... 49.3 GB Barbie and The Magic of Pegasus 2005 DVD DD 5.1 EN.... 9.0 GB IMMORTAL BELOVED 1994 [Gary Oldman] BluRay 1080p TrueHD... 30.7 GB
En Yeni Şarkılar 2017 Türkçe Pop Müzik En Çok Dinlenen... 886.3 MB Charlotte's Web 1972 DVD DD 2.0 EN. CC.EN. Sub.EN. The... 7.5 GB Conspiracy 2001 BluRay 720p Subs.CZE.EN. The Desert Rats... 10.2 GB Andor [HDTV 720p][Cap.205] 8145次下载
Cap
HDTV
720p
Маня и Груня.2024.WEB-DL 720p.Files-x 5109次下载
2024
WEB
DL
Havoc.2025.1080p.NF.WEB-DL.DDP5.1.Atmos.H.264-EniaHD.mkv 5077次下载
WEB
DL
DDP5
The.Super.Cube.S01E09.1080p.iQ.WEB-DL.AAC2.0.H.264-VARYG.mkv 5040次下载
WEB
DL
Cube
Star.Wars.Andor.S02E05.I.Have.Friends.Everywhere.1080p.DS... 4944次下载
WEB
DL
Star
新桥恋人.电影港 地址发布页 www.dygang.me 收藏不迷路 4365次下载
me
www
发布页
Night at the Museum Battle of the Smithsonian 2009 2160p... 4161次下载
KiNGDOM
WEB
DL
www.UIndex.org - ... 4126次下载
www
MeGusta
HEVC
Palma.2.2024.WEB-DL.1080p.ExKinoRay.mkv 4000次下载
WEB
DL
2.2024
Guns N' Roses - Greatest Hits Live Broadcast Collection... 3915次下载
Live
Remastered
Hits
Andor [HDTV 720p][Cap.205] 8145次下载
Cap
HDTV
720p
(同人CG集) [白色絵の具 (無味ムスミ)] 友達の母が巨乳で金髪の淫乱美女でした.zip 6346次下载
zip
巨乳
CG
You.S05E02.720p.HEVC.x265-MeGusta[EZTVx.to].mkv 6221次下载
S05E02
HEVC
720p
up-mod-minecraft-play-with-friends-v1-21-80-28-... 6023次下载
982108028
mod
play
the.last.of.us.s02e02.1080p.web.h264-successful... 5335次下载
web
last
h264
异世降临.6v电影 地址发布页 www.6v123.net 收藏不迷路 5220次下载
www
发布页
6v123
Opasnaya.blizost.S01.2025.WEB-DL.1080p 5127次下载
WEB
DL
S01
Маня и Груня.2024.WEB-DL 720p.Files-x 5109次下载
2024
WEB
DL
Andor.S02E02.Sagrona.Teema.1080p.HEVC.x265-MeGu... 5100次下载
HEVC
Andor
mkv
Havoc.2025.1080p.NF.WEB-DL.DDP5.1.Atmos.H.264-E... 5077次下载
WEB
DL
DDP5
Shoot.Paragon.1970.DVDRip.XviD-AFO [NO-RAR] -...
Shoot
www
AFO
DASS-041-U
DASS
041
www.UIndex.org - Andy Richter Controls...
www
Episode
S01E04
[AniDub]_Sora_Kara_Furu_Ichioku_no_Hoshi_[Oriko_Qbiq]
Furu
no
Oriko
[BEST-TORRENTS.COM]...
Cheese
DL
2160p
【成人抖音-黑料-换妻-直播-手机搜7t7a.cc】麻豆传媒映画・爆操黑丝车模小姐姐・超级圆润...
麻豆
小姐姐
车模
Por siempre [HDTV 720p][Cap.106]
siempre
720p
Cap
Workaholics.S04E01.Season.4.Episode.1.WEBRip.72...
Workaholics
Episode
HoC
MobLand.S01E01.1080P.ENG.ITA.H264-TheBlackKing.mkv
ENG
H264
ITA
43606101 - Public Dick Flash Compilation..mp4
Dick
..
Compilation
吃瓜！去欧美留学的林淑瑶 ️被欧美大鸡巴驯化3P大战被洋吊深喉狂艹！
欧美
3P
被洋
Hellraiser III Hell On Earth 1992 1080p BluRay...
5.1
1992
AAC
Ghosts S04E21 Kyle 1080p PMTP WEB-DL DDP5 1 H...
WEB
DL
STC
[Gecko] Araiguma Calcal-dan - S01E07...
WEB
DL
AAC
salamander-2-salamander-deluxe-pack-play-statio...
salamander
play
full
Catalina Cruz live cam show pack
Catalina
show
live
SDMU-534
534
SDMU
dccdom.com@MIDV111C
com
MIDV111C
dccdom