[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]

Creation Time	March 28, 2025, 3:22 p.m.
Last Access Time	April 9, 2025, 8:41 p.m.
File Size	19.7 GB
Keywords	En From Beginner Bootcamp to 2021 Go PostgreSQL Udemy Advanced
Total Requests	10
Total Files	1260
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.mp4 195.8 MB
28 Window Functions/015 Understanding window frames.mp4 185.1 MB
44 Managing PostgreSQL security/009 Row Level Security.mp4 169.4 MB
20 PostgreSQL Schemas/005 Schema search path.mp4 155.3 MB
30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.mp4 150.2 MB
33 Functions with SQL language/009 Function using parameters Part 3.mp4 132.9 MB
31 Table Partitions/006 Partition by List.mp4 130.7 MB
23 Indexes and Performance Optimization/030 Expression Index.mp4 120.1 MB
48 Extended PostgreSQL/001 Create a custom index method.mp4 119.5 MB
16 Using DATE_TIME functions/022 date_part function.mp4 119.2 MB
27 Grouping sets/002 Subtotals on group sets.mp4 114.6 MB
27 Grouping sets/004 Using GROUPING with ROLLUP.mp4 112.6 MB
31 Table Partitions/005 Partition by Range.mp4 102.8 MB
23 Indexes and Performance Optimization/027 Using organized vs random data.mp4 99.7 MB
23 Indexes and Performance Optimization/032 Invalidating an index.mp4 98.9 MB
28 Window Functions/002 Analyze Global Trades Data.mp4 96.7 MB
37 Using Cursors/010 Using a parametric cursor via function.mp4 92.3 MB
06 Filtering Data/009 Using Logical operators.mp4 90.4 MB
38 Creating Crosstab Reports/011 Dynamic pivot table columns.mp4 90.4 MB
46 PostgreSQL Internals/604 internal - view system administration functions.mp4 89.3 MB
12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.mp4 89.0 MB
06 Filtering Data/010 Using LIMIT and OFFSET.mp4 88.9 MB
06 Filtering Data/014 Using LIKE and ILIKE.mp4 88.0 MB
18 Joining Multiple Tables/007 LEFT joins Part 1.mp4 87.2 MB
31 Table Partitions/002 When a partition can be used_.mp4 86.4 MB
17 Grouping Data/004 Using HAVING.mp4 85.1 MB
36 PostgreSQL Triggers/014 Creating an audit trigger.mp4 84.6 MB
06 Filtering Data/011 Using FETCH.mp4 83.8 MB
45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.mp4 83.5 MB
18 Joining Multiple Tables/001 INNER joins.mp4 82.7 MB
22 JSON with PostgreSQL/017 Indexing on JSONB.mp4 82.1 MB
33 Functions with SQL language/010 Function using parameters Part 4.mp4 80.3 MB
47 Managing Tables/001 Using SELECT INTO to create a new table with joins.mp4 80.2 MB
28 Window Functions/013 Ordering inside window.mp4 79.2 MB
36 PostgreSQL Triggers/015 Creating conditional triggers.mp4 78.0 MB
38 Creating Crosstab Reports/012 Interactive client-side pivot.mp4 77.9 MB
23 Indexes and Performance Optimization/002 Create an index.mp4 77.8 MB
28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4 77.7 MB
07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.mp4 77.3 MB
46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.mp4 75.9 MB
33 Functions with SQL language/007 Function using parameters.mp4 75.5 MB
36 PostgreSQL Triggers/022 Creating an audit event trigger.mp4 75.2 MB
23 Indexes and Performance Optimization/019 The EXPLAIN statement.mp4 74.7 MB
26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.mp4 74.3 MB
26 Common Table Expressions (CTE)/002 CTE query examples.mp4 73.6 MB
28 Window Functions/021 LEAD and LAG functions.mp4 73.0 MB
18 Joining Multiple Tables/020 Append tables with different columns.mp4 70.8 MB
44 Managing PostgreSQL security/007 Table Level Security.mp4 70.5 MB
44 Managing PostgreSQL security/015 Encrypted data in columns.mp4 69.7 MB
34 Functions with PL_pgSQL language/026 Using RETURN NEXT.mp4 69.7 MB
06 Filtering Data/012 Using IN, NOT IN.mp4 68.5 MB
22 JSON with PostgreSQL/013 Getting information from JSON documents.mp4 68.5 MB
15 Aggregate functions/003 MIN and MAX functions.mp4 68.4 MB
33 Functions with SQL language/011 Function returning a composite.mp4 67.8 MB
34 Functions with PL_pgSQL language/030 Exception with data exception errors.mp4 67.6 MB
31 Table Partitions/003 Table inheritance.mp4 66.6 MB
25 Fun with subqueries/002 Subqueries with WHERE Clause.mp4 66.0 MB
24 All about Views/024 Using materialized view for websites page analysis.mp4 63.7 MB
30 Powerful text searches in PostgreSQL/004 Full text search within a table.mp4 63.5 MB
21 Exploring array functions/017 Array vs JSONB.mp4 63.3 MB
31 Table Partitions/007 Partition by Hash.mp4 63.0 MB
31 Table Partitions/009 Multi-level partitioning.mp4 62.4 MB
38 Creating Crosstab Reports/013 Handling missing values.mp4 62.3 MB
07 PostgreSQL Data types/014 Network Addresses.mp4 62.0 MB
38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.mp4 61.9 MB
06 Filtering Data/002 AND operator.mp4 61.6 MB
15 Aggregate functions/005 Average with AVG function.mp4 61.5 MB
06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.mp4 61.4 MB
28 Window Functions/016 ROWS and RANGE indicators.mp4 61.3 MB
17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.mp4 61.1 MB
16 Using DATE_TIME functions/004 Strings to Dates conversions.mp4 61.0 MB
18 Joining Multiple Tables/014 Joining multiple tables.mp4 61.0 MB
16 Using DATE_TIME functions/006 Formatting Dates.mp4 60.9 MB
34 Functions with PL_pgSQL language/016 CASE Statement.mp4 60.8 MB
07 PostgreSQL Data types/008 TIME.mp4 60.8 MB
16 Using DATE_TIME functions/021 How to handle timezones.mp4 60.6 MB
12 Explore PostgreSQL Constraints/003 UNIQUE constraint.mp4 60.3 MB
09 Data type conversions/002 Using CAST for data conversions.mp4 59.6 MB
23 Indexes and Performance Optimization/023 Index are not free.mp4 58.7 MB
47 Managing Tables/012 Recovering unused space with VACUUM.mp4 58.5 MB
22 JSON with PostgreSQL/011 Null Values in JSON documents.mp4 58.5 MB
47 Managing Tables/011 PostgreSQL autovacuum proces.mp4 57.8 MB
16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.mp4 57.8 MB
39 Internationalization/001 Global Character Set Support.mp4 57.7 MB
38 Creating Crosstab Reports/008 Aggregate over filter.mp4 57.5 MB
23 Indexes and Performance Optimization/003 Create unique indexes.mp4 57.3 MB
39 Internationalization/002 Client and Server Encoding.mp4 57.2 MB
34 Functions with PL_pgSQL language/024 Using RETURN QUERY.mp4 56.9 MB
18 Joining Multiple Tables/003 INNER joins with filter data Part 1.mp4 56.9 MB
03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.mp4 56.8 MB
23 Indexes and Performance Optimization/022 Understanding query cost model.mp4 56.6 MB
40 PostgreSQL Transactions/005 Transaction analysis.mp4 56.2 MB
23 Indexes and Performance Optimization/029 Partial indexes.mp4 55.8 MB
17 Grouping Data/001 Using GROUP BY.mp4 55.8 MB
12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.mp4 55.8 MB
18 Joining Multiple Tables/017 CROSS Joins.mp4 55.8 MB
21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.mp4 55.6 MB
33 Functions with SQL language/015 Function as a table source.mp4 55.4 MB
24 All about Views/019 Changing materialized view data.mp4 55.4 MB
33 Functions with SQL language/012 Function returning multiple rows.mp4 55.2 MB
47 Managing Tables/013 Generated Columns.mp4 55.1 MB
07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.mp4 54.9 MB
24 All about Views/002 Creating a view.mp4 54.5 MB
07 PostgreSQL Data types/001 Boolean.mp4 54.5 MB
18 Joining Multiple Tables/011 RIGHT joins.mp4 54.5 MB
19 Combining queries together/001 Combine results sets with UNION.mp4 54.4 MB
28 Window Functions/023 ROW_NUMBER function.mp4 53.8 MB
22 JSON with PostgreSQL/006 Update and Delete JSON Data.mp4 53.2 MB
36 PostgreSQL Triggers/005 Pros and Cons of triggers.mp4 52.9 MB
34 Functions with PL_pgSQL language/023 WHILE loop.mp4 52.4 MB
07 PostgreSQL Data types/013 JSON.mp4 52.4 MB
30 Powerful text searches in PostgreSQL/002 Introducing tsvector.mp4 52.2 MB
25 Fun with subqueries/009 Correlated Queries.mp4 51.8 MB
12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.mp4 51.6 MB
18 Joining Multiple Tables/009 LEFT joins Part 3.mp4 51.2 MB
06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.mp4 50.7 MB
07 PostgreSQL Data types/010 UUID.mp4 50.3 MB
33 Functions with SQL language/001 Creating our first SQL function.mp4 50.2 MB
33 Functions with SQL language/004 Function returning a single value.mp4 50.2 MB
18 Joining Multiple Tables/002 INNER joins with USING.mp4 50.1 MB
36 PostgreSQL Triggers/010 Modify data at INSERT event.mp4 49.5 MB
44 Managing PostgreSQL security/006 Schema Level Security.mp4 48.9 MB
46 PostgreSQL Internals/006 View privileges information across tables.mp4 48.7 MB
05 Querying Data/003 Adding Aliases to columns in a table.mp4 48.5 MB
41 Using Northwind Database/009 Freight analysis.mp4 48.3 MB
16 Using DATE_TIME functions/023 date_trunc function.mp4 48.2 MB
28 Window Functions/003 Using aggregate functions.mp4 47.6 MB
21 Exploring array functions/016 Using Multi-dimensional arrays.mp4 47.6 MB
25 Fun with subqueries/004 Subquery with JOINs.mp4 47.4 MB
25 Fun with subqueries/012 Using ALL with subquery.mp4 47.3 MB
20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.mp4 47.3 MB
48 Extended PostgreSQL/002 Create a user-defined aggregate function.mp4 47.1 MB
28 Window Functions/034 Comparing with least number.mp4 47.0 MB
16 Using DATE_TIME functions/011 Using math operators with dates.mp4 46.8 MB
30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.mp4 46.4 MB
36 PostgreSQL Triggers/002 What is a trigger.mp4 46.2 MB
34 Functions with PL_pgSQL language/017 Searched CASE statement.mp4 46.1 MB
38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.mp4 46.1 MB
36 PostgreSQL Triggers/008 Data auditing with a trigger.mp4 45.9 MB
37 Using Cursors/009 Creating a PL_PGSQL Cursor.mp4 45.8 MB
12 Explore PostgreSQL Constraints/002 NOT NULL constraint.mp4 45.4 MB
33 Functions with SQL language/017 Function parameters with default values.mp4 45.2 MB
15 Aggregate functions/006 Combining Columns using Mathematical operators.mp4 45.1 MB
19 Combining queries together/002 UNION with filters and conditions.mp4 44.8 MB
16 Using DATE_TIME functions/001 Datetimes data types.mp4 44.3 MB
30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.mp4 44.3 MB
28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.mp4 44.2 MB
24 All about Views/016 What is a Materialized View.mp4 44.1 MB
16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.mp4 44.1 MB
10 Conversion Functions/001 to_char.mp4 44.0 MB
16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.mp4 43.9 MB
36 PostgreSQL Triggers/012 Disallow DELETE on a table.mp4 43.4 MB
05 Querying Data/005 Using ORDER BY to sort records.mp4 43.3 MB
07 PostgreSQL Data types/003 NUMERIC.mp4 43.2 MB
08 Modifying Table Structures, Add constraints/003 Add constraints to columns.mp4 43.1 MB
30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.mp4 42.9 MB
18 Joining Multiple Tables/008 LEFT joins Part 2.mp4 42.9 MB
46 PostgreSQL Internals/002 List all database and schemas.mp4 42.9 MB
41 Using Northwind Database/014 Late shipped orders by employees.mp4 42.9 MB
37 Using Cursors/001 Understanding row by row operations.mp4 42.9 MB
47 Managing Tables/003 Import data from CSV files.mp4 42.8 MB
37 Using Cursors/005 Opening a cursor.mp4 42.6 MB
07 PostgreSQL Data types/004 DECIMALS.mp4 42.5 MB
24 All about Views/014 Updatable views using WITH CHECK OPTION.mp4 42.5 MB
24 All about Views/007 Connecting multiple tables with a single view.mp4 42.4 MB
38 Creating Crosstab Reports/007 Matrix report via a query.mp4 42.3 MB
32 Server Programming/001 PostgreSQL as a development platform_.mp4 42.0 MB
12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.mp4 42.0 MB
23 Indexes and Performance Optimization/013 Index Nodes.mp4 41.9 MB
03 Creating and Modifying Tables/007 Install sample data for 'movies' database.mp4 41.0 MB
17 Grouping Data/007 Handling NULL values with GROUP BY.mp4 40.9 MB
20 PostgreSQL Schemas/007 Duplicate a schema along with all data.mp4 40.8 MB
24 All about Views/005 Using filters with views.mp4 40.7 MB
38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.mp4 40.7 MB
14 String Functions/002 LEFT and RIGHT.mp4 40.5 MB
25 Fun with subqueries/011 Using ANY with subquery.mp4 40.4 MB
24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 40.3 MB
34 Functions with PL_pgSQL language/010 Assigning variables from query.mp4 40.2 MB
46 PostgreSQL Internals/003 List all tables and views.mp4 39.9 MB
40 PostgreSQL Transactions/001 What is a transaction_.mp4 39.8 MB
12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.mp4 39.7 MB
29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.mp4 39.6 MB
25 Fun with subqueries/010 SELECT.. IN (Subquery).mp4 39.3 MB
05 Querying Data/001 Select all data from a table.mp4 39.2 MB
23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.mp4 39.2 MB
16 Using DATE_TIME functions/018 Date accuracy with EPOCH.mp4 38.8 MB
31 Table Partitions/011 ALTERing the partition bounds.mp4 38.5 MB
04 Modifying Data in the tables/009 Using UPSERT.mp4 38.4 MB
40 PostgreSQL Transactions/003 ACID Database.mp4 38.3 MB
41 Using Northwind Database/013 Orders with double entry line items.mp4 38.3 MB
28 Window Functions/020 NTILE function.mp4 38.1 MB
15 Aggregate functions/001 Counting results via COUNT function.mp4 38.1 MB
15 Aggregate functions/002 Sum with SUM function.mp4 37.8 MB
24 All about Views/021 Refreshing data in materialize views.mp4 37.8 MB
41 Using Northwind Database/018 First order from each country.mp4 37.7 MB
18 Joining Multiple Tables/010 LEFT joins Part 4.mp4 37.6 MB
37 Using Cursors/006 Using a cursor.mp4 37.5 MB
29 Using regular expressions for text patterns/002 Regular expressions notations table.mp4 37.3 MB
23 Indexes and Performance Optimization/014 Join Nodes.mp4 37.1 MB
16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.mp4 37.1 MB
36 PostgreSQL Triggers/023 Prevent schema changes.mp4 37.1 MB
21 Exploring array functions/009 Formatting and converting an array.mp4 37.0 MB
21 Exploring array functions/005 Array metadata functions.mp4 36.7 MB
13 PostgreSQL Sequences/007 Attach a sequence to a table column.mp4 36.5 MB
23 Indexes and Performance Optimization/012 Sequential Nodes.mp4 36.5 MB
16 Using DATE_TIME functions/010 Date Value Extractors functions.mp4 36.2 MB
23 Indexes and Performance Optimization/024 Indexes for sorted output.mp4 36.0 MB
20 PostgreSQL Schemas/010 Schemas and Privileges.mp4 36.0 MB
26 Common Table Expressions (CTE)/003 Combine CTE with a table.mp4 36.0 MB
28 Window Functions/017 Using WINDOW.mp4 35.8 MB
36 PostgreSQL Triggers/009 Bind a function to a table with trigger.mp4 35.5 MB
18 Joining Multiple Tables/015 Self Joins Part 1.mp4 35.5 MB
28 Window Functions/029 ROW_NUMBER() - Pagination technique.mp4 35.3 MB
37 Using Cursors/004 Creating a cursor.mp4 35.3 MB
21 Exploring array functions/003 Using inclusion operators.mp4 35.0 MB
44 Managing PostgreSQL security/008 Column Level Security.mp4 35.0 MB
08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.mp4 34.9 MB
23 Indexes and Performance Optimization/010 The query optimizer.mp4 34.9 MB
34 Functions with PL_pgSQL language/015 Using IF with table data.mp4 34.5 MB
12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.mp4 34.2 MB
21 Exploring array functions/002 Using comparison operators.mp4 34.2 MB
06 Filtering Data/016 Concatenation techniques.mp4 34.1 MB
35 Exploring Stored Procedures/002 Create a transactions.mp4 34.1 MB
22 JSON with PostgreSQL/002 JSON Syntax.mp4 33.9 MB
24 All about Views/001 Introduction to views.mp4 33.8 MB
41 Using Northwind Database/017 Customers with multiple orders.mp4 33.8 MB
31 Table Partitions/008 DEFAULT Partition.mp4 33.2 MB
14 String Functions/004 SPLIT_PART.mp4 33.0 MB
34 Functions with PL_pgSQL language/014 Control Structures - IF statement.mp4 32.7 MB
33 Functions with SQL language/018 Function based on views.mp4 32.6 MB
14 String Functions/009 STRPOS.mp4 32.6 MB
31 Table Partitions/014 Determining a field for partition over.mp4 32.5 MB
27 Grouping sets/003 Adding subtotal with ROLLUP.mp4 32.5 MB
18 Joining Multiple Tables/005 INNER joins with filter data Part 3.mp4 32.5 MB
23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.mp4 32.4 MB
26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.mp4 32.4 MB
34 Functions with PL_pgSQL language/013 How to return query results.mp4 32.4 MB
14 String Functions/006 LPAD and RPAD.mp4 32.4 MB
12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.mp4 32.3 MB
11 User-defined Data Types/013 Update an ENUM data in production server.mp4 32.3 MB
06 Filtering Data/004 Combining AND, OR operators.mp4 32.2 MB
42 Using Human Resource (hr) database/013 Discard characters from employees email address.mp4 32.1 MB
28 Window Functions/014 Sliding dynamic windows.mp4 32.0 MB
21 Exploring array functions/001 Constructing arrays and ranges.mp4 31.8 MB
40 PostgreSQL Transactions/007 How to fix transactions on crash.mp4 31.8 MB
22 JSON with PostgreSQL/005 Create our first table with JSONB data type.mp4 31.8 MB
07 PostgreSQL Data types/012 hstore.mp4 31.7 MB
13 PostgreSQL Sequences/010 Create an alphanumeric sequence.mp4 31.7 MB
31 Table Partitions/012 Partition Indexes.mp4 31.7 MB
02 Introduction to PostgreSQL/010 Install northwind database.mp4 31.6 MB
47 Managing Tables/010 Tracking table size.mp4 31.4 MB
09 Data type conversions/001 What is a data type conversion.mp4 31.2 MB
47 Managing Tables/005 Deleting duplicate records.mp4 31.0 MB
10 Conversion Functions/004 to_timestamp.mp4 30.9 MB
29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.mp4 30.8 MB
13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.mp4 30.2 MB
47 Managing Tables/004 Export Data to CSV files.mp4 30.2 MB
21 Exploring array functions/007 Array modification functions.mp4 30.1 MB
36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.mp4 30.0 MB
07 PostgreSQL Data types/011 Array.mp4 29.8 MB
09 Data type conversions/004 Table data conversion.mp4 29.7 MB
23 Indexes and Performance Optimization/033 Rebuilding an index.mp4 29.5 MB
24 All about Views/013 An updatable view with CRUD operations.mp4 29.3 MB
21 Exploring array functions/006 Array search functions.mp4 29.2 MB
29 Using regular expressions for text patterns/003 SIMILAR TO operator.mp4 29.0 MB
21 Exploring array functions/012 Query array data.mp4 28.9 MB
38 Creating Crosstab Reports/009 Static to dynamic pivots.mp4 28.9 MB
22 JSON with PostgreSQL/008 Use json_agg to aggregate data.mp4 28.8 MB
11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 28.8 MB
33 Functions with SQL language/005 Function returning a single value Part 2.mp4 28.7 MB
10 Conversion Functions/003 to_date.mp4 28.5 MB
33 Functions with SQL language/008 Function using parameters Part 2.mp4 28.4 MB
23 Indexes and Performance Optimization/026 Execution plans depends on input values.mp4 28.4 MB
22 JSON with PostgreSQL/007 Create JSON from tables.mp4 28.4 MB
02 Introduction to PostgreSQL/009 Install sample stocks market data.mp4 28.3 MB
20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).mp4 28.2 MB
23 Indexes and Performance Optimization/009 SQL statement execution stages.mp4 28.1 MB
47 Managing Tables/009 Database operations and table size.mp4 27.9 MB
22 JSON with PostgreSQL/010 Creating a document from data.mp4 27.8 MB
46 PostgreSQL Internals/007 Using system Administration functions.mp4 27.8 MB
28 Window Functions/011 Partitioning the data.mp4 27.7 MB
20 PostgreSQL Schemas/001 What is a Schema_.mp4 27.3 MB
14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.mp4 27.3 MB
11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.mp4 27.0 MB
16 Using DATE_TIME functions/007 Date construction functions.mp4 26.9 MB
31 Table Partitions/001 What is a partition.mp4 26.8 MB
28 Window Functions/039 Using PARTITION BY for group averages.mp4 26.8 MB
16 Using DATE_TIME functions/013 Date _ Time Functions.mp4 26.8 MB
20 PostgreSQL Schemas/003 Schema Hierarchy.mp4 26.7 MB
31 Table Partitions/010 Partition maintenance.mp4 26.7 MB
32 Server Programming/003 Keep the data on the server!.mp4 26.7 MB
22 JSON with PostgreSQL/004 Exploring JSON objects.mp4 26.7 MB
28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.mp4 26.7 MB
20 PostgreSQL Schemas/008 What is a system catalog schema_.mp4 26.4 MB
33 Functions with SQL language/006 Function returning a single value Part 3.mp4 26.3 MB
35 Exploring Stored Procedures/004 Returning a value.mp4 26.3 MB
05 Querying Data/010 Using DISTINCT for selecting distinct values.mp4 26.1 MB
07 PostgreSQL Data types/007 DATE.mp4 25.8 MB
02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.mp4 25.7 MB
07 PostgreSQL Data types/005 Selecting Numbers data types.mp4 25.6 MB
35 Exploring Stored Procedures/003 Understanding the use of stored procedures.mp4 25.5 MB
44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.mp4 25.5 MB
28 Window Functions/031 Calculate difference compared to average.mp4 25.4 MB
28 Window Functions/041 Using WITH clause to set ORDER BY values.mp4 25.3 MB
28 Window Functions/030 Using OVER() to calculate percentage.mp4 24.7 MB
16 Using DATE_TIME functions/003 Time of day formats and inputs.mp4 24.7 MB
26 Common Table Expressions (CTE)/001 Introduction to CTEs.mp4 24.7 MB
35 Exploring Stored Procedures/001 Functions vs Stored Procedures.mp4 24.6 MB
44 Managing PostgreSQL security/013 Inspecting permissions.mp4 24.4 MB
23 Indexes and Performance Optimization/016 Hash Index.mp4 24.3 MB
43 Exploring Stock Markets Data/002 Select first or last records in a table.mp4 24.2 MB
18 Joining Multiple Tables/018 Natural Joins Part 1.mp4 24.1 MB
30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.mp4 23.8 MB
34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.mp4 23.7 MB
29 Using regular expressions for text patterns/001 Text to structured data.mp4 23.7 MB
34 Functions with PL_pgSQL language/027 Error and exception handling.mp4 23.6 MB
34 Functions with PL_pgSQL language/005 Declaring variables.mp4 23.5 MB
21 Exploring array functions/011 Insert data into arrays.mp4 23.5 MB
37 Using Cursors/002 Cursors and procedural languages.mp4 23.4 MB
34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.mp4 23.4 MB
34 Functions with PL_pgSQL language/018 LOOP statement.mp4 23.4 MB
36 PostgreSQL Triggers/007 Steps to create a trigger.mp4 23.4 MB
41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.mp4 23.4 MB
44 Managing PostgreSQL security/005 Database Level Security.mp4 23.3 MB
36 PostgreSQL Triggers/016 Disallow data change on primary key.mp4 23.3 MB
24 All about Views/006 A view with UNION of multiple tables.mp4 23.2 MB
40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.mp4 23.2 MB
28 Window Functions/042 DELETE and INSERT in one query using WITH.mp4 23.2 MB
34 Functions with PL_pgSQL language/028 Exception - Too many rows.mp4 23.0 MB
44 Managing PostgreSQL security/011 Row level policy for application users.mp4 23.0 MB
44 Managing PostgreSQL security/002 Instance Level Security.mp4 23.0 MB
05 Querying Data/009 Using ORDER BY with NULL values.mp4 22.9 MB
10 Conversion Functions/002 to_number.mp4 22.9 MB
40 PostgreSQL Transactions/002 How SQL protect database during transaction.mp4 22.9 MB
17 Grouping Data/006 HAVING vs WHERE.mp4 22.8 MB
23 Indexes and Performance Optimization/011 Optimizer node types.mp4 22.8 MB
41 Using Northwind Database/010 Customers with no orders.mp4 22.7 MB
36 PostgreSQL Triggers/011 View triggers variables.mp4 22.7 MB
34 Functions with PL_pgSQL language/019 FOR Loops.mp4 22.7 MB
28 Window Functions/024 Finding Correlations.mp4 22.7 MB
31 Table Partitions/015 Sizing the partition.mp4 22.6 MB
41 Using Northwind Database/011 Top customers with total orders amount.mp4 22.6 MB
33 Functions with SQL language/003 Function returning no values.mp4 22.6 MB
18 Joining Multiple Tables/004 INNER joins with filter data Part 2.mp4 22.4 MB
28 Window Functions/009 Using FILTER clause.mp4 22.4 MB
29 Using regular expressions for text patterns/004 POSIX regular expressions.mp4 22.3 MB
19 Combining queries together/005 EXCEPT with tables.mp4 22.2 MB
12 Explore PostgreSQL Constraints/004 DEFAULT constraint.mp4 22.2 MB
31 Table Partitions/016 Partitioning Advantages.mp4 22.1 MB
18 Joining Multiple Tables/013 FULL Joins.mp4 22.1 MB
32 Server Programming/002 Procedural languages.mp4 22.0 MB
28 Window Functions/008 Query performance check.mp4 21.7 MB
03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.mp4 21.7 MB
28 Window Functions/004 GROUP BY ROLLUP.mp4 21.6 MB
31 Table Partitions/017 Common partitioning mistakes.mp4 21.6 MB
46 PostgreSQL Internals/008 Show all running queries.mp4 21.5 MB
38 Creating Crosstab Reports/006 Pivoting rows and columns.mp4 21.4 MB
21 Exploring array functions/004 Array constructions.mp4 21.3 MB
28 Window Functions/033 Using LEAD to compare with next values.mp4 21.3 MB
03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.mp4 21.2 MB
28 Window Functions/032 Calculating cumulative totals.mp4 21.2 MB
28 Window Functions/010 Using Window Functions.mp4 21.1 MB
34 Functions with PL_pgSQL language/007 Declaring variables in function.mp4 21.1 MB
15 Aggregate functions/004 GREATEST AND LEAST functions.mp4 21.0 MB
11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.mp4 20.9 MB
28 Window Functions/019 RANK and DENSE_RANK functions.mp4 20.9 MB
02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.mp4 20.9 MB
22 JSON with PostgreSQL/001 What is JSON_.mp4 20.7 MB
28 Window Functions/038 Getting RANK to compute group and global ranks.mp4 20.7 MB
03 Creating and Modifying Tables/002 Creating the movie database and a actors table.mp4 20.6 MB
36 PostgreSQL Triggers/020 Creating event triggers.mp4 20.5 MB
03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.mp4 20.5 MB
22 JSON with PostgreSQL/003 JSON and JSONB data types.mp4 20.5 MB
18 Joining Multiple Tables/006 INNER joins with different data type columns.mp4 20.5 MB
25 Fun with subqueries/013 Subquery using EXISTS.mp4 20.5 MB
44 Managing PostgreSQL security/014 Row Level Security Performance.mp4 20.3 MB
43 Exploring Stock Markets Data/003 Get first or last record per each group.mp4 20.3 MB
23 Indexes and Performance Optimization/005 Size of the table index.mp4 20.3 MB
23 Indexes and Performance Optimization/006 List counts of all indexes.mp4 20.1 MB
14 String Functions/001 UPPER, LOWER and INITCAP.mp4 20.1 MB
42 Using Human Resource (hr) database/002 Quick overview of all tables.mp4 20.1 MB
28 Window Functions/006 GROUP BY CUBE.mp4 20.1 MB
36 PostgreSQL Triggers/021 Event trigger events and variables.mp4 19.7 MB
34 Functions with PL_pgSQL language/021 CONTINUE statement.mp4 19.7 MB
38 Creating Crosstab Reports/001 What is a crosstab report.mp4 19.7 MB
25 Fun with subqueries/003 Subquery with IN operator.mp4 19.7 MB
21 Exploring array functions/010 Using arrays in tables.mp4 19.6 MB
28 Window Functions/007 GROUP BY GROUPING SETS.mp4 19.5 MB
23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.mp4 19.5 MB
26 Common Table Expressions (CTE)/006 Recursive CTEs.mp4 19.1 MB
34 Functions with PL_pgSQL language/012 Variables in block and subblock.mp4 19.0 MB
34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.mp4 19.0 MB
13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.mp4 18.9 MB
04 Modifying Data in the tables/005 Update data in a table.mp4 18.9 MB
16 Using DATE_TIME functions/017 CURRENT_TIME function.mp4 18.8 MB
41 Using Northwind Database/005 Show total order amount for each order.mp4 18.8 MB
16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.mp4 18.7 MB
24 All about Views/017 Creating a materialized view.mp4 18.6 MB
22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.mp4 18.5 MB
33 Functions with SQL language/019 Drop a function.mp4 18.5 MB
44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.mp4 18.4 MB
34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.mp4 18.4 MB
04 Modifying Data in the tables/001 Insert a data into table.mp4 18.4 MB
21 Exploring array functions/014 Array Dimensions are ignored!.mp4 18.3 MB
24 All about Views/003 Rename a view.mp4 18.3 MB
23 Indexes and Performance Optimization/001 What is an index_.mp4 18.2 MB
28 Window Functions/018 Using WINDOW with ROWS BETWEEN.mp4 18.2 MB
06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.mp4 18.2 MB
23 Indexes and Performance Optimization/008 SQL Statement execution process.mp4 18.1 MB
24 All about Views/022 Why not use a table instead of materialized view_.mp4 18.1 MB
31 Table Partitions/013 Partition pruning.mp4 18.0 MB
12 Explore PostgreSQL Constraints/001 Introduction to constraints.mp4 18.0 MB
13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 17.8 MB
46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.mp4 17.8 MB
23 Indexes and Performance Optimization/004 List all indexes.mp4 17.8 MB
05 Querying Data/008 Using ORDER BY with column name or column number.mp4 17.6 MB
12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.mp4 17.6 MB
28 Window Functions/005 ROLLUP - Grouping multiple columns.mp4 17.4 MB
32 Server Programming/004 Functions vs stored procedures.mp4 17.4 MB
11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.mp4 17.4 MB
22 JSON with PostgreSQL/009 Build a JSON array.mp4 17.4 MB
08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.mp4 17.3 MB
11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 17.3 MB
25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.mp4 17.3 MB
11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.mp4 17.2 MB
14 String Functions/012 REPLACE.mp4 17.1 MB
34 Functions with PL_pgSQL language/025 Returning a table.mp4 17.1 MB
19 Combining queries together/004 INTERSECT with tables.mp4 17.1 MB
09 Data type conversions/003 Implicit to Explicit conversions.mp4 17.1 MB
41 Using Northwind Database/004 Orders shipped to latin america.mp4 17.1 MB
24 All about Views/026 List materialized views with no unique index.mp4 17.1 MB
45 PostgreSQL Utilities - psql/014 Turn on query execution time.mp4 17.1 MB
14 String Functions/010 SUBSTRING.mp4 17.0 MB
22 JSON with PostgreSQL/015 The Containment Operator.mp4 17.0 MB
11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.mp4 16.9 MB
11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 16.8 MB
28 Window Functions/036 Planning tips on using Window Functions.mp4 16.8 MB
33 Functions with SQL language/013 Function - order matters!.mp4 16.7 MB
33 Functions with SQL language/016 Function parameter modes.mp4 16.7 MB
14 String Functions/007 LENGTH.mp4 16.7 MB
32 Server Programming/005 User-defined functions.mp4 16.5 MB
28 Window Functions/035 Window Function Summary.mp4 16.5 MB
23 Indexes and Performance Optimization/028 Try to use index only scan.mp4 16.4 MB
16 Using DATE_TIME functions/012 OVERLAPS Operator.mp4 16.2 MB
33 Functions with SQL language/002 Introducing dollar quoting.mp4 16.2 MB
13 PostgreSQL Sequences/009 Share one sequence between two tables.mp4 16.1 MB
45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.mp4 16.0 MB
45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.mp4 16.0 MB
27 Grouping sets/001 Introduction to summarization.mp4 16.0 MB
24 All about Views/023 The downsides of using materialized views.mp4 16.0 MB
24 All about Views/012 What is an updatable view_.mp4 16.0 MB
21 Exploring array functions/015 Display all array elements.mp4 16.0 MB
05 Querying Data/002 Selecting specific columns from a table.mp4 15.9 MB
07 PostgreSQL Data types/006 Date_Time data types.mp4 15.9 MB
05 Querying Data/007 Using ORDER BY to sort rows by expressions.mp4 15.8 MB
45 PostgreSQL Utilities - psql/001 Connect to local or remote database.mp4 15.8 MB
06 Filtering Data/003 OR operator.mp4 15.7 MB
03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.mp4 15.7 MB
24 All about Views/018 Drop a materialized view.mp4 15.6 MB
40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.mp4 15.3 MB
28 Window Functions/027 ROW_NUMBER() - Find Nth record.mp4 15.2 MB
40 PostgreSQL Transactions/006 How to fix aborted transaction.mp4 15.2 MB
34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.mp4 15.1 MB
18 Joining Multiple Tables/012 RIGHT joins Part 2.mp4 15.1 MB
41 Using Northwind Database/007 Total products in each categories.mp4 15.1 MB
16 Using DATE_TIME functions/020 View and set timezones.mp4 15.0 MB
23 Indexes and Performance Optimization/007 Drop a index.mp4 15.0 MB
14 String Functions/008 POSITION.mp4 14.7 MB
42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.mp4 14.7 MB
33 Functions with SQL language/014 Function returning a table.mp4 14.7 MB
11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.mp4 14.5 MB
03 Creating and Modifying Tables/003 Creating the directors table.mp4 14.4 MB
45 PostgreSQL Utilities - psql/003 List all databases and tables.mp4 14.4 MB
06 Filtering Data/005 What goes before and after WHERE clause.mp4 14.2 MB
28 Window Functions/040 Using WITH clause to create your own data.mp4 14.2 MB
36 PostgreSQL Triggers/017 Use triggers very cautiously.mp4 14.2 MB
28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.mp4 14.1 MB
36 PostgreSQL Triggers/019 Event triggers usage scenarios.mp4 14.1 MB
16 Using DATE_TIME functions/015 AGE function.mp4 14.1 MB
45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.mp4 14.1 MB
44 Managing PostgreSQL security/004 Use pgAdmin to create roles.mp4 14.0 MB
42 Using Human Resource (hr) database/019 Select employees not in range.mp4 13.9 MB
19 Combining queries together/003 UNION tables with different number of columns.mp4 13.8 MB
11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.mp4 13.8 MB
24 All about Views/011 Regular views are dynamic.mp4 13.7 MB
42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.mp4 13.7 MB
05 Querying Data/006 Using ORDER BY with alias column name.mp4 13.6 MB
02 Introduction to PostgreSQL/011 Drop a database.mp4 13.6 MB
41 Using Northwind Database/008 List products that needs re-ordering.mp4 13.6 MB
37 Using Cursors/003 Steps to create a cursor.mp4 13.5 MB
13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 13.5 MB
05 Querying Data/004 Using SELECT statement for expressions.mp4 13.5 MB
47 Managing Tables/002 Duplicate a table with or without data.mp4 13.3 MB
04 Modifying Data in the tables/008 Delete data from a table.mp4 13.2 MB
18 Joining Multiple Tables/019 Natural Joins Part 2.mp4 13.1 MB
03 Creating and Modifying Tables/005 Creating the movies_revenues table.mp4 13.1 MB
04 Modifying Data in the tables/007 Updating all records in a table.mp4 13.1 MB
29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.mp4 13.0 MB
18 Joining Multiple Tables/016 Self Joins Part 2.mp4 12.9 MB
16 Using DATE_TIME functions/002 System Month Date settings.mp4 12.8 MB
21 Exploring array functions/013 Modifying array data.mp4 12.8 MB
42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.mp4 12.6 MB
42 Using Human Resource (hr) database/001 Human Resources Database Structure.mp4 12.5 MB
38 Creating Crosstab Reports/004 Orders matters in crosstab reports.mp4 12.5 MB
45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.mp4 12.4 MB
22 JSON with PostgreSQL/014 The Existence Operator.mp4 12.4 MB
42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.mp4 12.3 MB
03 Creating and Modifying Tables/001 Movie Database Structure.mp4 12.2 MB
45 PostgreSQL Utilities - psql/011 Make table layout funkey!.mp4 12.1 MB
31 Table Partitions/004 Partition types.mp4 12.1 MB
28 Window Functions/037 Difference between RANK and DENSE_RANK.mp4 12.0 MB
24 All about Views/008 Re-arrange columns in a view.mp4 12.0 MB
46 PostgreSQL Internals/009 Terminate running and IDLE process.mp4 11.9 MB
23 Indexes and Performance Optimization/020 EXPLAIN output options.mp4 11.9 MB
46 PostgreSQL Internals/004 List all columns from a table.mp4 11.9 MB
44 Managing PostgreSQL security/001 Security concepts and and levels.mp4 11.8 MB
36 PostgreSQL Triggers/003 Types of triggers.mp4 11.8 MB
24 All about Views/020 How to check if a materialized view is populated or not_.mp4 11.8 MB
12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.mp4 11.8 MB
32 Server Programming/006 Structure of a function.mp4 11.7 MB
23 Indexes and Performance Optimization/031 Adding data while indexing.mp4 11.6 MB
02 Introduction to PostgreSQL/004 Creating a Database User.mp4 11.6 MB
13 PostgreSQL Sequences/004 Create a sequence using a specific data type.mp4 11.6 MB
34 Functions with PL_pgSQL language/009 Copying data types.mp4 11.6 MB
42 Using Human Resource (hr) database/021 Update phone_number with your strings.mp4 11.6 MB
11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.mp4 11.2 MB
36 PostgreSQL Triggers/004 Trigger table.mp4 11.2 MB
04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.mp4 11.1 MB
46 PostgreSQL Internals/005 View system metadata via system information functions.mp4 11.1 MB
28 Window Functions/012 Set data into millions format.mp4 11.0 MB
36 PostgreSQL Triggers/006 Trigger key points.mp4 10.9 MB
20 PostgreSQL Schemas/004 Move a table to a new schema.mp4 10.9 MB
04 Modifying Data in the tables/006 Updating a row and returning the updated row.mp4 10.9 MB
34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.mp4 10.8 MB
02 Introduction to PostgreSQL/005 Creating a Database.mp4 10.6 MB
41 Using Northwind Database/012 Orders with many lines of ordered items.mp4 10.6 MB
02 Introduction to PostgreSQL/007 Install sample data files on server.mp4 10.5 MB
41 Using Northwind Database/015 Countries with customers or suppliers.mp4 10.2 MB
42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.mp4 10.2 MB
25 Fun with subqueries/008 A SELECT without a FROM.mp4 10.2 MB
34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.mp4 10.1 MB
44 Managing PostgreSQL security/012 DROP a policy.mp4 10.0 MB
42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.mp4 10.0 MB
40 PostgreSQL Transactions/004 Transaction setup.mp4 9.8 MB
45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.mp4 9.8 MB
03 Creating and Modifying Tables/012 Deleting tables from a database.mp4 9.7 MB
04 Modifying Data in the tables/002 Insert multiple records into a table.mp4 9.6 MB
06 Filtering Data/006 Execution order with AND, OR operators.mp4 9.4 MB
11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 9.3 MB
42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.mp4 9.3 MB
41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.mp4 9.2 MB
41 Using Northwind Database/002 Orders shipping to USA or France.mp4 9.2 MB
06 Filtering Data/007 Can we use column aliases with WHERE_.mp4 9.2 MB
42 Using Human Resource (hr) database/018 Select employees with particular department id only.mp4 9.0 MB
23 Indexes and Performance Optimization/017 BRIN index.mp4 8.9 MB
34 Functions with PL_pgSQL language/008 Variable initializing timing.mp4 8.9 MB
24 All about Views/010 Add a column in a view.mp4 8.7 MB
14 String Functions/011 REPEAT.mp4 8.7 MB
42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.mp4 8.7 MB
42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.mp4 8.6 MB
42 Using Human Resource (hr) database/017 Get unique designations in employees table.mp4 8.6 MB
11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.mp4 8.6 MB
06 Filtering Data/001 Comparison, Logical and Arithmetic operators.mp4 8.6 MB
20 PostgreSQL Schemas/006 Alter a schema ownership.mp4 8.5 MB
41 Using Northwind Database/006 First the oldest and latest order date.mp4 8.4 MB
42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.mp4 8.3 MB
02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.mp4 8.2 MB
34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.mp4 8.2 MB
11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.mp4 8.1 MB
14 String Functions/003 REVERSE.mp4 8.1 MB
38 Creating Crosstab Reports/002 Installing the tablefunc extension.mp4 7.8 MB
42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.mp4 7.8 MB
37 Using Cursors/007 Updating data.mp4 7.6 MB
12 Explore PostgreSQL Constraints/011 Drop a constraint.mp4 7.6 MB
02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.mp4 7.6 MB
04 Modifying Data in the tables/003 Insert a data that had quotes.mp4 7.5 MB
36 PostgreSQL Triggers/018 What is an event trigger.mp4 7.5 MB
24 All about Views/009 Delete a column in a view.mp4 7.2 MB
42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.mp4 7.2 MB
23 Indexes and Performance Optimization/018 GIN Index.mp4 7.1 MB
25 Fun with subqueries/007 Subquery with an alias.mp4 6.9 MB
43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.mp4 6.9 MB
42 Using Human Resource (hr) database/010 Using an alias name with columns.mp4 6.8 MB
24 All about Views/004 Delete a view.mp4 6.8 MB
35 Exploring Stored Procedures/005 Drop a procedure.mp4 6.8 MB
45 PostgreSQL Utilities - psql/002 Switch connection to a new database.mp4 6.7 MB
46 PostgreSQL Internals/010 How to check live and dead rows in tables.mp4 6.7 MB
42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.mp4 6.7 MB
34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.mp4 6.4 MB
06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 6.3 MB
28 Window Functions/001 Introduction to Window Functions.mp4 6.3 MB
13 PostgreSQL Sequences/008 List all sequences in a database.mp4 6.0 MB
24 All about Views/025 List all materialized views by a SELECT statement.mp4 5.9 MB
37 Using Cursors/008 Closing a cursor.mp4 5.9 MB
02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.mp4 5.7 MB
29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.mp4 5.7 MB
13 PostgreSQL Sequences/006 Delete a sequence.mp4 5.6 MB
01 Welcome/001 Course Introduction.mp4 5.6 MB
17 Grouping Data/003 Order of execution in GROUP BY clause.mp4 5.5 MB
42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.mp4 5.3 MB
42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.mp4 5.2 MB
45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.mp4 5.0 MB
12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.mp4 4.9 MB
16 Using DATE_TIME functions/016 CURRENT_DATE function.mp4 4.6 MB
45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.mp4 4.4 MB
17 Grouping Data/005 Order of execution in HAVING clause.mp4 4.1 MB
41 Using Northwind Database/001 Using Northwind database.mp4 4.1 MB
45 PostgreSQL Utilities - psql/006 Describe a table.mp4 4.0 MB
36 PostgreSQL Triggers/024 Dropping a trigger.mp4 3.9 MB
42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.mp4 2.8 MB
49 Thank You!/003 Thank You!.mp4 2.4 MB
01 Welcome/002 sample_data.zip 1.4 MB
02 Introduction to PostgreSQL/010 sample_data.zip 1.4 MB
02 Introduction to PostgreSQL/011 sample_data.zip 1.4 MB
30 Powerful text searches in PostgreSQL/385 president_speeches.csv 1.1 MB
01 Welcome/002 trades.sql 510.2 KB
28 Window Functions/331 trades.sql 510.2 KB
01 Welcome/002 northwind.sql 341.5 KB
02 Introduction to PostgreSQL/012 northwind.sql 341.5 KB
31 Table Partitions/006 Partition by List.en.srt 36.9 KB
28 Window Functions/015 Understanding window frames.en.srt 33.1 KB
36 PostgreSQL Triggers/014 Creating an audit trigger.en.srt 30.7 KB
31 Table Partitions/005 Partition by Range.en.srt 30.2 KB
12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.en.srt 30.0 KB
18 Joining Multiple Tables/001 INNER joins.en.srt 29.2 KB
26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.en.srt 29.1 KB
48 Extended PostgreSQL/001 Create a custom index method.en.srt 28.7 KB
07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.en.srt 28.4 KB
31 Table Partitions/002 When a partition can be used_.en.srt 28.0 KB
29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.en.srt 27.9 KB
23 Indexes and Performance Optimization/027 Using organized vs random data.en.srt 27.8 KB
06 Filtering Data/014 Using LIKE and ILIKE.en.srt 25.6 KB
06 Filtering Data/010 Using LIMIT and OFFSET.en.srt 25.0 KB
38 Creating Crosstab Reports/011 Dynamic pivot table columns.en.srt 24.3 KB
31 Table Partitions/003 Table inheritance.en.srt 23.9 KB
06 Filtering Data/009 Using Logical operators.en.srt 23.5 KB
26 Common Table Expressions (CTE)/002 CTE query examples.en.srt 23.2 KB
40 PostgreSQL Transactions/005 Transaction analysis.en.srt 23.0 KB
23 Indexes and Performance Optimization/002 Create an index.en.srt 22.9 KB
23 Indexes and Performance Optimization/019 The EXPLAIN statement.en.srt 22.5 KB
12 Explore PostgreSQL Constraints/003 UNIQUE constraint.en.srt 22.2 KB
23 Indexes and Performance Optimization/030 Expression Index.en.srt 22.2 KB
31 Table Partitions/007 Partition by Hash.en.srt 22.1 KB
28 Window Functions/021 LEAD and LAG functions.en.srt 21.8 KB
30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.en.srt 21.7 KB
36 PostgreSQL Triggers/022 Creating an audit event trigger.en.srt 21.6 KB
38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.en.srt 21.5 KB
27 Grouping sets/004 Using GROUPING with ROLLUP.en.srt 21.3 KB
07 PostgreSQL Data types/008 TIME.en.srt 21.1 KB
28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.en.srt 21.0 KB
21 Exploring array functions/017 Array vs JSONB.en.srt 21.0 KB
21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.en.srt 21.0 KB
36 PostgreSQL Triggers/015 Creating conditional triggers.en.srt 20.9 KB
31 Table Partitions/009 Multi-level partitioning.en.srt 20.7 KB
17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.en.srt 20.6 KB
44 Managing PostgreSQL security/009 Row Level Security.en.srt 20.6 KB
20 PostgreSQL Schemas/005 Schema search path.en.srt 20.4 KB
07 PostgreSQL Data types/014 Network Addresses.en.srt 20.4 KB
30 Powerful text searches in PostgreSQL/004 Full text search within a table.en.srt 20.4 KB
37 Using Cursors/010 Using a parametric cursor via function.en.srt 20.0 KB
33 Functions with SQL language/007 Function using parameters.en.srt 19.8 KB
33 Functions with SQL language/009 Function using parameters Part 3.en.srt 19.6 KB
23 Indexes and Performance Optimization/022 Understanding query cost model.en.srt 19.5 KB
07 PostgreSQL Data types/001 Boolean.en.srt 19.4 KB
12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.en.srt 19.4 KB
34 Functions with PL_pgSQL language/026 Using RETURN NEXT.en.srt 19.3 KB
15 Aggregate functions/005 Average with AVG function.en.srt 18.7 KB
09 Data type conversions/002 Using CAST for data conversions.en.srt 18.6 KB
33 Functions with SQL language/010 Function using parameters Part 4.en.srt 18.6 KB
18 Joining Multiple Tables/020 Append tables with different columns.en.srt 18.3 KB
25 Fun with subqueries/009 Correlated Queries.en.srt 18.1 KB
25 Fun with subqueries/002 Subqueries with WHERE Clause.en.srt 18.1 KB
07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.en.srt 17.9 KB
33 Functions with SQL language/011 Function returning a composite.en.srt 17.9 KB
15 Aggregate functions/003 MIN and MAX functions.en.srt 17.8 KB
33 Functions with SQL language/004 Function returning a single value.en.srt 17.8 KB
48 Extended PostgreSQL/002 Create a user-defined aggregate function.en.srt 17.7 KB
23 Indexes and Performance Optimization/023 Index are not free.en.srt 17.6 KB
16 Using DATE_TIME functions/004 Strings to Dates conversions.en.srt 17.6 KB
27 Grouping sets/002 Subtotals on group sets.en.srt 17.5 KB
22 JSON with PostgreSQL/006 Update and Delete JSON Data.en.srt 17.5 KB
22 JSON with PostgreSQL/017 Indexing on JSONB.en.srt 17.5 KB
07 PostgreSQL Data types/013 JSON.en.srt 17.4 KB
30 Powerful text searches in PostgreSQL/002 Introducing tsvector.en.srt 17.4 KB
34 Functions with PL_pgSQL language/023 WHILE loop.en.srt 17.3 KB
16 Using DATE_TIME functions/022 date_part function.en.srt 17.0 KB
06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.en.srt 16.9 KB
47 Managing Tables/001 Using SELECT INTO to create a new table with joins.en.srt 16.9 KB
34 Functions with PL_pgSQL language/017 Searched CASE statement.en.srt 16.8 KB
21 Exploring array functions/016 Using Multi-dimensional arrays.en.srt 16.6 KB
17 Grouping Data/004 Using HAVING.en.srt 16.6 KB
36 PostgreSQL Triggers/010 Modify data at INSERT event.en.srt 16.6 KB
24 All about Views/024 Using materialized view for websites page analysis.en.srt 16.5 KB
39 Internationalization/002 Client and Server Encoding.en.srt 16.5 KB
34 Functions with PL_pgSQL language/016 CASE Statement.en.srt 16.5 KB
33 Functions with SQL language/017 Function parameters with default values.en.srt 16.4 KB
19 Combining queries together/001 Combine results sets with UNION.en.srt 16.4 KB
36 PostgreSQL Triggers/005 Pros and Cons of triggers.en.srt 16.4 KB
44 Managing PostgreSQL security/006 Schema Level Security.en.srt 16.4 KB
36 PostgreSQL Triggers/008 Data auditing with a trigger.en.srt 16.3 KB
34 Functions with PL_pgSQL language/024 Using RETURN QUERY.en.srt 16.1 KB
16 Using DATE_TIME functions/006 Formatting Dates.en.srt 16.1 KB
17 Grouping Data/001 Using GROUP BY.en.srt 16.1 KB
07 PostgreSQL Data types/003 NUMERIC.en.srt 16.0 KB
24 All about Views/002 Creating a view.en.srt 16.0 KB
07 PostgreSQL Data types/004 DECIMALS.en.srt 16.0 KB
15 Aggregate functions/006 Combining Columns using Mathematical operators.en.srt 15.9 KB
41 Using Northwind Database/014 Late shipped orders by employees.en.srt 15.9 KB
28 Window Functions/016 ROWS and RANGE indicators.en.srt 15.8 KB
47 Managing Tables/013 Generated Columns.en.srt 15.8 KB
38 Creating Crosstab Reports/013 Handling missing values.en.srt 15.7 KB
36 PostgreSQL Triggers/012 Disallow DELETE on a table.en.srt 15.6 KB
16 Using DATE_TIME functions/021 How to handle timezones.en.srt 15.5 KB
36 PostgreSQL Triggers/002 What is a trigger.en.srt 15.5 KB
07 PostgreSQL Data types/010 UUID.en.srt 15.4 KB
12 Explore PostgreSQL Constraints/002 NOT NULL constraint.en.srt 15.4 KB
44 Managing PostgreSQL security/007 Table Level Security.en.srt 15.4 KB
33 Functions with SQL language/001 Creating our first SQL function.en.srt 15.4 KB
39 Internationalization/001 Global Character Set Support.en.srt 15.4 KB
38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.en.srt 15.4 KB
16 Using DATE_TIME functions/011 Using math operators with dates.en.srt 15.3 KB
41 Using Northwind Database/013 Orders with double entry line items.en.srt 15.2 KB
47 Managing Tables/012 Recovering unused space with VACUUM.en.srt 15.1 KB
37 Using Cursors/009 Creating a PL_PGSQL Cursor.en.srt 14.9 KB
23 Indexes and Performance Optimization/029 Partial indexes.en.srt 14.8 KB
16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.en.srt 14.8 KB
16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.en.srt 14.8 KB
17 Grouping Data/007 Handling NULL values with GROUP BY.en.srt 14.7 KB
06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.en.srt 14.7 KB
23 Indexes and Performance Optimization/003 Create unique indexes.en.srt 14.7 KB
47 Managing Tables/011 PostgreSQL autovacuum proces.en.srt 14.6 KB
32 Server Programming/001 PostgreSQL as a development platform_.en.srt 14.6 KB
29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.en.srt 14.5 KB
18 Joining Multiple Tables/017 CROSS Joins.en.srt 14.4 KB
41 Using Northwind Database/009 Freight analysis.en.srt 14.4 KB
18 Joining Multiple Tables/011 RIGHT joins.en.srt 14.4 KB
23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.en.srt 14.3 KB
38 Creating Crosstab Reports/007 Matrix report via a query.en.srt 14.3 KB
28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.en.srt 14.2 KB
37 Using Cursors/005 Opening a cursor.en.srt 14.1 KB
16 Using DATE_TIME functions/001 Datetimes data types.en.srt 14.1 KB
19 Combining queries together/002 UNION with filters and conditions.en.srt 14.0 KB
04 Modifying Data in the tables/009 Using UPSERT.en.srt 14.0 KB
22 JSON with PostgreSQL/002 JSON Syntax.en.srt 14.0 KB
33 Functions with SQL language/015 Function as a table source.en.srt 13.9 KB
06 Filtering Data/011 Using FETCH.en.srt 13.9 KB
46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.en.srt 13.9 KB
21 Exploring array functions/009 Formatting and converting an array.en.srt 13.7 KB
28 Window Functions/023 ROW_NUMBER function.en.srt 13.7 KB
28 Window Functions/020 NTILE function.en.srt 13.5 KB
28 Window Functions/017 Using WINDOW.en.srt 13.4 KB
28 Window Functions/034 Comparing with least number.en.srt 13.3 KB
24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.en.srt 13.2 KB
29 Using regular expressions for text patterns/002 Regular expressions notations table.en.srt 13.2 KB
24 All about Views/016 What is a Materialized View.en.srt 13.1 KB
16 Using DATE_TIME functions/023 date_trunc function.en.srt 13.1 KB
18 Joining Multiple Tables/007 LEFT joins Part 1.en.srt 13.1 KB
29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.en.srt 13.0 KB
16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.en.srt 13.0 KB
37 Using Cursors/004 Creating a cursor.en.srt 13.0 KB
06 Filtering Data/012 Using IN, NOT IN.en.srt 13.0 KB
05 Querying Data/003 Adding Aliases to columns in a table.en.srt 13.0 KB
18 Joining Multiple Tables/003 INNER joins with filter data Part 1.en.srt 12.9 KB
31 Table Partitions/011 ALTERing the partition bounds.en.srt 12.9 KB
46 PostgreSQL Internals/003 List all tables and views.en.srt 12.7 KB
36 PostgreSQL Triggers/009 Bind a function to a table with trigger.en.srt 12.6 KB
23 Indexes and Performance Optimization/024 Indexes for sorted output.en.srt 12.6 KB
40 PostgreSQL Transactions/003 ACID Database.en.srt 12.5 KB
14 String Functions/002 LEFT and RIGHT.en.srt 12.5 KB
21 Exploring array functions/005 Array metadata functions.en.srt 12.5 KB
28 Window Functions/003 Using aggregate functions.en.srt 12.4 KB
30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.en.srt 12.4 KB
23 Indexes and Performance Optimization/010 The query optimizer.en.srt 12.2 KB
34 Functions with PL_pgSQL language/010 Assigning variables from query.en.srt 12.2 KB
33 Functions with SQL language/012 Function returning multiple rows.en.srt 12.2 KB
25 Fun with subqueries/004 Subquery with JOINs.en.srt 12.2 KB
18 Joining Multiple Tables/014 Joining multiple tables.en.srt 12.2 KB
12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.en.srt 12.2 KB
23 Indexes and Performance Optimization/032 Invalidating an index.en.srt 12.2 KB
10 Conversion Functions/001 to_char.en.srt 12.1 KB
18 Joining Multiple Tables/002 INNER joins with USING.en.srt 11.9 KB
28 Window Functions/013 Ordering inside window.en.srt 11.9 KB
46 PostgreSQL Internals/006 View privileges information across tables.en.srt 11.9 KB
23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.en.srt 11.8 KB
24 All about Views/014 Updatable views using WITH CHECK OPTION.en.srt 11.8 KB
44 Managing PostgreSQL security/008 Column Level Security.en.srt 11.8 KB
18 Joining Multiple Tables/015 Self Joins Part 1.en.srt 11.8 KB
18 Joining Multiple Tables/009 LEFT joins Part 3.en.srt 11.7 KB
36 PostgreSQL Triggers/023 Prevent schema changes.en.srt 11.7 KB
31 Table Partitions/014 Determining a field for partition over.en.srt 11.7 KB
30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.en.srt 11.6 KB
12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.en.srt 11.6 KB
21 Exploring array functions/002 Using comparison operators.en.srt 11.6 KB
15 Aggregate functions/002 Sum with SUM function.en.srt 11.6 KB
28 Window Functions/002 Analyze Global Trades Data.en.srt 11.6 KB
09 Data type conversions/004 Table data conversion.en.srt 11.5 KB
08 Modifying Table Structures, Add constraints/003 Add constraints to columns.en.srt 11.5 KB
01 Welcome/002 countries_iso_codes.csv 11.5 KB
47 Managing Tables/611 countries_iso_codes.csv 11.5 KB
28 Window Functions/014 Sliding dynamic windows.en.srt 11.4 KB
40 PostgreSQL Transactions/001 What is a transaction_.en.srt 11.4 KB
20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.en.srt 11.4 KB
35 Exploring Stored Procedures/002 Create a transactions.en.srt 11.4 KB
47 Managing Tables/010 Tracking table size.en.srt 11.3 KB
27 Grouping sets/003 Adding subtotal with ROLLUP.en.srt 11.1 KB
06 Filtering Data/016 Concatenation techniques.en.srt 11.1 KB
21 Exploring array functions/001 Constructing arrays and ranges.en.srt 11.1 KB
34 Functions with PL_pgSQL language/014 Control Structures - IF statement.en.srt 11.0 KB
22 JSON with PostgreSQL/005 Create our first table with JSONB data type.en.srt 11.0 KB
12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.en.srt 11.0 KB
25 Fun with subqueries/012 Using ALL with subquery.en.srt 11.0 KB
12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.en.srt 11.0 KB
38 Creating Crosstab Reports/503 rainfalldata.sql 10.9 KB
07 PostgreSQL Data types/012 hstore.en.srt 10.9 KB
44 Managing PostgreSQL security/015 Encrypted data in columns.en.srt 10.9 KB
20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).en.srt 10.9 KB
26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.en.srt 10.8 KB
21 Exploring array functions/012 Query array data.en.srt 10.8 KB
41 Using Northwind Database/018 First order from each country.en.srt 10.8 KB
25 Fun with subqueries/011 Using ANY with subquery.en.srt 10.8 KB
47 Managing Tables/005 Deleting duplicate records.en.srt 10.8 KB
16 Using DATE_TIME functions/018 Date accuracy with EPOCH.en.srt 10.8 KB
31 Table Partitions/012 Partition Indexes.en.srt 10.7 KB
06 Filtering Data/002 AND operator.en.srt 10.7 KB
23 Indexes and Performance Optimization/013 Index Nodes.en.srt 10.7 KB
45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.en.srt 10.6 KB
29 Using regular expressions for text patterns/003 SIMILAR TO operator.en.srt 10.6 KB
47 Managing Tables/003 Import data from CSV files.en.srt 10.6 KB
24 All about Views/007 Connecting multiple tables with a single view.en.srt 10.6 KB
23 Indexes and Performance Optimization/033 Rebuilding an index.en.srt 10.6 KB
13 PostgreSQL Sequences/007 Attach a sequence to a table column.en.srt 10.5 KB
24 All about Views/001 Introduction to views.en.srt 10.4 KB
14 String Functions/004 SPLIT_PART.en.srt 10.4 KB
41 Using Northwind Database/017 Customers with multiple orders.en.srt 10.3 KB
24 All about Views/005 Using filters with views.en.srt 10.3 KB
38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.en.srt 10.3 KB
07 PostgreSQL Data types/011 Array.en.srt 10.3 KB
38 Creating Crosstab Reports/009 Static to dynamic pivots.en.srt 10.2 KB
21 Exploring array functions/006 Array search functions.en.srt 10.2 KB
22 JSON with PostgreSQL/004 Exploring JSON objects.en.srt 10.2 KB
18 Joining Multiple Tables/008 LEFT joins Part 2.en.srt 10.1 KB
14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.en.srt 10.1 KB
28 Window Functions/036 Planning tips on using Window Functions.en.srt 10.1 KB
34 Functions with PL_pgSQL language/030 Exception with data exception errors.en.srt 10.0 KB
26 Common Table Expressions (CTE)/003 Combine CTE with a table.en.srt 10.0 KB
12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.en.srt 9.9 KB
13 PostgreSQL Sequences/010 Create an alphanumeric sequence.en.srt 9.9 KB
11 User-defined Data Types/013 Update an ENUM data in production server.en.srt 9.9 KB
16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.en.srt 9.9 KB
16 Using DATE_TIME functions/007 Date construction functions.en.srt 9.9 KB
28 Window Functions/041 Using WITH clause to set ORDER BY values.en.srt 9.8 KB
21 Exploring array functions/007 Array modification functions.en.srt 9.8 KB
25 Fun with subqueries/010 SELECT.. IN (Subquery).en.srt 9.8 KB
23 Indexes and Performance Optimization/026 Execution plans depends on input values.en.srt 9.7 KB
08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.en.srt 9.7 KB
37 Using Cursors/001 Understanding row by row operations.en.srt 9.7 KB
30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.en.srt 9.6 KB
20 PostgreSQL Schemas/003 Schema Hierarchy.en.srt 9.6 KB
20 PostgreSQL Schemas/010 Schemas and Privileges.en.srt 9.5 KB
31 Table Partitions/015 Sizing the partition.en.srt 9.4 KB
37 Using Cursors/006 Using a cursor.en.srt 9.4 KB
33 Functions with SQL language/018 Function based on views.en.srt 9.4 KB
31 Table Partitions/008 DEFAULT Partition.en.srt 9.4 KB
23 Indexes and Performance Optimization/014 Join Nodes.en.srt 9.3 KB
24 All about Views/021 Refreshing data in materialize views.en.srt 9.3 KB
03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.en.srt 9.3 KB
16 Using DATE_TIME functions/010 Date Value Extractors functions.en.srt 9.2 KB
20 PostgreSQL Schemas/007 Duplicate a schema along with all data.en.srt 9.2 KB
12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.en.srt 9.2 KB
16 Using DATE_TIME functions/003 Time of day formats and inputs.en.srt 9.1 KB
13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.en.srt 9.1 KB
20 PostgreSQL Schemas/001 What is a Schema_.en.srt 9.1 KB
40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.en.srt 9.1 KB
05 Querying Data/005 Using ORDER BY to sort records.en.srt 9.1 KB
11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.en.srt 9.1 KB
07 PostgreSQL Data types/007 DATE.en.srt 9.0 KB
24 All about Views/019 Changing materialized view data.en.srt 9.0 KB
22 JSON with PostgreSQL/013 Getting information from JSON documents.en.srt 9.0 KB
44 Managing PostgreSQL security/002 Instance Level Security.en.srt 8.9 KB
32 Server Programming/003 Keep the data on the server!.en.srt 8.9 KB
44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.en.srt 8.9 KB
09 Data type conversions/001 What is a data type conversion.en.srt 8.9 KB
23 Indexes and Performance Optimization/009 SQL statement execution stages.en.srt 8.9 KB
29 Using regular expressions for text patterns/001 Text to structured data.en.srt 8.9 KB
28 Window Functions/029 ROW_NUMBER() - Pagination technique.en.srt 8.9 KB
38 Creating Crosstab Reports/012 Interactive client-side pivot.en.srt 8.9 KB
21 Exploring array functions/011 Insert data into arrays.en.srt 8.8 KB
41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.en.srt 8.8 KB
05 Querying Data/001 Select all data from a table.en.srt 8.8 KB
05 Querying Data/009 Using ORDER BY with NULL values.en.srt 8.8 KB
23 Indexes and Performance Optimization/012 Sequential Nodes.en.srt 8.7 KB
10 Conversion Functions/002 to_number.en.srt 8.7 KB
34 Functions with PL_pgSQL language/019 FOR Loops.en.srt 8.6 KB
28 Window Functions/033 Using LEAD to compare with next values.en.srt 8.6 KB
28 Window Functions/030 Using OVER() to calculate percentage.en.srt 8.6 KB
35 Exploring Stored Procedures/001 Functions vs Stored Procedures.en.srt 8.6 KB
28 Window Functions/039 Using PARTITION BY for group averages.en.srt 8.6 KB
28 Window Functions/024 Finding Correlations.en.srt 8.6 KB
22 JSON with PostgreSQL/010 Creating a document from data.en.srt 8.6 KB
47 Managing Tables/009 Database operations and table size.en.srt 8.5 KB
28 Window Functions/031 Calculate difference compared to average.en.srt 8.5 KB
34 Functions with PL_pgSQL language/018 LOOP statement.en.srt 8.5 KB
07 PostgreSQL Data types/005 Selecting Numbers data types.en.srt 8.5 KB
02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.en.srt 8.4 KB
34 Functions with PL_pgSQL language/005 Declaring variables.en.srt 8.4 KB
14 String Functions/006 LPAD and RPAD.en.srt 8.4 KB
10 Conversion Functions/003 to_date.en.srt 8.4 KB
16 Using DATE_TIME functions/013 Date _ Time Functions.en.srt 8.3 KB
36 PostgreSQL Triggers/016 Disallow data change on primary key.en.srt 8.2 KB
05 Querying Data/010 Using DISTINCT for selecting distinct values.en.srt 8.2 KB
15 Aggregate functions/001 Counting results via COUNT function.en.srt 8.2 KB
18 Joining Multiple Tables/010 LEFT joins Part 4.en.srt 8.2 KB
34 Functions with PL_pgSQL language/027 Error and exception handling.en.srt 8.1 KB
19 Combining queries together/005 EXCEPT with tables.en.srt 8.1 KB
32 Server Programming/002 Procedural languages.en.srt 8.1 KB
40 PostgreSQL Transactions/007 How to fix transactions on crash.en.srt 8.1 KB
18 Joining Multiple Tables/018 Natural Joins Part 1.en.srt 8.1 KB
31 Table Partitions/001 What is a partition.en.srt 8.0 KB
21 Exploring array functions/004 Array constructions.en.srt 8.0 KB
28 Window Functions/032 Calculating cumulative totals.en.srt 8.0 KB
26 Common Table Expressions (CTE)/001 Introduction to CTEs.en.srt 8.0 KB
02 Introduction to PostgreSQL/010 Install northwind database.en.srt 8.0 KB
24 All about Views/013 An updatable view with CRUD operations.en.srt 7.9 KB
46 PostgreSQL Internals/007 Using system Administration functions.en.srt 7.9 KB
41 Using Northwind Database/010 Customers with no orders.en.srt 7.9 KB
11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.en.srt 7.9 KB
17 Grouping Data/006 HAVING vs WHERE.en.srt 7.8 KB
36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.en.srt 7.8 KB
28 Window Functions/042 DELETE and INSERT in one query using WITH.en.srt 7.8 KB
40 PostgreSQL Transactions/002 How SQL protect database during transaction.en.srt 7.8 KB
34 Functions with PL_pgSQL language/015 Using IF with table data.en.srt 7.8 KB
23 Indexes and Performance Optimization/011 Optimizer node types.en.srt 7.8 KB
03 Creating and Modifying Tables/007 Install sample data for 'movies' database.en.srt 7.8 KB
30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.en.srt 7.7 KB
28 Window Functions/004 GROUP BY ROLLUP.en.srt 7.7 KB
33 Functions with SQL language/005 Function returning a single value Part 2.en.srt 7.7 KB
03 Creating and Modifying Tables/002 Creating the movie database and a actors table.en.srt 7.7 KB
28 Window Functions/019 RANK and DENSE_RANK functions.en.srt 7.7 KB
28 Window Functions/009 Using FILTER clause.en.srt 7.7 KB
44 Managing PostgreSQL security/005 Database Level Security.en.srt 7.7 KB
35 Exploring Stored Procedures/003 Understanding the use of stored procedures.en.srt 7.6 KB
38 Creating Crosstab Reports/008 Aggregate over filter.en.srt 7.6 KB
33 Functions with SQL language/008 Function using parameters Part 2.en.srt 7.5 KB
34 Functions with PL_pgSQL language/028 Exception - Too many rows.en.srt 7.5 KB
36 PostgreSQL Triggers/011 View triggers variables.en.srt 7.5 KB
28 Window Functions/010 Using Window Functions.en.srt 7.5 KB
34 Functions with PL_pgSQL language/021 CONTINUE statement.en.srt 7.5 KB
03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.en.srt 7.4 KB
28 Window Functions/008 Query performance check.en.srt 7.4 KB
34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.en.srt 7.4 KB
29 Using regular expressions for text patterns/004 POSIX regular expressions.en.srt 7.4 KB
22 JSON with PostgreSQL/007 Create JSON from tables.en.srt 7.4 KB
36 PostgreSQL Triggers/007 Steps to create a trigger.en.srt 7.4 KB
44 Managing PostgreSQL security/011 Row level policy for application users.en.srt 7.4 KB
22 JSON with PostgreSQL/008 Use json_agg to aggregate data.en.srt 7.3 KB
03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.en.srt 7.3 KB
34 Functions with PL_pgSQL language/007 Declaring variables in function.en.srt 7.3 KB
14 String Functions/009 STRPOS.en.srt 7.2 KB
22 JSON with PostgreSQL/011 Null Values in JSON documents.en.srt 7.2 KB
11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.en.srt 7.2 KB
28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.en.srt 7.2 KB
23 Indexes and Performance Optimization/005 Size of the table index.en.srt 7.2 KB
15 Aggregate functions/004 GREATEST AND LEAST functions.en.srt 7.2 KB
42 Using Human Resource (hr) database/002 Quick overview of all tables.en.srt 7.1 KB
31 Table Partitions/010 Partition maintenance.en.srt 7.1 KB
33 Functions with SQL language/003 Function returning no values.en.srt 7.1 KB
28 Window Functions/006 GROUP BY CUBE.en.srt 7.1 KB
26 Common Table Expressions (CTE)/006 Recursive CTEs.en.srt 7.1 KB
37 Using Cursors/002 Cursors and procedural languages.en.srt 7.1 KB
31 Table Partitions/017 Common partitioning mistakes.en.srt 7.1 KB
10 Conversion Functions/004 to_timestamp.en.srt 7.1 KB
42 Using Human Resource (hr) database/013 Discard characters from employees email address.en.srt 7.0 KB
31 Table Partitions/016 Partitioning Advantages.en.srt 7.0 KB
25 Fun with subqueries/013 Subquery using EXISTS.en.srt 7.0 KB
18 Joining Multiple Tables/005 INNER joins with filter data Part 3.en.srt 7.0 KB
18 Joining Multiple Tables/013 FULL Joins.en.srt 7.0 KB
24 All about Views/006 A view with UNION of multiple tables.en.srt 6.9 KB
06 Filtering Data/004 Combining AND, OR operators.en.srt 6.9 KB
28 Window Functions/035 Window Function Summary.en.srt 6.8 KB
09 Data type conversions/003 Implicit to Explicit conversions.en.srt 6.8 KB
33 Functions with SQL language/019 Drop a function.en.srt 6.8 KB
34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.en.srt 6.8 KB
14 String Functions/001 UPPER, LOWER and INITCAP.en.srt 6.8 KB
28 Window Functions/011 Partitioning the data.en.srt 6.8 KB
21 Exploring array functions/003 Using inclusion operators.en.srt 6.7 KB
18 Joining Multiple Tables/006 INNER joins with different data type columns.en.srt 6.7 KB
22 JSON with PostgreSQL/009 Build a JSON array.en.srt 6.7 KB
34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.en.srt 6.7 KB
03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.en.srt 6.7 KB
24 All about Views/017 Creating a materialized view.en.srt 6.7 KB
34 Functions with PL_pgSQL language/012 Variables in block and subblock.en.srt 6.7 KB
16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.en.srt 6.7 KB
41 Using Northwind Database/011 Top customers with total orders amount.en.srt 6.6 KB
36 PostgreSQL Triggers/020 Creating event triggers.en.srt 6.6 KB
23 Indexes and Performance Optimization/006 List counts of all indexes.en.srt 6.6 KB
20 PostgreSQL Schemas/008 What is a system catalog schema_.en.srt 6.5 KB
34 Functions with PL_pgSQL language/013 How to return query results.en.srt 6.5 KB
28 Window Functions/038 Getting RANK to compute group and global ranks.en.srt 6.5 KB
24 All about Views/003 Rename a view.en.srt 6.5 KB
25 Fun with subqueries/003 Subquery with IN operator.en.srt 6.5 KB
36 PostgreSQL Triggers/021 Event trigger events and variables.en.srt 6.5 KB
46 PostgreSQL Internals/008 Show all running queries.en.srt 6.5 KB
12 Explore PostgreSQL Constraints/004 DEFAULT constraint.en.srt 6.4 KB
19 Combining queries together/004 INTERSECT with tables.en.srt 6.4 KB
46 PostgreSQL Internals/002 List all database and schemas.en.srt 6.4 KB
13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.en.srt 6.4 KB
02 Introduction to PostgreSQL/004 Creating a Database User.en.srt 6.3 KB
34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.en.srt 6.3 KB
44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.en.srt 6.3 KB
21 Exploring array functions/010 Using arrays in tables.en.srt 6.3 KB
25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.en.srt 6.3 KB
38 Creating Crosstab Reports/006 Pivoting rows and columns.en.srt 6.2 KB
21 Exploring array functions/014 Array Dimensions are ignored!.en.srt 6.2 KB
24 All about Views/022 Why not use a table instead of materialized view_.en.srt 6.2 KB
23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.en.srt 6.2 KB
23 Indexes and Performance Optimization/016 Hash Index.en.srt 6.2 KB
06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.en.srt 6.2 KB
16 Using DATE_TIME functions/012 OVERLAPS Operator.en.srt 6.1 KB
23 Indexes and Performance Optimization/008 SQL Statement execution process.en.srt 6.1 KB
44 Managing PostgreSQL security/004 Use pgAdmin to create roles.en.srt 6.1 KB
23 Indexes and Performance Optimization/028 Try to use index only scan.en.srt 6.1 KB
44 Managing PostgreSQL security/001 Security concepts and and levels.en.srt 6.1 KB
22 JSON with PostgreSQL/015 The Containment Operator.en.srt 6.0 KB
32 Server Programming/004 Functions vs stored procedures.en.srt 6.0 KB
46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.en.srt 6.0 KB
23 Indexes and Performance Optimization/004 List all indexes.en.srt 6.0 KB
22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.en.srt 5.9 KB
24 All about Views/026 List materialized views with no unique index.en.srt 5.9 KB
14 String Functions/010 SUBSTRING.en.srt 5.9 KB
34 Functions with PL_pgSQL language/025 Returning a table.en.srt 5.9 KB
04 Modifying Data in the tables/001 Insert a data into table.en.srt 5.9 KB
14 String Functions/007 LENGTH.en.srt 5.9 KB
45 PostgreSQL Utilities - psql/001 Connect to local or remote database.en.srt 5.8 KB
44 Managing PostgreSQL security/014 Row Level Security Performance.en.srt 5.8 KB
40 PostgreSQL Transactions/006 How to fix aborted transaction.en.srt 5.8 KB
21 Exploring array functions/015 Display all array elements.en.srt 5.7 KB
14 String Functions/012 REPLACE.en.srt 5.7 KB
31 Table Partitions/013 Partition pruning.en.srt 5.6 KB
28 Window Functions/005 ROLLUP - Grouping multiple columns.en.srt 5.6 KB
11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.en.srt 5.6 KB
23 Indexes and Performance Optimization/001 What is an index_.en.srt 5.6 KB
41 Using Northwind Database/007 Total products in each categories.en.srt 5.6 KB
33 Functions with SQL language/002 Introducing dollar quoting.en.srt 5.6 KB
34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.en.srt 5.6 KB
45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.en.srt 5.6 KB
45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.en.srt 5.6 KB
28 Window Functions/040 Using WITH clause to create your own data.en.srt 5.6 KB
16 Using DATE_TIME functions/020 View and set timezones.en.srt 5.5 KB
07 PostgreSQL Data types/006 Date_Time data types.en.srt 5.5 KB
18 Joining Multiple Tables/004 INNER joins with filter data Part 2.en.srt 5.5 KB
40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.en.srt 5.5 KB
38 Creating Crosstab Reports/001 What is a crosstab report.en.srt 5.4 KB
23 Indexes and Performance Optimization/007 Drop a index.en.srt 5.4 KB
28 Window Functions/007 GROUP BY GROUPING SETS.en.srt 5.4 KB
35 Exploring Stored Procedures/004 Returning a value.en.srt 5.3 KB
28 Window Functions/027 ROW_NUMBER() - Find Nth record.en.srt 5.3 KB
13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.en.srt 5.3 KB
12 Explore PostgreSQL Constraints/001 Introduction to constraints.en.srt 5.3 KB
16 Using DATE_TIME functions/015 AGE function.en.srt 5.3 KB
08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.en.srt 5.3 KB
03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.en.srt 5.2 KB
24 All about Views/012 What is an updatable view_.en.srt 5.2 KB
43 Exploring Stock Markets Data/003 Get first or last record per each group.en.srt 5.2 KB
45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.en.srt 5.2 KB
28 Window Functions/018 Using WINDOW with ROWS BETWEEN.en.srt 5.2 KB
05 Querying Data/002 Selecting specific columns from a table.en.srt 5.1 KB
22 JSON with PostgreSQL/003 JSON and JSONB data types.en.srt 5.1 KB
43 Exploring Stock Markets Data/002 Select first or last records in a table.en.srt 5.1 KB
03 Creating and Modifying Tables/001 Movie Database Structure.en.srt 5.1 KB
28 Window Functions/001 Introduction to Window Functions.en.srt 5.1 KB
13 PostgreSQL Sequences/009 Share one sequence between two tables.en.srt 5.0 KB
22 JSON with PostgreSQL/001 What is JSON_.en.srt 5.0 KB
16 Using DATE_TIME functions/017 CURRENT_TIME function.en.srt 5.0 KB
02 Introduction to PostgreSQL/011 Drop a database.en.srt 5.0 KB
42 Using Human Resource (hr) database/019 Select employees not in range.en.srt 4.9 KB
42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.en.srt 4.9 KB
45 PostgreSQL Utilities - psql/003 List all databases and tables.en.srt 4.9 KB
11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.en.srt 4.9 KB
14 String Functions/008 POSITION.en.srt 4.8 KB
41 Using Northwind Database/008 List products that needs re-ordering.en.srt 4.8 KB
27 Grouping sets/001 Introduction to summarization.en.srt 4.8 KB
33 Functions with SQL language/006 Function returning a single value Part 3.en.srt 4.8 KB
32 Server Programming/005 User-defined functions.en.srt 4.8 KB
24 All about Views/008 Re-arrange columns in a view.en.srt 4.7 KB
18 Joining Multiple Tables/016 Self Joins Part 2.en.srt 4.7 KB
38 Creating Crosstab Reports/004 Orders matters in crosstab reports.en.srt 4.7 KB
06 Filtering Data/003 OR operator.en.srt 4.7 KB
11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.en.srt 4.7 KB
19 Combining queries together/003 UNION tables with different number of columns.en.srt 4.7 KB
45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.en.srt 4.6 KB
05 Querying Data/008 Using ORDER BY with column name or column number.en.srt 4.6 KB
36 PostgreSQL Triggers/017 Use triggers very cautiously.en.srt 4.6 KB
42 Using Human Resource (hr) database/001 Human Resources Database Structure.en.srt 4.5 KB
05 Querying Data/007 Using ORDER BY to sort rows by expressions.en.srt 4.5 KB
16 Using DATE_TIME functions/002 System Month Date settings.en.srt 4.5 KB
20 PostgreSQL Schemas/004 Move a table to a new schema.en.srt 4.5 KB
11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.en.srt 4.5 KB
18 Joining Multiple Tables/012 RIGHT joins Part 2.en.srt 4.5 KB
21 Exploring array functions/013 Modifying array data.en.srt 4.4 KB
24 All about Views/018 Drop a materialized view.en.srt 4.4 KB
23 Indexes and Performance Optimization/031 Adding data while indexing.en.srt 4.4 KB
23 Indexes and Performance Optimization/020 EXPLAIN output options.en.srt 4.4 KB
22 JSON with PostgreSQL/014 The Existence Operator.en.srt 4.3 KB
03 Creating and Modifying Tables/005 Creating the movies_revenues table.en.srt 4.3 KB
42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.en.srt 4.3 KB
13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.en.srt 4.3 KB
41 Using Northwind Database/012 Orders with many lines of ordered items.en.srt 4.3 KB
41 Using Northwind Database/015 Countries with customers or suppliers.en.srt 4.2 KB
33 Functions with SQL language/013 Function - order matters!.en.srt 4.2 KB
33 Functions with SQL language/016 Function parameter modes.en.srt 4.2 KB
42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.en.srt 4.2 KB
36 PostgreSQL Triggers/019 Event triggers usage scenarios.en.srt 4.2 KB
29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.en.srt 4.2 KB
04 Modifying Data in the tables/005 Update data in a table.en.srt 4.2 KB
24 All about Views/011 Regular views are dynamic.en.srt 4.1 KB
24 All about Views/023 The downsides of using materialized views.en.srt 4.1 KB
28 Window Functions/037 Difference between RANK and DENSE_RANK.en.srt 4.1 KB
04 Modifying Data in the tables/007 Updating all records in a table.en.srt 4.1 KB
46 PostgreSQL Internals/004 List all columns from a table.en.srt 4.1 KB
03 Creating and Modifying Tables/003 Creating the directors table.en.srt 4.1 KB
47 Managing Tables/002 Duplicate a table with or without data.en.srt 4.1 KB
41 Using Northwind Database/004 Orders shipped to latin america.en.srt 4.1 KB
11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.en.srt 4.0 KB
04 Modifying Data in the tables/008 Delete data from a table.en.srt 4.0 KB
11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.en.srt 4.0 KB
32 Server Programming/006 Structure of a function.en.srt 4.0 KB
31 Table Partitions/004 Partition types.en.srt 4.0 KB
34 Functions with PL_pgSQL language/009 Copying data types.en.srt 4.0 KB
36 PostgreSQL Triggers/006 Trigger key points.en.srt 4.0 KB
05 Querying Data/004 Using SELECT statement for expressions.en.srt 4.0 KB
37 Using Cursors/003 Steps to create a cursor.en.srt 3.9 KB
04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.en.srt 3.9 KB
36 PostgreSQL Triggers/004 Trigger table.en.srt 3.9 KB
24 All about Views/010 Add a column in a view.en.srt 3.9 KB
02 Introduction to PostgreSQL/005 Creating a Database.en.srt 3.9 KB
33 Functions with SQL language/014 Function returning a table.en.srt 3.9 KB
44 Managing PostgreSQL security/013 Inspecting permissions.en.srt 3.9 KB
46 PostgreSQL Internals/009 Terminate running and IDLE process.en.srt 3.9 KB
06 Filtering Data/005 What goes before and after WHERE clause.en.srt 3.8 KB
46 PostgreSQL Internals/005 View system metadata via system information functions.en.srt 3.8 KB
42 Using Human Resource (hr) database/021 Update phone_number with your strings.en.srt 3.8 KB
12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.en.srt 3.8 KB
28 Window Functions/012 Set data into millions format.en.srt 3.8 KB
11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.en.srt 3.8 KB
05 Querying Data/006 Using ORDER BY with alias column name.en.srt 3.7 KB
40 PostgreSQL Transactions/004 Transaction setup.en.srt 3.7 KB
11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.en.srt 3.7 KB
47 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 KB
25 Fun with subqueries/008 A SELECT without a FROM.en.srt 3.6 KB
24 All about Views/020 How to check if a materialized view is populated or not_.en.srt 3.6 KB
14 String Functions/011 REPEAT.en.srt 3.6 KB
34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.en.srt 3.6 KB
02 Introduction to PostgreSQL/007 Install sample data files on server.en.srt 3.6 KB
45 PostgreSQL Utilities - psql/014 Turn on query execution time.en.srt 3.6 KB
36 PostgreSQL Triggers/003 Types of triggers.en.srt 3.6 KB
03 Creating and Modifying Tables/012 Deleting tables from a database.en.srt 3.5 KB
28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.en.srt 3.4 KB
06 Filtering Data/007 Can we use column aliases with WHERE_.en.srt 3.4 KB
18 Joining Multiple Tables/019 Natural Joins Part 2.en.srt 3.4 KB
42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.en.srt 3.3 KB
42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.en.srt 3.3 KB
34 Functions with PL_pgSQL language/008 Variable initializing timing.en.srt 3.3 KB
11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.en.srt 3.2 KB
04 Modifying Data in the tables/002 Insert multiple records into a table.en.srt 3.2 KB
14 String Functions/003 REVERSE.en.srt 3.2 KB
42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.en.srt 3.2 KB
02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.en.srt 3.1 KB
44 Managing PostgreSQL security/012 DROP a policy.en.srt 3.1 KB
42 Using Human Resource (hr) database/018 Select employees with particular department id only.en.srt 3.1 KB
34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.en.srt 3.1 KB
02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.en.srt 3.1 KB
24 All about Views/009 Delete a column in a view.en.srt 3.1 KB
34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.en.srt 3.1 KB
02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.en.srt 3.1 KB
12 Explore PostgreSQL Constraints/011 Drop a constraint.en.srt 3.0 KB
24 All about Views/004 Delete a view.en.srt 3.0 KB
02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.en.srt 3.0 KB
06 Filtering Data/001 Comparison, Logical and Arithmetic operators.en.srt 3.0 KB
42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.en.srt 3.0 KB
02 Introduction to PostgreSQL/009 Install sample stocks market data.en.srt 2.9 KB
20 PostgreSQL Schemas/006 Alter a schema ownership.en.srt 2.9 KB
23 Indexes and Performance Optimization/017 BRIN index.en.srt 2.9 KB
04 Modifying Data in the tables/006 Updating a row and returning the updated row.en.srt 2.9 KB
42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.en.srt 2.9 KB
11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.en.srt 2.9 KB
13 PostgreSQL Sequences/004 Create a sequence using a specific data type.en.srt 2.9 KB
42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.en.srt 2.9 KB
02 Introduction to PostgreSQL/009 sample_data.zip 2.8 KB
41 Using Northwind Database/006 First the oldest and latest order date.en.srt 2.8 KB
35 Exploring Stored Procedures/005 Drop a procedure.en.srt 2.8 KB
25 Fun with subqueries/001 Introduction to subqueries.html 2.7 KB
42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.en.srt 2.7 KB
45 PostgreSQL Utilities - psql/011 Make table layout funkey!.en.srt 2.7 KB
41 Using Northwind Database/002 Orders shipping to USA or France.en.srt 2.7 KB
11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.en.srt 2.6 KB
38 Creating Crosstab Reports/002 Installing the tablefunc extension.en.srt 2.6 KB
45 PostgreSQL Utilities - psql/002 Switch connection to a new database.en.srt 2.6 KB
04 Modifying Data in the tables/003 Insert a data that had quotes.en.srt 2.5 KB
42 Using Human Resource (hr) database/017 Get unique designations in employees table.en.srt 2.5 KB
42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.en.srt 2.5 KB
36 PostgreSQL Triggers/018 What is an event trigger.en.srt 2.5 KB
41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.en.srt 2.4 KB
23 Indexes and Performance Optimization/018 GIN Index.en.srt 2.4 KB
37 Using Cursors/007 Updating data.en.srt 2.4 KB
45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.en.srt 2.4 KB
34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.en.srt 2.4 KB
06 Filtering Data/006 Execution order with AND, OR operators.en.srt 2.3 KB
46 PostgreSQL Internals/010 How to check live and dead rows in tables.en.srt 2.3 KB
42 Using Human Resource (hr) database/010 Using an alias name with columns.en.srt 2.2 KB
29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.en.srt 2.2 KB
03 Creating and Modifying Tables/008 Create a sample Database _mydata_.html 2.2 KB
24 All about Views/025 List all materialized views by a SELECT statement.en.srt 2.2 KB
42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.en.srt 2.1 KB
37 Using Cursors/008 Closing a cursor.en.srt 2.1 KB
12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.en.srt 2.1 KB
43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.en.srt 2.0 KB
17 Grouping Data/003 Order of execution in GROUP BY clause.en.srt 2.0 KB
36 PostgreSQL Triggers/001 Introduction to triggers.html 1.9 KB
42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.en.srt 1.9 KB
18 Joining Multiple Tables/021 ON versus WHERE.html 1.9 KB
25 Fun with subqueries/007 Subquery with an alias.en.srt 1.9 KB
16 Using DATE_TIME functions/016 CURRENT_DATE function.en.srt 1.9 KB
06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.en.srt 1.8 KB
13 PostgreSQL Sequences/006 Delete a sequence.en.srt 1.8 KB
25 Fun with subqueries/005 Get total revenues for all 'English' films.html 1.8 KB
13 PostgreSQL Sequences/008 List all sequences in a database.en.srt 1.8 KB
47 Managing Tables/006 Backup your databases regularly.html 1.8 KB
01 Welcome/001 Course Introduction.en.srt 1.7 KB
47 Managing Tables/007 Test queries on a test database.html 1.7 KB
24 All about Views/027 Quick queries for materialized views.html 1.6 KB
42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.en.srt 1.6 KB
26 Common Table Expressions (CTE)/004 Get the total revenues for each director.html 1.6 KB
47 Managing Tables/008 Not documenting your process_.html 1.5 KB
41 Using Northwind Database/001 Using Northwind database.en.srt 1.5 KB
22 JSON with PostgreSQL/012 JSON nulls and SQL nulls.html 1.5 KB
49 Thank You!/001 Your feedback is very valuable.html 1.5 KB
45 PostgreSQL Utilities - psql/006 Describe a table.en.srt 1.5 KB
43 Exploring Stock Markets Data/001 Introduction To stock market data.html 1.4 KB
42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.en.srt 1.4 KB
17 Grouping Data/005 Order of execution in HAVING clause.en.srt 1.4 KB
45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.en.srt 1.4 KB
36 PostgreSQL Triggers/024 Dropping a trigger.en.srt 1.3 KB
01 Welcome/002 Sample Data Files.html 1.3 KB
49 Thank You!/002 Upcoming course - Advanced Time Series Analysis.html 1.3 KB
45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.en.srt 1.3 KB
42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.en.srt 1.1 KB
49 Thank You!/003 Thank You!.en.srt 1.0 KB
38 Creating Crosstab Reports/509 pivotcode.sql 948 bytes
04 Modifying Data in the tables/026 q_insert data into table.sql 267 bytes
03 Creating and Modifying Tables/017 q_creating the movies table with a foreign key.sql 258 bytes
03 Creating and Modifying Tables/016 q_creating the directors table.sql 227 bytes
04 Modifying Data in the tables/029 q_use RETURNING to get info on added rows.sql 224 bytes
03 Creating and Modifying Tables/018 q_creating the movies_revenues table.sql 216 bytes
34 Functions with PL_pgSQL language/437 q_variable_initialization_timing.sql 192 bytes
03 Creating and Modifying Tables/015 q_creating movies database and actors table.sql 186 bytes
03 Creating and Modifying Tables/019 q_creating a junction table with movies and actors table.sql 184 bytes
04 Modifying Data in the tables/027 q_insert multiple records into a table.sql 137 bytes
03 Creating and Modifying Tables/025 q_deleting tables from a database.sql 119 bytes
04 Modifying Data in the tables/028 q_insert a data that had quotes.sql 93 bytes

[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En]

File List

Download Torrent

Related Resources

Copyright Infringement