TorBT - Torrents and Magnet Links Search Engine
Udemy - PostgreSQL Bootcamp Go From Beginner to Advanced, 60+hours (10.2023)
- Date: 2026-03-25
- Size: 20 GB
- Files: 1276
File Name
Size
01. Welcome/1. Course Introduction.mp4
2.1 MB
01. Welcome/1. Course Introduction.vtt
1.5 kB
01. Welcome/2. countries_iso_codes.csv
12 kB
01. Welcome/2. northwind.sql
342 kB
01. Welcome/2. Sample Data Files.html
492 B
01. Welcome/2. sample_data.zip
1.4 MB
01. Welcome/2. trades.sql
510 kB
02. Introduction to PostgreSQL/1. Installing PostgreSQL on Mac.mp4
5.3 MB
02. Introduction to PostgreSQL/1. Installing PostgreSQL on Mac.vtt
2.6 kB
02. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.mp4
26 MB
02. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.vtt
7.2 kB
02. Introduction to PostgreSQL/3. Configure pgAdmin 4 client.mp4
7.5 MB
02. Introduction to PostgreSQL/3. Configure pgAdmin 4 client.vtt
2.7 kB
02. Introduction to PostgreSQL/4. Creating a Database User.mp4
12 MB
02. Introduction to PostgreSQL/4. Creating a Database User.vtt
5.3 kB
02. Introduction to PostgreSQL/5. Creating a Database.mp4
10 MB
02. Introduction to PostgreSQL/5. Creating a Database.vtt
3.4 kB
02. Introduction to PostgreSQL/6. Running a query in pgAdmin tool.mp4
5.7 MB
02. Introduction to PostgreSQL/6. Running a query in pgAdmin tool.vtt
2.7 kB
02. Introduction to PostgreSQL/7. Install sample data files on server.mp4
10 MB
02. Introduction to PostgreSQL/7. Install sample data files on server.vtt
3.1 kB
02. Introduction to PostgreSQL/7. sample_data.zip
1.4 MB
02. Introduction to PostgreSQL/8. Install Human Resources (hr) database.mp4
8.2 MB
02. Introduction to PostgreSQL/8. Install Human Resources (hr) database.vtt
2.5 kB
02. Introduction to PostgreSQL/8. sample_data.zip
1.4 MB
02. Introduction to PostgreSQL/9. Install sample stocks market data.mp4
28 MB
02. Introduction to PostgreSQL/9. Install sample stocks market data.vtt
2.5 kB
02. Introduction to PostgreSQL/9. sample_data.zip
1.4 MB
02. Introduction to PostgreSQL/10. Install northwind database.mp4
32 MB
02. Introduction to PostgreSQL/10. Install northwind database.vtt
7.0 kB
02. Introduction to PostgreSQL/10. northwind.sql
342 kB
02. Introduction to PostgreSQL/11. Drop a database.mp4
14 MB
02. Introduction to PostgreSQL/11. Drop a database.vtt
4.5 kB
03. Creating and Modifying Tables/1. Movie Database Structure.mp4
12 MB
03. Creating and Modifying Tables/1. Movie Database Structure.vtt
4.4 kB
03. Creating and Modifying Tables/2. Creating the movie database and a actors table.mp4
20 MB
03. Creating and Modifying Tables/2. Creating the movie database and a actors table.vtt
6.7 kB
03. Creating and Modifying Tables/2. q_creating movies database and actors table.sql
186 B
03. Creating and Modifying Tables/3. Creating the directors table.mp4
14 MB
03. Creating and Modifying Tables/3. Creating the directors table.vtt
3.4 kB
03. Creating and Modifying Tables/3. q_creating the directors table.sql
227 B
03. Creating and Modifying Tables/4. Creating the movies table with a foreign key.mp4
20 MB
03. Creating and Modifying Tables/4. Creating the movies table with a foreign key.vtt
6.3 kB
03. Creating and Modifying Tables/4. q_creating the movies table with a foreign key.sql
258 B
03. Creating and Modifying Tables/5. Creating the movies_revenues table.mp4
13 MB
03. Creating and Modifying Tables/5. Creating the movies_revenues table.vtt
3.8 kB
03. Creating and Modifying Tables/5. q_creating the movies_revenues table.sql
216 B
03. Creating and Modifying Tables/6. Creating a Junction table with movies and actors tables.mp4
16 MB
03. Creating and Modifying Tables/6. Creating a Junction table with movies and actors tables.vtt
4.5 kB
03. Creating and Modifying Tables/6. q_creating a junction table with movies and actors table.sql
184 B
03. Creating and Modifying Tables/7. Install sample data for 'movies' database.mp4
41 MB
03. Creating and Modifying Tables/7. Install sample data for 'movies' database.vtt
7.0 kB
03. Creating and Modifying Tables/7. sample_data.zip
1.4 MB
03. Creating and Modifying Tables/8. 2021-04-01_15-33-06-faabd956903cfa4c427d171bb035faff.png
98 kB
03. Creating and Modifying Tables/8. 2021-04-01_15-33-22-3cc7c77c6f93d169a2ca456613da1080.png
58 kB
03. Creating and Modifying Tables/8. Create a sample Database mydata.html
1.2 kB
03. Creating and Modifying Tables/9. Using pgAdmin - Create and modify a table.mp4
21 MB
03. Creating and Modifying Tables/9. Using pgAdmin - Create and modify a table.vtt
5.7 kB
03. Creating and Modifying Tables/10. Using pgAdmin - View table structure, and create column.mp4
22 MB
03. Creating and Modifying Tables/10. Using pgAdmin - View table structure, and create column.vtt
6.5 kB
03. Creating and Modifying Tables/11. Using pgAdmin - Rename, delete and change the data type of a column.mp4
57 MB
03. Creating and Modifying Tables/11. Using pgAdmin - Rename, delete and change the data type of a column.vtt
8.0 kB
03. Creating and Modifying Tables/12. Deleting tables from a database.mp4
9.6 MB
03. Creating and Modifying Tables/12. Deleting tables from a database.vtt
3.1 kB
03. Creating and Modifying Tables/12. q_deleting tables from a database.sql
119 B
04. Modifying Data in the tables/1. Insert a data into table.mp4
18 MB
04. Modifying Data in the tables/1. Insert a data into table.vtt
5.2 kB
04. Modifying Data in the tables/1. q_insert data into table.sql
267 B
04. Modifying Data in the tables/2. Insert multiple records into a table.mp4
9.6 MB
04. Modifying Data in the tables/2. Insert multiple records into a table.vtt
3.0 kB
04. Modifying Data in the tables/2. q_insert multiple records into a table.sql
137 B
04. Modifying Data in the tables/3. Insert a data that had quotes.mp4
7.5 MB
04. Modifying Data in the tables/3. Insert a data that had quotes.vtt
2.3 kB
04. Modifying Data in the tables/3. q_insert a data that had quotes.sql
93 B
04. Modifying Data in the tables/4. q_use RETURNING to get info on added rows.sql
224 B
04. Modifying Data in the tables/4. Use RETURNING to get info on added rows.mp4
11 MB
04. Modifying Data in the tables/4. Use RETURNING to get info on added rows.vtt
3.4 kB
04. Modifying Data in the tables/5. q_update_data_in_a_table.sql
165 B
04. Modifying Data in the tables/5. Update data in a table.mp4
19 MB
04. Modifying Data in the tables/5. Update data in a table.vtt
3.6 kB
04. Modifying Data in the tables/6. q_updating_a_row_and_returning_the_updated_row.sql
102 B
04. Modifying Data in the tables/6. Updating a row and returning the updated row.mp4
11 MB
04. Modifying Data in the tables/6. Updating a row and returning the updated row.vtt
2.6 kB
04. Modifying Data in the tables/7. q_updating_all_records_in_a_table.sql
62 B
04. Modifying Data in the tables/7. Updating all records in a table.mp4
13 MB
04. Modifying Data in the tables/7. Updating all records in a table.vtt
3.6 kB
04. Modifying Data in the tables/8. Delete data from a table.mp4
13 MB
04. Modifying Data in the tables/8. Delete data from a table.vtt
3.6 kB
04. Modifying Data in the tables/8. q_delete_data_from_a_table.sql
96 B
04. Modifying Data in the tables/9. q_upsert.sql
618 B
04. Modifying Data in the tables/9. Using UPSERT.mp4
38 MB
04. Modifying Data in the tables/9. Using UPSERT.vtt
12 kB
05. Querying Data/1. Select all data from a table.mp4
39 MB
05. Querying Data/1. Select all data from a table.vtt
7.5 kB
05. Querying Data/2. Selecting specific columns from a table.mp4
16 MB
05. Querying Data/2. Selecting specific columns from a table.vtt
4.3 kB
05. Querying Data/3. Adding Aliases to columns in a table.mp4
48 MB
05. Querying Data/3. Adding Aliases to columns in a table.vtt
11 kB
05. Querying Data/4. Using SELECT statement for expressions.mp4
13 MB
05. Querying Data/4. Using SELECT statement for expressions.vtt
3.6 kB
05. Querying Data/5. Using ORDER BY to sort records.mp4
43 MB
05. Querying Data/5. Using ORDER BY to sort records.vtt
8.1 kB
05. Querying Data/6. Using ORDER BY with alias column name.mp4
14 MB
05. Querying Data/6. Using ORDER BY with alias column name.vtt
3.4 kB
05. Querying Data/7. Using ORDER BY to sort rows by expressions.mp4
16 MB
05. Querying Data/7. Using ORDER BY to sort rows by expressions.vtt
4.0 kB
05. Querying Data/8. Using ORDER BY with column name or column number.mp4
18 MB
05. Querying Data/8. Using ORDER BY with column name or column number.vtt
4.0 kB
05. Querying Data/9. Using ORDER BY with NULL values.mp4
23 MB
05. Querying Data/9. Using ORDER BY with NULL values.vtt
7.5 kB
05. Querying Data/10. Using DISTINCT for selecting distinct values.mp4
26 MB
05. Querying Data/10. Using DISTINCT for selecting distinct values.vtt
6.9 kB
06. Filtering Data/1. Comparison, Logical and Arithmetic operators.mp4
8.5 MB
06. Filtering Data/1. Comparison, Logical and Arithmetic operators.vtt
2.6 kB
06. Filtering Data/2. AND operator.mp4
62 MB
06. Filtering Data/2. AND operator.vtt
9.5 kB
06. Filtering Data/3. OR operator.mp4
16 MB
06. Filtering Data/3. OR operator.vtt
4.2 kB
06. Filtering Data/4. Combining AND, OR operators.mp4
32 MB
06. Filtering Data/4. Combining AND, OR operators.vtt
6.2 kB
06. Filtering Data/5. What goes before and after WHERE clause.mp4
14 MB
06. Filtering Data/5. What goes before and after WHERE clause.vtt
3.6 kB
06. Filtering Data/6. Execution order with AND, OR operators.mp4
9.3 MB
06. Filtering Data/6. Execution order with AND, OR operators.vtt
2.2 kB
06. Filtering Data/7. Can we use column aliases with WHERE.mp4
9.1 MB
06. Filtering Data/7. Can we use column aliases with WHERE.vtt
2.9 kB
06. Filtering Data/8. Order of execution of WHERE, SELECT and ORDER BY clauses.mp4
6.3 MB
06. Filtering Data/8. Order of execution of WHERE, SELECT and ORDER BY clauses.vtt
1.6 kB
06. Filtering Data/9. Using Logical operators.mp4
90 MB
06. Filtering Data/9. Using Logical operators.vtt
20 kB
06. Filtering Data/10. Using LIMIT and OFFSET.mp4
89 MB
06. Filtering Data/10. Using LIMIT and OFFSET.vtt
21 kB
06. Filtering Data/11. Using FETCH.mp4
84 MB
06. Filtering Data/11. Using FETCH.vtt
12 kB
06. Filtering Data/12. Using IN, NOT IN.mp4
68 MB
06. Filtering Data/12. Using IN, NOT IN.vtt
11 kB
06. Filtering Data/13. Using BETWEEN and NOT BETWEEN.mp4
51 MB
06. Filtering Data/13. Using BETWEEN and NOT BETWEEN.vtt
12 kB
06. Filtering Data/14. Using LIKE and ILIKE.mp4
88 MB
06. Filtering Data/14. Using LIKE and ILIKE.vtt
22 kB
06. Filtering Data/15. Using IS NULL and IS NOT NULL keywords.mp4
61 MB
06. Filtering Data/15. Using IS NULL and IS NOT NULL keywords.vtt
15 kB
06. Filtering Data/16. Concatenation techniques.mp4
34 MB
06. Filtering Data/16. Concatenation techniques.vtt
8.8 kB
06. Filtering Data/17. Concatenation with , CONCAT and CONCAT_WS.mp4
18 MB
06. Filtering Data/17. Concatenation with , CONCAT and CONCAT_WS.vtt
5.9 kB
07. PostgreSQL Data types/1. Boolean.mp4
54 MB
07. PostgreSQL Data types/1. Boolean.vtt
17 kB
07. PostgreSQL Data types/2. CHAR, VARCHAR and TEXT.mp4
77 MB
07. PostgreSQL Data types/2. CHAR, VARCHAR and TEXT.vtt
25 kB
07. PostgreSQL Data types/3. NUMERIC.mp4
43 MB
07. PostgreSQL Data types/3. NUMERIC.vtt
14 kB
07. PostgreSQL Data types/4. DECIMALS.mp4
42 MB
07. PostgreSQL Data types/4. DECIMALS.vtt
14 kB
07. PostgreSQL Data types/5. Selecting Numbers data types.mp4
26 MB
07. PostgreSQL Data types/5. Selecting Numbers data types.vtt
7.3 kB
07. PostgreSQL Data types/6. DateTime data types.mp4
16 MB
07. PostgreSQL Data types/6. DateTime data types.vtt
4.8 kB
07. PostgreSQL Data types/7. DATE.mp4
26 MB
07. PostgreSQL Data types/7. DATE.vtt
7.9 kB
07. PostgreSQL Data types/8. TIME.mp4
61 MB
07. PostgreSQL Data types/8. TIME.vtt
18 kB
07. PostgreSQL Data types/9. TIMESTAMP and TIMESTAMPTZ.mp4
55 MB
07. PostgreSQL Data types/9. TIMESTAMP and TIMESTAMPTZ.vtt
16 kB
07. PostgreSQL Data types/10. UUID.mp4
50 MB
07. PostgreSQL Data types/10. UUID.vtt
13 kB
07. PostgreSQL Data types/11. Array.mp4
30 MB
07. PostgreSQL Data types/11. Array.vtt
8.8 kB
07. PostgreSQL Data types/12. hstore.mp4
32 MB
07. PostgreSQL Data types/12. hstore.vtt
8.3 kB
07. PostgreSQL Data types/13. JSON.mp4
52 MB
07. PostgreSQL Data types/13. JSON.vtt
15 kB
07. PostgreSQL Data types/14. Network Addresses.mp4
62 MB
07. PostgreSQL Data types/14. Network Addresses.vtt
17 kB
08. Modifying Table Structures, Add constraints/1. Creating sample database 'mydata', adding columns.mp4
17 MB
08. Modifying Table Structures, Add constraints/1. Creating sample database 'mydata', adding columns.vtt
4.4 kB
08. Modifying Table Structures, Add constraints/2. Modify Table Structures, AddModify Columns.mp4
35 MB
08. Modifying Table Structures, Add constraints/2. Modify Table Structures, AddModify Columns.vtt
8.5 kB
08. Modifying Table Structures, Add constraints/3. Add constraints to columns.mp4
43 MB
08. Modifying Table Structures, Add constraints/3. Add constraints to columns.vtt
10 kB
09. Data type conversions/1. What is a data type conversion.mp4
31 MB
09. Data type conversions/1. What is a data type conversion.vtt
7.7 kB
09. Data type conversions/2. Using CAST for data conversions.mp4
59 MB
09. Data type conversions/2. Using CAST for data conversions.vtt
16 kB
09. Data type conversions/3. Implicit to Explicit conversions.mp4
17 MB
09. Data type conversions/3. Implicit to Explicit conversions.vtt
5.9 kB
09. Data type conversions/4. Table data conversion.mp4
30 MB
09. Data type conversions/4. Table data conversion.vtt
10 kB
10. Conversion Functions/1. to_char.mp4
44 MB
10. Conversion Functions/1. to_char.vtt
10 kB
10. Conversion Functions/2. to_number.mp4
23 MB
10. Conversion Functions/2. to_number.vtt
7.4 kB
10. Conversion Functions/3. to_date.mp4
28 MB
10. Conversion Functions/3. to_date.vtt
7.0 kB
10. Conversion Functions/4. to_timestamp.mp4
31 MB
10. Conversion Functions/4. to_timestamp.vtt
6.0 kB
11. User-defined Data Types/1. CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4
29 MB
11. User-defined Data Types/1. CREATE DOMAIN - Create a DOMAIN data type, create an address.vtt
7.5 kB
11. User-defined Data Types/2. CREATE DOMAIN - Create a data type for a positive number.mp4
8.6 MB
11. User-defined Data Types/2. CREATE DOMAIN - Create a data type for a positive number.vtt
2.3 kB
11. User-defined Data Types/3. CREATE DOMAIN - Create a postal code validation data type.mp4
11 MB
11. User-defined Data Types/3. CREATE DOMAIN - Create a postal code validation data type.vtt
3.3 kB
11. User-defined Data Types/4. CREATE DOMAIN - Create a domain data type for an email validation.mp4
14 MB
11. User-defined Data Types/4. CREATE DOMAIN - Create a domain data type for an email validation.vtt
3.6 kB
11. User-defined Data Types/5. CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4
17 MB
11. User-defined Data Types/5. CREATE DOMAIN - Create a Enum or Set of values domain data type.vtt
4.9 kB
11. User-defined Data Types/6. CREATE DOMAIN - Get the list of all DOMAIN data types.mp4
9.3 MB
11. User-defined Data Types/6. CREATE DOMAIN - Get the list of all DOMAIN data types.vtt
2.7 kB
11. User-defined Data Types/7. CREATE DOMAIN - How to drop a domain data type.mp4
21 MB
11. User-defined Data Types/7. CREATE DOMAIN - How to drop a domain data type.vtt
6.3 kB
11. User-defined Data Types/8. CREATE TYPE - Create a composite address object.mp4
27 MB
11. User-defined Data Types/8. CREATE TYPE - Create a composite address object.vtt
7.1 kB
11. User-defined Data Types/9. CREATE TYPE - Create a composite inventory_item data type.mp4
17 MB
11. User-defined Data Types/9. CREATE TYPE - Create a composite inventory_item data type.vtt
4.2 kB
11. User-defined Data Types/10. CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4
17 MB
11. User-defined Data Types/10. CREATE TYPE - Create an ENUM data type and see how to drop a data type.vtt
4.4 kB
11. User-defined Data Types/11. ALTER TYPE - Alter a composite data type, change schema and more.mp4
17 MB
11. User-defined Data Types/11. ALTER TYPE - Alter a composite data type, change schema and more.vtt
4.0 kB
11. User-defined Data Types/12. ALTER TYPE - Alter an ENUM data type.mp4
14 MB
11. User-defined Data Types/12. ALTER TYPE - Alter an ENUM data type.vtt
3.6 kB
11. User-defined Data Types/13. Update an ENUM data in production server.mp4
32 MB
11. User-defined Data Types/13. Update an ENUM data in production server.vtt
8.5 kB
11. User-defined Data Types/14. An ENUM with a DEFAULT value in a table.mp4
17 MB
11. User-defined Data Types/14. An ENUM with a DEFAULT value in a table.vtt
3.7 kB
11. User-defined Data Types/15. Create a type if not exists using a PLpgSQL function.mp4
8.1 MB
11. User-defined Data Types/15. Create a type if not exists using a PLpgSQL function.vtt
2.4 kB
12. Explore PostgreSQL Constraints/1. Introduction to constraints.mp4
18 MB
12. Explore PostgreSQL Constraints/1. Introduction to constraints.vtt
4.4 kB
12. Explore PostgreSQL Constraints/2. NOT NULL constraint.mp4
45 MB
12. Explore PostgreSQL Constraints/2. NOT NULL constraint.vtt
13 kB
12. Explore PostgreSQL Constraints/3. UNIQUE constraint.mp4
60 MB
12. Explore PostgreSQL Constraints/3. UNIQUE constraint.vtt
18 kB
12. Explore PostgreSQL Constraints/4. DEFAULT constraint.mp4
22 MB
12. Explore PostgreSQL Constraints/4. DEFAULT constraint.vtt
5.5 kB
12. Explore PostgreSQL Constraints/5. PRIMARY KEY Constraints.mp4
89 MB
12. Explore PostgreSQL Constraints/5. PRIMARY KEY Constraints.vtt
26 kB
12. Explore PostgreSQL Constraints/6. PRIMARY KEY Constraints on multiple columns.mp4
56 MB
12. Explore PostgreSQL Constraints/6. PRIMARY KEY Constraints on multiple columns.vtt
17 kB
12. Explore PostgreSQL Constraints/7. FOREIGN KEY Constraints.mp4
18 MB
12. Explore PostgreSQL Constraints/7. FOREIGN KEY Constraints.vtt
7.9 kB
12. Explore PostgreSQL Constraints/8. Tables without foreign key constraints.mp4
52 MB
12. Explore PostgreSQL Constraints/8. Tables without foreign key constraints.vtt
8.7 kB
12. Explore PostgreSQL Constraints/9. Creating foreign key constraints.mp4
32 MB
12. Explore PostgreSQL Constraints/9. Creating foreign key constraints.vtt
9.7 kB
12. Explore PostgreSQL Constraints/10. Foreign keys maintains referential data integrity.mp4
34 MB
12. Explore PostgreSQL Constraints/10. Foreign keys maintains referential data integrity.vtt
9.7 kB
12. Explore PostgreSQL Constraints/11. Drop a constraint.mp4
7.6 MB
12. Explore PostgreSQL Constraints/11. Drop a constraint.vtt
2.9 kB
12. Explore PostgreSQL Constraints/12. Add or update foreign key constraint on existing table.mp4
12 MB
12. Explore PostgreSQL Constraints/12. Add or update foreign key constraint on existing table.vtt
3.5 kB
12. Explore PostgreSQL Constraints/13. CHECK constraint - An Introduction.mp4
4.9 MB
12. Explore PostgreSQL Constraints/13. CHECK constraint - An Introduction.vtt
1.8 kB
12. Explore PostgreSQL Constraints/14. CHECK constraint - Add to new table.mp4
42 MB
12. Explore PostgreSQL Constraints/14. CHECK constraint - Add to new table.vtt
10 kB
12. Explore PostgreSQL Constraints/15. CHECK constraint - Add, Rename, Drop on existing table.mp4
40 MB
12. Explore PostgreSQL Constraints/15. CHECK constraint - Add, Rename, Drop on existing table.vtt
10 kB
13. PostgreSQL Sequences/1. Create a sequence, advance a sequence, get current value, set value.mp4
30 MB
13. PostgreSQL Sequences/1. Create a sequence, advance a sequence, get current value, set value.vtt
7.9 kB
13. PostgreSQL Sequences/2. Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4
18 MB
13. PostgreSQL Sequences/2. Restart, rename a sequence, and use pgAdmin to alter a sequence.vtt
4.6 kB
13. PostgreSQL Sequences/3. Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4
14 MB
13. PostgreSQL Sequences/3. Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.vtt
3.6 kB
13. PostgreSQL Sequences/4. Create a sequence using a specific data type.mp4
12 MB
13. PostgreSQL Sequences/4. Create a sequence using a specific data type.vtt
2.5 kB
13. PostgreSQL Sequences/5. Creating a descending sequence, and CYCLE sequence.mp4
19 MB
13. PostgreSQL Sequences/5. Creating a descending sequence, and CYCLE sequence.vtt
5.5 kB
13. PostgreSQL Sequences/6. Delete a sequence.mp4
5.6 MB
13. PostgreSQL Sequences/6. Delete a sequence.vtt
1.7 kB
13. PostgreSQL Sequences/7. Attach a sequence to a table column.mp4
36 MB
13. PostgreSQL Sequences/7. Attach a sequence to a table column.vtt
9.2 kB
13. PostgreSQL Sequences/8. List all sequences in a database.mp4
6.0 MB
13. PostgreSQL Sequences/8. List all sequences in a database.vtt
1.6 kB
13. PostgreSQL Sequences/9. Share one sequence between two tables.mp4
16 MB
13. PostgreSQL Sequences/9. Share one sequence between two tables.vtt
4.2 kB
13. PostgreSQL Sequences/10. Create an alphanumeric sequence.mp4
32 MB
13. PostgreSQL Sequences/10. Create an alphanumeric sequence.vtt
8.7 kB
14. String Functions/1. UPPER, LOWER and INITCAP.mp4
20 MB
14. String Functions/1. UPPER, LOWER and INITCAP.vtt
6.0 kB
14. String Functions/2. LEFT and RIGHT.mp4
40 MB
14. String Functions/2. LEFT and RIGHT.vtt
10 kB
14. String Functions/3. REVERSE.mp4
8.1 MB
14. String Functions/3. REVERSE.vtt
2.8 kB
14. String Functions/4. SPLIT_PART.mp4
33 MB
14. String Functions/4. SPLIT_PART.vtt
8.7 kB
14. String Functions/5. TRIM, BTRIM, LTRIM and RTRIM.mp4
27 MB
14. String Functions/5. TRIM, BTRIM, LTRIM and RTRIM.vtt
9.0 kB
14. String Functions/6. LPAD and RPAD.mp4
32 MB
14. String Functions/6. LPAD and RPAD.vtt
7.1 kB
14. String Functions/7. LENGTH.mp4
17 MB
14. String Functions/7. LENGTH.vtt
5.0 kB
14. String Functions/8. POSITION.mp4
15 MB
14. String Functions/8. POSITION.vtt
4.1 kB
14. String Functions/9. STRPOS.mp4
32 MB
14. String Functions/9. STRPOS.vtt
6.1 kB
14. String Functions/10. SUBSTRING.mp4
17 MB
14. String Functions/10. SUBSTRING.vtt
5.6 kB
14. String Functions/11. REPEAT.mp4
8.7 MB
14. String Functions/11. REPEAT.vtt
3.2 kB
14. String Functions/12. REPLACE.mp4
17 MB
14. String Functions/12. REPLACE.vtt
5.0 kB
15. Aggregate functions/1. Counting results via COUNT function.mp4
38 MB
15. Aggregate functions/1. Counting results via COUNT function.vtt
7.5 kB
15. Aggregate functions/2. COUNT(), COUNT() and COUNT(1).html
1.3 kB
15. Aggregate functions/3. Sum with SUM function.mp4
38 MB
15. Aggregate functions/3. Sum with SUM function.vtt
9.9 kB
15. Aggregate functions/4. MIN and MAX functions.mp4
68 MB
15. Aggregate functions/4. MIN and MAX functions.vtt
16 kB
15. Aggregate functions/5. GREATEST AND LEAST functions.mp4
21 MB
15. Aggregate functions/5. GREATEST AND LEAST functions.vtt
6.4 kB
15. Aggregate functions/6. GREATEST vs. MAX().html
2.0 kB
15. Aggregate functions/7. Average with AVG function.mp4
61 MB
15. Aggregate functions/7. Average with AVG function.vtt
16 kB
15. Aggregate functions/8. Combining Columns using Mathematical operators.mp4
45 MB
15. Aggregate functions/8. Combining Columns using Mathematical operators.vtt
14 kB
16. Using DATETIME functions/1. Datetimes data types.mp4
44 MB
16. Using DATETIME functions/1. Datetimes data types.vtt
12 kB
16. Using DATETIME functions/2. System Month Date settings.mp4
13 MB
16. Using DATETIME functions/2. System Month Date settings.vtt
3.8 kB
16. Using DATETIME functions/3. Time of day formats and inputs.mp4
25 MB
16. Using DATETIME functions/3. Time of day formats and inputs.vtt
7.7 kB
16. Using DATETIME functions/4. Strings to Dates conversions.mp4
61 MB
16. Using DATETIME functions/4. Strings to Dates conversions.vtt
15 kB
16. Using DATETIME functions/5. Using TO_TIMESTAMP function.mp4
44 MB
16. Using DATETIME functions/5. Using TO_TIMESTAMP function.vtt
12 kB
16. Using DATETIME functions/6. Formatting Dates.mp4
61 MB
16. Using DATETIME functions/6. Formatting Dates.vtt
14 kB
16. Using DATETIME functions/7. Date construction functions.mp4
27 MB
16. Using DATETIME functions/7. Date construction functions.vtt
7.3 kB
16. Using DATETIME functions/8. Using MAKE_INTERVAL function.mp4
37 MB
16. Using DATETIME functions/8. Using MAKE_INTERVAL function.vtt
8.7 kB
16. Using DATETIME functions/9. Using MAKE_TIMESTAMPTZ function.mp4
58 MB
16. Using DATETIME functions/9. Using MAKE_TIMESTAMPTZ function.vtt
12 kB
16. Using DATETIME functions/10. Date Value Extractors functions.mp4
36 MB
16. Using DATETIME functions/10. Date Value Extractors functions.vtt
7.8 kB
16. Using DATETIME functions/11. Using math operators with dates.mp4
47 MB
16. Using DATETIME functions/11. Using math operators with dates.vtt
12 kB
16. Using DATETIME functions/12. OVERLAPS Operator.mp4
16 MB
16. Using DATETIME functions/12. OVERLAPS Operator.vtt
5.1 kB
16. Using DATETIME functions/13. Date Time Functions.mp4
27 MB
16. Using DATETIME functions/13. Date Time Functions.vtt
6.5 kB
16. Using DATETIME functions/14. PostgreSQL Date Time Functions.vtt
5.6 kB
16. Using DATETIME functions/14. PostgreSQL Date Time Functions.mp4
19 MB
16. Using DATETIME functions/14. PostgreSQL Date Time Functions.vtt
5.4 kB
16. Using DATETIME functions/15. AGE function.mp4
14 MB
16. Using DATETIME functions/15. AGE function.vtt
4.4 kB
16. Using DATETIME functions/16. CURRENT_DATE function.mp4
4.6 MB
16. Using DATETIME functions/16. CURRENT_DATE function.vtt
1.7 kB
16. Using DATETIME functions/17. CURRENT_TIME function.mp4
19 MB
16. Using DATETIME functions/17. CURRENT_TIME function.vtt
4.3 kB
16. Using DATETIME functions/18. Date accuracy with EPOCH.mp4
39 MB
16. Using DATETIME functions/18. Date accuracy with EPOCH.vtt
8.9 kB
16. Using DATETIME functions/19. Using Date, time, timestamp in tables.mp4
44 MB
16. Using DATETIME functions/19. Using Date, time, timestamp in tables.vtt
11 kB
16. Using DATETIME functions/20. View and set timezones.mp4
15 MB
16. Using DATETIME functions/20. View and set timezones.vtt
4.6 kB
16. Using DATETIME functions/21. How to handle timezones.mp4
60 MB
16. Using DATETIME functions/21. How to handle timezones.vtt
14 kB
16. Using DATETIME functions/22. date_part function.mp4
119 MB
16. Using DATETIME functions/22. date_part function.vtt
15 kB
16. Using DATETIME functions/23. date_trunc function.mp4
48 MB
16. Using DATETIME functions/23. date_trunc function.vtt
11 kB
17. Grouping Data/1. Using GROUP BY.mp4
56 MB
17. Grouping Data/1. Using GROUP BY.vtt
14 kB
17. Grouping Data/2. Using GROUP BY with multiple columns, ORDER BY.mp4
61 MB
17. Grouping Data/2. Using GROUP BY with multiple columns, ORDER BY.vtt
18 kB
17. Grouping Data/3. Order of execution in GROUP BY clause.mp4
5.5 MB
17. Grouping Data/3. Order of execution in GROUP BY clause.vtt
1.7 kB
17. Grouping Data/4. Using HAVING.mp4
85 MB
17. Grouping Data/4. Using HAVING.vtt
14 kB
17. Grouping Data/5. Order of execution in HAVING clause.mp4
4.1 MB
17. Grouping Data/5. Order of execution in HAVING clause.vtt
1.3 kB
17. Grouping Data/6. HAVING vs WHERE.mp4
23 MB
17. Grouping Data/6. HAVING vs WHERE.vtt
6.8 kB
17. Grouping Data/7. Handling NULL values with GROUP BY.mp4
41 MB
17. Grouping Data/7. Handling NULL values with GROUP BY.vtt
13 kB
18. Joining Multiple Tables/1. INNER joins.mp4
82 MB
18. Joining Multiple Tables/1. INNER joins.vtt
25 kB
18. Joining Multiple Tables/2. INNER joins with USING.mp4
50 MB
18. Joining Multiple Tables/2. INNER joins with USING.vtt
10 kB
18. Joining Multiple Tables/3. INNER joins with filter data Part 1.mp4
57 MB
18. Joining Multiple Tables/3. INNER joins with filter data Part 1.vtt
11 kB
18. Joining Multiple Tables/4. INNER joins with filter data Part 2.mp4
22 MB
18. Joining Multiple Tables/4. INNER joins with filter data Part 2.vtt
4.0 kB
18. Joining Multiple Tables/5. INNER joins with filter data Part 3.mp4
32 MB
18. Joining Multiple Tables/5. INNER joins with filter data Part 3.vtt
5.9 kB
18. Joining Multiple Tables/6. INNER joins with different data type columns.mp4
20 MB
18. Joining Multiple Tables/6. INNER joins with different data type columns.vtt
6.1 kB
18. Joining Multiple Tables/7. LEFT joins Part 1.mp4
87 MB
18. Joining Multiple Tables/7. LEFT joins Part 1.vtt
11 kB
18. Joining Multiple Tables/8. LEFT joins Part 2.mp4
43 MB
18. Joining Multiple Tables/8. LEFT joins Part 2.vtt
8.5 kB
18. Joining Multiple Tables/9. LEFT joins Part 3.mp4
51 MB
18. Joining Multiple Tables/9. LEFT joins Part 3.vtt
10 kB
18. Joining Multiple Tables/10. LEFT joins Part 4.mp4
38 MB
18. Joining Multiple Tables/10. LEFT joins Part 4.vtt
7.2 kB
18. Joining Multiple Tables/11. RIGHT joins.mp4
54 MB
18. Joining Multiple Tables/11. RIGHT joins.vtt
13 kB
18. Joining Multiple Tables/12. RIGHT joins Part 2.mp4
15 MB
18. Joining Multiple Tables/12. RIGHT joins Part 2.vtt
4.1 kB
18. Joining Multiple Tables/13. FULL Joins.mp4
22 MB
18. Joining Multiple Tables/13. FULL Joins.vtt
6.1 kB
18. Joining Multiple Tables/14. Joining multiple tables.mp4
61 MB
18. Joining Multiple Tables/14. Joining multiple tables.vtt
10 kB
18. Joining Multiple Tables/15. Self Joins Part 1.mp4
35 MB
18. Joining Multiple Tables/15. Self Joins Part 1.vtt
10 kB
18. Joining Multiple Tables/16. Self Joins Part 2.mp4
13 MB
18. Joining Multiple Tables/16. Self Joins Part 2.vtt
4.0 kB
18. Joining Multiple Tables/17. CROSS Joins.mp4
56 MB
18. Joining Multiple Tables/17. CROSS Joins.vtt
13 kB
18. Joining Multiple Tables/18. Natural Joins Part 1.mp4
24 MB
18. Joining Multiple Tables/18. Natural Joins Part 1.vtt
7.2 kB
18. Joining Multiple Tables/19. Natural Joins Part 2.mp4
13 MB
18. Joining Multiple Tables/19. Natural Joins Part 2.vtt
2.8 kB
18. Joining Multiple Tables/20. Append tables with different columns.mp4
71 MB
18. Joining Multiple Tables/20. Append tables with different columns.vtt
16 kB
18. Joining Multiple Tables/21. ON versus WHERE.html
1.1 kB
19. Combining queries together/1. Combine results sets with UNION.mp4
54 MB
19. Combining queries together/1. Combine results sets with UNION.vtt
12 kB
19. Combining queries together/2. UNION with filters and conditions.mp4
45 MB
19. Combining queries together/2. UNION with filters and conditions.vtt
13 kB
19. Combining queries together/3. UNION tables with different number of columns.mp4
14 MB
19. Combining queries together/3. UNION tables with different number of columns.vtt
4.1 kB
19. Combining queries together/4. INTERSECT with tables.mp4
17 MB
19. Combining queries together/4. INTERSECT with tables.vtt
5.5 kB
19. Combining queries together/5. EXCEPT with tables.mp4
22 MB
19. Combining queries together/5. EXCEPT with tables.vtt
7.3 kB
20. PostgreSQL Schemas/1. What is a Schema.mp4
27 MB
20. PostgreSQL Schemas/1. What is a Schema.vtt
7.9 kB
20. PostgreSQL Schemas/2. Schema Operations (AddAlterDelete schemas).mp4
28 MB
20. PostgreSQL Schemas/2. Schema Operations (AddAlterDelete schemas).vtt
9.3 kB
20. PostgreSQL Schemas/3. Schema Hierarchy.mp4
27 MB
20. PostgreSQL Schemas/3. Schema Hierarchy.vtt
8.2 kB
20. PostgreSQL Schemas/4. Move a table to a new schema.mp4
11 MB
20. PostgreSQL Schemas/4. Move a table to a new schema.vtt
3.8 kB
20. PostgreSQL Schemas/5. Schema search path.mp4
155 MB
20. PostgreSQL Schemas/5. Schema search path.vtt
18 kB
20. PostgreSQL Schemas/6. Alter a schema ownership.mp4
8.5 MB
20. PostgreSQL Schemas/6. Alter a schema ownership.vtt
2.5 kB
20. PostgreSQL Schemas/7. Duplicate a schema along with all data.mp4
41 MB
20. PostgreSQL Schemas/7. Duplicate a schema along with all data.vtt
7.9 kB
20. PostgreSQL Schemas/8. What is a system catalog schema.mp4
26 MB
20. PostgreSQL Schemas/8. What is a system catalog schema.vtt
5.9 kB
20. PostgreSQL Schemas/9. Compare tables and columns in two schemas.mp4
47 MB
20. PostgreSQL Schemas/9. Compare tables and columns in two schemas.vtt
9.9 kB
20. PostgreSQL Schemas/10. Schemas and Privileges.mp4
36 MB
20. PostgreSQL Schemas/10. Schemas and Privileges.vtt
8.3 kB
21. Exploring array functions/1. Constructing arrays and ranges.mp4
32 MB
21. Exploring array functions/1. Constructing arrays and ranges.vtt
9.7 kB
21. Exploring array functions/2. Using comparison operators.mp4
34 MB
21. Exploring array functions/2. Using comparison operators.vtt
10 kB
21. Exploring array functions/3. Using inclusion operators.mp4
35 MB
21. Exploring array functions/3. Using inclusion operators.vtt
5.7 kB
21. Exploring array functions/4. Array constructions.mp4
21 MB
21. Exploring array functions/4. Array constructions.vtt
6.8 kB
21. Exploring array functions/5. Array metadata functions.mp4
37 MB
21. Exploring array functions/5. Array metadata functions.vtt
11 kB
21. Exploring array functions/6. Array search functions.mp4
29 MB
21. Exploring array functions/6. Array search functions.vtt
8.8 kB
21. Exploring array functions/7. Array modification functions.mp4
30 MB
21. Exploring array functions/7. Array modification functions.vtt
8.6 kB
21. Exploring array functions/8. Array comparison with IN, ALL, ANY and SOME.mp4
55 MB
21. Exploring array functions/8. Array comparison with IN, ALL, ANY and SOME.vtt
17 kB
21. Exploring array functions/9. Formatting and converting an array.mp4
37 MB
21. Exploring array functions/9. Formatting and converting an array.vtt
12 kB
21. Exploring array functions/10. Using arrays in tables.mp4
20 MB
21. Exploring array functions/10. Using arrays in tables.vtt
5.6 kB
21. Exploring array functions/11. Insert data into arrays.mp4
23 MB
21. Exploring array functions/11. Insert data into arrays.vtt
7.8 kB
21. Exploring array functions/12. Query array data.mp4
29 MB
21. Exploring array functions/12. Query array data.vtt
9.5 kB
21. Exploring array functions/13. Modifying array data.mp4
13 MB
21. Exploring array functions/13. Modifying array data.vtt
4.0 kB
21. Exploring array functions/14. Array Dimensions are ignored!.mp4
18 MB
21. Exploring array functions/14. Array Dimensions are ignored!.vtt
5.3 kB
21. Exploring array functions/15. Display all array elements.mp4
16 MB
21. Exploring array functions/15. Display all array elements.vtt
5.0 kB
21. Exploring array functions/16. Using Multi-dimensional arrays.mp4
47 MB
21. Exploring array functions/16. Using Multi-dimensional arrays.vtt
14 kB
21. Exploring array functions/17. Array vs JSONB.mp4
63 MB
21. Exploring array functions/17. Array vs JSONB.vtt
18 kB
21. Exploring array functions/18. Single and Multi-dimensional arrays.html
2.8 kB
22. JSON with PostgreSQL/1. What is JSON.mp4
21 MB
22. JSON with PostgreSQL/1. What is JSON.vtt
4.3 kB
22. JSON with PostgreSQL/2. JSON Syntax.mp4
34 MB
22. JSON with PostgreSQL/2. JSON Syntax.vtt
12 kB
22. JSON with PostgreSQL/3. JSON and JSONB data types.mp4
20 MB
22. JSON with PostgreSQL/3. JSON and JSONB data types.vtt
4.6 kB
22. JSON with PostgreSQL/4. Exploring JSON objects.mp4
27 MB
22. JSON with PostgreSQL/4. Exploring JSON objects.vtt
8.4 kB
22. JSON with PostgreSQL/5. Create our first table with JSONB data type.mp4
32 MB
22. JSON with PostgreSQL/5. Create our first table with JSONB data type.vtt
9.7 kB
22. JSON with PostgreSQL/6. Update and Delete JSON Data.mp4
53 MB
22. JSON with PostgreSQL/6. Update and Delete JSON Data.vtt
15 kB
22. JSON with PostgreSQL/7. Create JSON from tables.mp4
28 MB
22. JSON with PostgreSQL/7. Create JSON from tables.vtt
6.0 kB
22. JSON with PostgreSQL/8. Use json_agg to aggregate data.mp4
29 MB
22. JSON with PostgreSQL/8. Use json_agg to aggregate data.vtt
6.3 kB
22. JSON with PostgreSQL/9. Build a JSON array.mp4
17 MB
22. JSON with PostgreSQL/9. Build a JSON array.vtt
5.8 kB
22. JSON with PostgreSQL/10. Creating a document from data.mp4
28 MB
22. JSON with PostgreSQL/10. Creating a document from data.vtt
7.2 kB
22. JSON with PostgreSQL/11. Null Values in JSON documents.mp4
58 MB
22. JSON with PostgreSQL/11. Null Values in JSON documents.vtt
6.1 kB
22. JSON with PostgreSQL/12. JSON nulls and SQL nulls.html
708 B
22. JSON with PostgreSQL/13. Getting information from JSON documents.mp4
68 MB
22. JSON with PostgreSQL/13. Getting information from JSON documents.vtt
7.7 kB
22. JSON with PostgreSQL/14. The Existence Operator.mp4
12 MB
22. JSON with PostgreSQL/14. The Existence Operator.vtt
3.8 kB
22. JSON with PostgreSQL/15. The Containment Operator.mp4
17 MB
22. JSON with PostgreSQL/15. The Containment Operator.vtt
5.4 kB
22. JSON with PostgreSQL/16. JSON search with PostgreSQL functions.mp4
18 MB
22. JSON with PostgreSQL/16. JSON search with PostgreSQL functions.vtt
5.2 kB
22. JSON with PostgreSQL/17. Indexing on JSONB.mp4
82 MB
22. JSON with PostgreSQL/17. Indexing on JSONB.vtt
15 kB
23. Indexes and Performance Optimization/1. What is an index.mp4
18 MB
23. Indexes and Performance Optimization/1. What is an index.vtt
4.8 kB
23. Indexes and Performance Optimization/2. Create an index.mp4
78 MB
23. Indexes and Performance Optimization/2. Create an index.vtt
20 kB
23. Indexes and Performance Optimization/3. Create unique indexes.mp4
57 MB
23. Indexes and Performance Optimization/3. Create unique indexes.vtt
13 kB
23. Indexes and Performance Optimization/4. List all indexes.mp4
18 MB
23. Indexes and Performance Optimization/4. List all indexes.vtt
5.2 kB
23. Indexes and Performance Optimization/5. Size of the table index.mp4
20 MB
23. Indexes and Performance Optimization/5. Size of the table index.vtt
6.0 kB
23. Indexes and Performance Optimization/6. List counts of all indexes.mp4
20 MB
23. Indexes and Performance Optimization/6. List counts of all indexes.vtt
5.6 kB
23. Indexes and Performance Optimization/7. Drop a index.mp4
15 MB
23. Indexes and Performance Optimization/7. Drop a index.vtt
4.7 kB
23. Indexes and Performance Optimization/8. SQL Statement execution process.mp4
18 MB
23. Indexes and Performance Optimization/8. SQL Statement execution process.vtt
5.4 kB
23. Indexes and Performance Optimization/9. SQL statement execution stages.mp4
28 MB
23. Indexes and Performance Optimization/9. SQL statement execution stages.vtt
7.7 kB
23. Indexes and Performance Optimization/10. The query optimizer.mp4
35 MB
23. Indexes and Performance Optimization/10. The query optimizer.vtt
11 kB
23. Indexes and Performance Optimization/11. Optimizer node types.mp4
23 MB
23. Indexes and Performance Optimization/11. Optimizer node types.vtt
6.8 kB
23. Indexes and Performance Optimization/12. Sequential Nodes.mp4
36 MB
23. Indexes and Performance Optimization/12. Sequential Nodes.vtt
7.5 kB
23. Indexes and Performance Optimization/13. Index Nodes.mp4
42 MB
23. Indexes and Performance Optimization/13. Index Nodes.vtt
9.7 kB
23. Indexes and Performance Optimization/14. Join Nodes.mp4
37 MB
23. Indexes and Performance Optimization/14. Join Nodes.vtt
8.0 kB
23. Indexes and Performance Optimization/15. Index Types - B-Tree Index.mp4
19 MB
23. Indexes and Performance Optimization/15. Index Types - B-Tree Index.vtt
5.6 kB
23. Indexes and Performance Optimization/16. Hash Index.mp4
24 MB
23. Indexes and Performance Optimization/16. Hash Index.vtt
5.4 kB
23. Indexes and Performance Optimization/17. BRIN index.mp4
8.9 MB
23. Indexes and Performance Optimization/17. BRIN index.vtt
2.6 kB
23. Indexes and Performance Optimization/18. GIN Index.mp4
7.0 MB
23. Indexes and Performance Optimization/18. GIN Index.vtt
2.2 kB
23. Indexes and Performance Optimization/19. The EXPLAIN statement.mp4
74 MB
23. Indexes and Performance Optimization/19. The EXPLAIN statement.vtt
19 kB
23. Indexes and Performance Optimization/20. EXPLAIN output options.mp4
12 MB
23. Indexes and Performance Optimization/20. EXPLAIN output options.vtt
3.6 kB
23. Indexes and Performance Optimization/21. Using EXPLAIN ANALYZE.mp4
39 MB
23. Indexes and Performance Optimization/21. Using EXPLAIN ANALYZE.vtt
12 kB
23. Indexes and Performance Optimization/22. Understanding query cost model.mp4
57 MB
23. Indexes and Performance Optimization/22. Understanding query cost model.vtt
16 kB
23. Indexes and Performance Optimization/23. Index are not free.mp4
58 MB
23. Indexes and Performance Optimization/23. Index are not free.vtt
15 kB
23. Indexes and Performance Optimization/24. Indexes for sorted output.mp4
36 MB
23. Indexes and Performance Optimization/24. Indexes for sorted output.vtt
11 kB
23. Indexes and Performance Optimization/25. Using multiple indexes on a single query.mp4
32 MB
23. Indexes and Performance Optimization/25. Using multiple indexes on a single query.vtt
10 kB
23. Indexes and Performance Optimization/26. Execution plans depends on input values.mp4
28 MB
23. Indexes and Performance Optimization/26. Execution plans depends on input values.vtt
8.3 kB
23. Indexes and Performance Optimization/27. Using organized vs random data.mp4
99 MB
23. Indexes and Performance Optimization/27. Using organized vs random data.vtt
24 kB
23. Indexes and Performance Optimization/28. Try to use index only scan.mp4
16 MB
23. Indexes and Performance Optimization/28. Try to use index only scan.vtt
5.2 kB
23. Indexes and Performance Optimization/29. Partial indexes.mp4
56 MB
23. Indexes and Performance Optimization/29. Partial indexes.vtt
13 kB
23. Indexes and Performance Optimization/30. Expression Index.mp4
120 MB
23. Indexes and Performance Optimization/30. Expression Index.vtt
19 kB
23. Indexes and Performance Optimization/31. Adding data while indexing.mp4
12 MB
23. Indexes and Performance Optimization/31. Adding data while indexing.vtt
3.9 kB
23. Indexes and Performance Optimization/32. Invalidating an index.mp4
99 MB
23. Indexes and Performance Optimization/32. Invalidating an index.vtt
10 kB
23. Indexes and Performance Optimization/33. Rebuilding an index.mp4
29 MB
23. Indexes and Performance Optimization/33. Rebuilding an index.vtt
9.0 kB
24. All about Views/1. Introduction to views.mp4
34 MB
24. All about Views/1. Introduction to views.vtt
8.8 kB
24. All about Views/2. Creating a view.mp4
54 MB
24. All about Views/2. Creating a view.vtt
13 kB
24. All about Views/3. Rename a view.mp4
18 MB
24. All about Views/3. Rename a view.vtt
5.3 kB
24. All about Views/4. Delete a view.mp4
6.8 MB
24. All about Views/4. Delete a view.vtt
2.5 kB
24. All about Views/5. Using filters with views.mp4
41 MB
24. All about Views/5. Using filters with views.vtt
8.7 kB
24. All about Views/6. A view with UNION of multiple tables.mp4
23 MB
24. All about Views/6. A view with UNION of multiple tables.vtt
5.4 kB
24. All about Views/7. Connecting multiple tables with a single view.mp4
42 MB
24. All about Views/7. Connecting multiple tables with a single view.vtt
8.9 kB
24. All about Views/8. Re-arrange columns in a view.mp4
12 MB
24. All about Views/8. Re-arrange columns in a view.vtt
4.2 kB
24. All about Views/9. Delete a column in a view.mp4
7.2 MB
24. All about Views/9. Delete a column in a view.vtt
2.6 kB
24. All about Views/10. Add a column in a view.mp4
8.7 MB
24. All about Views/10. Add a column in a view.vtt
3.2 kB
24. All about Views/11. Regular views are dynamic.mp4
14 MB
24. All about Views/11. Regular views are dynamic.vtt
3.5 kB
24. All about Views/12. What is an updatable view.mp4
16 MB
24. All about Views/12. What is an updatable view.vtt
4.6 kB
24. All about Views/13. An updatable view with CRUD operations.mp4
29 MB
24. All about Views/13. An updatable view with CRUD operations.vtt
6.8 kB
24. All about Views/14. Updatable views using WITH CHECK OPTION.mp4
42 MB
24. All about Views/14. Updatable views using WITH CHECK OPTION.vtt
9.9 kB
24. All about Views/15. Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4
40 MB
24. All about Views/15. Updatable views using WITH LOCAL and CASCADED CHECK OPTION.vtt
11 kB
24. All about Views/16. What is a Materialized View.mp4
44 MB
24. All about Views/16. What is a Materialized View.vtt
12 kB
24. All about Views/17. Creating a materialized view.mp4
19 MB
24. All about Views/17. Creating a materialized view.vtt
5.8 kB
24. All about Views/18. Drop a materialized view.mp4
16 MB
24. All about Views/18. Drop a materialized view.vtt
4.0 kB
24. All about Views/19. Changing materialized view data.mp4
55 MB
24. All about Views/19. Changing materialized view data.vtt
7.8 kB
24. All about Views/20. How to check if a materialized view is populated or not.mp4
12 MB
24. All about Views/20. How to check if a materialized view is populated or not.vtt
3.2 kB
24. All about Views/21. Refreshing data in materialize views.mp4
38 MB
24. All about Views/21. Refreshing data in materialize views.vtt
7.6 kB
24. All about Views/22. Why not use a table instead of materialized view.mp4
18 MB
24. All about Views/22. Why not use a table instead of materialized view.vtt
5.6 kB
24. All about Views/23. The downsides of using materialized views.mp4
16 MB
24. All about Views/23. The downsides of using materialized views.vtt
3.8 kB
24. All about Views/24. Using materialized view for websites page analysis.mp4
64 MB
24. All about Views/24. Using materialized view for websites page analysis.vtt
14 kB
24. All about Views/25. List all materialized views by a SELECT statement.mp4
5.9 MB
24. All about Views/25. List all materialized views by a SELECT statement.vtt
2.0 kB
24. All about Views/26. List materialized views with no unique index.mp4
17 MB
24. All about Views/26. List materialized views with no unique index.vtt
5.0 kB
24. All about Views/27. Quick queries for materialized views.html
771 B
25. Fun with subqueries/1. Introduction to subqueries.html
1.9 kB
25. Fun with subqueries/2. Subqueries with WHERE Clause.mp4
66 MB
25. Fun with subqueries/2. Subqueries with WHERE Clause.vtt
15 kB
25. Fun with subqueries/3. Subquery with IN operator.mp4
20 MB
25. Fun with subqueries/3. Subquery with IN operator.vtt
5.7 kB
25. Fun with subqueries/4. Subquery with JOINs.mp4
47 MB
25. Fun with subqueries/4. Subquery with JOINs.vtt
10 kB
25. Fun with subqueries/5. Get total revenues for all 'English' films.html
970 B
25. Fun with subqueries/6. Order entries in UNION without using ORDER BY.mp4
17 MB
25. Fun with subqueries/6. Order entries in UNION without using ORDER BY.vtt
5.3 kB
25. Fun with subqueries/7. Subquery with an alias.mp4
6.9 MB
25. Fun with subqueries/7. Subquery with an alias.vtt
1.8 kB
25. Fun with subqueries/8. A SELECT without a FROM.mp4
10 MB
25. Fun with subqueries/8. A SELECT without a FROM.vtt
3.1 kB
25. Fun with subqueries/9. Correlated Queries.mp4
52 MB
25. Fun with subqueries/9. Correlated Queries.vtt
16 kB
25. Fun with subqueries/10. SELECT.. IN (Subquery).mp4
39 MB
25. Fun with subqueries/10. SELECT.. IN (Subquery).vtt
8.5 kB
25. Fun with subqueries/11. Using ANY with subquery.mp4
40 MB
25. Fun with subqueries/11. Using ANY with subquery.vtt
9.3 kB
25. Fun with subqueries/12. Using ALL with subquery.mp4
47 MB
25. Fun with subqueries/12. Using ALL with subquery.vtt
9.8 kB
25. Fun with subqueries/13. Subquery using EXISTS.mp4
20 MB
25. Fun with subqueries/13. Subquery using EXISTS.vtt
5.8 kB
26. Common Table Expressions (CTE)/1. Introduction to CTEs.mp4
25 MB
26. Common Table Expressions (CTE)/1. Introduction to CTEs.vtt
6.9 kB
26. Common Table Expressions (CTE)/2. CTE query examples.mp4
73 MB
26. Common Table Expressions (CTE)/2. CTE query examples.vtt
20 kB
26. Common Table Expressions (CTE)/3. Combine CTE with a table.mp4
36 MB
26. Common Table Expressions (CTE)/3. Combine CTE with a table.vtt
8.6 kB
26. Common Table Expressions (CTE)/4. Get the total revenues for each director.html
732 B
26. Common Table Expressions (CTE)/5. Simultaneously DELETE INSERT via CTE.mp4
32 MB
26. Common Table Expressions (CTE)/5. Simultaneously DELETE INSERT via CTE.vtt
9.4 kB
26. Common Table Expressions (CTE)/6. Recursive CTEs.mp4
19 MB
26. Common Table Expressions (CTE)/6. Recursive CTEs.vtt
6.2 kB
26. Common Table Expressions (CTE)/7. Parent-child relationship via recursive CTE.mp4
74 MB
26. Common Table Expressions (CTE)/7. Parent-child relationship via recursive CTE.vtt
26 kB
27. Grouping sets/1. Introduction to summarization.mp4
16 MB
27. Grouping sets/1. Introduction to summarization.vtt
4.1 kB
27. Grouping sets/2. Subtotals on group sets.mp4
114 MB
27. Grouping sets/2. Subtotals on group sets.vtt
15 kB
27. Grouping sets/3. Adding subtotal with ROLLUP.mp4
32 MB
27. Grouping sets/3. Adding subtotal with ROLLUP.vtt
9.5 kB
27. Grouping sets/4. Using GROUPING with ROLLUP.mp4
112 MB
27. Grouping sets/4. Using GROUPING with ROLLUP.vtt
18 kB
28. Window Functions/1. Introduction to Window Functions.mp4
6.2 MB
28. Window Functions/1. Introduction to Window Functions.vtt
4.5 kB
28. Window Functions/2. Analyze Global Trades Data.mp4
97 MB
28. Window Functions/2. Analyze Global Trades Data.vtt
9.8 kB
28. Window Functions/2. trades.sql
510 kB
28. Window Functions/3. Using aggregate functions.mp4
48 MB
28. Window Functions/3. Using aggregate functions.vtt
10 kB
28. Window Functions/4. GROUP BY ROLLUP.mp4
22 MB
28. Window Functions/4. GROUP BY ROLLUP.vtt
6.8 kB
28. Window Functions/5. ROLLUP - Grouping multiple columns.mp4
17 MB
28. Window Functions/5. ROLLUP - Grouping multiple columns.vtt
4.9 kB
28. Window Functions/6. GROUP BY CUBE.mp4
20 MB
28. Window Functions/6. GROUP BY CUBE.vtt
6.3 kB
28. Window Functions/7. GROUP BY GROUPING SETS.mp4
19 MB
28. Window Functions/7. GROUP BY GROUPING SETS.vtt
4.7 kB
28. Window Functions/8. Query performance check.mp4
22 MB
28. Window Functions/8. Query performance check.vtt
6.2 kB
28. Window Functions/9. Using FILTER clause.mp4
22 MB
28. Window Functions/9. Using FILTER clause.vtt
6.5 kB
28. Window Functions/10. Using Window Functions.mp4
21 MB
28. Window Functions/10. Using Window Functions.vtt
6.3 kB
28. Window Functions/11. Partitioning the data.mp4
28 MB
28. Window Functions/11. Partitioning the data.vtt
5.7 kB
28. Window Functions/12. Set data into millions format.mp4
11 MB
28. Window Functions/12. Set data into millions format.vtt
3.3 kB
28. Window Functions/13. Ordering inside window.mp4
79 MB
28. Window Functions/13. Ordering inside window.vtt
9.9 kB
28. Window Functions/14. Sliding dynamic windows.mp4
32 MB
28. Window Functions/14. Sliding dynamic windows.vtt
9.6 kB
28. Window Functions/15. Understanding window frames.mp4
185 MB
28. Window Functions/15. Understanding window frames.vtt
29 kB
28. Window Functions/16. ROWS and RANGE indicators.mp4
61 MB
28. Window Functions/16. ROWS and RANGE indicators.vtt
14 kB
28. Window Functions/17. Using WINDOW.mp4
36 MB
28. Window Functions/17. Using WINDOW.vtt
11 kB
28. Window Functions/18. Using WINDOW with ROWS BETWEEN.mp4
18 MB
28. Window Functions/18. Using WINDOW with ROWS BETWEEN.vtt
4.5 kB
28. Window Functions/19. RANK and DENSE_RANK functions.mp4
21 MB
28. Window Functions/19. RANK and DENSE_RANK functions.vtt
6.4 kB
28. Window Functions/20. NTILE function.mp4
38 MB
28. Window Functions/20. NTILE function.vtt
12 kB
28. Window Functions/21. LEAD and LAG functions.mp4
73 MB
28. Window Functions/21. LEAD and LAG functions.vtt
19 kB
28. Window Functions/22. FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4
78 MB
28. Window Functions/22. FIRST_VALUE, LAST_VALUE and NTH_value functions.vtt
20 kB
28. Window Functions/23. ROW_NUMBER function.mp4
54 MB
28. Window Functions/23. ROW_NUMBER function.vtt
12 kB
28. Window Functions/24. Finding Correlations.mp4
23 MB
28. Window Functions/24. Finding Correlations.vtt
7.4 kB
28. Window Functions/25. ROW_NUMBER() - Window with Partition datasets.mp4
44 MB
28. Window Functions/25. ROW_NUMBER() - Window with Partition datasets.vtt
12 kB
28. Window Functions/26. ROW_NUMBER() - Reverse fields with order by.mp4
14 MB
28. Window Functions/26. ROW_NUMBER() - Reverse fields with order by.vtt
2.9 kB
28. Window Functions/27. ROW_NUMBER() - Find Nth record.mp4
15 MB
28. Window Functions/27. ROW_NUMBER() - Find Nth record.vtt
4.4 kB
28. Window Functions/28. ROW_NUMBER() - Find DISTINCT with subquery.mp4
27 MB
28. Window Functions/28. ROW_NUMBER() - Find DISTINCT with subquery.vtt
6.4 kB
28. Window Functions/29. ROW_NUMBER() - Pagination technique.mp4
35 MB
28. Window Functions/29. ROW_NUMBER() - Pagination technique.vtt
7.7 kB
28. Window Functions/30. Using OVER() to calculate percentage.mp4
25 MB
28. Window Functions/30. Using OVER() to calculate percentage.vtt
7.6 kB
28. Window Functions/31. Calculate difference compared to average.mp4
25 MB
28. Window Functions/31. Calculate difference compared to average.vtt
7.2 kB
28. Window Functions/32. Calculating cumulative totals.mp4
21 MB
28. Window Functions/32. Calculating cumulative totals.vtt
6.8 kB
28. Window Functions/33. Using LEAD to compare with next values.mp4
21 MB
28. Window Functions/33. Using LEAD to compare with next values.vtt
7.3 kB
28. Window Functions/34. Comparing with least number.mp4
47 MB
28. Window Functions/34. Comparing with least number.vtt
11 kB
28. Window Functions/35. Window Function Summary.mp4
16 MB
28. Window Functions/35. Window Function Summary.vtt
6.0 kB
28. Window Functions/36. Planning tips on using Window Functions.mp4
17 MB
28. Window Functions/36. Planning tips on using Window Functions.vtt
8.6 kB
28. Window Functions/37. Difference between RANK and DENSE_RANK.mp4
12 MB
28. Window Functions/37. Difference between RANK and DENSE_RANK.vtt
3.6 kB
28. Window Functions/38. Getting RANK to compute group and global ranks.mp4
21 MB
28. Window Functions/38. Getting RANK to compute group and global ranks.vtt
6.0 kB
28. Window Functions/39. Using PARTITION BY for group averages.mp4
27 MB
28. Window Functions/39. Using PARTITION BY for group averages.vtt
7.1 kB
28. Window Functions/40. Using WITH clause to create your own data.mp4
14 MB
28. Window Functions/40. Using WITH clause to create your own data.vtt
4.9 kB
28. Window Functions/41. Using WITH clause to set ORDER BY values.mp4
25 MB
28. Window Functions/41. Using WITH clause to set ORDER BY values.vtt
8.6 kB
28. Window Functions/42. DELETE and INSERT in one query using WITH.mp4
23 MB
28. Window Functions/42. DELETE and INSERT in one query using WITH.vtt
6.1 kB
29. Using regular expressions for text patterns/1. Text to structured data.mp4
24 MB
29. Using regular expressions for text patterns/1. Text to structured data.vtt
7.8 kB
29. Using regular expressions for text patterns/2. Regular expressions notations table.mp4
37 MB
29. Using regular expressions for text patterns/2. Regular expressions notations table.vtt
12 kB
29. Using regular expressions for text patterns/3. SIMILAR TO operator.mp4
29 MB
29. Using regular expressions for text patterns/3. SIMILAR TO operator.vtt
8.7 kB
29. Using regular expressions for text patterns/4. POSIX regular expressions.mp4
22 MB
29. Using regular expressions for text patterns/4. POSIX regular expressions.vtt
6.7 kB
29. Using regular expressions for text patterns/5. SUBSTRING with regular expressions.mp4
196 MB
29. Using regular expressions for text patterns/5. SUBSTRING with regular expressions.vtt
24 kB
29. Using regular expressions for text patterns/6. REGEXP_MATCHES Function.mp4
40 MB
29. Using regular expressions for text patterns/6. REGEXP_MATCHES Function.vtt
13 kB
29. Using regular expressions for text patterns/7. REGEXP_REPLACE Function.mp4
31 MB
29. Using regular expressions for text patterns/7. REGEXP_REPLACE Function.vtt
11 kB
29. Using regular expressions for text patterns/8. REGEXP_SPLIT_TO_TABLE Function.mp4
5.7 MB
29. Using regular expressions for text patterns/8. REGEXP_SPLIT_TO_TABLE Function.vtt
1.9 kB
29. Using regular expressions for text patterns/9. REGEXP_SPLIT_TO_ARRAY function.mp4
13 MB
29. Using regular expressions for text patterns/9. REGEXP_SPLIT_TO_ARRAY function.vtt
3.6 kB
30. Powerful text searches in PostgreSQL/1. The Good Ol' Text Search.mp4
44 MB
30. Powerful text searches in PostgreSQL/1. The Good Ol' Text Search.vtt
11 kB
30. Powerful text searches in PostgreSQL/2. Introducing tsvector.mp4
52 MB
30. Powerful text searches in PostgreSQL/2. Introducing tsvector.vtt
15 kB
30. Powerful text searches in PostgreSQL/3. Using tsquery with operators.mp4
150 MB
30. Powerful text searches in PostgreSQL/3. Using tsquery with operators.vtt
19 kB
30. Powerful text searches in PostgreSQL/4. Full text search within a table.mp4
63 MB
30. Powerful text searches in PostgreSQL/4. Full text search within a table.vtt
18 kB
30. Powerful text searches in PostgreSQL/5. president_speeches.csv
1.1 MB
30. Powerful text searches in PostgreSQL/5. Setup presidents speeches data.mp4
46 MB
30. Powerful text searches in PostgreSQL/5. Setup presidents speeches data.vtt
8.4 kB
30. Powerful text searches in PostgreSQL/6. Analyzing presidents speeches text data.mp4
43 MB
30. Powerful text searches in PostgreSQL/6. Analyzing presidents speeches text data.vtt
10 kB
30. Powerful text searches in PostgreSQL/7. Ranking and Normalizing text results.mp4
24 MB
30. Powerful text searches in PostgreSQL/7. Ranking and Normalizing text results.vtt
6.5 kB
31. Table Partitions/1. What is a partition.mp4
27 MB
31. Table Partitions/1. What is a partition.vtt
6.8 kB
31. Table Partitions/2. When a partition can be used.mp4
86 MB
31. Table Partitions/2. When a partition can be used.vtt
21 kB
31. Table Partitions/3. Table inheritance.mp4
66 MB
31. Table Partitions/3. Table inheritance.vtt
21 kB
31. Table Partitions/4. Partition types.mp4
12 MB
31. Table Partitions/4. Partition types.vtt
3.2 kB
31. Table Partitions/5. Partition by Range.mp4
102 MB
31. Table Partitions/5. Partition by Range.vtt
26 kB
31. Table Partitions/6. Partition by List.mp4
130 MB
31. Table Partitions/6. Partition by List.vtt
32 kB
31. Table Partitions/7. Partition by Hash.mp4
63 MB
31. Table Partitions/7. Partition by Hash.vtt
19 kB
31. Table Partitions/8. DEFAULT Partition.mp4
33 MB
31. Table Partitions/8. DEFAULT Partition.vtt
8.3 kB
31. Table Partitions/9. Multi-level partitioning.mp4
62 MB
31. Table Partitions/9. Multi-level partitioning.vtt
18 kB
31. Table Partitions/10. Partition maintenance.mp4
27 MB
31. Table Partitions/10. Partition maintenance.vtt
5.9 kB
31. Table Partitions/11. ALTERing the partition bounds.mp4
38 MB
31. Table Partitions/11. ALTERing the partition bounds.vtt
11 kB
31. Table Partitions/12. Partition Indexes.mp4
32 MB
31. Table Partitions/12. Partition Indexes.vtt
9.2 kB
31. Table Partitions/13. Partition pruning.mp4
18 MB
31. Table Partitions/13. Partition pruning.vtt
4.8 kB
31. Table Partitions/14. Determining a field for partition over.mp4
32 MB
31. Table Partitions/14. Determining a field for partition over.vtt
10 kB
31. Table Partitions/15. Sizing the partition.mp4
23 MB
31. Table Partitions/15. Sizing the partition.vtt
7.9 kB
31. Table Partitions/16. Partitioning Advantages.mp4
22 MB
31. Table Partitions/16. Partitioning Advantages.vtt
6.0 kB
31. Table Partitions/17. Common partitioning mistakes.mp4
22 MB
31. Table Partitions/17. Common partitioning mistakes.vtt
6.1 kB
32. Server Programming/1. PostgreSQL as a development platform.mp4
42 MB
32. Server Programming/1. PostgreSQL as a development platform.vtt
12 kB
32. Server Programming/2. Procedural languages.mp4
22 MB
32. Server Programming/2. Procedural languages.vtt
5.8 kB
32. Server Programming/3. Keep the data on the server!.mp4
27 MB
32. Server Programming/3. Keep the data on the server!.vtt
7.7 kB
32. Server Programming/4. Functions vs stored procedures.mp4
17 MB
32. Server Programming/4. Functions vs stored procedures.vtt
5.3 kB
32. Server Programming/5. User-defined functions.mp4
16 MB
32. Server Programming/5. User-defined functions.vtt
4.0 kB
32. Server Programming/6. Structure of a function.mp4
12 MB
32. Server Programming/6. Structure of a function.vtt
3.3 kB
33. Functions with SQL language/1. Creating our first SQL function.mp4
50 MB
33. Functions with SQL language/1. Creating our first SQL function.vtt
13 kB
33. Functions with SQL language/2. Introducing dollar quoting.mp4
16 MB
33. Functions with SQL language/2. Introducing dollar quoting.vtt
4.7 kB
33. Functions with SQL language/3. Function returning no values.mp4
22 MB
33. Functions with SQL language/3. Function returning no values.vtt
6.3 kB
33. Functions with SQL language/4. Function returning a single value.mp4
50 MB
33. Functions with SQL language/4. Function returning a single value.vtt
15 kB
33. Functions with SQL language/5. Function returning a single value Part 2.mp4
29 MB
33. Functions with SQL language/5. Function returning a single value Part 2.vtt
6.4 kB
33. Functions with SQL language/6. Function returning a single value Part 3.mp4
26 MB
33. Functions with SQL language/6. Function returning a single value Part 3.vtt
4.0 kB
33. Functions with SQL language/7. Function using parameters.mp4
75 MB
33. Functions with SQL language/7. Function using parameters.vtt
16 kB
33. Functions with SQL language/8. Function using parameters Part 2.mp4
28 MB
33. Functions with SQL language/8. Function using parameters Part 2.vtt
6.3 kB
33. Functions with SQL language/9. Function using parameters Part 3.mp4
133 MB
33. Functions with SQL language/9. Function using parameters Part 3.vtt
17 kB
33. Functions with SQL language/10. Function using parameters Part 4.mp4
80 MB
33. Functions with SQL language/10. Function using parameters Part 4.vtt
16 kB
33. Functions with SQL language/11. Function returning a composite.mp4
68 MB
33. Functions with SQL language/11. Function returning a composite.vtt
15 kB
33. Functions with SQL language/12. Function returning multiple rows.mp4
55 MB
33. Functions with SQL language/12. Function returning multiple rows.vtt
11 kB
33. Functions with SQL language/13. Function returning a table.mp4
15 MB
33. Functions with SQL language/13. Function returning a table.vtt
3.5 kB
33. Functions with SQL language/14. Function - order matters!.mp4
17 MB
33. Functions with SQL language/14. Function - order matters!.vtt
3.7 kB
33. Functions with SQL language/15. Function as a table source.mp4
55 MB
33. Functions with SQL language/15. Function as a table source.vtt
12 kB
33. Functions with SQL language/16. Function parameter modes.mp4
17 MB
33. Functions with SQL language/16. Function parameter modes.vtt
3.7 kB
33. Functions with SQL language/17. Function parameters with default values.mp4
45 MB
33. Functions with SQL language/17. Function parameters with default values.vtt
14 kB
33. Functions with SQL language/18. Function based on views.mp4
33 MB
33. Functions with SQL language/18. Function based on views.vtt
7.9 kB
33. Functions with SQL language/19. Drop a function.mp4
18 MB
33. Functions with SQL language/19. Drop a function.vtt
6.0 kB
34. Functions with PLpgSQL language/1. Introduction to PLpgSQL language.mp4
8.2 MB
34. Functions with PLpgSQL language/1. Introduction to PLpgSQL language.vtt
2.5 kB
34. Functions with PLpgSQL language/2. PLpgSQL vs SQL.mp4
11 MB
34. Functions with PLpgSQL language/2. PLpgSQL vs SQL.vtt
3.0 kB
34. Functions with PLpgSQL language/3. Structure of a PLpgSQL function.mp4
19 MB
34. Functions with PLpgSQL language/3. Structure of a PLpgSQL function.vtt
6.2 kB
34. Functions with PLpgSQL language/4. PLpgSQL block structure.mp4
10 MB
34. Functions with PLpgSQL language/4. PLpgSQL block structure.vtt
2.8 kB
34. Functions with PLpgSQL language/5. Declaring variables.mp4
23 MB
34. Functions with PLpgSQL language/5. Declaring variables.vtt
7.6 kB
34. Functions with PLpgSQL language/6. Declaring variables via ALIAS FOR.mp4
6.4 MB
34. Functions with PLpgSQL language/6. Declaring variables via ALIAS FOR.vtt
1.9 kB
34. Functions with PLpgSQL language/7. Declaring variables in function.mp4
21 MB
34. Functions with PLpgSQL language/7. Declaring variables in function.vtt
6.4 kB
34. Functions with PLpgSQL language/8. q_variable_initialization_timing.sql
192 B
34. Functions with PLpgSQL language/8. Variable initializing timing.mp4
8.8 MB
34. Functions with PLpgSQL language/8. Variable initializing timing.vtt
2.9 kB
34. Functions with PLpgSQL language/9. Copying data types.mp4
12 MB
34. Functions with PLpgSQL language/9. Copying data types.vtt
3.5 kB
34. Functions with PLpgSQL language/10. Assigning variables from query.mp4
40 MB
34. Functions with PLpgSQL language/10. Assigning variables from query.vtt
11 kB
34. Functions with PLpgSQL language/11. Using IN, OUT without RETURNS.mp4
18 MB
34. Functions with PLpgSQL language/11. Using IN, OUT without RETURNS.vtt
5.7 kB
34. Functions with PLpgSQL language/12. Variables in block and subblock.mp4
19 MB
34. Functions with PLpgSQL language/12. Variables in block and subblock.vtt
6.1 kB
34. Functions with PLpgSQL language/13. How to return query results.mp4
32 MB
34. Functions with PLpgSQL language/13. How to return query results.vtt
5.8 kB
34. Functions with PLpgSQL language/14. Control Structures - IF statement.mp4
33 MB
34. Functions with PLpgSQL language/14. Control Structures - IF statement.vtt
9.9 kB
34. Functions with PLpgSQL language/15. Using IF with table data.mp4
34 MB
34. Functions with PLpgSQL language/15. Using IF with table data.vtt
6.7 kB
34. Functions with PLpgSQL language/16. CASE Statement.mp4
61 MB
34. Functions with PLpgSQL language/16. CASE Statement.vtt
14 kB
34. Functions with PLpgSQL language/17. Searched CASE statement.mp4
46 MB
34. Functions with PLpgSQL language/17. Searched CASE statement.vtt
14 kB
34. Functions with PLpgSQL language/18. LOOP statement.mp4
23 MB
34. Functions with PLpgSQL language/18. LOOP statement.vtt
7.6 kB
34. Functions with PLpgSQL language/19. FOR Loops.mp4
23 MB
34. Functions with PLpgSQL language/19. FOR Loops.vtt
7.6 kB
34. Functions with PLpgSQL language/20. FOR Loops iterate over result set.mp4
23 MB
34. Functions with PLpgSQL language/20. FOR Loops iterate over result set.vtt
5.8 kB
34. Functions with PLpgSQL language/21. CONTINUE statement.mp4
20 MB
34. Functions with PLpgSQL language/21. CONTINUE statement.vtt
6.6 kB
34. Functions with PLpgSQL language/22. FOREACH loop with arrays.mp4
15 MB
34. Functions with PLpgSQL language/22. FOREACH loop with arrays.vtt
5.1 kB
34. Functions with PLpgSQL language/23. WHILE loop.mp4
52 MB
34. Functions with PLpgSQL language/23. WHILE loop.vtt
15 kB
34. Functions with PLpgSQL language/24. Using RETURN QUERY.mp4
57 MB
34. Functions with PLpgSQL language/24. Using RETURN QUERY.vtt
13 kB
34. Functions with PLpgSQL language/25. Returning a table.mp4
17 MB
34. Functions with PLpgSQL language/25. Returning a table.vtt
5.2 kB
34. Functions with PLpgSQL language/26. Using RETURN NEXT.mp4
70 MB
34. Functions with PLpgSQL language/26. Using RETURN NEXT.vtt
17 kB
34. Functions with PLpgSQL language/27. Error and exception handling.mp4
24 MB
34. Functions with PLpgSQL language/27. Error and exception handling.vtt
6.9 kB
34. Functions with PLpgSQL language/28. Exception - Too many rows.mp4
23 MB
34. Functions with PLpgSQL language/28. Exception - Too many rows.vtt
6.7 kB
34. Functions with PLpgSQL language/29. Using SQLSTATE codes for exception handling.mp4
24 MB
34. Functions with PLpgSQL language/29. Using SQLSTATE codes for exception handling.vtt
5.1 kB
34. Functions with PLpgSQL language/30. Exception with data exception errors.mp4
68 MB
34. Functions with PLpgSQL language/30. Exception with data exception errors.vtt
8.7 kB
35. Exploring Stored Procedures/1. Functions vs Stored Procedures.mp4
25 MB
35. Exploring Stored Procedures/1. Functions vs Stored Procedures.vtt
7.2 kB
35. Exploring Stored Procedures/2. Create a transactions.mp4
34 MB
35. Exploring Stored Procedures/2. Create a transactions.vtt
9.8 kB
35. Exploring Stored Procedures/3. Understanding the use of stored procedures.mp4
26 MB
35. Exploring Stored Procedures/3. Understanding the use of stored procedures.vtt
6.4 kB
35. Exploring Stored Procedures/4. Returning a value.mp4
26 MB
35. Exploring Stored Procedures/4. Returning a value.vtt
4.7 kB
35. Exploring Stored Procedures/5. Drop a procedure.mp4
6.7 MB
35. Exploring Stored Procedures/5. Drop a procedure.vtt
2.5 kB
36. PostgreSQL Triggers/1. Introduction to triggers.html
1.1 kB
36. PostgreSQL Triggers/2. What is a trigger.mp4
46 MB
36. PostgreSQL Triggers/2. What is a trigger.vtt
14 kB
36. PostgreSQL Triggers/3. Types of triggers.mp4
12 MB
36. PostgreSQL Triggers/3. Types of triggers.vtt
3.1 kB
36. PostgreSQL Triggers/4. Trigger table.mp4
11 MB
36. PostgreSQL Triggers/4. Trigger table.vtt
3.5 kB
36. PostgreSQL Triggers/5. Pros and Cons of triggers.mp4
53 MB
36. PostgreSQL Triggers/5. Pros and Cons of triggers.vtt
14 kB
36. PostgreSQL Triggers/6. Trigger key points.mp4
11 MB
36. PostgreSQL Triggers/6. Trigger key points.vtt
3.5 kB
36. PostgreSQL Triggers/7. Steps to create a trigger.mp4
23 MB
36. PostgreSQL Triggers/7. Steps to create a trigger.vtt
6.7 kB
36. PostgreSQL Triggers/8. Data auditing with a trigger.mp4
46 MB
36. PostgreSQL Triggers/8. Data auditing with a trigger.vtt
14 kB
36. PostgreSQL Triggers/9. Bind a function to a table with trigger.mp4
35 MB
36. PostgreSQL Triggers/9. Bind a function to a table with trigger.vtt
11 kB
36. PostgreSQL Triggers/10. Modify data at INSERT event.mp4
49 MB
36. PostgreSQL Triggers/10. Modify data at INSERT event.vtt
15 kB
36. PostgreSQL Triggers/11. View triggers variables.mp4
23 MB
36. PostgreSQL Triggers/11. View triggers variables.vtt
6.3 kB
36. PostgreSQL Triggers/12. Disallow DELETE on a table.mp4
43 MB
36. PostgreSQL Triggers/12. Disallow DELETE on a table.vtt
13 kB
36. PostgreSQL Triggers/13. Disallow TRUNCATE on a table.mp4
30 MB
36. PostgreSQL Triggers/13. Disallow TRUNCATE on a table.vtt
6.9 kB
36. PostgreSQL Triggers/14. Creating an audit trigger.mp4
84 MB
36. PostgreSQL Triggers/14. Creating an audit trigger.vtt
26 kB
36. PostgreSQL Triggers/15. Creating conditional triggers.mp4
78 MB
36. PostgreSQL Triggers/15. Creating conditional triggers.vtt
19 kB
36. PostgreSQL Triggers/16. Disallow data change on primary key.mp4
23 MB
36. PostgreSQL Triggers/16. Disallow data change on primary key.vtt
7.3 kB
36. PostgreSQL Triggers/17. Use triggers very cautiously.mp4
14 MB
36. PostgreSQL Triggers/17. Use triggers very cautiously.vtt
4.0 kB
36. PostgreSQL Triggers/18. What is an event trigger.mp4
7.5 MB
36. PostgreSQL Triggers/18. What is an event trigger.vtt
2.1 kB
36. PostgreSQL Triggers/19. Event triggers usage scenarios.mp4
14 MB
36. PostgreSQL Triggers/19. Event triggers usage scenarios.vtt
3.7 kB
36. PostgreSQL Triggers/20. Creating event triggers.mp4
20 MB
36. PostgreSQL Triggers/20. Creating event triggers.vtt
5.7 kB
36. PostgreSQL Triggers/21. Event trigger events and variables.mp4
20 MB
36. PostgreSQL Triggers/21. Event trigger events and variables.vtt
5.4 kB
36. PostgreSQL Triggers/22. Creating an audit event trigger.mp4
75 MB
36. PostgreSQL Triggers/22. Creating an audit event trigger.vtt
18 kB
36. PostgreSQL Triggers/23. Prevent schema changes.mp4
37 MB
36. PostgreSQL Triggers/23. Prevent schema changes.vtt
10 kB
36. PostgreSQL Triggers/24. Dropping a trigger.mp4
3.9 MB
36. PostgreSQL Triggers/24. Dropping a trigger.vtt
1.2 kB
37. Using Cursors/1. Understanding row by row operations.mp4
43 MB
37. Using Cursors/1. Understanding row by row operations.vtt
8.5 kB
37. Using Cursors/2. Cursors and procedural languages.mp4
23 MB
37. Using Cursors/2. Cursors and procedural languages.vtt
6.2 kB
37. Using Cursors/3. Steps to create a cursor.mp4
14 MB
37. Using Cursors/3. Steps to create a cursor.vtt
3.4 kB
37. Using Cursors/4. Creating a cursor.mp4
35 MB
37. Using Cursors/4. Creating a cursor.vtt
11 kB
37. Using Cursors/5. Opening a cursor.mp4
42 MB
37. Using Cursors/5. Opening a cursor.vtt
12 kB
37. Using Cursors/6. Using a cursor.mp4
37 MB
37. Using Cursors/6. Using a cursor.vtt
8.3 kB
37. Using Cursors/7. Updating data.mp4
7.6 MB
37. Using Cursors/7. Updating data.vtt
2.1 kB
37. Using Cursors/8. Closing a cursor.mp4
5.8 MB
37. Using Cursors/8. Closing a cursor.vtt
1.8 kB
37. Using Cursors/9. Creating a PLPGSQL Cursor.mp4
46 MB
37. Using Cursors/9. Creating a PLPGSQL Cursor.vtt
13 kB
37. Using Cursors/10. Using a parametric cursor via function.mp4
92 MB
37. Using Cursors/10. Using a parametric cursor via function.vtt
17 kB
38. Creating Crosstab Reports/1. What is a crosstab report.mp4
20 MB
38. Creating Crosstab Reports/1. What is a crosstab report.vtt
4.9 kB
38. Creating Crosstab Reports/2. Installing the tablefunc extension.mp4
7.8 MB
38. Creating Crosstab Reports/2. Installing the tablefunc extension.vtt
2.2 kB
38. Creating Crosstab Reports/3. Creating a crosstab report - Student Rankings.mp4
62 MB
38. Creating Crosstab Reports/3. Creating a crosstab report - Student Rankings.vtt
18 kB
38. Creating Crosstab Reports/4. Orders matters in crosstab reports.mp4
12 MB
38. Creating Crosstab Reports/4. Orders matters in crosstab reports.vtt
4.0 kB
38. Creating Crosstab Reports/5. Pivoting with Rainfalls data.mp4
46 MB
38. Creating Crosstab Reports/5. Pivoting with Rainfalls data.vtt
13 kB
38. Creating Crosstab Reports/5. rainfalldata.sql
11 kB
38. Creating Crosstab Reports/6. Pivoting rows and columns.mp4
21 MB
38. Creating Crosstab Reports/6. Pivoting rows and columns.vtt
5.3 kB
38. Creating Crosstab Reports/7. Matrix report via a query.mp4
42 MB
38. Creating Crosstab Reports/7. Matrix report via a query.vtt
12 kB
38. Creating Crosstab Reports/8. Aggregate over filter.mp4
58 MB
38. Creating Crosstab Reports/8. Aggregate over filter.vtt
6.3 kB
38. Creating Crosstab Reports/9. Static to dynamic pivots.mp4
29 MB
38. Creating Crosstab Reports/9. Static to dynamic pivots.vtt
8.7 kB
38. Creating Crosstab Reports/10. Dynamic pivot query via JSON.mp4
41 MB
38. Creating Crosstab Reports/10. Dynamic pivot query via JSON.vtt
8.6 kB
38. Creating Crosstab Reports/11. Dynamic pivot table columns.mp4
90 MB
38. Creating Crosstab Reports/11. Dynamic pivot table columns.vtt
20 kB
38. Creating Crosstab Reports/11. pivotcode.sql
948 B
38. Creating Crosstab Reports/12. Interactive client-side pivot.mp4
78 MB
38. Creating Crosstab Reports/12. Interactive client-side pivot.vtt
7.8 kB
38. Creating Crosstab Reports/13. Handling missing values.mp4
62 MB
38. Creating Crosstab Reports/13. Handling missing values.vtt
13 kB
39. Internationalization/1. Global Character Set Support.mp4
58 MB
39. Internationalization/1. Global Character Set Support.vtt
13 kB
39. Internationalization/2. Client and Server Encoding.mp4
57 MB
39. Internationalization/2. Client and Server Encoding.vtt
14 kB
40. PostgreSQL Transactions/1. What is a transaction.mp4
40 MB
40. PostgreSQL Transactions/1. What is a transaction.vtt
9.8 kB
40. PostgreSQL Transactions/2. How SQL protect database during transaction.mp4
23 MB
40. PostgreSQL Transactions/2. How SQL protect database during transaction.vtt
6.8 kB
40. PostgreSQL Transactions/3. ACID Database.mp4
38 MB
40. PostgreSQL Transactions/3. ACID Database.vtt
11 kB
40. PostgreSQL Transactions/4. Transaction setup.mp4
9.7 MB
40. PostgreSQL Transactions/4. Transaction setup.vtt
3.2 kB
40. PostgreSQL Transactions/5. Transaction analysis.mp4
56 MB
40. PostgreSQL Transactions/5. Transaction analysis.vtt
20 kB
40. PostgreSQL Transactions/6. How to fix aborted transaction.mp4
15 MB
40. PostgreSQL Transactions/6. How to fix aborted transaction.vtt
5.0 kB
40. PostgreSQL Transactions/7. How to fix transactions on crash.mp4
32 MB
40. PostgreSQL Transactions/7. How to fix transactions on crash.vtt
7.2 kB
40. PostgreSQL Transactions/8. Partial transaction rollback with savepoints.mp4
15 MB
40. PostgreSQL Transactions/8. Partial transaction rollback with savepoints.vtt
4.6 kB
40. PostgreSQL Transactions/9. Using SAVEPOINT with transaction.mp4
23 MB
40. PostgreSQL Transactions/9. Using SAVEPOINT with transaction.vtt
7.9 kB
41. Using Northwind Database/1. Using Northwind database.mp4
4.0 MB
41. Using Northwind Database/1. Using Northwind database.vtt
1.4 kB
41. Using Northwind Database/2. Orders shipping to USA or France.mp4
9.1 MB
41. Using Northwind Database/2. Orders shipping to USA or France.vtt
2.3 kB
41. Using Northwind Database/3. Total numbers of orders shipped to USA or France.mp4
9.2 MB
41. Using Northwind Database/3. Total numbers of orders shipped to USA or France.vtt
2.0 kB
41. Using Northwind Database/4. Orders shipped to latin america.mp4
17 MB
41. Using Northwind Database/4. Orders shipped to latin america.vtt
3.9 kB
41. Using Northwind Database/5. Show total order amount for each order.mp4
19 MB
41. Using Northwind Database/5. Show total order amount for each order.vtt
4.9 kB
41. Using Northwind Database/6. First the oldest and latest order date.mp4
8.3 MB
41. Using Northwind Database/6. First the oldest and latest order date.vtt
2.4 kB
41. Using Northwind Database/7. Total products in each categories.mp4
15 MB
41. Using Northwind Database/7. Total products in each categories.vtt
4.9 kB
41. Using Northwind Database/8. List products that needs re-ordering.mp4
14 MB
41. Using Northwind Database/8. List products that needs re-ordering.vtt
4.1 kB
41. Using Northwind Database/9. Freight analysis.mp4
48 MB
41. Using Northwind Database/9. Freight analysis.vtt
12 kB
41. Using Northwind Database/10. Customers with no orders.mp4
23 MB
41. Using Northwind Database/10. Customers with no orders.vtt
7.1 kB
41. Using Northwind Database/11. Top customers with total orders amount.mp4
22 MB
41. Using Northwind Database/11. Top customers with total orders amount.vtt
5.6 kB
41. Using Northwind Database/12. Orders with many lines of ordered items.mp4
10 MB
41. Using Northwind Database/12. Orders with many lines of ordered items.vtt
3.4 kB
41. Using Northwind Database/13. Orders with double entry line items.mp4
38 MB
41. Using Northwind Database/13. Orders with double entry line items.vtt
13 kB
41. Using Northwind Database/14. Late shipped orders by employees.mp4
43 MB
41. Using Northwind Database/14. Late shipped orders by employees.vtt
14 kB
41. Using Northwind Database/15. Countries with customers or suppliers.mp4
10 MB
41. Using Northwind Database/15. Countries with customers or suppliers.vtt
3.8 kB
41. Using Northwind Database/16. Countries with customers or suppliers - Using CTE.mp4
23 MB
41. Using Northwind Database/16. Countries with customers or suppliers - Using CTE.vtt
7.8 kB
41. Using Northwind Database/17. Customers with multiple orders.mp4
34 MB
41. Using Northwind Database/17. Customers with multiple orders.vtt
9.0 kB
41. Using Northwind Database/18. First order from each country.mp4
38 MB
41. Using Northwind Database/18. First order from each country.vtt
9.4 kB
42. Using Human Resource (hr) database/1. Human Resources Database Structure.mp4
12 MB
42. Using Human Resource (hr) database/1. Human Resources Database Structure.vtt
4.0 kB
42. Using Human Resource (hr) database/2. Quick overview of all tables.mp4
20 MB
42. Using Human Resource (hr) database/2. Quick overview of all tables.vtt
6.5 kB
42. Using Human Resource (hr) database/3. Quick overview of all tables Part 2.mp4
14 MB
42. Using Human Resource (hr) database/3. Quick overview of all tables Part 2.vtt
3.8 kB
42. Using Human Resource (hr) database/4. Get highest, lowest, total, and average salaries of employees.mp4
15 MB
42. Using Human Resource (hr) database/4. Get highest, lowest, total, and average salaries of employees.vtt
4.2 kB
42. Using Human Resource (hr) database/5. Difference bw highest and lowest salaries by job_id.mp4
5.3 MB
42. Using Human Resource (hr) database/5. Difference bw highest and lowest salaries by job_id.vtt
1.4 kB
42. Using Human Resource (hr) database/6. Get lowest paid salaries by each manager.mp4
8.3 MB
42. Using Human Resource (hr) database/6. Get lowest paid salaries by each manager.vtt
2.3 kB
42. Using Human Resource (hr) database/7. Average salary for each department with more than 10 employees.mp4
9.9 MB
42. Using Human Resource (hr) database/7. Average salary for each department with more than 10 employees.vtt
2.6 kB
42. Using Human Resource (hr) database/8. Average salary for each post excluding programmer.mp4
7.8 MB
42. Using Human Resource (hr) database/8. Average salary for each post excluding programmer.vtt
1.7 kB
42. Using Human Resource (hr) database/9. Maximum salary for each post where salary is at or above $5000.mp4
9.3 MB
42. Using Human Resource (hr) database/9. Maximum salary for each post where salary is at or above $5000.vtt
2.3 kB
42. Using Human Resource (hr) database/10. Using an alias name with columns.mp4
6.8 MB
42. Using Human Resource (hr) database/10. Using an alias name with columns.vtt
1.9 kB
42. Using Human Resource (hr) database/11. Compute 15% of salary for all employees.mp4
12 MB
42. Using Human Resource (hr) database/11. Compute 15% of salary for all employees.vtt
2.7 kB
42. Using Human Resource (hr) database/12. To list all employees IDs within each job_id group.mp4
5.1 MB
42. Using Human Resource (hr) database/12. To list all employees IDs within each job_id group.vtt
1.1 kB
42. Using Human Resource (hr) database/13. Discard characters from employees email address.mp4
32 MB
42. Using Human Resource (hr) database/13. Discard characters from employees email address.vtt
6.1 kB
42. Using Human Resource (hr) database/14. List all employees with first_name starts with letters A, C or M.mp4
13 MB
42. Using Human Resource (hr) database/14. List all employees with first_name starts with letters A, C or M.vtt
3.6 kB
42. Using Human Resource (hr) database/15. String manipulation with upper, lower and initcap functions.mp4
7.1 MB
42. Using Human Resource (hr) database/15. String manipulation with upper, lower and initcap functions.vtt
2.2 kB
42. Using Human Resource (hr) database/16. Using SUBSTRING to get portion of string data.mp4
2.8 MB
42. Using Human Resource (hr) database/16. Using SUBSTRING to get portion of string data.vtt
1013 B
42. Using Human Resource (hr) database/17. Get unique designations in employees table.mp4
8.6 MB
42. Using Human Resource (hr) database/17. Get unique designations in employees table.vtt
2.1 kB
42. Using Human Resource (hr) database/18. Select employees with particular department id only.mp4
8.9 MB
42. Using Human Resource (hr) database/18. Select employees with particular department id only.vtt
2.7 kB
42. Using Human Resource (hr) database/19. Select employees not in range.mp4
14 MB
42. Using Human Resource (hr) database/19. Select employees not in range.vtt
3.9 kB
42. Using Human Resource (hr) database/20. Find Letter C in last_name at 3rd or greater position.mp4
10 MB
42. Using Human Resource (hr) database/20. Find Letter C in last_name at 3rd or greater position.vtt
2.8 kB
42. Using Human Resource (hr) database/21. Update phone_number with your strings.mp4
12 MB
42. Using Human Resource (hr) database/21. Update phone_number with your strings.vtt
3.5 kB
42. Using Human Resource (hr) database/22. Get the monthly salary of each employees.mp4
8.7 MB
42. Using Human Resource (hr) database/22. Get the monthly salary of each employees.vtt
2.6 kB
42. Using Human Resource (hr) database/23. Calculate average salary with total number of employees.mp4
6.7 MB
42. Using Human Resource (hr) database/23. Calculate average salary with total number of employees.vtt
1.8 kB
42. Using Human Resource (hr) database/24. find employees whose names contains exactly six characters.mp4
8.6 MB
42. Using Human Resource (hr) database/24. find employees whose names contains exactly six characters.vtt
2.9 kB
43. Exploring Stock Markets Data/1. Introduction To stock market data.html
612 B
43. Exploring Stock Markets Data/2. Select first or last records in a table.mp4
24 MB
43. Exploring Stock Markets Data/2. Select first or last records in a table.vtt
4.3 kB
43. Exploring Stock Markets Data/3. Get first or last record per each group.mp4
20 MB
43. Exploring Stock Markets Data/3. Get first or last record per each group.vtt
4.2 kB
43. Exploring Stock Markets Data/4. How to calculate cube root in PostgreSQL.mp4
6.8 MB
43. Exploring Stock Markets Data/4. How to calculate cube root in PostgreSQL.vtt
1.7 kB
44. Managing PostgreSQL security/1. Security concepts and and levels.mp4
12 MB
44. Managing PostgreSQL security/1. Security concepts and and levels.vtt
5.2 kB
44. Managing PostgreSQL security/2. Instance Level Security.mp4
23 MB
44. Managing PostgreSQL security/2. Instance Level Security.vtt
7.6 kB
44. Managing PostgreSQL security/3. Instance Level Security - Add users to roles.mp4
18 MB
44. Managing PostgreSQL security/3. Instance Level Security - Add users to roles.vtt
5.5 kB
44. Managing PostgreSQL security/4. Use pgAdmin to create roles.mp4
14 MB
44. Managing PostgreSQL security/4. Use pgAdmin to create roles.vtt
5.2 kB
44. Managing PostgreSQL security/5. Database Level Security.mp4
23 MB
44. Managing PostgreSQL security/5. Database Level Security.vtt
6.5 kB
44. Managing PostgreSQL security/6. Schema Level Security.mp4
49 MB
44. Managing PostgreSQL security/6. Schema Level Security.vtt
14 kB
44. Managing PostgreSQL security/7. Table Level Security.mp4
70 MB
44. Managing PostgreSQL security/7. Table Level Security.vtt
13 kB
44. Managing PostgreSQL security/8. Column Level Security.mp4
35 MB
44. Managing PostgreSQL security/8. Column Level Security.vtt
10 kB
44. Managing PostgreSQL security/9. Row Level Security.mp4
169 MB
44. Managing PostgreSQL security/9. Row Level Security.vtt
18 kB
44. Managing PostgreSQL security/10. Using CURRENT_USER with RLS.mp4
26 MB
44. Managing PostgreSQL security/10. Using CURRENT_USER with RLS.vtt
7.7 kB
44. Managing PostgreSQL security/11. Row level policy for application users.mp4
23 MB
44. Managing PostgreSQL security/11. Row level policy for application users.vtt
6.0 kB
44. Managing PostgreSQL security/12. DROP a policy.mp4
10 MB
44. Managing PostgreSQL security/12. DROP a policy.vtt
2.8 kB
44. Managing PostgreSQL security/13. Inspecting permissions.mp4
24 MB
44. Managing PostgreSQL security/13. Inspecting permissions.vtt
3.4 kB
44. Managing PostgreSQL security/14. Row Level Security Performance.mp4
20 MB
44. Managing PostgreSQL security/14. Row Level Security Performance.vtt
5.0 kB
44. Managing PostgreSQL security/15. Encrypted data in columns.mp4
70 MB
44. Managing PostgreSQL security/15. Encrypted data in columns.vtt
9.5 kB
45. PostgreSQL Utilities - psql/1. Connect to local or remote database.mp4
16 MB
45. PostgreSQL Utilities - psql/1. Connect to local or remote database.vtt
5.0 kB
45. PostgreSQL Utilities - psql/2. Switch connection to a new database.mp4
6.7 MB
45. PostgreSQL Utilities - psql/2. Switch connection to a new database.vtt
2.2 kB
45. PostgreSQL Utilities - psql/3. List all databases and tables.mp4
14 MB
45. PostgreSQL Utilities - psql/3. List all databases and tables.vtt
4.3 kB
45. PostgreSQL Utilities - psql/4. List all table space, schemas, and indices.mp4
14 MB
45. PostgreSQL Utilities - psql/4. List all table space, schemas, and indices.vtt
4.3 kB
45. PostgreSQL Utilities - psql/5. List all sequences, roles, data types, domain data types.mp4
83 MB
45. PostgreSQL Utilities - psql/5. List all sequences, roles, data types, domain data types.vtt
9.0 kB
45. PostgreSQL Utilities - psql/6. Describe a table.mp4
3.9 MB
45. PostgreSQL Utilities - psql/6. Describe a table.vtt
1.3 kB
45. PostgreSQL Utilities - psql/7. Edit SQL commands in editor.mp4
5.0 MB
45. PostgreSQL Utilities - psql/7. Edit SQL commands in editor.vtt
1.4 kB
45. PostgreSQL Utilities - psql/8. Display command history, run commands from a file.mp4
12 MB
45. PostgreSQL Utilities - psql/8. Display command history, run commands from a file.vtt
3.8 kB
45. PostgreSQL Utilities - psql/9. Built-in syntax reference for commands.mp4
4.4 MB
45. PostgreSQL Utilities - psql/9. Built-in syntax reference for commands.vtt
1.2 kB
45. PostgreSQL Utilities - psql/10. Represent NULL values on psql terminal.mp4
16 MB
45. PostgreSQL Utilities - psql/10. Represent NULL values on psql terminal.vtt
4.7 kB
45. PostgreSQL Utilities - psql/11. Make table layout funkey!.mp4
12 MB
45. PostgreSQL Utilities - psql/11. Make table layout funkey!.vtt
2.4 kB
45. PostgreSQL Utilities - psql/12. Repeatedly Execute a Query.mp4
9.8 MB
45. PostgreSQL Utilities - psql/12. Repeatedly Execute a Query.vtt
2.0 kB
45. PostgreSQL Utilities - psql/13. Represent NULL Visibly.mp4
16 MB
45. PostgreSQL Utilities - psql/13. Represent NULL Visibly.vtt
4.7 kB
45. PostgreSQL Utilities - psql/14. Turn on query execution time.mp4
17 MB
45. PostgreSQL Utilities - psql/14. Turn on query execution time.vtt
3.1 kB
46. PostgreSQL Internals/1. List database users, and database sizes with and without indexes.mp4
18 MB
46. PostgreSQL Internals/1. List database users, and database sizes with and without indexes.vtt
5.1 kB
46. PostgreSQL Internals/2. List all database and schemas.mp4
43 MB
46. PostgreSQL Internals/2. List all database and schemas.vtt
5.7 kB
46. PostgreSQL Internals/3. List all tables and views.mp4
40 MB
46. PostgreSQL Internals/3. List all tables and views.vtt
11 kB
46. PostgreSQL Internals/4. List all columns from a table.mp4
12 MB
46. PostgreSQL Internals/4. List all columns from a table.vtt
3.4 kB
46. PostgreSQL Internals/5. View system metadata via system information functions.mp4
11 MB
46. PostgreSQL Internals/5. View system metadata via system information functions.vtt
3.2 kB
46. PostgreSQL Internals/6. View privileges information across tables.mp4
49 MB
46. PostgreSQL Internals/6. View privileges information across tables.vtt
10 kB
46. PostgreSQL Internals/7. internal - view system administration functions.mp4
89 MB
46. PostgreSQL Internals/7. internal - view system administration functions.vtt
6.6 kB
46. PostgreSQL Internals/7. Using system Administration functions.mp4
28 MB
46. PostgreSQL Internals/7. Using system Administration functions.vtt
6.7 kB
46. PostgreSQL Internals/8. Show all running queries.mp4
22 MB
46. PostgreSQL Internals/8. Show all running queries.vtt
5.3 kB
46. PostgreSQL Internals/9. Terminate running and IDLE process.mp4
12 MB
46. PostgreSQL Internals/9. Terminate running and IDLE process.vtt
3.3 kB
46. PostgreSQL Internals/10. How to check live and dead rows in tables.mp4
6.7 MB
46. PostgreSQL Internals/10. How to check live and dead rows in tables.vtt
2.0 kB
46. PostgreSQL Internals/11. File layout of PostgreSQL Tables.mp4
76 MB
46. PostgreSQL Internals/11. File layout of PostgreSQL Tables.vtt
12 kB
47. Managing Tables/1. Using SELECT INTO to create a new table with joins.mp4
81 MB
47. Managing Tables/1. Using SELECT INTO to create a new table with joins.vtt
14 kB
47. Managing Tables/2. Duplicate a table with or without data.mp4
13 MB
47. Managing Tables/2. Duplicate a table with or without data.vtt
3.6 kB
47. Managing Tables/3. countries_iso_codes.csv
12 kB
47. Managing Tables/3. Import data from CSV files.mp4
43 MB
47. Managing Tables/3. Import data from CSV files.vtt
9.0 kB
47. Managing Tables/4. Export Data to CSV files.mp4
30 MB
47. Managing Tables/4. Export Data to CSV files.vtt
3.1 kB
47. Managing Tables/5. Deleting duplicate records.mp4
31 MB
47. Managing Tables/5. Deleting duplicate records.vtt
9.3 kB
47. Managing Tables/6. Backup your databases regularly.html
929 B
47. Managing Tables/7. Test queries on a test database.html
893 B
47. Managing Tables/8. Not documenting your process.html
720 B
47. Managing Tables/9. Database operations and table size.mp4
28 MB
47. Managing Tables/9. Database operations and table size.vtt
7.1 kB
47. Managing Tables/10. Tracking table size.mp4
31 MB
47. Managing Tables/10. Tracking table size.vtt
9.6 kB
47. Managing Tables/11. PostgreSQL autovacuum proces.mp4
58 MB
47. Managing Tables/11. PostgreSQL autovacuum proces.vtt
13 kB
47. Managing Tables/12. Recovering unused space with VACUUM.mp4
58 MB
47. Managing Tables/12. Recovering unused space with VACUUM.vtt
13 kB
47. Managing Tables/13. Generated Columns.mp4
55 MB
47. Managing Tables/13. Generated Columns.vtt
14 kB
48. Extended PostgreSQL/1. Create a custom index method.mp4
119 MB
48. Extended PostgreSQL/1. Create a custom index method.vtt
25 kB
48. Extended PostgreSQL/2. Create a user-defined aggregate function.mp4
47 MB
48. Extended PostgreSQL/2. Create a user-defined aggregate function.vtt
14 kB
49. Thank You!/1. Your feedback is very valuable.html
662 B
49. Thank You!/2. Upcoming course - Advanced Time Series Analysis.html
454 B
49. Thank You!/3. 2021-07-28_17-28-45-9da980a10061e26d058c147abe85f11b.png
122 kB
49. Thank You!/3. 2022-03-07_17-01-13-1fd24125e6dc740f0adf17fd4be7ce44.png
240 kB
49. Thank You!/3. Bonus Courses.html
1.2 kB
49. Thank You!/4. Thank You!.mp4
2.4 MB
49. Thank You!/4. Thank You!.vtt
929 B