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

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

Create Tool:

Create Time:2022-09-09 20:20:20

File Size:19.70 GB

File Count:1260

File Hash:b2e0c657eb287dfd4133f18cb80b69e4d3ba87bf

Magnet Link:

Magnet Link:

Torrent File:

29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.mp4 195.75 MB
01 Welcome/001 Course Introduction.mp4 5.58 MB
01 Welcome/002 countries_iso_codes.csv 11.45 KB
01 Welcome/002 northwind.sql 341.51 KB
01 Welcome/002 Sample Data Files.html 1.31 KB
01 Welcome/002 sample_data.zip 1.41 MB
01 Welcome/002 trades.sql 510.16 KB
02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.en.srt 3.06 KB
02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.mp4 20.88 MB
02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.en.srt 8.45 KB
02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.mp4 25.73 MB
02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.en.srt 2.99 KB
02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.mp4 7.56 MB
02 Introduction to PostgreSQL/004 Creating a Database User.en.srt 6.34 KB
02 Introduction to PostgreSQL/004 Creating a Database User.mp4 11.59 MB
02 Introduction to PostgreSQL/005 Creating a Database.en.srt 3.92 KB
02 Introduction to PostgreSQL/005 Creating a Database.mp4 10.58 MB
02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.en.srt 3.12 KB
02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.mp4 5.73 MB
02 Introduction to PostgreSQL/007 Install sample data files on server.en.srt 3.58 KB
02 Introduction to PostgreSQL/007 Install sample data files on server.mp4 10.54 MB
02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.en.srt 3.14 KB
02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.mp4 8.20 MB
02 Introduction to PostgreSQL/009 Install sample stocks market data.en.srt 2.94 KB
02 Introduction to PostgreSQL/009 Install sample stocks market data.mp4 28.33 MB
02 Introduction to PostgreSQL/009 sample_data.zip 2.83 KB
02 Introduction to PostgreSQL/010 Install northwind database.en.srt 7.97 KB
02 Introduction to PostgreSQL/010 Install northwind database.mp4 31.65 MB
02 Introduction to PostgreSQL/010 sample_data.zip 1.41 MB
02 Introduction to PostgreSQL/011 Drop a database.en.srt 5.02 KB
02 Introduction to PostgreSQL/011 Drop a database.mp4 13.59 MB
02 Introduction to PostgreSQL/011 sample_data.zip 1.41 MB
02 Introduction to PostgreSQL/012 northwind.sql 341.51 KB
03 Creating and Modifying Tables/001 Movie Database Structure.en.srt 5.09 KB
03 Creating and Modifying Tables/001 Movie Database Structure.mp4 12.23 MB
03 Creating and Modifying Tables/002 Creating the movie database and a actors table.en.srt 7.68 KB
03 Creating and Modifying Tables/002 Creating the movie database and a actors table.mp4 20.60 MB
03 Creating and Modifying Tables/003 Creating the directors table.en.srt 4.08 KB
03 Creating and Modifying Tables/003 Creating the directors table.mp4 14.45 MB
03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.en.srt 7.30 KB
03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.mp4 20.51 MB
03 Creating and Modifying Tables/005 Creating the movies_revenues table.en.srt 4.33 KB
03 Creating and Modifying Tables/005 Creating the movies_revenues table.mp4 13.14 MB
03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.en.srt 5.25 KB
03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.mp4 15.66 MB
03 Creating and Modifying Tables/007 Install sample data for 'movies' database.en.srt 7.76 KB
03 Creating and Modifying Tables/007 Install sample data for 'movies' database.mp4 41.02 MB
03 Creating and Modifying Tables/008 Create a sample Database _mydata_.html 2.17 KB
03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.en.srt 6.67 KB
03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.mp4 21.24 MB
03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.en.srt 7.45 KB
03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.mp4 21.69 MB
03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.en.srt 9.28 KB
03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.mp4 56.81 MB
03 Creating and Modifying Tables/012 Deleting tables from a database.en.srt 3.46 KB
03 Creating and Modifying Tables/012 Deleting tables from a database.mp4 9.68 MB
03 Creating and Modifying Tables/015 q_creating movies database and actors table.sql 186 B
03 Creating and Modifying Tables/016 q_creating the directors table.sql 227 B
03 Creating and Modifying Tables/017 q_creating the movies table with a foreign key.sql 258 B
03 Creating and Modifying Tables/018 q_creating the movies_revenues table.sql 216 B
03 Creating and Modifying Tables/019 q_creating a junction table with movies and actors table.sql 184 B
03 Creating and Modifying Tables/025 q_deleting tables from a database.sql 119 B
04 Modifying Data in the tables/001 Insert a data into table.en.srt 5.90 KB
04 Modifying Data in the tables/001 Insert a data into table.mp4 18.36 MB
04 Modifying Data in the tables/002 Insert multiple records into a table.en.srt 3.19 KB
04 Modifying Data in the tables/002 Insert multiple records into a table.mp4 9.59 MB
04 Modifying Data in the tables/003 Insert a data that had quotes.en.srt 2.54 KB
04 Modifying Data in the tables/003 Insert a data that had quotes.mp4 7.55 MB
04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.en.srt 3.93 KB
04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.mp4 11.11 MB
04 Modifying Data in the tables/005 Update data in a table.en.srt 4.18 KB
04 Modifying Data in the tables/005 Update data in a table.mp4 18.89 MB
04 Modifying Data in the tables/006 Updating a row and returning the updated row.en.srt 2.90 KB
04 Modifying Data in the tables/006 Updating a row and returning the updated row.mp4 10.87 MB
04 Modifying Data in the tables/007 Updating all records in a table.en.srt 4.13 KB
04 Modifying Data in the tables/007 Updating all records in a table.mp4 13.12 MB
04 Modifying Data in the tables/008 Delete data from a table.en.srt 4.04 KB
04 Modifying Data in the tables/008 Delete data from a table.mp4 13.16 MB
04 Modifying Data in the tables/009 Using UPSERT.en.srt 13.98 KB
04 Modifying Data in the tables/009 Using UPSERT.mp4 38.42 MB
04 Modifying Data in the tables/026 q_insert data into table.sql 267 B
04 Modifying Data in the tables/027 q_insert multiple records into a table.sql 137 B
04 Modifying Data in the tables/028 q_insert a data that had quotes.sql 93 B
04 Modifying Data in the tables/029 q_use RETURNING to get info on added rows.sql 224 B
05 Querying Data/001 Select all data from a table.en.srt 8.77 KB
05 Querying Data/001 Select all data from a table.mp4 39.24 MB
05 Querying Data/002 Selecting specific columns from a table.en.srt 5.12 KB
05 Querying Data/002 Selecting specific columns from a table.mp4 15.91 MB
05 Querying Data/003 Adding Aliases to columns in a table.en.srt 12.99 KB
05 Querying Data/003 Adding Aliases to columns in a table.mp4 48.49 MB
05 Querying Data/004 Using SELECT statement for expressions.en.srt 3.98 KB
05 Querying Data/004 Using SELECT statement for expressions.mp4 13.49 MB
05 Querying Data/005 Using ORDER BY to sort records.en.srt 9.11 KB
05 Querying Data/005 Using ORDER BY to sort records.mp4 43.30 MB
05 Querying Data/006 Using ORDER BY with alias column name.en.srt 3.74 KB
05 Querying Data/006 Using ORDER BY with alias column name.mp4 13.61 MB
05 Querying Data/007 Using ORDER BY to sort rows by expressions.en.srt 4.53 KB
05 Querying Data/007 Using ORDER BY to sort rows by expressions.mp4 15.79 MB
05 Querying Data/008 Using ORDER BY with column name or column number.en.srt 4.60 KB
05 Querying Data/008 Using ORDER BY with column name or column number.mp4 17.64 MB
05 Querying Data/009 Using ORDER BY with NULL values.en.srt 8.76 KB
05 Querying Data/009 Using ORDER BY with NULL values.mp4 22.92 MB
05 Querying Data/010 Using DISTINCT for selecting distinct values.en.srt 8.24 KB
05 Querying Data/010 Using DISTINCT for selecting distinct values.mp4 26.06 MB
06 Filtering Data/001 Comparison, Logical and Arithmetic operators.en.srt 2.99 KB
06 Filtering Data/001 Comparison, Logical and Arithmetic operators.mp4 8.55 MB
06 Filtering Data/002 AND operator.en.srt 10.73 KB
06 Filtering Data/002 AND operator.mp4 61.62 MB
06 Filtering Data/003 OR operator.en.srt 4.70 KB
06 Filtering Data/003 OR operator.mp4 15.71 MB
06 Filtering Data/004 Combining AND, OR operators.en.srt 6.89 KB
06 Filtering Data/004 Combining AND, OR operators.mp4 32.21 MB
06 Filtering Data/005 What goes before and after WHERE clause.en.srt 3.84 KB
06 Filtering Data/005 What goes before and after WHERE clause.mp4 14.24 MB
06 Filtering Data/006 Execution order with AND, OR operators.en.srt 2.26 KB
06 Filtering Data/006 Execution order with AND, OR operators.mp4 9.35 MB
06 Filtering Data/007 Can we use column aliases with WHERE_.en.srt 3.40 KB
06 Filtering Data/007 Can we use column aliases with WHERE_.mp4 9.16 MB
06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.en.srt 1.82 KB
06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 6.31 MB
06 Filtering Data/009 Using Logical operators.en.srt 23.50 KB
06 Filtering Data/009 Using Logical operators.mp4 90.42 MB
06 Filtering Data/010 Using LIMIT and OFFSET.en.srt 24.98 KB
06 Filtering Data/010 Using LIMIT and OFFSET.mp4 88.95 MB
06 Filtering Data/011 Using FETCH.en.srt 13.85 KB
06 Filtering Data/011 Using FETCH.mp4 83.80 MB
06 Filtering Data/012 Using IN, NOT IN.en.srt 12.99 KB
06 Filtering Data/012 Using IN, NOT IN.mp4 68.53 MB
06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.en.srt 14.67 KB
06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.mp4 50.70 MB
06 Filtering Data/014 Using LIKE and ILIKE.en.srt 25.58 KB
06 Filtering Data/014 Using LIKE and ILIKE.mp4 88.04 MB
06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.en.srt 16.90 KB
06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.mp4 61.40 MB
06 Filtering Data/016 Concatenation techniques.en.srt 11.10 KB
06 Filtering Data/016 Concatenation techniques.mp4 34.08 MB
06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.en.srt 6.15 KB
06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.mp4 18.17 MB
07 PostgreSQL Data types/001 Boolean.en.srt 19.42 KB
07 PostgreSQL Data types/001 Boolean.mp4 54.54 MB
07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.en.srt 28.42 KB
07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.mp4 77.28 MB
07 PostgreSQL Data types/003 NUMERIC.en.srt 16.03 KB
07 PostgreSQL Data types/003 NUMERIC.mp4 43.22 MB
07 PostgreSQL Data types/004 DECIMALS.en.srt 16.01 KB
07 PostgreSQL Data types/004 DECIMALS.mp4 42.53 MB
07 PostgreSQL Data types/005 Selecting Numbers data types.en.srt 8.49 KB
07 PostgreSQL Data types/005 Selecting Numbers data types.mp4 25.61 MB
07 PostgreSQL Data types/006 Date_Time data types.en.srt 5.47 KB
07 PostgreSQL Data types/006 Date_Time data types.mp4 15.89 MB
07 PostgreSQL Data types/007 DATE.en.srt 9.04 KB
07 PostgreSQL Data types/007 DATE.mp4 25.84 MB
07 PostgreSQL Data types/008 TIME.en.srt 21.13 KB
07 PostgreSQL Data types/008 TIME.mp4 60.80 MB
07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.en.srt 17.91 KB
07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.mp4 54.88 MB
07 PostgreSQL Data types/010 UUID.en.srt 15.45 KB
07 PostgreSQL Data types/010 UUID.mp4 50.32 MB
07 PostgreSQL Data types/011 Array.en.srt 10.25 KB
07 PostgreSQL Data types/011 Array.mp4 29.79 MB
07 PostgreSQL Data types/012 hstore.en.srt 10.92 KB
07 PostgreSQL Data types/012 hstore.mp4 31.75 MB
07 PostgreSQL Data types/013 JSON.en.srt 17.42 KB
07 PostgreSQL Data types/013 JSON.mp4 52.38 MB
07 PostgreSQL Data types/014 Network Addresses.en.srt 20.42 KB
07 PostgreSQL Data types/014 Network Addresses.mp4 61.98 MB
08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.en.srt 5.26 KB
08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.mp4 17.34 MB
08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.en.srt 9.68 KB
08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.mp4 34.95 MB
08 Modifying Table Structures, Add constraints/003 Add constraints to columns.en.srt 11.47 KB
08 Modifying Table Structures, Add constraints/003 Add constraints to columns.mp4 43.08 MB
09 Data type conversions/001 What is a data type conversion.en.srt 8.89 KB
09 Data type conversions/001 What is a data type conversion.mp4 31.21 MB
09 Data type conversions/002 Using CAST for data conversions.en.srt 18.64 KB
09 Data type conversions/002 Using CAST for data conversions.mp4 59.56 MB
09 Data type conversions/003 Implicit to Explicit conversions.en.srt 6.84 KB
09 Data type conversions/003 Implicit to Explicit conversions.mp4 17.09 MB
09 Data type conversions/004 Table data conversion.en.srt 11.50 KB
09 Data type conversions/004 Table data conversion.mp4 29.67 MB
10 Conversion Functions/001 to_char.en.srt 12.14 KB
10 Conversion Functions/001 to_char.mp4 43.98 MB
10 Conversion Functions/002 to_number.en.srt 8.68 KB
10 Conversion Functions/002 to_number.mp4 22.91 MB
10 Conversion Functions/003 to_date.en.srt 8.36 KB
10 Conversion Functions/003 to_date.mp4 28.47 MB
10 Conversion Functions/004 to_timestamp.en.srt 7.09 KB
10 Conversion Functions/004 to_timestamp.mp4 30.95 MB
11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.en.srt 9.06 KB
11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 28.79 MB
11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.en.srt 2.64 KB
11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.mp4 8.57 MB
11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.en.srt 3.67 KB
11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.mp4 11.20 MB
11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.en.srt 4.05 KB
11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.mp4 14.47 MB
11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.en.srt 5.63 KB
11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 17.32 MB
11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.en.srt 3.25 KB
11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 9.32 MB
11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.en.srt 7.20 KB
11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.mp4 20.95 MB
11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.en.srt 7.88 KB
11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.mp4 26.96 MB
11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.en.srt 4.87 KB
11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.mp4 16.87 MB
11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.en.srt 4.69 KB
11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 16.85 MB
11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.en.srt 4.49 KB
11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.mp4 17.38 MB
11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.en.srt 3.76 KB
11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.mp4 13.75 MB
11 User-defined Data Types/013 Update an ENUM data in production server.en.srt 9.88 KB
11 User-defined Data Types/013 Update an ENUM data in production server.mp4 32.27 MB
11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.en.srt 4.02 KB
11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.mp4 17.21 MB
11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.en.srt 2.88 KB
11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.mp4 8.12 MB
12 Explore PostgreSQL Constraints/001 Introduction to constraints.en.srt 5.30 KB
12 Explore PostgreSQL Constraints/001 Introduction to constraints.mp4 17.99 MB
12 Explore PostgreSQL Constraints/002 NOT NULL constraint.en.srt 15.45 KB
12 Explore PostgreSQL Constraints/002 NOT NULL constraint.mp4 45.36 MB
12 Explore PostgreSQL Constraints/003 UNIQUE constraint.en.srt 22.21 KB
12 Explore PostgreSQL Constraints/003 UNIQUE constraint.mp4 60.32 MB
12 Explore PostgreSQL Constraints/004 DEFAULT constraint.en.srt 6.44 KB
12 Explore PostgreSQL Constraints/004 DEFAULT constraint.mp4 22.22 MB
12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.en.srt 29.96 KB
12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.mp4 89.01 MB
12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.en.srt 19.41 KB
12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.mp4 55.75 MB
12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.en.srt 9.19 KB
12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.mp4 17.56 MB
12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.en.srt 9.90 KB
12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.mp4 51.55 MB
12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.en.srt 11.00 KB
12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.mp4 32.29 MB
12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.en.srt 10.97 KB
12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.mp4 34.21 MB
12 Explore PostgreSQL Constraints/011 Drop a constraint.en.srt 3.01 KB
12 Explore PostgreSQL Constraints/011 Drop a constraint.mp4 7.59 MB
12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.en.srt 3.81 KB
12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.mp4 11.76 MB
12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.en.srt 2.06 KB
12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.mp4 4.90 MB
12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.en.srt 12.18 KB
12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.mp4 41.96 MB
12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.en.srt 11.62 KB
12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.mp4 39.71 MB
13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.en.srt 9.14 KB
13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.mp4 30.21 MB
13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.en.srt 5.30 KB
13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 17.82 MB
13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.en.srt 4.30 KB
13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 13.52 MB
13 PostgreSQL Sequences/004 Create a sequence using a specific data type.en.srt 2.86 KB
13 PostgreSQL Sequences/004 Create a sequence using a specific data type.mp4 11.57 MB
13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.en.srt 6.38 KB
13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.mp4 18.92 MB
13 PostgreSQL Sequences/006 Delete a sequence.en.srt 1.80 KB
13 PostgreSQL Sequences/006 Delete a sequence.mp4 5.63 MB
13 PostgreSQL Sequences/007 Attach a sequence to a table column.en.srt 10.51 KB
13 PostgreSQL Sequences/007 Attach a sequence to a table column.mp4 36.50 MB
13 PostgreSQL Sequences/008 List all sequences in a database.en.srt 1.78 KB
13 PostgreSQL Sequences/008 List all sequences in a database.mp4 6.01 MB
13 PostgreSQL Sequences/009 Share one sequence between two tables.en.srt 5.05 KB
13 PostgreSQL Sequences/009 Share one sequence between two tables.mp4 16.09 MB
13 PostgreSQL Sequences/010 Create an alphanumeric sequence.en.srt 9.88 KB
13 PostgreSQL Sequences/010 Create an alphanumeric sequence.mp4 31.71 MB
14 String Functions/001 UPPER, LOWER and INITCAP.en.srt 6.77 KB
14 String Functions/001 UPPER, LOWER and INITCAP.mp4 20.09 MB
14 String Functions/002 LEFT and RIGHT.en.srt 12.48 KB
14 String Functions/002 LEFT and RIGHT.mp4 40.45 MB
14 String Functions/003 REVERSE.en.srt 3.18 KB
14 String Functions/003 REVERSE.mp4 8.08 MB
14 String Functions/004 SPLIT_PART.en.srt 10.38 KB
14 String Functions/004 SPLIT_PART.mp4 32.95 MB
14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.en.srt 10.12 KB
14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.mp4 27.26 MB
14 String Functions/006 LPAD and RPAD.en.srt 8.37 KB
14 String Functions/006 LPAD and RPAD.mp4 32.36 MB
14 String Functions/007 LENGTH.en.srt 5.86 KB
14 String Functions/007 LENGTH.mp4 16.66 MB
14 String Functions/008 POSITION.en.srt 4.83 KB
14 String Functions/008 POSITION.mp4 14.74 MB
14 String Functions/009 STRPOS.en.srt 7.23 KB
14 String Functions/009 STRPOS.mp4 32.56 MB
14 String Functions/010 SUBSTRING.en.srt 5.93 KB
14 String Functions/010 SUBSTRING.mp4 17.01 MB
14 String Functions/011 REPEAT.en.srt 3.62 KB
14 String Functions/011 REPEAT.mp4 8.73 MB
14 String Functions/012 REPLACE.en.srt 5.69 KB
14 String Functions/012 REPLACE.mp4 17.13 MB
15 Aggregate functions/001 Counting results via COUNT function.en.srt 8.23 KB
15 Aggregate functions/001 Counting results via COUNT function.mp4 38.06 MB
15 Aggregate functions/002 Sum with SUM function.en.srt 11.58 KB
15 Aggregate functions/002 Sum with SUM function.mp4 37.84 MB
15 Aggregate functions/003 MIN and MAX functions.en.srt 17.85 KB
15 Aggregate functions/003 MIN and MAX functions.mp4 68.42 MB
15 Aggregate functions/004 GREATEST AND LEAST functions.en.srt 7.15 KB
15 Aggregate functions/004 GREATEST AND LEAST functions.mp4 21.04 MB
15 Aggregate functions/005 Average with AVG function.en.srt 18.74 KB
15 Aggregate functions/005 Average with AVG function.mp4 61.53 MB
15 Aggregate functions/006 Combining Columns using Mathematical operators.en.srt 15.93 KB
15 Aggregate functions/006 Combining Columns using Mathematical operators.mp4 45.11 MB
16 Using DATE_TIME functions/001 Datetimes data types.en.srt 14.07 KB
16 Using DATE_TIME functions/001 Datetimes data types.mp4 44.30 MB
16 Using DATE_TIME functions/002 System Month Date settings.en.srt 4.53 KB
16 Using DATE_TIME functions/002 System Month Date settings.mp4 12.84 MB
16 Using DATE_TIME functions/003 Time of day formats and inputs.en.srt 9.14 KB
16 Using DATE_TIME functions/003 Time of day formats and inputs.mp4 24.67 MB
16 Using DATE_TIME functions/004 Strings to Dates conversions.en.srt 17.57 KB
16 Using DATE_TIME functions/004 Strings to Dates conversions.mp4 61.01 MB
16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.en.srt 14.77 KB
16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.mp4 43.94 MB
16 Using DATE_TIME functions/006 Formatting Dates.en.srt 16.10 KB
16 Using DATE_TIME functions/006 Formatting Dates.mp4 60.86 MB
16 Using DATE_TIME functions/007 Date construction functions.en.srt 9.87 KB
16 Using DATE_TIME functions/007 Date construction functions.mp4 26.90 MB
16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.en.srt 9.87 KB
16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.mp4 37.11 MB
16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.en.srt 14.83 KB
16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.mp4 57.78 MB
16 Using DATE_TIME functions/010 Date Value Extractors functions.en.srt 9.22 KB
16 Using DATE_TIME functions/010 Date Value Extractors functions.mp4 36.21 MB
16 Using DATE_TIME functions/011 Using math operators with dates.en.srt 15.26 KB
16 Using DATE_TIME functions/011 Using math operators with dates.mp4 46.76 MB
16 Using DATE_TIME functions/012 OVERLAPS Operator.en.srt 6.14 KB
16 Using DATE_TIME functions/012 OVERLAPS Operator.mp4 16.22 MB
16 Using DATE_TIME functions/013 Date _ Time Functions.en.srt 8.30 KB
16 Using DATE_TIME functions/013 Date _ Time Functions.mp4 26.76 MB
16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.en.srt 6.65 KB
16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.mp4 18.66 MB
16 Using DATE_TIME functions/015 AGE function.en.srt 5.30 KB
16 Using DATE_TIME functions/015 AGE function.mp4 14.14 MB
16 Using DATE_TIME functions/016 CURRENT_DATE function.en.srt 1.89 KB
16 Using DATE_TIME functions/016 CURRENT_DATE function.mp4 4.64 MB
16 Using DATE_TIME functions/017 CURRENT_TIME function.en.srt 5.03 KB
16 Using DATE_TIME functions/017 CURRENT_TIME function.mp4 18.82 MB
16 Using DATE_TIME functions/018 Date accuracy with EPOCH.en.srt 10.77 KB
16 Using DATE_TIME functions/018 Date accuracy with EPOCH.mp4 38.83 MB
16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.en.srt 13.02 KB
16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.mp4 44.05 MB
16 Using DATE_TIME functions/020 View and set timezones.en.srt 5.48 KB
16 Using DATE_TIME functions/020 View and set timezones.mp4 15.02 MB
16 Using DATE_TIME functions/021 How to handle timezones.en.srt 15.55 KB
16 Using DATE_TIME functions/021 How to handle timezones.mp4 60.64 MB
16 Using DATE_TIME functions/022 date_part function.en.srt 16.97 KB
16 Using DATE_TIME functions/022 date_part function.mp4 119.18 MB
16 Using DATE_TIME functions/023 date_trunc function.en.srt 13.09 KB
16 Using DATE_TIME functions/023 date_trunc function.mp4 48.22 MB
17 Grouping Data/001 Using GROUP BY.en.srt 16.05 KB
17 Grouping Data/001 Using GROUP BY.mp4 55.77 MB
17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.en.srt 20.62 KB
17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.mp4 61.11 MB
17 Grouping Data/003 Order of execution in GROUP BY clause.en.srt 1.99 KB
17 Grouping Data/003 Order of execution in GROUP BY clause.mp4 5.48 MB
17 Grouping Data/004 Using HAVING.en.srt 16.58 KB
17 Grouping Data/004 Using HAVING.mp4 85.07 MB
17 Grouping Data/005 Order of execution in HAVING clause.en.srt 1.42 KB
17 Grouping Data/005 Order of execution in HAVING clause.mp4 4.09 MB
17 Grouping Data/006 HAVING vs WHERE.en.srt 7.84 KB
17 Grouping Data/006 HAVING vs WHERE.mp4 22.83 MB
17 Grouping Data/007 Handling NULL values with GROUP BY.en.srt 14.72 KB
17 Grouping Data/007 Handling NULL values with GROUP BY.mp4 40.86 MB
18 Joining Multiple Tables/001 INNER joins.en.srt 29.24 KB
18 Joining Multiple Tables/001 INNER joins.mp4 82.69 MB
18 Joining Multiple Tables/002 INNER joins with USING.en.srt 11.93 KB
18 Joining Multiple Tables/002 INNER joins with USING.mp4 50.14 MB
18 Joining Multiple Tables/003 INNER joins with filter data Part 1.en.srt 12.95 KB
18 Joining Multiple Tables/003 INNER joins with filter data Part 1.mp4 56.94 MB
18 Joining Multiple Tables/004 INNER joins with filter data Part 2.en.srt 5.47 KB
18 Joining Multiple Tables/004 INNER joins with filter data Part 2.mp4 22.38 MB
18 Joining Multiple Tables/005 INNER joins with filter data Part 3.en.srt 7.00 KB
18 Joining Multiple Tables/005 INNER joins with filter data Part 3.mp4 32.50 MB
18 Joining Multiple Tables/006 INNER joins with different data type columns.en.srt 6.74 KB
18 Joining Multiple Tables/006 INNER joins with different data type columns.mp4 20.49 MB
18 Joining Multiple Tables/007 LEFT joins Part 1.en.srt 13.07 KB
18 Joining Multiple Tables/007 LEFT joins Part 1.mp4 87.22 MB
18 Joining Multiple Tables/008 LEFT joins Part 2.en.srt 10.15 KB
18 Joining Multiple Tables/008 LEFT joins Part 2.mp4 42.91 MB
18 Joining Multiple Tables/009 LEFT joins Part 3.en.srt 11.72 KB
18 Joining Multiple Tables/009 LEFT joins Part 3.mp4 51.16 MB
18 Joining Multiple Tables/010 LEFT joins Part 4.en.srt 8.17 KB
18 Joining Multiple Tables/010 LEFT joins Part 4.mp4 37.55 MB
18 Joining Multiple Tables/011 RIGHT joins.en.srt 14.35 KB
18 Joining Multiple Tables/011 RIGHT joins.mp4 54.47 MB
18 Joining Multiple Tables/012 RIGHT joins Part 2.en.srt 4.45 KB
18 Joining Multiple Tables/012 RIGHT joins Part 2.mp4 15.08 MB
18 Joining Multiple Tables/013 FULL Joins.en.srt 6.98 KB
18 Joining Multiple Tables/013 FULL Joins.mp4 22.09 MB
18 Joining Multiple Tables/014 Joining multiple tables.en.srt 12.22 KB
18 Joining Multiple Tables/014 Joining multiple tables.mp4 60.96 MB
18 Joining Multiple Tables/015 Self Joins Part 1.en.srt 11.76 KB
18 Joining Multiple Tables/015 Self Joins Part 1.mp4 35.48 MB
18 Joining Multiple Tables/016 Self Joins Part 2.en.srt 4.71 KB
18 Joining Multiple Tables/016 Self Joins Part 2.mp4 12.92 MB
18 Joining Multiple Tables/017 CROSS Joins.en.srt 14.42 KB
18 Joining Multiple Tables/017 CROSS Joins.mp4 55.75 MB
18 Joining Multiple Tables/018 Natural Joins Part 1.en.srt 8.09 KB
18 Joining Multiple Tables/018 Natural Joins Part 1.mp4 24.06 MB
18 Joining Multiple Tables/019 Natural Joins Part 2.en.srt 3.37 KB
18 Joining Multiple Tables/019 Natural Joins Part 2.mp4 13.15 MB
18 Joining Multiple Tables/020 Append tables with different columns.en.srt 18.34 KB
18 Joining Multiple Tables/020 Append tables with different columns.mp4 70.75 MB
18 Joining Multiple Tables/021 ON versus WHERE.html 1.92 KB
19 Combining queries together/001 Combine results sets with UNION.en.srt 16.37 KB
19 Combining queries together/001 Combine results sets with UNION.mp4 54.40 MB
19 Combining queries together/002 UNION with filters and conditions.en.srt 14.01 KB
19 Combining queries together/002 UNION with filters and conditions.mp4 44.77 MB
19 Combining queries together/003 UNION tables with different number of columns.en.srt 4.66 KB
19 Combining queries together/003 UNION tables with different number of columns.mp4 13.81 MB
19 Combining queries together/004 INTERSECT with tables.en.srt 6.43 KB
19 Combining queries together/004 INTERSECT with tables.mp4 17.11 MB
19 Combining queries together/005 EXCEPT with tables.en.srt 8.13 KB
19 Combining queries together/005 EXCEPT with tables.mp4 22.24 MB
20 PostgreSQL Schemas/001 What is a Schema_.en.srt 9.13 KB
20 PostgreSQL Schemas/001 What is a Schema_.mp4 27.28 MB
20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).en.srt 10.88 KB
20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).mp4 28.19 MB
20 PostgreSQL Schemas/003 Schema Hierarchy.en.srt 9.59 KB
20 PostgreSQL Schemas/003 Schema Hierarchy.mp4 26.73 MB
20 PostgreSQL Schemas/004 Move a table to a new schema.en.srt 4.52 KB
20 PostgreSQL Schemas/004 Move a table to a new schema.mp4 10.87 MB
20 PostgreSQL Schemas/005 Schema search path.en.srt 20.43 KB
20 PostgreSQL Schemas/005 Schema search path.mp4 155.25 MB
20 PostgreSQL Schemas/006 Alter a schema ownership.en.srt 2.94 KB
20 PostgreSQL Schemas/006 Alter a schema ownership.mp4 8.53 MB
20 PostgreSQL Schemas/007 Duplicate a schema along with all data.en.srt 9.20 KB
20 PostgreSQL Schemas/007 Duplicate a schema along with all data.mp4 40.78 MB
20 PostgreSQL Schemas/008 What is a system catalog schema_.en.srt 6.53 KB
20 PostgreSQL Schemas/008 What is a system catalog schema_.mp4 26.37 MB
20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.en.srt 11.41 KB
20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.mp4 47.30 MB
20 PostgreSQL Schemas/010 Schemas and Privileges.en.srt 9.50 KB
20 PostgreSQL Schemas/010 Schemas and Privileges.mp4 36.00 MB
21 Exploring array functions/001 Constructing arrays and ranges.en.srt 11.05 KB
21 Exploring array functions/001 Constructing arrays and ranges.mp4 31.80 MB
21 Exploring array functions/002 Using comparison operators.en.srt 11.62 KB
21 Exploring array functions/002 Using comparison operators.mp4 34.19 MB
21 Exploring array functions/003 Using inclusion operators.en.srt 6.74 KB
21 Exploring array functions/003 Using inclusion operators.mp4 35.01 MB
21 Exploring array functions/004 Array constructions.en.srt 8.03 KB
21 Exploring array functions/004 Array constructions.mp4 21.30 MB
21 Exploring array functions/005 Array metadata functions.en.srt 12.46 KB
21 Exploring array functions/005 Array metadata functions.mp4 36.75 MB
21 Exploring array functions/006 Array search functions.en.srt 10.23 KB
21 Exploring array functions/006 Array search functions.mp4 29.16 MB
21 Exploring array functions/007 Array modification functions.en.srt 9.82 KB
21 Exploring array functions/007 Array modification functions.mp4 30.13 MB
21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.en.srt 20.96 KB
21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.mp4 55.61 MB
21 Exploring array functions/009 Formatting and converting an array.en.srt 13.69 KB
21 Exploring array functions/009 Formatting and converting an array.mp4 37.04 MB
21 Exploring array functions/010 Using arrays in tables.en.srt 6.26 KB
21 Exploring array functions/010 Using arrays in tables.mp4 19.64 MB
21 Exploring array functions/011 Insert data into arrays.en.srt 8.84 KB
21 Exploring array functions/011 Insert data into arrays.mp4 23.46 MB
21 Exploring array functions/012 Query array data.en.srt 10.81 KB
21 Exploring array functions/012 Query array data.mp4 28.93 MB
21 Exploring array functions/013 Modifying array data.en.srt 4.45 KB
21 Exploring array functions/013 Modifying array data.mp4 12.82 MB
21 Exploring array functions/014 Array Dimensions are ignored!.en.srt 6.23 KB
21 Exploring array functions/014 Array Dimensions are ignored!.mp4 18.33 MB
21 Exploring array functions/015 Display all array elements.en.srt 5.70 KB
21 Exploring array functions/015 Display all array elements.mp4 15.96 MB
21 Exploring array functions/016 Using Multi-dimensional arrays.en.srt 16.58 KB
21 Exploring array functions/016 Using Multi-dimensional arrays.mp4 47.56 MB
21 Exploring array functions/017 Array vs JSONB.en.srt 21.02 KB
21 Exploring array functions/017 Array vs JSONB.mp4 63.28 MB
21 Exploring array functions/018 Single and Multi-dimensional arrays.html 3.65 KB
22 JSON with PostgreSQL/001 What is JSON_.en.srt 5.05 KB
22 JSON with PostgreSQL/001 What is JSON_.mp4 20.75 MB
22 JSON with PostgreSQL/002 JSON Syntax.en.srt 13.96 KB
22 JSON with PostgreSQL/002 JSON Syntax.mp4 33.91 MB
22 JSON with PostgreSQL/003 JSON and JSONB data types.en.srt 5.11 KB
22 JSON with PostgreSQL/003 JSON and JSONB data types.mp4 20.49 MB
22 JSON with PostgreSQL/004 Exploring JSON objects.en.srt 10.18 KB
22 JSON with PostgreSQL/004 Exploring JSON objects.mp4 26.66 MB
22 JSON with PostgreSQL/005 Create our first table with JSONB data type.en.srt 11.00 KB
22 JSON with PostgreSQL/005 Create our first table with JSONB data type.mp4 31.77 MB
22 JSON with PostgreSQL/006 Update and Delete JSON Data.en.srt 17.46 KB
22 JSON with PostgreSQL/006 Update and Delete JSON Data.mp4 53.19 MB
22 JSON with PostgreSQL/007 Create JSON from tables.en.srt 7.44 KB
22 JSON with PostgreSQL/007 Create JSON from tables.mp4 28.35 MB
22 JSON with PostgreSQL/008 Use json_agg to aggregate data.en.srt 7.32 KB
22 JSON with PostgreSQL/008 Use json_agg to aggregate data.mp4 28.80 MB
22 JSON with PostgreSQL/009 Build a JSON array.en.srt 6.68 KB
22 JSON with PostgreSQL/009 Build a JSON array.mp4 17.37 MB
22 JSON with PostgreSQL/010 Creating a document from data.en.srt 8.55 KB
22 JSON with PostgreSQL/010 Creating a document from data.mp4 27.84 MB
22 JSON with PostgreSQL/011 Null Values in JSON documents.en.srt 7.22 KB
22 JSON with PostgreSQL/011 Null Values in JSON documents.mp4 58.45 MB
22 JSON with PostgreSQL/012 JSON nulls and SQL nulls.html 1.53 KB
22 JSON with PostgreSQL/013 Getting information from JSON documents.en.srt 8.98 KB
22 JSON with PostgreSQL/013 Getting information from JSON documents.mp4 68.46 MB
22 JSON with PostgreSQL/014 The Existence Operator.en.srt 4.34 KB
22 JSON with PostgreSQL/014 The Existence Operator.mp4 12.41 MB
22 JSON with PostgreSQL/015 The Containment Operator.en.srt 6.05 KB
22 JSON with PostgreSQL/015 The Containment Operator.mp4 16.97 MB
22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.en.srt 5.94 KB
22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.mp4 18.47 MB
22 JSON with PostgreSQL/017 Indexing on JSONB.en.srt 17.45 KB
22 JSON with PostgreSQL/017 Indexing on JSONB.mp4 82.13 MB
23 Indexes and Performance Optimization/001 What is an index_.en.srt 5.62 KB
23 Indexes and Performance Optimization/001 What is an index_.mp4 18.21 MB
23 Indexes and Performance Optimization/002 Create an index.en.srt 22.90 KB
23 Indexes and Performance Optimization/002 Create an index.mp4 77.79 MB
23 Indexes and Performance Optimization/003 Create unique indexes.en.srt 14.67 KB
23 Indexes and Performance Optimization/003 Create unique indexes.mp4 57.30 MB
23 Indexes and Performance Optimization/004 List all indexes.en.srt 5.97 KB
23 Indexes and Performance Optimization/004 List all indexes.mp4 17.75 MB
23 Indexes and Performance Optimization/005 Size of the table index.en.srt 7.19 KB
23 Indexes and Performance Optimization/005 Size of the table index.mp4 20.28 MB
23 Indexes and Performance Optimization/006 List counts of all indexes.en.srt 6.58 KB
23 Indexes and Performance Optimization/006 List counts of all indexes.mp4 20.13 MB
23 Indexes and Performance Optimization/007 Drop a index.en.srt 5.40 KB
23 Indexes and Performance Optimization/007 Drop a index.mp4 14.99 MB
23 Indexes and Performance Optimization/008 SQL Statement execution process.en.srt 6.07 KB
23 Indexes and Performance Optimization/008 SQL Statement execution process.mp4 18.08 MB
23 Indexes and Performance Optimization/009 SQL statement execution stages.en.srt 8.89 KB
23 Indexes and Performance Optimization/009 SQL statement execution stages.mp4 28.13 MB
23 Indexes and Performance Optimization/010 The query optimizer.en.srt 12.25 KB
23 Indexes and Performance Optimization/010 The query optimizer.mp4 34.85 MB
23 Indexes and Performance Optimization/011 Optimizer node types.en.srt 7.78 KB
23 Indexes and Performance Optimization/011 Optimizer node types.mp4 22.76 MB
23 Indexes and Performance Optimization/012 Sequential Nodes.en.srt 8.73 KB
23 Indexes and Performance Optimization/012 Sequential Nodes.mp4 36.48 MB
23 Indexes and Performance Optimization/013 Index Nodes.en.srt 10.65 KB
23 Indexes and Performance Optimization/013 Index Nodes.mp4 41.90 MB
23 Indexes and Performance Optimization/014 Join Nodes.en.srt 9.35 KB
23 Indexes and Performance Optimization/014 Join Nodes.mp4 37.11 MB
23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.en.srt 6.19 KB
23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.mp4 19.45 MB
23 Indexes and Performance Optimization/016 Hash Index.en.srt 6.18 KB
23 Indexes and Performance Optimization/016 Hash Index.mp4 24.25 MB
23 Indexes and Performance Optimization/017 BRIN index.en.srt 2.92 KB
23 Indexes and Performance Optimization/017 BRIN index.mp4 8.94 MB
23 Indexes and Performance Optimization/018 GIN Index.en.srt 2.37 KB
23 Indexes and Performance Optimization/018 GIN Index.mp4 7.05 MB
23 Indexes and Performance Optimization/019 The EXPLAIN statement.en.srt 22.53 KB
23 Indexes and Performance Optimization/019 The EXPLAIN statement.mp4 74.74 MB
23 Indexes and Performance Optimization/020 EXPLAIN output options.en.srt 4.36 KB
23 Indexes and Performance Optimization/020 EXPLAIN output options.mp4 11.91 MB
23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.en.srt 14.28 KB
23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.mp4 39.23 MB
23 Indexes and Performance Optimization/022 Understanding query cost model.en.srt 19.51 KB
23 Indexes and Performance Optimization/022 Understanding query cost model.mp4 56.56 MB
23 Indexes and Performance Optimization/023 Index are not free.en.srt 17.61 KB
23 Indexes and Performance Optimization/023 Index are not free.mp4 58.70 MB
23 Indexes and Performance Optimization/024 Indexes for sorted output.en.srt 12.59 KB
23 Indexes and Performance Optimization/024 Indexes for sorted output.mp4 36.01 MB
23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.en.srt 11.83 KB
23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.mp4 32.43 MB
23 Indexes and Performance Optimization/026 Execution plans depends on input values.en.srt 9.74 KB
23 Indexes and Performance Optimization/026 Execution plans depends on input values.mp4 28.40 MB
23 Indexes and Performance Optimization/027 Using organized vs random data.en.srt 27.81 KB
23 Indexes and Performance Optimization/027 Using organized vs random data.mp4 99.66 MB
23 Indexes and Performance Optimization/028 Try to use index only scan.en.srt 6.07 KB
23 Indexes and Performance Optimization/028 Try to use index only scan.mp4 16.37 MB
23 Indexes and Performance Optimization/029 Partial indexes.en.srt 14.85 KB
23 Indexes and Performance Optimization/029 Partial indexes.mp4 55.83 MB
23 Indexes and Performance Optimization/030 Expression Index.en.srt 22.20 KB
23 Indexes and Performance Optimization/030 Expression Index.mp4 120.06 MB
23 Indexes and Performance Optimization/031 Adding data while indexing.en.srt 4.44 KB
23 Indexes and Performance Optimization/031 Adding data while indexing.mp4 11.62 MB
23 Indexes and Performance Optimization/032 Invalidating an index.en.srt 12.15 KB
23 Indexes and Performance Optimization/032 Invalidating an index.mp4 98.90 MB
23 Indexes and Performance Optimization/033 Rebuilding an index.en.srt 10.58 KB
23 Indexes and Performance Optimization/033 Rebuilding an index.mp4 29.46 MB
24 All about Views/001 Introduction to views.en.srt 10.40 KB
24 All about Views/001 Introduction to views.mp4 33.85 MB
24 All about Views/002 Creating a view.en.srt 16.02 KB
24 All about Views/002 Creating a view.mp4 54.55 MB
24 All about Views/003 Rename a view.en.srt 6.47 KB
24 All about Views/003 Rename a view.mp4 18.28 MB
24 All about Views/004 Delete a view.en.srt 3.01 KB
24 All about Views/004 Delete a view.mp4 6.80 MB
24 All about Views/005 Using filters with views.en.srt 10.32 KB
24 All about Views/005 Using filters with views.mp4 40.67 MB
24 All about Views/006 A view with UNION of multiple tables.en.srt 6.90 KB
24 All about Views/006 A view with UNION of multiple tables.mp4 23.24 MB
24 All about Views/007 Connecting multiple tables with a single view.en.srt 10.59 KB
24 All about Views/007 Connecting multiple tables with a single view.mp4 42.36 MB
24 All about Views/008 Re-arrange columns in a view.en.srt 4.72 KB
24 All about Views/008 Re-arrange columns in a view.mp4 12.00 MB
24 All about Views/009 Delete a column in a view.en.srt 3.11 KB
24 All about Views/009 Delete a column in a view.mp4 7.21 MB
24 All about Views/010 Add a column in a view.en.srt 3.92 KB
24 All about Views/010 Add a column in a view.mp4 8.74 MB
24 All about Views/011 Regular views are dynamic.en.srt 4.14 KB
24 All about Views/011 Regular views are dynamic.mp4 13.70 MB
24 All about Views/012 What is an updatable view_.en.srt 5.23 KB
24 All about Views/012 What is an updatable view_.mp4 15.98 MB
24 All about Views/013 An updatable view with CRUD operations.en.srt 7.94 KB
24 All about Views/013 An updatable view with CRUD operations.mp4 29.25 MB
24 All about Views/014 Updatable views using WITH CHECK OPTION.en.srt 11.78 KB
24 All about Views/014 Updatable views using WITH CHECK OPTION.mp4 42.53 MB
24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.en.srt 13.15 KB
24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 40.26 MB
24 All about Views/016 What is a Materialized View.en.srt 13.10 KB
24 All about Views/016 What is a Materialized View.mp4 44.05 MB
24 All about Views/017 Creating a materialized view.en.srt 6.66 KB
24 All about Views/017 Creating a materialized view.mp4 18.63 MB
24 All about Views/018 Drop a materialized view.en.srt 4.44 KB
24 All about Views/018 Drop a materialized view.mp4 15.60 MB
24 All about Views/019 Changing materialized view data.en.srt 9.04 KB
24 All about Views/019 Changing materialized view data.mp4 55.35 MB
24 All about Views/020 How to check if a materialized view is populated or not_.en.srt 3.62 KB
24 All about Views/020 How to check if a materialized view is populated or not_.mp4 11.78 MB
24 All about Views/021 Refreshing data in materialize views.en.srt 9.29 KB
24 All about Views/021 Refreshing data in materialize views.mp4 37.80 MB
24 All about Views/022 Why not use a table instead of materialized view_.en.srt 6.21 KB
24 All about Views/022 Why not use a table instead of materialized view_.mp4 18.06 MB
24 All about Views/023 The downsides of using materialized views.en.srt 4.13 KB
24 All about Views/023 The downsides of using materialized views.mp4 15.98 MB
24 All about Views/024 Using materialized view for websites page analysis.en.srt 16.50 KB
24 All about Views/024 Using materialized view for websites page analysis.mp4 63.74 MB
24 All about Views/025 List all materialized views by a SELECT statement.en.srt 2.16 KB
24 All about Views/025 List all materialized views by a SELECT statement.mp4 5.88 MB
24 All about Views/026 List materialized views with no unique index.en.srt 5.94 KB
24 All about Views/026 List materialized views with no unique index.mp4 17.08 MB
24 All about Views/027 Quick queries for materialized views.html 1.60 KB
25 Fun with subqueries/001 Introduction to subqueries.html 2.74 KB
25 Fun with subqueries/002 Subqueries with WHERE Clause.en.srt 18.07 KB
25 Fun with subqueries/002 Subqueries with WHERE Clause.mp4 66.00 MB
25 Fun with subqueries/003 Subquery with IN operator.en.srt 6.47 KB
25 Fun with subqueries/003 Subquery with IN operator.mp4 19.66 MB
25 Fun with subqueries/004 Subquery with JOINs.en.srt 12.23 KB
25 Fun with subqueries/004 Subquery with JOINs.mp4 47.44 MB
25 Fun with subqueries/005 Get total revenues for all 'English' films.html 1.80 KB
25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.en.srt 6.26 KB
25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.mp4 17.32 MB
25 Fun with subqueries/007 Subquery with an alias.en.srt 1.91 KB
25 Fun with subqueries/007 Subquery with an alias.mp4 6.92 MB
25 Fun with subqueries/008 A SELECT without a FROM.en.srt 3.63 KB
25 Fun with subqueries/008 A SELECT without a FROM.mp4 10.18 MB
25 Fun with subqueries/009 Correlated Queries.en.srt 18.11 KB
25 Fun with subqueries/009 Correlated Queries.mp4 51.83 MB
25 Fun with subqueries/010 SELECT.. IN (Subquery).en.srt 9.78 KB
25 Fun with subqueries/010 SELECT.. IN (Subquery).mp4 39.29 MB
25 Fun with subqueries/011 Using ANY with subquery.en.srt 10.80 KB
25 Fun with subqueries/011 Using ANY with subquery.mp4 40.43 MB
25 Fun with subqueries/012 Using ALL with subquery.en.srt 11.00 KB
25 Fun with subqueries/012 Using ALL with subquery.mp4 47.31 MB
25 Fun with subqueries/013 Subquery using EXISTS.en.srt 7.00 KB
25 Fun with subqueries/013 Subquery using EXISTS.mp4 20.45 MB
26 Common Table Expressions (CTE)/001 Introduction to CTEs.en.srt 7.99 KB
26 Common Table Expressions (CTE)/001 Introduction to CTEs.mp4 24.66 MB
26 Common Table Expressions (CTE)/002 CTE query examples.en.srt 23.18 KB
26 Common Table Expressions (CTE)/002 CTE query examples.mp4 73.64 MB
26 Common Table Expressions (CTE)/003 Combine CTE with a table.en.srt 9.96 KB
26 Common Table Expressions (CTE)/003 Combine CTE with a table.mp4 35.97 MB
26 Common Table Expressions (CTE)/004 Get the total revenues for each director.html 1.57 KB
26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.en.srt 10.83 KB
26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.mp4 32.42 MB
26 Common Table Expressions (CTE)/006 Recursive CTEs.en.srt 7.11 KB
26 Common Table Expressions (CTE)/006 Recursive CTEs.mp4 19.10 MB
26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.en.srt 29.10 KB
26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.mp4 74.34 MB
27 Grouping sets/001 Introduction to summarization.en.srt 4.78 KB
27 Grouping sets/001 Introduction to summarization.mp4 16.02 MB
27 Grouping sets/002 Subtotals on group sets.en.srt 17.54 KB
27 Grouping sets/002 Subtotals on group sets.mp4 114.61 MB
27 Grouping sets/003 Adding subtotal with ROLLUP.en.srt 11.13 KB
27 Grouping sets/003 Adding subtotal with ROLLUP.mp4 32.51 MB
27 Grouping sets/004 Using GROUPING with ROLLUP.en.srt 21.26 KB
27 Grouping sets/004 Using GROUPING with ROLLUP.mp4 112.57 MB
28 Window Functions/001 Introduction to Window Functions.en.srt 5.07 KB
28 Window Functions/001 Introduction to Window Functions.mp4 6.29 MB
28 Window Functions/002 Analyze Global Trades Data.en.srt 11.56 KB
28 Window Functions/002 Analyze Global Trades Data.mp4 96.75 MB
28 Window Functions/003 Using aggregate functions.en.srt 12.41 KB
28 Window Functions/003 Using aggregate functions.mp4 47.62 MB
28 Window Functions/004 GROUP BY ROLLUP.en.srt 7.74 KB
28 Window Functions/004 GROUP BY ROLLUP.mp4 21.65 MB
28 Window Functions/005 ROLLUP - Grouping multiple columns.en.srt 5.63 KB
28 Window Functions/005 ROLLUP - Grouping multiple columns.mp4 17.45 MB
28 Window Functions/006 GROUP BY CUBE.en.srt 7.11 KB
28 Window Functions/006 GROUP BY CUBE.mp4 20.08 MB
28 Window Functions/007 GROUP BY GROUPING SETS.en.srt 5.38 KB
28 Window Functions/007 GROUP BY GROUPING SETS.mp4 19.48 MB
28 Window Functions/008 Query performance check.en.srt 7.45 KB
28 Window Functions/008 Query performance check.mp4 21.71 MB
28 Window Functions/009 Using FILTER clause.en.srt 7.65 KB
28 Window Functions/009 Using FILTER clause.mp4 22.36 MB
28 Window Functions/010 Using Window Functions.en.srt 7.48 KB
28 Window Functions/010 Using Window Functions.mp4 21.09 MB
28 Window Functions/011 Partitioning the data.en.srt 6.76 KB
28 Window Functions/011 Partitioning the data.mp4 27.74 MB
28 Window Functions/012 Set data into millions format.en.srt 3.81 KB
28 Window Functions/012 Set data into millions format.mp4 11.01 MB
28 Window Functions/013 Ordering inside window.en.srt 11.90 KB
28 Window Functions/013 Ordering inside window.mp4 79.20 MB
28 Window Functions/014 Sliding dynamic windows.en.srt 11.44 KB
28 Window Functions/014 Sliding dynamic windows.mp4 31.96 MB
28 Window Functions/015 Understanding window frames.en.srt 33.06 KB
28 Window Functions/015 Understanding window frames.mp4 185.12 MB
28 Window Functions/016 ROWS and RANGE indicators.en.srt 15.82 KB
28 Window Functions/016 ROWS and RANGE indicators.mp4 61.31 MB
28 Window Functions/017 Using WINDOW.en.srt 13.39 KB
28 Window Functions/017 Using WINDOW.mp4 35.79 MB
28 Window Functions/018 Using WINDOW with ROWS BETWEEN.en.srt 5.15 KB
28 Window Functions/018 Using WINDOW with ROWS BETWEEN.mp4 18.17 MB
28 Window Functions/019 RANK and DENSE_RANK functions.en.srt 7.67 KB
28 Window Functions/019 RANK and DENSE_RANK functions.mp4 20.89 MB
28 Window Functions/020 NTILE function.en.srt 13.47 KB
28 Window Functions/020 NTILE function.mp4 38.08 MB
28 Window Functions/021 LEAD and LAG functions.en.srt 21.76 KB
28 Window Functions/021 LEAD and LAG functions.mp4 72.96 MB
28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.en.srt 21.03 KB
28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4 77.75 MB
28 Window Functions/023 ROW_NUMBER function.en.srt 13.66 KB
28 Window Functions/023 ROW_NUMBER function.mp4 53.81 MB
28 Window Functions/024 Finding Correlations.en.srt 8.56 KB
28 Window Functions/024 Finding Correlations.mp4 22.68 MB
28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.en.srt 14.22 KB
28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.mp4 44.15 MB
28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.en.srt 3.41 KB
28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.mp4 14.15 MB
28 Window Functions/027 ROW_NUMBER() - Find Nth record.en.srt 5.33 KB
28 Window Functions/027 ROW_NUMBER() - Find Nth record.mp4 15.25 MB
28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.en.srt 7.20 KB
28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.mp4 26.66 MB
28 Window Functions/029 ROW_NUMBER() - Pagination technique.en.srt 8.88 KB
28 Window Functions/029 ROW_NUMBER() - Pagination technique.mp4 35.29 MB
28 Window Functions/030 Using OVER() to calculate percentage.en.srt 8.60 KB
28 Window Functions/030 Using OVER() to calculate percentage.mp4 24.68 MB
28 Window Functions/031 Calculate difference compared to average.en.srt 8.53 KB
28 Window Functions/031 Calculate difference compared to average.mp4 25.36 MB
28 Window Functions/032 Calculating cumulative totals.en.srt 8.01 KB
28 Window Functions/032 Calculating cumulative totals.mp4 21.19 MB
28 Window Functions/033 Using LEAD to compare with next values.en.srt 8.63 KB
28 Window Functions/033 Using LEAD to compare with next values.mp4 21.25 MB
28 Window Functions/034 Comparing with least number.en.srt 13.34 KB
28 Window Functions/034 Comparing with least number.mp4 47.02 MB
28 Window Functions/035 Window Function Summary.en.srt 6.85 KB
28 Window Functions/035 Window Function Summary.mp4 16.48 MB
28 Window Functions/036 Planning tips on using Window Functions.en.srt 10.08 KB
28 Window Functions/036 Planning tips on using Window Functions.mp4 16.81 MB
28 Window Functions/037 Difference between RANK and DENSE_RANK.en.srt 4.13 KB
28 Window Functions/037 Difference between RANK and DENSE_RANK.mp4 12.04 MB
28 Window Functions/038 Getting RANK to compute group and global ranks.en.srt 6.48 KB
28 Window Functions/038 Getting RANK to compute group and global ranks.mp4 20.69 MB
28 Window Functions/039 Using PARTITION BY for group averages.en.srt 8.57 KB
28 Window Functions/039 Using PARTITION BY for group averages.mp4 26.78 MB
28 Window Functions/040 Using WITH clause to create your own data.en.srt 5.56 KB
28 Window Functions/040 Using WITH clause to create your own data.mp4 14.23 MB
28 Window Functions/041 Using WITH clause to set ORDER BY values.en.srt 9.84 KB
28 Window Functions/041 Using WITH clause to set ORDER BY values.mp4 25.32 MB
28 Window Functions/042 DELETE and INSERT in one query using WITH.en.srt 7.82 KB
28 Window Functions/042 DELETE and INSERT in one query using WITH.mp4 23.20 MB
28 Window Functions/331 trades.sql 510.16 KB
29 Using regular expressions for text patterns/001 Text to structured data.en.srt 8.88 KB
29 Using regular expressions for text patterns/001 Text to structured data.mp4 23.69 MB
29 Using regular expressions for text patterns/002 Regular expressions notations table.en.srt 13.15 KB
29 Using regular expressions for text patterns/002 Regular expressions notations table.mp4 37.32 MB
29 Using regular expressions for text patterns/003 SIMILAR TO operator.en.srt 10.60 KB
29 Using regular expressions for text patterns/003 SIMILAR TO operator.mp4 29.04 MB
29 Using regular expressions for text patterns/004 POSIX regular expressions.en.srt 7.44 KB
29 Using regular expressions for text patterns/004 POSIX regular expressions.mp4 22.30 MB
29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.en.srt 27.93 KB
01 Welcome/001 Course Introduction.en.srt 1.72 KB
29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.en.srt 14.53 KB
29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.mp4 39.59 MB
29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.en.srt 13.04 KB
29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.mp4 30.80 MB
29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.en.srt 2.19 KB
29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.mp4 5.71 MB
29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.en.srt 4.18 KB
29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.mp4 12.96 MB
30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.en.srt 12.40 KB
30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.mp4 44.28 MB
30 Powerful text searches in PostgreSQL/002 Introducing tsvector.en.srt 17.38 KB
30 Powerful text searches in PostgreSQL/002 Introducing tsvector.mp4 52.25 MB
30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.en.srt 21.67 KB
30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.mp4 150.20 MB
30 Powerful text searches in PostgreSQL/004 Full text search within a table.en.srt 20.37 KB
30 Powerful text searches in PostgreSQL/004 Full text search within a table.mp4 63.55 MB
30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.en.srt 9.61 KB
30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.mp4 46.42 MB
30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.en.srt 11.62 KB
30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.mp4 42.94 MB
30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.en.srt 7.74 KB
30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.mp4 23.82 MB
30 Powerful text searches in PostgreSQL/385 president_speeches.csv 1.12 MB
31 Table Partitions/001 What is a partition.en.srt 8.04 KB
31 Table Partitions/001 What is a partition.mp4 26.83 MB
31 Table Partitions/002 When a partition can be used_.en.srt 28.04 KB
31 Table Partitions/002 When a partition can be used_.mp4 86.44 MB
31 Table Partitions/003 Table inheritance.en.srt 23.92 KB
31 Table Partitions/003 Table inheritance.mp4 66.59 MB
31 Table Partitions/004 Partition types.en.srt 4.02 KB
31 Table Partitions/004 Partition types.mp4 12.07 MB
31 Table Partitions/005 Partition by Range.en.srt 30.15 KB
31 Table Partitions/005 Partition by Range.mp4 102.76 MB
31 Table Partitions/006 Partition by List.en.srt 36.94 KB
31 Table Partitions/006 Partition by List.mp4 130.72 MB
31 Table Partitions/007 Partition by Hash.en.srt 22.13 KB
31 Table Partitions/007 Partition by Hash.mp4 63.02 MB
31 Table Partitions/008 DEFAULT Partition.en.srt 9.35 KB
31 Table Partitions/008 DEFAULT Partition.mp4 33.18 MB
31 Table Partitions/009 Multi-level partitioning.en.srt 20.75 KB
31 Table Partitions/009 Multi-level partitioning.mp4 62.36 MB
31 Table Partitions/010 Partition maintenance.en.srt 7.13 KB
31 Table Partitions/010 Partition maintenance.mp4 26.72 MB
31 Table Partitions/011 ALTERing the partition bounds.en.srt 12.88 KB
31 Table Partitions/011 ALTERing the partition bounds.mp4 38.50 MB
31 Table Partitions/012 Partition Indexes.en.srt 10.73 KB
31 Table Partitions/012 Partition Indexes.mp4 31.69 MB
31 Table Partitions/013 Partition pruning.en.srt 5.63 KB
31 Table Partitions/013 Partition pruning.mp4 18.05 MB
31 Table Partitions/014 Determining a field for partition over.en.srt 11.68 KB
31 Table Partitions/014 Determining a field for partition over.mp4 32.52 MB
31 Table Partitions/015 Sizing the partition.en.srt 9.44 KB
31 Table Partitions/015 Sizing the partition.mp4 22.65 MB
31 Table Partitions/016 Partitioning Advantages.en.srt 7.01 KB
31 Table Partitions/016 Partitioning Advantages.mp4 22.10 MB
31 Table Partitions/017 Common partitioning mistakes.en.srt 7.10 KB
31 Table Partitions/017 Common partitioning mistakes.mp4 21.64 MB
32 Server Programming/001 PostgreSQL as a development platform_.en.srt 14.58 KB
32 Server Programming/001 PostgreSQL as a development platform_.mp4 42.05 MB
32 Server Programming/002 Procedural languages.en.srt 8.11 KB
32 Server Programming/002 Procedural languages.mp4 22.01 MB
32 Server Programming/003 Keep the data on the server!.en.srt 8.94 KB
32 Server Programming/003 Keep the data on the server!.mp4 26.71 MB
32 Server Programming/004 Functions vs stored procedures.en.srt 6.00 KB
32 Server Programming/004 Functions vs stored procedures.mp4 17.44 MB
32 Server Programming/005 User-defined functions.en.srt 4.77 KB
32 Server Programming/005 User-defined functions.mp4 16.53 MB
32 Server Programming/006 Structure of a function.en.srt 4.02 KB
32 Server Programming/006 Structure of a function.mp4 11.70 MB
33 Functions with SQL language/001 Creating our first SQL function.en.srt 15.38 KB
33 Functions with SQL language/001 Creating our first SQL function.mp4 50.19 MB
33 Functions with SQL language/002 Introducing dollar quoting.en.srt 5.61 KB
33 Functions with SQL language/002 Introducing dollar quoting.mp4 16.18 MB
33 Functions with SQL language/003 Function returning no values.en.srt 7.13 KB
33 Functions with SQL language/003 Function returning no values.mp4 22.58 MB
33 Functions with SQL language/004 Function returning a single value.en.srt 17.76 KB
33 Functions with SQL language/004 Function returning a single value.mp4 50.18 MB
33 Functions with SQL language/005 Function returning a single value Part 2.en.srt 7.72 KB
33 Functions with SQL language/005 Function returning a single value Part 2.mp4 28.68 MB
33 Functions with SQL language/006 Function returning a single value Part 3.en.srt 4.78 KB
33 Functions with SQL language/006 Function returning a single value Part 3.mp4 26.35 MB
33 Functions with SQL language/007 Function using parameters.en.srt 19.76 KB
33 Functions with SQL language/007 Function using parameters.mp4 75.52 MB
33 Functions with SQL language/008 Function using parameters Part 2.en.srt 7.55 KB
33 Functions with SQL language/008 Function using parameters Part 2.mp4 28.44 MB
33 Functions with SQL language/009 Function using parameters Part 3.en.srt 19.63 KB
33 Functions with SQL language/009 Function using parameters Part 3.mp4 132.86 MB
33 Functions with SQL language/010 Function using parameters Part 4.en.srt 18.59 KB
33 Functions with SQL language/010 Function using parameters Part 4.mp4 80.29 MB
33 Functions with SQL language/011 Function returning a composite.en.srt 17.90 KB
33 Functions with SQL language/011 Function returning a composite.mp4 67.81 MB
33 Functions with SQL language/012 Function returning multiple rows.en.srt 12.23 KB
33 Functions with SQL language/012 Function returning multiple rows.mp4 55.17 MB
33 Functions with SQL language/013 Function - order matters!.en.srt 4.20 KB
33 Functions with SQL language/013 Function - order matters!.mp4 16.69 MB
33 Functions with SQL language/014 Function returning a table.en.srt 3.88 KB
33 Functions with SQL language/014 Function returning a table.mp4 14.70 MB
33 Functions with SQL language/015 Function as a table source.en.srt 13.92 KB
33 Functions with SQL language/015 Function as a table source.mp4 55.42 MB
33 Functions with SQL language/016 Function parameter modes.en.srt 4.20 KB
33 Functions with SQL language/016 Function parameter modes.mp4 16.68 MB
33 Functions with SQL language/017 Function parameters with default values.en.srt 16.39 KB
33 Functions with SQL language/017 Function parameters with default values.mp4 45.21 MB
33 Functions with SQL language/018 Function based on views.en.srt 9.37 KB
33 Functions with SQL language/018 Function based on views.mp4 32.64 MB
33 Functions with SQL language/019 Drop a function.en.srt 6.84 KB
33 Functions with SQL language/019 Drop a function.mp4 18.46 MB
34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.en.srt 3.08 KB
34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.mp4 8.19 MB
34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.en.srt 3.61 KB
34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.mp4 10.78 MB
34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.en.srt 7.44 KB
34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.mp4 18.99 MB
34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.en.srt 3.13 KB
34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.mp4 10.06 MB
34 Functions with PL_pgSQL language/005 Declaring variables.en.srt 8.44 KB
34 Functions with PL_pgSQL language/005 Declaring variables.mp4 23.46 MB
34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.en.srt 2.35 KB
34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.mp4 6.43 MB
34 Functions with PL_pgSQL language/007 Declaring variables in function.en.srt 7.30 KB
34 Functions with PL_pgSQL language/007 Declaring variables in function.mp4 21.05 MB
34 Functions with PL_pgSQL language/008 Variable initializing timing.en.srt 3.30 KB
34 Functions with PL_pgSQL language/008 Variable initializing timing.mp4 8.85 MB
34 Functions with PL_pgSQL language/009 Copying data types.en.srt 4.00 KB
34 Functions with PL_pgSQL language/009 Copying data types.mp4 11.56 MB
34 Functions with PL_pgSQL language/010 Assigning variables from query.en.srt 12.24 KB
34 Functions with PL_pgSQL language/010 Assigning variables from query.mp4 40.18 MB
34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.en.srt 6.67 KB
34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.mp4 18.37 MB
34 Functions with PL_pgSQL language/012 Variables in block and subblock.en.srt 6.66 KB
34 Functions with PL_pgSQL language/012 Variables in block and subblock.mp4 19.03 MB
34 Functions with PL_pgSQL language/013 How to return query results.en.srt 6.52 KB
34 Functions with PL_pgSQL language/013 How to return query results.mp4 32.37 MB
34 Functions with PL_pgSQL language/014 Control Structures - IF statement.en.srt 11.05 KB
34 Functions with PL_pgSQL language/014 Control Structures - IF statement.mp4 32.71 MB
34 Functions with PL_pgSQL language/015 Using IF with table data.en.srt 7.80 KB
34 Functions with PL_pgSQL language/015 Using IF with table data.mp4 34.46 MB
34 Functions with PL_pgSQL language/016 CASE Statement.en.srt 16.46 KB
34 Functions with PL_pgSQL language/016 CASE Statement.mp4 60.81 MB
34 Functions with PL_pgSQL language/017 Searched CASE statement.en.srt 16.76 KB
34 Functions with PL_pgSQL language/017 Searched CASE statement.mp4 46.14 MB
34 Functions with PL_pgSQL language/018 LOOP statement.en.srt 8.49 KB
34 Functions with PL_pgSQL language/018 LOOP statement.mp4 23.43 MB
34 Functions with PL_pgSQL language/019 FOR Loops.en.srt 8.63 KB
34 Functions with PL_pgSQL language/019 FOR Loops.mp4 22.69 MB
34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.en.srt 6.82 KB
34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.mp4 23.43 MB
34 Functions with PL_pgSQL language/021 CONTINUE statement.en.srt 7.45 KB
34 Functions with PL_pgSQL language/021 CONTINUE statement.mp4 19.70 MB
34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.en.srt 5.59 KB
34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.mp4 15.10 MB
34 Functions with PL_pgSQL language/023 WHILE loop.en.srt 17.25 KB
34 Functions with PL_pgSQL language/023 WHILE loop.mp4 52.44 MB
34 Functions with PL_pgSQL language/024 Using RETURN QUERY.en.srt 16.12 KB
34 Functions with PL_pgSQL language/024 Using RETURN QUERY.mp4 56.95 MB
34 Functions with PL_pgSQL language/025 Returning a table.en.srt 5.91 KB
34 Functions with PL_pgSQL language/025 Returning a table.mp4 17.11 MB
34 Functions with PL_pgSQL language/026 Using RETURN NEXT.en.srt 19.33 KB
34 Functions with PL_pgSQL language/026 Using RETURN NEXT.mp4 69.66 MB
34 Functions with PL_pgSQL language/027 Error and exception handling.en.srt 8.14 KB
34 Functions with PL_pgSQL language/027 Error and exception handling.mp4 23.58 MB
34 Functions with PL_pgSQL language/028 Exception - Too many rows.en.srt 7.54 KB
34 Functions with PL_pgSQL language/028 Exception - Too many rows.mp4 22.98 MB
34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.en.srt 6.30 KB
34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.mp4 23.74 MB
34 Functions with PL_pgSQL language/030 Exception with data exception errors.en.srt 10.02 KB
34 Functions with PL_pgSQL language/030 Exception with data exception errors.mp4 67.57 MB
34 Functions with PL_pgSQL language/437 q_variable_initialization_timing.sql 192 B
35 Exploring Stored Procedures/001 Functions vs Stored Procedures.en.srt 8.58 KB
35 Exploring Stored Procedures/001 Functions vs Stored Procedures.mp4 24.63 MB
35 Exploring Stored Procedures/002 Create a transactions.en.srt 11.40 KB
35 Exploring Stored Procedures/002 Create a transactions.mp4 34.08 MB
35 Exploring Stored Procedures/003 Understanding the use of stored procedures.en.srt 7.65 KB
35 Exploring Stored Procedures/003 Understanding the use of stored procedures.mp4 25.54 MB
35 Exploring Stored Procedures/004 Returning a value.en.srt 5.35 KB
35 Exploring Stored Procedures/004 Returning a value.mp4 26.31 MB
35 Exploring Stored Procedures/005 Drop a procedure.en.srt 2.77 KB
35 Exploring Stored Procedures/005 Drop a procedure.mp4 6.77 MB
36 PostgreSQL Triggers/001 Introduction to triggers.html 1.95 KB
36 PostgreSQL Triggers/002 What is a trigger.en.srt 15.50 KB
36 PostgreSQL Triggers/002 What is a trigger.mp4 46.25 MB
36 PostgreSQL Triggers/003 Types of triggers.en.srt 3.56 KB
36 PostgreSQL Triggers/003 Types of triggers.mp4 11.81 MB
36 PostgreSQL Triggers/004 Trigger table.en.srt 3.92 KB
36 PostgreSQL Triggers/004 Trigger table.mp4 11.18 MB
36 PostgreSQL Triggers/005 Pros and Cons of triggers.en.srt 16.36 KB
36 PostgreSQL Triggers/005 Pros and Cons of triggers.mp4 52.88 MB
36 PostgreSQL Triggers/006 Trigger key points.en.srt 3.99 KB
36 PostgreSQL Triggers/006 Trigger key points.mp4 10.93 MB
36 PostgreSQL Triggers/007 Steps to create a trigger.en.srt 7.38 KB
36 PostgreSQL Triggers/007 Steps to create a trigger.mp4 23.42 MB
36 PostgreSQL Triggers/008 Data auditing with a trigger.en.srt 16.34 KB
36 PostgreSQL Triggers/008 Data auditing with a trigger.mp4 45.93 MB
36 PostgreSQL Triggers/009 Bind a function to a table with trigger.en.srt 12.64 KB
36 PostgreSQL Triggers/009 Bind a function to a table with trigger.mp4 35.52 MB
36 PostgreSQL Triggers/010 Modify data at INSERT event.en.srt 16.56 KB
36 PostgreSQL Triggers/010 Modify data at INSERT event.mp4 49.46 MB
36 PostgreSQL Triggers/011 View triggers variables.en.srt 7.51 KB
36 PostgreSQL Triggers/011 View triggers variables.mp4 22.73 MB
36 PostgreSQL Triggers/012 Disallow DELETE on a table.en.srt 15.55 KB
36 PostgreSQL Triggers/012 Disallow DELETE on a table.mp4 43.37 MB
36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.en.srt 7.83 KB
36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.mp4 30.00 MB
36 PostgreSQL Triggers/014 Creating an audit trigger.en.srt 30.66 KB
36 PostgreSQL Triggers/014 Creating an audit trigger.mp4 84.59 MB
36 PostgreSQL Triggers/015 Creating conditional triggers.en.srt 20.94 KB
36 PostgreSQL Triggers/015 Creating conditional triggers.mp4 78.01 MB
36 PostgreSQL Triggers/016 Disallow data change on primary key.en.srt 8.24 KB
36 PostgreSQL Triggers/016 Disallow data change on primary key.mp4 23.30 MB
36 PostgreSQL Triggers/017 Use triggers very cautiously.en.srt 4.56 KB
36 PostgreSQL Triggers/017 Use triggers very cautiously.mp4 14.20 MB
36 PostgreSQL Triggers/018 What is an event trigger.en.srt 2.46 KB
36 PostgreSQL Triggers/018 What is an event trigger.mp4 7.48 MB
36 PostgreSQL Triggers/019 Event triggers usage scenarios.en.srt 4.19 KB
36 PostgreSQL Triggers/019 Event triggers usage scenarios.mp4 14.15 MB
36 PostgreSQL Triggers/020 Creating event triggers.en.srt 6.62 KB
36 PostgreSQL Triggers/020 Creating event triggers.mp4 20.54 MB
36 PostgreSQL Triggers/021 Event trigger events and variables.en.srt 6.47 KB
36 PostgreSQL Triggers/021 Event trigger events and variables.mp4 19.71 MB
36 PostgreSQL Triggers/022 Creating an audit event trigger.en.srt 21.56 KB
36 PostgreSQL Triggers/022 Creating an audit event trigger.mp4 75.20 MB
36 PostgreSQL Triggers/023 Prevent schema changes.en.srt 11.70 KB
36 PostgreSQL Triggers/023 Prevent schema changes.mp4 37.10 MB
36 PostgreSQL Triggers/024 Dropping a trigger.en.srt 1.33 KB
36 PostgreSQL Triggers/024 Dropping a trigger.mp4 3.93 MB
37 Using Cursors/001 Understanding row by row operations.en.srt 9.68 KB
37 Using Cursors/001 Understanding row by row operations.mp4 42.86 MB
37 Using Cursors/002 Cursors and procedural languages.en.srt 7.11 KB
37 Using Cursors/002 Cursors and procedural languages.mp4 23.43 MB
37 Using Cursors/003 Steps to create a cursor.en.srt 3.94 KB
37 Using Cursors/003 Steps to create a cursor.mp4 13.53 MB
37 Using Cursors/004 Creating a cursor.en.srt 13.02 KB
37 Using Cursors/004 Creating a cursor.mp4 35.27 MB
37 Using Cursors/005 Opening a cursor.en.srt 14.10 KB
37 Using Cursors/005 Opening a cursor.mp4 42.63 MB
37 Using Cursors/006 Using a cursor.en.srt 9.38 KB
37 Using Cursors/006 Using a cursor.mp4 37.47 MB
37 Using Cursors/007 Updating data.en.srt 2.37 KB
37 Using Cursors/007 Updating data.mp4 7.65 MB
37 Using Cursors/008 Closing a cursor.en.srt 2.09 KB
37 Using Cursors/008 Closing a cursor.mp4 5.85 MB
37 Using Cursors/009 Creating a PL_PGSQL Cursor.en.srt 14.91 KB
37 Using Cursors/009 Creating a PL_PGSQL Cursor.mp4 45.77 MB
37 Using Cursors/010 Using a parametric cursor via function.en.srt 20.00 KB
37 Using Cursors/010 Using a parametric cursor via function.mp4 92.26 MB
38 Creating Crosstab Reports/001 What is a crosstab report.en.srt 5.44 KB
38 Creating Crosstab Reports/001 What is a crosstab report.mp4 19.67 MB
38 Creating Crosstab Reports/002 Installing the tablefunc extension.en.srt 2.62 KB
38 Creating Crosstab Reports/002 Installing the tablefunc extension.mp4 7.82 MB
38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.en.srt 21.49 KB
38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.mp4 61.87 MB
38 Creating Crosstab Reports/004 Orders matters in crosstab reports.en.srt 4.71 KB
38 Creating Crosstab Reports/004 Orders matters in crosstab reports.mp4 12.47 MB
38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.en.srt 15.35 KB
38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.mp4 46.07 MB
38 Creating Crosstab Reports/006 Pivoting rows and columns.en.srt 6.24 KB
38 Creating Crosstab Reports/006 Pivoting rows and columns.mp4 21.39 MB
38 Creating Crosstab Reports/007 Matrix report via a query.en.srt 14.26 KB
38 Creating Crosstab Reports/007 Matrix report via a query.mp4 42.26 MB
38 Creating Crosstab Reports/008 Aggregate over filter.en.srt 7.60 KB
38 Creating Crosstab Reports/008 Aggregate over filter.mp4 57.54 MB
38 Creating Crosstab Reports/009 Static to dynamic pivots.en.srt 10.24 KB
38 Creating Crosstab Reports/009 Static to dynamic pivots.mp4 28.93 MB
38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.en.srt 10.31 KB
38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.mp4 40.65 MB
38 Creating Crosstab Reports/011 Dynamic pivot table columns.en.srt 24.30 KB
38 Creating Crosstab Reports/011 Dynamic pivot table columns.mp4 90.35 MB
38 Creating Crosstab Reports/012 Interactive client-side pivot.en.srt 8.86 KB
38 Creating Crosstab Reports/012 Interactive client-side pivot.mp4 77.88 MB
38 Creating Crosstab Reports/013 Handling missing values.en.srt 15.74 KB
38 Creating Crosstab Reports/013 Handling missing values.mp4 62.27 MB
38 Creating Crosstab Reports/503 rainfalldata.sql 10.93 KB
38 Creating Crosstab Reports/509 pivotcode.sql 948 B
39 Internationalization/001 Global Character Set Support.en.srt 15.37 KB
39 Internationalization/001 Global Character Set Support.mp4 57.67 MB
39 Internationalization/002 Client and Server Encoding.en.srt 16.47 KB
39 Internationalization/002 Client and Server Encoding.mp4 57.22 MB
40 PostgreSQL Transactions/001 What is a transaction_.en.srt 11.41 KB
40 PostgreSQL Transactions/001 What is a transaction_.mp4 39.79 MB
40 PostgreSQL Transactions/002 How SQL protect database during transaction.en.srt 7.81 KB
40 PostgreSQL Transactions/002 How SQL protect database during transaction.mp4 22.89 MB
40 PostgreSQL Transactions/003 ACID Database.en.srt 12.54 KB
40 PostgreSQL Transactions/003 ACID Database.mp4 38.33 MB
40 PostgreSQL Transactions/004 Transaction setup.en.srt 3.73 KB
40 PostgreSQL Transactions/004 Transaction setup.mp4 9.77 MB
40 PostgreSQL Transactions/005 Transaction analysis.en.srt 22.96 KB
40 PostgreSQL Transactions/005 Transaction analysis.mp4 56.24 MB
40 PostgreSQL Transactions/006 How to fix aborted transaction.en.srt 5.76 KB
40 PostgreSQL Transactions/006 How to fix aborted transaction.mp4 15.22 MB
40 PostgreSQL Transactions/007 How to fix transactions on crash.en.srt 8.09 KB
40 PostgreSQL Transactions/007 How to fix transactions on crash.mp4 31.78 MB
40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.en.srt 5.46 KB
40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.mp4 15.34 MB
40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.en.srt 9.12 KB
40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.mp4 23.24 MB
41 Using Northwind Database/001 Using Northwind database.en.srt 1.54 KB
41 Using Northwind Database/001 Using Northwind database.mp4 4.06 MB
41 Using Northwind Database/002 Orders shipping to USA or France.en.srt 2.69 KB
41 Using Northwind Database/002 Orders shipping to USA or France.mp4 9.18 MB
41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.en.srt 2.40 KB
41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.mp4 9.19 MB
41 Using Northwind Database/004 Orders shipped to latin america.en.srt 4.07 KB
41 Using Northwind Database/004 Orders shipped to latin america.mp4 17.08 MB
41 Using Northwind Database/005 Show total order amount for each order.mp4 18.76 MB
41 Using Northwind Database/006 First the oldest and latest order date.en.srt 2.82 KB
41 Using Northwind Database/006 First the oldest and latest order date.mp4 8.35 MB
41 Using Northwind Database/007 Total products in each categories.en.srt 5.62 KB
41 Using Northwind Database/007 Total products in each categories.mp4 15.07 MB
41 Using Northwind Database/008 List products that needs re-ordering.en.srt 4.79 KB
41 Using Northwind Database/008 List products that needs re-ordering.mp4 13.56 MB
41 Using Northwind Database/009 Freight analysis.en.srt 14.40 KB
41 Using Northwind Database/009 Freight analysis.mp4 48.28 MB
41 Using Northwind Database/010 Customers with no orders.en.srt 7.91 KB
41 Using Northwind Database/010 Customers with no orders.mp4 22.74 MB
41 Using Northwind Database/011 Top customers with total orders amount.en.srt 6.65 KB
41 Using Northwind Database/011 Top customers with total orders amount.mp4 22.61 MB
41 Using Northwind Database/012 Orders with many lines of ordered items.en.srt 4.27 KB
41 Using Northwind Database/012 Orders with many lines of ordered items.mp4 10.57 MB
41 Using Northwind Database/013 Orders with double entry line items.en.srt 15.19 KB
41 Using Northwind Database/013 Orders with double entry line items.mp4 38.28 MB
41 Using Northwind Database/014 Late shipped orders by employees.en.srt 15.90 KB
41 Using Northwind Database/014 Late shipped orders by employees.mp4 42.87 MB
41 Using Northwind Database/015 Countries with customers or suppliers.en.srt 4.21 KB
41 Using Northwind Database/015 Countries with customers or suppliers.mp4 10.25 MB
41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.en.srt 8.79 KB
41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.mp4 23.37 MB
41 Using Northwind Database/017 Customers with multiple orders.en.srt 10.33 KB
41 Using Northwind Database/017 Customers with multiple orders.mp4 33.83 MB
41 Using Northwind Database/018 First order from each country.en.srt 10.80 KB
41 Using Northwind Database/018 First order from each country.mp4 37.69 MB
42 Using Human Resource (hr) database/001 Human Resources Database Structure.en.srt 4.54 KB
42 Using Human Resource (hr) database/001 Human Resources Database Structure.mp4 12.52 MB
42 Using Human Resource (hr) database/002 Quick overview of all tables.en.srt 7.14 KB
42 Using Human Resource (hr) database/002 Quick overview of all tables.mp4 20.08 MB
42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.en.srt 4.19 KB
42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.mp4 13.70 MB
42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.en.srt 4.91 KB
42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.mp4 14.70 MB
42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.en.srt 1.60 KB
42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.mp4 5.29 MB
42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.en.srt 2.85 KB
42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.mp4 8.35 MB
42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.en.srt 2.98 KB
42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.mp4 9.98 MB
42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.en.srt 1.94 KB
42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.mp4 7.78 MB
42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.en.srt 2.72 KB
42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.mp4 9.29 MB
42 Using Human Resource (hr) database/010 Using an alias name with columns.en.srt 2.23 KB
42 Using Human Resource (hr) database/010 Using an alias name with columns.mp4 6.82 MB
42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.en.srt 3.34 KB
42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.mp4 12.25 MB
42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.en.srt 1.44 KB
42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.mp4 5.16 MB
42 Using Human Resource (hr) database/013 Discard characters from employees email address.en.srt 7.03 KB
42 Using Human Resource (hr) database/013 Discard characters from employees email address.mp4 32.13 MB
42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.en.srt 4.31 KB
42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.mp4 12.61 MB
42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.en.srt 2.48 KB
42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.mp4 7.18 MB
42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.en.srt 1.12 KB
42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.mp4 2.82 MB
42 Using Human Resource (hr) database/017 Get unique designations in employees table.en.srt 2.53 KB
42 Using Human Resource (hr) database/017 Get unique designations in employees table.mp4 8.62 MB
42 Using Human Resource (hr) database/018 Select employees with particular department id only.en.srt 3.14 KB
42 Using Human Resource (hr) database/018 Select employees with particular department id only.mp4 8.95 MB
42 Using Human Resource (hr) database/019 Select employees not in range.en.srt 4.95 KB
42 Using Human Resource (hr) database/019 Select employees not in range.mp4 13.94 MB
42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.en.srt 3.15 KB
42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.mp4 10.24 MB
42 Using Human Resource (hr) database/021 Update phone_number with your strings.en.srt 3.82 KB
42 Using Human Resource (hr) database/021 Update phone_number with your strings.mp4 11.55 MB
42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.en.srt 2.90 KB
42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.mp4 8.72 MB
42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.en.srt 2.09 KB
42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.mp4 6.72 MB
42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.en.srt 3.32 KB
42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.mp4 8.63 MB
43 Exploring Stock Markets Data/001 Introduction To stock market data.html 1.45 KB
43 Exploring Stock Markets Data/002 Select first or last records in a table.en.srt 5.11 KB
43 Exploring Stock Markets Data/002 Select first or last records in a table.mp4 24.20 MB
43 Exploring Stock Markets Data/003 Get first or last record per each group.en.srt 5.18 KB
43 Exploring Stock Markets Data/003 Get first or last record per each group.mp4 20.30 MB
43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.en.srt 2.02 KB
43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.mp4 6.85 MB
44 Managing PostgreSQL security/001 Security concepts and and levels.en.srt 6.06 KB
44 Managing PostgreSQL security/001 Security concepts and and levels.mp4 11.81 MB
44 Managing PostgreSQL security/002 Instance Level Security.en.srt 8.95 KB
44 Managing PostgreSQL security/002 Instance Level Security.mp4 22.97 MB
44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.en.srt 6.27 KB
44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.mp4 18.40 MB
44 Managing PostgreSQL security/004 Use pgAdmin to create roles.en.srt 6.07 KB
44 Managing PostgreSQL security/004 Use pgAdmin to create roles.mp4 14.03 MB
44 Managing PostgreSQL security/005 Database Level Security.en.srt 7.65 KB
44 Managing PostgreSQL security/005 Database Level Security.mp4 23.32 MB
44 Managing PostgreSQL security/006 Schema Level Security.en.srt 16.35 KB
44 Managing PostgreSQL security/006 Schema Level Security.mp4 48.85 MB
44 Managing PostgreSQL security/007 Table Level Security.en.srt 15.42 KB
44 Managing PostgreSQL security/007 Table Level Security.mp4 70.47 MB
44 Managing PostgreSQL security/008 Column Level Security.en.srt 11.76 KB
44 Managing PostgreSQL security/008 Column Level Security.mp4 34.98 MB
44 Managing PostgreSQL security/009 Row Level Security.en.srt 20.58 KB
44 Managing PostgreSQL security/009 Row Level Security.mp4 169.35 MB
44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.en.srt 8.93 KB
44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.mp4 25.54 MB
44 Managing PostgreSQL security/011 Row level policy for application users.en.srt 7.36 KB
44 Managing PostgreSQL security/011 Row level policy for application users.mp4 22.97 MB
44 Managing PostgreSQL security/012 DROP a policy.en.srt 3.14 KB
44 Managing PostgreSQL security/012 DROP a policy.mp4 10.03 MB
44 Managing PostgreSQL security/013 Inspecting permissions.en.srt 3.88 KB
44 Managing PostgreSQL security/013 Inspecting permissions.mp4 24.40 MB
44 Managing PostgreSQL security/014 Row Level Security Performance.en.srt 5.77 KB
44 Managing PostgreSQL security/014 Row Level Security Performance.mp4 20.31 MB
44 Managing PostgreSQL security/015 Encrypted data in columns.en.srt 10.91 KB
44 Managing PostgreSQL security/015 Encrypted data in columns.mp4 69.73 MB
45 PostgreSQL Utilities - psql/001 Connect to local or remote database.en.srt 5.80 KB
45 PostgreSQL Utilities - psql/001 Connect to local or remote database.mp4 15.78 MB
45 PostgreSQL Utilities - psql/002 Switch connection to a new database.en.srt 2.60 KB
45 PostgreSQL Utilities - psql/002 Switch connection to a new database.mp4 6.75 MB
45 PostgreSQL Utilities - psql/003 List all databases and tables.en.srt 4.89 KB
45 PostgreSQL Utilities - psql/003 List all databases and tables.mp4 14.41 MB
45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.en.srt 5.18 KB
45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.mp4 14.13 MB
45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.en.srt 10.65 KB
45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.mp4 83.50 MB
45 PostgreSQL Utilities - psql/006 Describe a table.en.srt 1.47 KB
45 PostgreSQL Utilities - psql/006 Describe a table.mp4 3.95 MB
45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.en.srt 1.39 KB
45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.mp4 4.98 MB
45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.en.srt 4.63 KB
45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.mp4 12.41 MB
45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.en.srt 1.30 KB
45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.mp4 4.39 MB
45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.en.srt 5.57 KB
45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.mp4 16.03 MB
45 PostgreSQL Utilities - psql/011 Make table layout funkey!.en.srt 2.70 KB
45 PostgreSQL Utilities - psql/011 Make table layout funkey!.mp4 12.10 MB
45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.en.srt 2.36 KB
45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.mp4 9.77 MB
45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.en.srt 5.57 KB
45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.mp4 16.03 MB
45 PostgreSQL Utilities - psql/014 Turn on query execution time.en.srt 3.56 KB
45 PostgreSQL Utilities - psql/014 Turn on query execution time.mp4 17.06 MB
46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.en.srt 5.98 KB
46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.mp4 17.77 MB
46 PostgreSQL Internals/002 List all database and schemas.en.srt 6.42 KB
46 PostgreSQL Internals/002 List all database and schemas.mp4 42.89 MB
46 PostgreSQL Internals/003 List all tables and views.en.srt 12.69 KB
46 PostgreSQL Internals/003 List all tables and views.mp4 39.95 MB
46 PostgreSQL Internals/004 List all columns from a table.en.srt 4.09 KB
46 PostgreSQL Internals/004 List all columns from a table.mp4 11.89 MB
46 PostgreSQL Internals/005 View system metadata via system information functions.en.srt 3.83 KB
46 PostgreSQL Internals/005 View system metadata via system information functions.mp4 11.06 MB
46 PostgreSQL Internals/006 View privileges information across tables.en.srt 11.87 KB
46 PostgreSQL Internals/006 View privileges information across tables.mp4 48.72 MB
46 PostgreSQL Internals/007 Using system Administration functions.en.srt 7.92 KB
46 PostgreSQL Internals/007 Using system Administration functions.mp4 27.82 MB
46 PostgreSQL Internals/008 Show all running queries.en.srt 6.46 KB
46 PostgreSQL Internals/008 Show all running queries.mp4 21.54 MB
46 PostgreSQL Internals/009 Terminate running and IDLE process.en.srt 3.86 KB
46 PostgreSQL Internals/009 Terminate running and IDLE process.mp4 11.94 MB
46 PostgreSQL Internals/010 How to check live and dead rows in tables.en.srt 2.25 KB
46 PostgreSQL Internals/010 How to check live and dead rows in tables.mp4 6.72 MB
46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.en.srt 13.85 KB
46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.mp4 75.89 MB
46 PostgreSQL Internals/604 internal - view system administration functions.mp4 89.29 MB
47 Managing Tables/001 Using SELECT INTO to create a new table with joins.en.srt 16.87 KB
47 Managing Tables/001 Using SELECT INTO to create a new table with joins.mp4 80.16 MB
47 Managing Tables/002 Duplicate a table with or without data.en.srt 4.07 KB
47 Managing Tables/002 Duplicate a table with or without data.mp4 13.29 MB
47 Managing Tables/003 Import data from CSV files.en.srt 10.60 KB
47 Managing Tables/003 Import data from CSV files.mp4 42.75 MB
47 Managing Tables/004 Export Data to CSV files.en.srt 3.66 KB
47 Managing Tables/004 Export Data to CSV files.mp4 30.17 MB
47 Managing Tables/005 Deleting duplicate records.en.srt 10.78 KB
47 Managing Tables/005 Deleting duplicate records.mp4 31.02 MB
47 Managing Tables/006 Backup your databases regularly.html 1.75 KB
47 Managing Tables/007 Test queries on a test database.html 1.72 KB
47 Managing Tables/008 Not documenting your process_.html 1.55 KB
47 Managing Tables/009 Database operations and table size.en.srt 8.54 KB
47 Managing Tables/009 Database operations and table size.mp4 27.86 MB
47 Managing Tables/010 Tracking table size.en.srt 11.32 KB
47 Managing Tables/010 Tracking table size.mp4 31.38 MB
47 Managing Tables/011 PostgreSQL autovacuum proces.en.srt 14.59 KB
47 Managing Tables/011 PostgreSQL autovacuum proces.mp4 57.79 MB
47 Managing Tables/012 Recovering unused space with VACUUM.en.srt 15.14 KB
47 Managing Tables/012 Recovering unused space with VACUUM.mp4 58.52 MB
47 Managing Tables/013 Generated Columns.en.srt 15.81 KB
47 Managing Tables/013 Generated Columns.mp4 55.14 MB
47 Managing Tables/611 countries_iso_codes.csv 11.45 KB
48 Extended PostgreSQL/001 Create a custom index method.en.srt 28.70 KB
48 Extended PostgreSQL/001 Create a custom index method.mp4 119.53 MB
48 Extended PostgreSQL/002 Create a user-defined aggregate function.en.srt 17.67 KB
48 Extended PostgreSQL/002 Create a user-defined aggregate function.mp4 47.15 MB
49 Thank You!/001 Your feedback is very valuable.html 1.48 KB
49 Thank You!/002 Upcoming course - Advanced Time Series Analysis.html 1.31 KB
49 Thank You!/003 Thank You!.en.srt 1.01 KB
49 Thank You!/003 Thank You!.mp4 2.41 MB
udp://open.demonii.com:1337/announce
udp://tracker.leech.ie:1337/announce
udp://transkaroo.joustasie.net:6969/announce
udp://thouvenin.cloud:6969/announce
http://tracker3.ctix.cn:8080/announce
udp://tracker.altrosky.nl:6969/announce
udp://open.free-tracker.ga:6969/announce
udp://bt2.archive.org:6969/announce
udp://9.rarbg.com:2810/announce
https://tracker.foreverpirates.co:443/announce
udp://bt1.archive.org:6969/announce
http://tracker4.itzmx.com:2710/announce
udp://run.publictracker.xyz:6969/announce
http://open.acgnxtracker.com:80/announce
udp://public.publictracker.xyz:6969/announce
udp://tracker.opentrackr.org:1337/announce
http://tracker.edkj.club:6969/announce
udp://tracker.ddunlimited.net:6969/announce
udp://tracker.dler.org:6969/announce
udp://tracker.torrent.eu.org:451/announce
http://tracker.dler.org:6969/announce
udp://keke.re:6969/announce
udp://bt.ktrackers.com:6666/announce
udp://ben.kerbertools.xyz:6969/announce
udp://bt.oiyo.tk:6969/announce
udp://tracker.srv00.com:6969/announce
https://tracker.lilithraws.org:443/announce
udp://tracker.bitsearch.to:1337/announce
http://tracker.mywaifu.best:6969/announce
udp://explodie.org:6969/announce
http://fosstorrents.com:6969/announce
http://t.acg.rip:6699/announce
http://tracker1.itzmx.com:8080/announce
http://vps02.net.orel.ru:80/announce
https://tr.abir.ga:443/announce
https://tracker.jiesen.life:8443/announce
udp://960303.xyz:6969/announce
https://tracker.nanoha.org:443/announce
udp://bubu.mapfactor.com:6969/announce
udp://moonburrow.club:6969/announce
udp://v2.iperson.xyz:6969/announce
udp://fe.dealclub.de:6969/announce
udp://torrentclub.space:6969/announce
http://tracker.nucozer-tracker.ml:2710/announce
http://1337.abcvg.info:80/announce
http://tracker.files.fm:6969/announce
udp://zecircle.xyz:6969/announce
udp://exodus.desync.com:6969/announce
udp://smtp-relay.odysseylabel.com.au:6969/announce
udp://admin.videoenpoche.info:6969/announce
udp://tracker1.bt.moack.co.kr:80/announce
udp://fh2.cmp-gaming.com:6969/announce
udp://tr.bangumi.moe:6969/announce
udp://tracker.theoks.net:6969/announce
https://xtremex.herokuapp.com:443/announce
http://tracker.openbittorrent.com:80/announce
udp://tracker.monitorit4.me:6969/announce
https://tr.abiir.top:443/announce
http://fxtt.ru:80/announce
http://bt.okmp3.ru:2710/announce
udp://qtstm32fan.ru:6969/announce
udp://uploads.gamecoast.net:6969/announce
udp://mirror.aptus.co.tz:6969/announce
udp://tracker.tiny-vps.com:6969/announce
udp://cutscloud.duckdns.org:6969/announce
udp://public.tracker.vraphim.com:6969/announce
udp://open.tracker.ink:6969/announce
udp://torrents.artixlinux.org:6969/announce
https://opentracker.i2p.rocks:443/announce
udp://tracker.jonaslsa.com:6969/announce
udp://astrr.ru:6969/announce
udp://tamas3.ynh.fr:6969/announce
http://tracker1.bt.moack.co.kr:80/announce
udp://black-bird.ynh.fr:6969/announce
http://t.overflow.biz:6969/announce
udp://movies.zsw.ca:6969/announce
http://widemus.de:6969/announce
udp://open.stealth.si:80/announce
https://tracker.kuroy.me:443/announce
http://tracker.opentrackr.org:1337/announce
udp://6ahddutb1ucc3cp.ru:6969/announce
udp://htz3.noho.st:6969/announce
udp://new-line.net:6969/announce
udp://tracker.auctor.tv:6969/announce
udp://tracker.filemail.com:6969/announce
udp://laze.cc:6969/announce
udp://tracker.moeking.me:6969/announce
udp://concen.org:6969/announce
https://tr.burnabyhighstar.com:443/announce
udp://tracker.publictracker.xyz:6969/announce
udp://tracker.openbittorrent.com:6969/announce
udp://aarsen.me:6969/announce
udp://tracker.zemoj.com:6969/announce
udp://sanincode.com:6969/announce
udp://camera.lei001.com:6969/announce
udp://vibe.sleepyinternetfun.xyz:1738/announce
udp://tracker.pomf.se:80/announce
udp://tracker.4.babico.name.tr:3131/announce
udp://tracker2.dler.org:80/announce
udp://psyco.fr:6969/announce
http://tracker2.dler.org:80/announce
udp://yahor.ftp.sh:6969/announce
udp://mts.tvbit.co:6969/announce
http://torrenttracker.nwc.acsalaska.net:6969/announce
udp://rep-art.ynh.fr:6969/announce
udp://chouchou.top:8080/announce
udp://tracker.0x.tf:6969/announce
udp://epider.me:6969/announce
udp://tracker.tcp.exchange:6969/announce
https://tracker1.520.jp:443/announce
https://tracker.expli.top:443/announce
https://1337.abcvg.info:443/announce
http://tracker3.itzmx.com:6961/announce
http://tracker.bt4g.com:2095/announce
http://incine.ru:6969/announce

TorrentBank
Copyright © 2024