|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 1. Boolean.mp4 |
54.37MB |
| 1. Boolean.vtt |
16.80KB |
| 1. Combine results sets with UNION.mp4 |
54.25MB |
| 1. Combine results sets with UNION.vtt |
12.36KB |
| 1. Comparison, Logical and Arithmetic operators.mp4 |
8.52MB |
| 1. Comparison, Logical and Arithmetic operators.vtt |
2.60KB |
| 1. Connect to local or remote database.mp4 |
15.72MB |
| 1. Connect to local or remote database.vtt |
4.96KB |
| 1. Constructing arrays and ranges.mp4 |
31.71MB |
| 1. Constructing arrays and ranges.vtt |
9.67KB |
| 1. Counting results via COUNT function.mp4 |
37.96MB |
| 1. Counting results via COUNT function.vtt |
7.52KB |
| 1. Course Introduction.mp4 |
2.06MB |
| 1. Course Introduction.vtt |
1.50KB |
| 1. Create a custom index method.mp4 |
119.23MB |
| 1. Create a custom index method.vtt |
25.39KB |
| 1. Create a sequence, advance a sequence, get current value, set value.mp4 |
30.11MB |
| 1. Create a sequence, advance a sequence, get current value, set value.vtt |
7.91KB |
| 1. CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 |
28.70MB |
| 1. CREATE DOMAIN - Create a DOMAIN data type, create an address.vtt |
7.54KB |
| 1. Creating our first SQL function.mp4 |
50.06MB |
| 1. Creating our first SQL function.vtt |
13.14KB |
| 1. Creating sample database 'mydata', adding columns.mp4 |
17.28MB |
| 1. Creating sample database 'mydata', adding columns.vtt |
4.40KB |
| 1. Datetimes data types.mp4 |
44.17MB |
| 1. Datetimes data types.vtt |
11.94KB |
| 1. Functions vs Stored Procedures.mp4 |
24.56MB |
| 1. Functions vs Stored Procedures.vtt |
7.17KB |
| 1. Global Character Set Support.mp4 |
57.54MB |
| 1. Global Character Set Support.vtt |
12.78KB |
| 1. Human Resources Database Structure.mp4 |
12.52MB |
| 1. Human Resources Database Structure.vtt |
3.95KB |
| 1. INNER joins.mp4 |
82.42MB |
| 1. INNER joins.vtt |
25.08KB |
| 1. Insert a data into table.mp4 |
18.30MB |
| 1. Insert a data into table.vtt |
5.22KB |
| 1. Installing PostgreSQL on Mac.mp4 |
5.29MB |
| 1. Installing PostgreSQL on Mac.vtt |
2.59KB |
| 1. Introduction to constraints.mp4 |
17.94MB |
| 1. Introduction to constraints.vtt |
4.44KB |
| 1. Introduction to CTEs.mp4 |
24.66MB |
| 1. Introduction to CTEs.vtt |
6.92KB |
| 1. Introduction to PLpgSQL language.mp4 |
8.16MB |
| 1. Introduction to PLpgSQL language.vtt |
2.54KB |
| 1. Introduction To stock market data.html |
612B |
| 1. Introduction to subqueries.html |
1.90KB |
| 1. Introduction to summarization.mp4 |
16.02MB |
| 1. Introduction to summarization.vtt |
4.09KB |
| 1. Introduction to triggers.html |
1.11KB |
| 1. Introduction to views.mp4 |
33.75MB |
| 1. Introduction to views.vtt |
8.85KB |
| 1. Introduction to Window Functions.mp4 |
6.24MB |
| 1. Introduction to Window Functions.vtt |
4.47KB |
| 1. List database users, and database sizes with and without indexes.mp4 |
17.71MB |
| 1. List database users, and database sizes with and without indexes.vtt |
5.06KB |
| 1. Movie Database Structure.mp4 |
12.18MB |
| 1. Movie Database Structure.vtt |
4.43KB |
| 1. PostgreSQL as a development platform.mp4 |
41.92MB |
| 1. PostgreSQL as a development platform.vtt |
12.33KB |
| 1. q_insert data into table.sql |
267B |
| 1. Security concepts and and levels.mp4 |
11.75MB |
| 1. Security concepts and and levels.vtt |
5.20KB |
| 1. Select all data from a table.mp4 |
39.15MB |
| 1. Select all data from a table.vtt |
7.45KB |
| 1. Text to structured data.mp4 |
23.61MB |
| 1. Text to structured data.vtt |
7.83KB |
| 1. The Good Ol' Text Search.mp4 |
44.16MB |
| 1. The Good Ol' Text Search.vtt |
10.63KB |
| 1. to_char.mp4 |
43.87MB |
| 1. to_char.vtt |
10.31KB |
| 1. Understanding row by row operations.mp4 |
42.77MB |
| 1. Understanding row by row operations.vtt |
8.50KB |
| 1. UPPER, LOWER and INITCAP.mp4 |
20.03MB |
| 1. UPPER, LOWER and INITCAP.vtt |
5.99KB |
| 1. Using GROUP BY.mp4 |
55.62MB |
| 1. Using GROUP BY.vtt |
14.01KB |
| 1. Using Northwind database.mp4 |
4.04MB |
| 1. Using Northwind database.vtt |
1.39KB |
| 1. Using SELECT INTO to create a new table with joins.mp4 |
80.64MB |
| 1. Using SELECT INTO to create a new table with joins.vtt |
14.21KB |
| 1. What is a crosstab report.mp4 |
19.67MB |
| 1. What is a crosstab report.vtt |
4.86KB |
| 1. What is a data type conversion.mp4 |
31.14MB |
| 1. What is a data type conversion.vtt |
7.70KB |
| 1. What is an index.mp4 |
18.16MB |
| 1. What is an index.vtt |
4.77KB |
| 1. What is a partition.mp4 |
26.83MB |
| 1. What is a partition.vtt |
6.75KB |
| 1. What is a Schema.mp4 |
27.20MB |
| 1. What is a Schema.vtt |
7.86KB |
| 1. What is a transaction.mp4 |
39.68MB |
| 1. What is a transaction.vtt |
9.83KB |
| 1. What is JSON.mp4 |
20.75MB |
| 1. What is JSON.vtt |
4.33KB |
| 1. Your feedback is very valuable.html |
662B |
| 10. Add a column in a view.mp4 |
8.71MB |
| 10. Add a column in a view.vtt |
3.21KB |
| 10. Assigning variables from query.mp4 |
40.04MB |
| 10. Assigning variables from query.vtt |
11.16KB |
| 10. Create an alphanumeric sequence.mp4 |
31.60MB |
| 10. Create an alphanumeric sequence.vtt |
8.67KB |
| 10. CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 |
16.79MB |
| 10. CREATE TYPE - Create an ENUM data type and see how to drop a data type.vtt |
4.39KB |
| 10. Creating a document from data.mp4 |
27.76MB |
| 10. Creating a document from data.vtt |
7.17KB |
| 10. Customers with no orders.mp4 |
22.66MB |
| 10. Customers with no orders.vtt |
7.15KB |
| 10. Date Value Extractors functions.mp4 |
36.14MB |
| 10. Date Value Extractors functions.vtt |
7.76KB |
| 10. Dynamic pivot query via JSON.mp4 |
40.56MB |
| 10. Dynamic pivot query via JSON.vtt |
8.65KB |
| 10. Foreign keys maintains referential data integrity.mp4 |
34.11MB |
| 10. Foreign keys maintains referential data integrity.vtt |
9.68KB |
| 10. Function using parameters Part 4.mp4 |
80.11MB |
| 10. Function using parameters Part 4.vtt |
16.45KB |
| 10. How to check live and dead rows in tables.mp4 |
6.70MB |
| 10. How to check live and dead rows in tables.vtt |
1.95KB |
| 10. Install northwind database.mp4 |
31.58MB |
| 10. Install northwind database.vtt |
7.04KB |
| 10. LEFT joins Part 4.mp4 |
37.48MB |
| 10. LEFT joins Part 4.vtt |
7.17KB |
| 10. Modify data at INSERT event.mp4 |
49.30MB |
| 10. Modify data at INSERT event.vtt |
14.87KB |
| 10. northwind.sql |
341.51KB |
| 10. Partition maintenance.mp4 |
26.65MB |
| 10. Partition maintenance.vtt |
5.86KB |
| 10. Represent NULL values on psql terminal.mp4 |
15.98MB |
| 10. Represent NULL values on psql terminal.vtt |
4.66KB |
| 10. Schemas and Privileges.mp4 |
36.00MB |
| 10. Schemas and Privileges.vtt |
8.30KB |
| 10. SELECT.. IN (Subquery).mp4 |
39.19MB |
| 10. SELECT.. IN (Subquery).vtt |
8.49KB |
| 10. SUBSTRING.mp4 |
16.96MB |
| 10. SUBSTRING.vtt |
5.57KB |
| 10. The query optimizer.mp4 |
34.72MB |
| 10. The query optimizer.vtt |
10.60KB |
| 10. Tracking table size.mp4 |
31.29MB |
| 10. Tracking table size.vtt |
9.62KB |
| 10. Using an alias name with columns.mp4 |
6.80MB |
| 10. Using an alias name with columns.vtt |
1.88KB |
| 10. Using a parametric cursor via function.mp4 |
92.07MB |
| 10. Using a parametric cursor via function.vtt |
16.97KB |
| 10. Using arrays in tables.mp4 |
19.58MB |
| 10. Using arrays in tables.vtt |
5.57KB |
| 10. Using CURRENT_USER with RLS.mp4 |
25.45MB |
| 10. Using CURRENT_USER with RLS.vtt |
7.74KB |
| 10. Using DISTINCT for selecting distinct values.mp4 |
25.99MB |
| 10. Using DISTINCT for selecting distinct values.vtt |
6.93KB |
| 10. Using LIMIT and OFFSET.mp4 |
88.73MB |
| 10. Using LIMIT and OFFSET.vtt |
21.33KB |
| 10. Using pgAdmin - View table structure, and create column.mp4 |
21.61MB |
| 10. Using pgAdmin - View table structure, and create column.vtt |
6.55KB |
| 10. Using Window Functions.mp4 |
21.03MB |
| 10. Using Window Functions.vtt |
6.32KB |
| 10. UUID.mp4 |
50.16MB |
| 10. UUID.vtt |
13.40KB |
| 11. ALTERing the partition bounds.mp4 |
38.38MB |
| 11. ALTERing the partition bounds.vtt |
11.05KB |
| 11. ALTER TYPE - Alter a composite data type, change schema and more.mp4 |
17.32MB |
| 11. ALTER TYPE - Alter a composite data type, change schema and more.vtt |
3.95KB |
| 11. Array.mp4 |
29.70MB |
| 11. Array.vtt |
8.84KB |
| 11. Compute 15% of salary for all employees.mp4 |
12.21MB |
| 11. Compute 15% of salary for all employees.vtt |
2.67KB |
| 11. Drop a constraint.mp4 |
7.56MB |
| 11. Drop a constraint.vtt |
2.85KB |
| 11. Drop a database.mp4 |
13.55MB |
| 11. Drop a database.vtt |
4.50KB |
| 11. Dynamic pivot table columns.mp4 |
90.12MB |
| 11. Dynamic pivot table columns.vtt |
20.02KB |
| 11. File layout of PostgreSQL Tables.mp4 |
75.77MB |
| 11. File layout of PostgreSQL Tables.vtt |
11.51KB |
| 11. Function returning a composite.mp4 |
67.64MB |
| 11. Function returning a composite.vtt |
14.84KB |
| 11. Insert data into arrays.mp4 |
23.38MB |
| 11. Insert data into arrays.vtt |
7.81KB |
| 11. Make table layout funkey!.mp4 |
12.07MB |
| 11. Make table layout funkey!.vtt |
2.40KB |
| 11. Null Values in JSON documents.mp4 |
58.39MB |
| 11. Null Values in JSON documents.vtt |
6.09KB |
| 11. Optimizer node types.mp4 |
22.69MB |
| 11. Optimizer node types.vtt |
6.78KB |
| 11. Partitioning the data.mp4 |
27.68MB |
| 11. Partitioning the data.vtt |
5.67KB |
| 11. pivotcode.sql |
948B |
| 11. PostgreSQL autovacuum proces.mp4 |
57.65MB |
| 11. PostgreSQL autovacuum proces.vtt |
12.67KB |
| 11. Regular views are dynamic.mp4 |
13.67MB |
| 11. Regular views are dynamic.vtt |
3.49KB |
| 11. REPEAT.mp4 |
8.69MB |
| 11. REPEAT.vtt |
3.15KB |
| 11. RIGHT joins.mp4 |
54.34MB |
| 11. RIGHT joins.vtt |
12.99KB |
| 11. Row level policy for application users.mp4 |
22.91MB |
| 11. Row level policy for application users.vtt |
6.01KB |
| 11. Top customers with total orders amount.mp4 |
22.55MB |
| 11. Top customers with total orders amount.vtt |
5.63KB |
| 11. Using ANY with subquery.mp4 |
40.33MB |
| 11. Using ANY with subquery.vtt |
9.32KB |
| 11. Using FETCH.mp4 |
83.67MB |
| 11. Using FETCH.vtt |
12.31KB |
| 11. Using IN, OUT without RETURNS.mp4 |
18.31MB |
| 11. Using IN, OUT without RETURNS.vtt |
5.67KB |
| 11. Using math operators with dates.mp4 |
46.64MB |
| 11. Using math operators with dates.vtt |
12.17KB |
| 11. Using pgAdmin - Rename, delete and change the data type of a column.mp4 |
56.72MB |
| 11. Using pgAdmin - Rename, delete and change the data type of a column.vtt |
8.01KB |
| 11. View triggers variables.mp4 |
22.66MB |
| 11. View triggers variables.vtt |
6.33KB |
| 12. Add or update foreign key constraint on existing table.mp4 |
11.72MB |
| 12. Add or update foreign key constraint on existing table.vtt |
3.45KB |
| 12. ALTER TYPE - Alter an ENUM data type.mp4 |
13.71MB |
| 12. ALTER TYPE - Alter an ENUM data type.vtt |
3.62KB |
| 12. Deleting tables from a database.mp4 |
9.65MB |
| 12. Deleting tables from a database.vtt |
3.12KB |
| 12. Disallow DELETE on a table.mp4 |
43.23MB |
| 12. Disallow DELETE on a table.vtt |
13.22KB |
| 12. DROP a policy.mp4 |
10.00MB |
| 12. DROP a policy.vtt |
2.84KB |
| 12. Function returning multiple rows.mp4 |
55.04MB |
| 12. Function returning multiple rows.vtt |
10.57KB |
| 12. hstore.mp4 |
31.64MB |
| 12. hstore.vtt |
8.28KB |
| 12. Interactive client-side pivot.mp4 |
77.80MB |
| 12. Interactive client-side pivot.vtt |
7.79KB |
| 12. JSON nulls and SQL nulls.html |
708B |
| 12. Orders with many lines of ordered items.mp4 |
10.53MB |
| 12. Orders with many lines of ordered items.vtt |
3.43KB |
| 12. OVERLAPS Operator.mp4 |
16.17MB |
| 12. OVERLAPS Operator.vtt |
5.14KB |
| 12. Partition Indexes.mp4 |
31.60MB |
| 12. Partition Indexes.vtt |
9.24KB |
| 12. q_deleting tables from a database.sql |
119B |
| 12. Query array data.mp4 |
28.84MB |
| 12. Query array data.vtt |
9.47KB |
| 12. Recovering unused space with VACUUM.mp4 |
58.39MB |
| 12. Recovering unused space with VACUUM.vtt |
13.09KB |
| 12. Repeatedly Execute a Query.mp4 |
9.75MB |
| 12. Repeatedly Execute a Query.vtt |
2.00KB |
| 12. REPLACE.mp4 |
17.08MB |
| 12. REPLACE.vtt |
5.00KB |
| 12. RIGHT joins Part 2.mp4 |
15.04MB |
| 12. RIGHT joins Part 2.vtt |
4.09KB |
| 12. Sequential Nodes.mp4 |
36.39MB |
| 12. Sequential Nodes.vtt |
7.47KB |
| 12. Set data into millions format.mp4 |
10.97MB |
| 12. Set data into millions format.vtt |
3.32KB |
| 12. To list all employees IDs within each job_id group.mp4 |
5.14MB |
| 12. To list all employees IDs within each job_id group.vtt |
1.13KB |
| 12. Using ALL with subquery.mp4 |
47.21MB |
| 12. Using ALL with subquery.vtt |
9.78KB |
| 12. Using IN, NOT IN.mp4 |
68.39MB |
| 12. Using IN, NOT IN.vtt |
11.24KB |
| 12. Variables in block and subblock.mp4 |
18.96MB |
| 12. Variables in block and subblock.vtt |
6.07KB |
| 12. What is an updatable view.mp4 |
15.93MB |
| 12. What is an updatable view.vtt |
4.65KB |
| 13. An updatable view with CRUD operations.mp4 |
29.18MB |
| 13. An updatable view with CRUD operations.vtt |
6.85KB |
| 13. CHECK constraint - An Introduction.mp4 |
4.88MB |
| 13. CHECK constraint - An Introduction.vtt |
1.81KB |
| 13. Date Time Functions.mp4 |
26.70MB |
| 13. Date Time Functions.vtt |
6.48KB |
| 13. Disallow TRUNCATE on a table.mp4 |
29.93MB |
| 13. Disallow TRUNCATE on a table.vtt |
6.90KB |
| 13. Discard characters from employees email address.mp4 |
32.06MB |
| 13. Discard characters from employees email address.vtt |
6.11KB |
| 13. FULL Joins.mp4 |
22.02MB |
| 13. FULL Joins.vtt |
6.12KB |
| 13. Function returning a table.mp4 |
14.66MB |
| 13. Function returning a table.vtt |
3.49KB |
| 13. Generated Columns.mp4 |
55.00MB |
| 13. Generated Columns.vtt |
13.83KB |
| 13. Getting information from JSON documents.mp4 |
68.37MB |
| 13. Getting information from JSON documents.vtt |
7.68KB |
| 13. Handling missing values.mp4 |
62.13MB |
| 13. Handling missing values.vtt |
13.21KB |
| 13. How to return query results.mp4 |
32.29MB |
| 13. How to return query results.vtt |
5.83KB |
| 13. Index Nodes.mp4 |
41.79MB |
| 13. Index Nodes.vtt |
9.66KB |
| 13. Inspecting permissions.mp4 |
24.36MB |
| 13. Inspecting permissions.vtt |
3.42KB |
| 13. JSON.mp4 |
52.38MB |
| 13. JSON.vtt |
14.70KB |
| 13. Modifying array data.mp4 |
12.78MB |
| 13. Modifying array data.vtt |
4.04KB |
| 13. Ordering inside window.mp4 |
79.10MB |
| 13. Ordering inside window.vtt |
9.86KB |
| 13. Orders with double entry line items.mp4 |
38.14MB |
| 13. Orders with double entry line items.vtt |
13.20KB |
| 13. Partition pruning.mp4 |
17.99MB |
| 13. Partition pruning.vtt |
4.82KB |
| 13. Represent NULL Visibly.mp4 |
15.98MB |
| 13. Represent NULL Visibly.vtt |
4.66KB |
| 13. Subquery using EXISTS.mp4 |
20.39MB |
| 13. Subquery using EXISTS.vtt |
5.82KB |
| 13. Update an ENUM data in production server.mp4 |
32.16MB |
| 13. Update an ENUM data in production server.vtt |
8.51KB |
| 13. Using BETWEEN and NOT BETWEEN.mp4 |
50.55MB |
| 13. Using BETWEEN and NOT BETWEEN.vtt |
12.20KB |
| 14. An ENUM with a DEFAULT value in a table.mp4 |
17.16MB |
| 14. An ENUM with a DEFAULT value in a table.vtt |
3.72KB |
| 14. Array Dimensions are ignored!.mp4 |
18.27MB |
| 14. Array Dimensions are ignored!.vtt |
5.30KB |
| 14. CHECK constraint - Add to new table.mp4 |
41.83MB |
| 14. CHECK constraint - Add to new table.vtt |
9.96KB |
| 14. Control Structures - IF statement.mp4 |
32.59MB |
| 14. Control Structures - IF statement.vtt |
9.91KB |
| 14. Creating an audit trigger.mp4 |
84.32MB |
| 14. Creating an audit trigger.vtt |
26.52KB |
| 14. Determining a field for partition over.mp4 |
32.42MB |
| 14. Determining a field for partition over.vtt |
10.03KB |
| 14. Function - order matters!.mp4 |
16.65MB |
| 14. Function - order matters!.vtt |
3.69KB |
| 14. Joining multiple tables.mp4 |
60.84MB |
| 14. Joining multiple tables.vtt |
10.49KB |
| 14. Join Nodes.mp4 |
37.02MB |
| 14. Join Nodes.vtt |
8.03KB |
| 14. Late shipped orders by employees.mp4 |
42.72MB |
| 14. Late shipped orders by employees.vtt |
13.70KB |
| 14. List all employees with first_name starts with letters A, C or M.mp4 |
12.57MB |
| 14. List all employees with first_name starts with letters A, C or M.vtt |
3.61KB |
| 14. Network Addresses.mp4 |
61.79MB |
| 14. Network Addresses.vtt |
16.98KB |
| 14. PostgreSQL Date Time Functions.mp4 |
18.60MB |
| 14. PostgreSQL Date Time Functions.vtt |
5.45KB |
| 14. PostgreSQL Date Time Functions.vtt |
5.60KB |
| 14. Row Level Security Performance.mp4 |
20.26MB |
| 14. Row Level Security Performance.vtt |
5.00KB |
| 14. Sliding dynamic windows.mp4 |
31.85MB |
| 14. Sliding dynamic windows.vtt |
9.59KB |
| 14. The Existence Operator.mp4 |
12.37MB |
| 14. The Existence Operator.vtt |
3.80KB |
| 14. Turn on query execution time.mp4 |
17.02MB |
| 14. Turn on query execution time.vtt |
3.05KB |
| 14. Updatable views using WITH CHECK OPTION.mp4 |
42.42MB |
| 14. Updatable views using WITH CHECK OPTION.vtt |
9.86KB |
| 14. Using LIKE and ILIKE.mp4 |
87.81MB |
| 14. Using LIKE and ILIKE.vtt |
21.49KB |
| 15. AGE function.mp4 |
14.09MB |
| 15. AGE function.vtt |
4.45KB |
| 15. CHECK constraint - Add, Rename, Drop on existing table.mp4 |
39.57MB |
| 15. CHECK constraint - Add, Rename, Drop on existing table.vtt |
10.25KB |
| 15. Countries with customers or suppliers.mp4 |
10.21MB |
| 15. Countries with customers or suppliers.vtt |
3.81KB |
| 15. Create a type if not exists using a PLpgSQL function.mp4 |
8.09MB |
| 15. Create a type if not exists using a PLpgSQL function.vtt |
2.39KB |
| 15. Creating conditional triggers.mp4 |
77.81MB |
| 15. Creating conditional triggers.vtt |
18.68KB |
| 15. Display all array elements.mp4 |
15.91MB |
| 15. Display all array elements.vtt |
4.99KB |
| 15. Encrypted data in columns.mp4 |
69.63MB |
| 15. Encrypted data in columns.vtt |
9.52KB |
| 15. Function as a table source.mp4 |
55.28MB |
| 15. Function as a table source.vtt |
12.14KB |
| 15. Index Types - B-Tree Index.mp4 |
19.39MB |
| 15. Index Types - B-Tree Index.vtt |
5.60KB |
| 15. Self Joins Part 1.mp4 |
35.37MB |
| 15. Self Joins Part 1.vtt |
10.22KB |
| 15. Sizing the partition.mp4 |
22.57MB |
| 15. Sizing the partition.vtt |
7.86KB |
| 15. String manipulation with upper, lower and initcap functions.mp4 |
7.15MB |
| 15. String manipulation with upper, lower and initcap functions.vtt |
2.16KB |
| 15. The Containment Operator.mp4 |
16.91MB |
| 15. The Containment Operator.vtt |
5.37KB |
| 15. Understanding window frames.mp4 |
184.84MB |
| 15. Understanding window frames.vtt |
28.95KB |
| 15. Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 |
40.14MB |
| 15. Updatable views using WITH LOCAL and CASCADED CHECK OPTION.vtt |
11.08KB |
| 15. Using IF with table data.mp4 |
34.38MB |
| 15. Using IF with table data.vtt |
6.73KB |
| 15. Using IS NULL and IS NOT NULL keywords.mp4 |
61.23MB |
| 15. Using IS NULL and IS NOT NULL keywords.vtt |
15.31KB |
| 16. CASE Statement.mp4 |
60.64MB |
| 16. CASE Statement.vtt |
13.61KB |
| 16. Concatenation techniques.mp4 |
33.97MB |
| 16. Concatenation techniques.vtt |
8.81KB |
| 16. Countries with customers or suppliers - Using CTE.mp4 |
23.28MB |
| 16. Countries with customers or suppliers - Using CTE.vtt |
7.83KB |
| 16. CURRENT_DATE function.mp4 |
4.62MB |
| 16. CURRENT_DATE function.vtt |
1.73KB |
| 16. Disallow data change on primary key.mp4 |
23.23MB |
| 16. Disallow data change on primary key.vtt |
7.26KB |
| 16. Function parameter modes.mp4 |
16.64MB |
| 16. Function parameter modes.vtt |
3.69KB |
| 16. Hash Index.mp4 |
24.19MB |
| 16. Hash Index.vtt |
5.42KB |
| 16. JSON search with PostgreSQL functions.mp4 |
18.41MB |
| 16. JSON search with PostgreSQL functions.vtt |
5.18KB |
| 16. Partitioning Advantages.mp4 |
22.04MB |
| 16. Partitioning Advantages.vtt |
6.03KB |
| 16. ROWS and RANGE indicators.mp4 |
61.16MB |
| 16. ROWS and RANGE indicators.vtt |
13.72KB |
| 16. Self Joins Part 2.mp4 |
12.89MB |
| 16. Self Joins Part 2.vtt |
3.99KB |
| 16. Using Multi-dimensional arrays.mp4 |
47.42MB |
| 16. Using Multi-dimensional arrays.vtt |
14.21KB |
| 16. Using SUBSTRING to get portion of string data.mp4 |
2.81MB |
| 16. Using SUBSTRING to get portion of string data.vtt |
1013B |
| 16. What is a Materialized View.mp4 |
43.92MB |
| 16. What is a Materialized View.vtt |
11.69KB |
| 17. Array vs JSONB.mp4 |
63.10MB |
| 17. Array vs JSONB.vtt |
17.92KB |
| 17. BRIN index.mp4 |
8.91MB |
| 17. BRIN index.vtt |
2.60KB |
| 17. Common partitioning mistakes.mp4 |
21.64MB |
| 17. Common partitioning mistakes.vtt |
6.14KB |
| 17. Concatenation with , CONCAT and CONCAT_WS.mp4 |
18.10MB |
| 17. Concatenation with , CONCAT and CONCAT_WS.vtt |
5.94KB |
| 17. Creating a materialized view.mp4 |
18.57MB |
| 17. Creating a materialized view.vtt |
5.78KB |
| 17. CROSS Joins.mp4 |
55.61MB |
| 17. CROSS Joins.vtt |
13.17KB |
| 17. CURRENT_TIME function.mp4 |
18.77MB |
| 17. CURRENT_TIME function.vtt |
4.32KB |
| 17. Customers with multiple orders.mp4 |
33.74MB |
| 17. Customers with multiple orders.vtt |
9.03KB |
| 17. Function parameters with default values.mp4 |
45.06MB |
| 17. Function parameters with default values.vtt |
13.96KB |
| 17. Get unique designations in employees table.mp4 |
8.59MB |
| 17. Get unique designations in employees table.vtt |
2.13KB |
| 17. Indexing on JSONB.mp4 |
81.97MB |
| 17. Indexing on JSONB.vtt |
14.69KB |
| 17. Searched CASE statement.mp4 |
45.98MB |
| 17. Searched CASE statement.vtt |
13.83KB |
| 17. Use triggers very cautiously.mp4 |
14.16MB |
| 17. Use triggers very cautiously.vtt |
4.04KB |
| 17. Using WINDOW.mp4 |
35.68MB |
| 17. Using WINDOW.vtt |
10.94KB |
| 18. Date accuracy with EPOCH.mp4 |
38.73MB |
| 18. Date accuracy with EPOCH.vtt |
8.93KB |
| 18. Drop a materialized view.mp4 |
15.55MB |
| 18. Drop a materialized view.vtt |
3.97KB |
| 18. First order from each country.mp4 |
37.58MB |
| 18. First order from each country.vtt |
9.39KB |
| 18. Function based on views.mp4 |
32.55MB |
| 18. Function based on views.vtt |
7.91KB |
| 18. GIN Index.mp4 |
7.03MB |
| 18. GIN Index.vtt |
2.18KB |
| 18. LOOP statement.mp4 |
23.34MB |
| 18. LOOP statement.vtt |
7.62KB |
| 18. Natural Joins Part 1.mp4 |
23.98MB |
| 18. Natural Joins Part 1.vtt |
7.25KB |
| 18. Select employees with particular department id only.mp4 |
8.92MB |
| 18. Select employees with particular department id only.vtt |
2.65KB |
| 18. Single and Multi-dimensional arrays.html |
2.80KB |
| 18. Using WINDOW with ROWS BETWEEN.mp4 |
18.13MB |
| 18. Using WINDOW with ROWS BETWEEN.vtt |
4.48KB |
| 18. What is an event trigger.mp4 |
7.46MB |
| 18. What is an event trigger.vtt |
2.13KB |
| 19. Changing materialized view data.mp4 |
55.26MB |
| 19. Changing materialized view data.vtt |
7.81KB |
| 19. Drop a function.mp4 |
18.40MB |
| 19. Drop a function.vtt |
6.05KB |
| 19. Event triggers usage scenarios.mp4 |
14.10MB |
| 19. Event triggers usage scenarios.vtt |
3.67KB |
| 19. FOR Loops.mp4 |
22.61MB |
| 19. FOR Loops.vtt |
7.64KB |
| 19. Natural Joins Part 2.mp4 |
13.12MB |
| 19. Natural Joins Part 2.vtt |
2.80KB |
| 19. RANK and DENSE_RANK functions.mp4 |
20.82MB |
| 19. RANK and DENSE_RANK functions.vtt |
6.44KB |
| 19. Select employees not in range.mp4 |
13.90MB |
| 19. Select employees not in range.vtt |
3.86KB |
| 19. The EXPLAIN statement.mp4 |
74.55MB |
| 19. The EXPLAIN statement.vtt |
19.42KB |
| 19. Using Date, time, timestamp in tables.mp4 |
43.94MB |
| 19. Using Date, time, timestamp in tables.vtt |
10.85KB |
| 2. Analyze Global Trades Data.mp4 |
96.64MB |
| 2. Analyze Global Trades Data.vtt |
9.83KB |
| 2. AND operator.mp4 |
61.52MB |
| 2. AND operator.vtt |
9.46KB |
| 2. CHAR, VARCHAR and TEXT.mp4 |
77.04MB |
| 2. CHAR, VARCHAR and TEXT.vtt |
24.73KB |
| 2. Client and Server Encoding.mp4 |
57.06MB |
| 2. Client and Server Encoding.vtt |
13.90KB |
| 2. COUNT(), COUNT() and COUNT(1).html |
1.34KB |
| 2. countries_iso_codes.csv |
11.45KB |
| 2. Create an index.mp4 |
77.58MB |
| 2. Create an index.vtt |
20.03KB |
| 2. Create a transactions.mp4 |
33.97MB |
| 2. Create a transactions.vtt |
9.81KB |
| 2. Create a user-defined aggregate function.mp4 |
47.00MB |
| 2. Create a user-defined aggregate function.vtt |
14.41KB |
| 2. CREATE DOMAIN - Create a data type for a positive number.mp4 |
8.57MB |
| 2. CREATE DOMAIN - Create a data type for a positive number.vtt |
2.31KB |
| 2. Creating a view.mp4 |
54.40MB |
| 2. Creating a view.vtt |
13.43KB |
| 2. Creating the movie database and a actors table.mp4 |
20.52MB |
| 2. Creating the movie database and a actors table.vtt |
6.73KB |
| 2. CTE query examples.mp4 |
73.43MB |
| 2. CTE query examples.vtt |
19.46KB |
| 2. Cursors and procedural languages.mp4 |
23.37MB |
| 2. Cursors and procedural languages.vtt |
6.15KB |
| 2. Duplicate a table with or without data.mp4 |
13.25MB |
| 2. Duplicate a table with or without data.vtt |
3.56KB |
| 2. How SQL protect database during transaction.mp4 |
22.82MB |
| 2. How SQL protect database during transaction.vtt |
6.83KB |
| 2. INNER joins with USING.mp4 |
50.02MB |
| 2. INNER joins with USING.vtt |
10.36KB |
| 2. Insert multiple records into a table.mp4 |
9.55MB |
| 2. Insert multiple records into a table.vtt |
3.03KB |
| 2. Installing PostgreSQL on Windows.mp4 |
25.65MB |
| 2. Installing PostgreSQL on Windows.vtt |
7.21KB |
| 2. Installing the tablefunc extension.mp4 |
7.80MB |
| 2. Installing the tablefunc extension.vtt |
2.20KB |
| 2. Instance Level Security.mp4 |
22.90MB |
| 2. Instance Level Security.vtt |
7.64KB |
| 2. Introducing dollar quoting.mp4 |
16.13MB |
| 2. Introducing dollar quoting.vtt |
4.65KB |
| 2. Introducing tsvector.mp4 |
52.10MB |
| 2. Introducing tsvector.vtt |
14.91KB |
| 2. JSON Syntax.mp4 |
33.79MB |
| 2. JSON Syntax.vtt |
11.82KB |
| 2. LEFT and RIGHT.mp4 |
40.35MB |
| 2. LEFT and RIGHT.vtt |
10.39KB |
| 2. List all database and schemas.mp4 |
42.83MB |
| 2. List all database and schemas.vtt |
5.74KB |
| 2. Modify Table Structures, AddModify Columns.mp4 |
34.83MB |
| 2. Modify Table Structures, AddModify Columns.vtt |
8.51KB |
| 2. northwind.sql |
341.51KB |
| 2. NOT NULL constraint.mp4 |
45.21MB |
| 2. NOT NULL constraint.vtt |
13.30KB |
| 2. Orders shipping to USA or France.mp4 |
9.15MB |
| 2. Orders shipping to USA or France.vtt |
2.28KB |
| 2. PLpgSQL vs SQL.mp4 |
10.75MB |
| 2. PLpgSQL vs SQL.vtt |
3.04KB |
| 2. Procedural languages.mp4 |
21.94MB |
| 2. Procedural languages.vtt |
5.79KB |
| 2. q_creating movies database and actors table.sql |
186B |
| 2. q_insert multiple records into a table.sql |
137B |
| 2. Quick overview of all tables.mp4 |
20.01MB |
| 2. Quick overview of all tables.vtt |
6.52KB |
| 2. Regular expressions notations table.mp4 |
37.20MB |
| 2. Regular expressions notations table.vtt |
11.58KB |
| 2. Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 |
17.77MB |
| 2. Restart, rename a sequence, and use pgAdmin to alter a sequence.vtt |
4.60KB |
| 2. sample_data.zip |
1.41MB |
| 2. Sample Data Files.html |
492B |
| 2. Schema Operations (AddAlterDelete schemas).mp4 |
28.09MB |
| 2. Schema Operations (AddAlterDelete schemas).vtt |
9.29KB |
| 2. Select first or last records in a table.mp4 |
24.15MB |
| 2. Select first or last records in a table.vtt |
4.33KB |
| 2. Selecting specific columns from a table.mp4 |
15.86MB |
| 2. Selecting specific columns from a table.vtt |
4.31KB |
| 2. Subqueries with WHERE Clause.mp4 |
65.82MB |
| 2. Subqueries with WHERE Clause.vtt |
14.96KB |
| 2. Subtotals on group sets.mp4 |
114.46MB |
| 2. Subtotals on group sets.vtt |
14.95KB |
| 2. Switch connection to a new database.mp4 |
6.73MB |
| 2. Switch connection to a new database.vtt |
2.25KB |
| 2. System Month Date settings.mp4 |
12.79MB |
| 2. System Month Date settings.vtt |
3.80KB |
| 2. to_number.mp4 |
22.84MB |
| 2. to_number.vtt |
7.39KB |
| 2. trades.sql |
510.16KB |
| 2. trades.sql |
510.16KB |
| 2. UNION with filters and conditions.mp4 |
44.63MB |
| 2. UNION with filters and conditions.vtt |
12.67KB |
| 2. Upcoming course - Advanced Time Series Analysis.html |
454B |
| 2. Using CAST for data conversions.mp4 |
59.40MB |
| 2. Using CAST for data conversions.vtt |
16.22KB |
| 2. Using comparison operators.mp4 |
34.09MB |
| 2. Using comparison operators.vtt |
9.97KB |
| 2. Using GROUP BY with multiple columns, ORDER BY.mp4 |
60.91MB |
| 2. Using GROUP BY with multiple columns, ORDER BY.vtt |
18.44KB |
| 2. What is a trigger.mp4 |
46.10MB |
| 2. What is a trigger.vtt |
13.66KB |
| 2. When a partition can be used.mp4 |
86.19MB |
| 2. When a partition can be used.vtt |
20.83KB |
| 20. Append tables with different columns.mp4 |
70.57MB |
| 20. Append tables with different columns.vtt |
15.92KB |
| 20. Creating event triggers.mp4 |
20.48MB |
| 20. Creating event triggers.vtt |
5.72KB |
| 20. EXPLAIN output options.mp4 |
11.87MB |
| 20. EXPLAIN output options.vtt |
3.61KB |
| 20. Find Letter C in last_name at 3rd or greater position.mp4 |
10.21MB |
| 20. Find Letter C in last_name at 3rd or greater position.vtt |
2.85KB |
| 20. FOR Loops iterate over result set.mp4 |
23.37MB |
| 20. FOR Loops iterate over result set.vtt |
5.81KB |
| 20. How to check if a materialized view is populated or not.mp4 |
11.78MB |
| 20. How to check if a materialized view is populated or not.vtt |
3.23KB |
| 20. NTILE function.mp4 |
37.96MB |
| 20. NTILE function.vtt |
11.82KB |
| 20. View and set timezones.mp4 |
14.98MB |
| 20. View and set timezones.vtt |
4.59KB |
| 21. CONTINUE statement.mp4 |
19.63MB |
| 21. CONTINUE statement.vtt |
6.58KB |
| 21. Event trigger events and variables.mp4 |
19.65MB |
| 21. Event trigger events and variables.vtt |
5.37KB |
| 21. How to handle timezones.mp4 |
60.50MB |
| 21. How to handle timezones.vtt |
13.57KB |
| 21. LEAD and LAG functions.mp4 |
72.77MB |
| 21. LEAD and LAG functions.vtt |
18.64KB |
| 21. ON versus WHERE.html |
1.09KB |
| 21. Refreshing data in materialize views.mp4 |
37.71MB |
| 21. Refreshing data in materialize views.vtt |
7.55KB |
| 21. Update phone_number with your strings.mp4 |
11.51MB |
| 21. Update phone_number with your strings.vtt |
3.48KB |
| 21. Using EXPLAIN ANALYZE.mp4 |
39.11MB |
| 21. Using EXPLAIN ANALYZE.vtt |
12.30KB |
| 22. Creating an audit event trigger.mp4 |
75.01MB |
| 22. Creating an audit event trigger.vtt |
18.26KB |
| 22. date_part function.mp4 |
119.03MB |
| 22. date_part function.vtt |
14.72KB |
| 22. FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4 |
77.56MB |
| 22. FIRST_VALUE, LAST_VALUE and NTH_value functions.vtt |
19.79KB |
| 22. FOREACH loop with arrays.mp4 |
15.05MB |
| 22. FOREACH loop with arrays.vtt |
5.08KB |
| 22. Get the monthly salary of each employees.mp4 |
8.69MB |
| 22. Get the monthly salary of each employees.vtt |
2.55KB |
| 22. Understanding query cost model.mp4 |
56.56MB |
| 22. Understanding query cost model.vtt |
16.50KB |
| 22. Why not use a table instead of materialized view.mp4 |
18.00MB |
| 22. Why not use a table instead of materialized view.vtt |
5.56KB |
| 23. Calculate average salary with total number of employees.mp4 |
6.70MB |
| 23. Calculate average salary with total number of employees.vtt |
1.80KB |
| 23. date_trunc function.mp4 |
48.10MB |
| 23. date_trunc function.vtt |
11.25KB |
| 23. Index are not free.mp4 |
58.54MB |
| 23. Index are not free.vtt |
14.96KB |
| 23. Prevent schema changes.mp4 |
36.99MB |
| 23. Prevent schema changes.vtt |
10.26KB |
| 23. ROW_NUMBER function.mp4 |
53.68MB |
| 23. ROW_NUMBER function.vtt |
11.88KB |
| 23. The downsides of using materialized views.mp4 |
15.94MB |
| 23. The downsides of using materialized views.vtt |
3.84KB |
| 23. WHILE loop.mp4 |
52.26MB |
| 23. WHILE loop.vtt |
15.28KB |
| 24. Dropping a trigger.mp4 |
3.92MB |
| 24. Dropping a trigger.vtt |
1.16KB |
| 24. find employees whose names contains exactly six characters.mp4 |
8.60MB |
| 24. find employees whose names contains exactly six characters.vtt |
2.89KB |
| 24. Finding Correlations.mp4 |
22.60MB |
| 24. Finding Correlations.vtt |
7.38KB |
| 24. Indexes for sorted output.mp4 |
35.89MB |
| 24. Indexes for sorted output.vtt |
10.81KB |
| 24. Using materialized view for websites page analysis.mp4 |
63.59MB |
| 24. Using materialized view for websites page analysis.vtt |
13.92KB |
| 24. Using RETURN QUERY.mp4 |
56.79MB |
| 24. Using RETURN QUERY.vtt |
13.25KB |
| 25. List all materialized views by a SELECT statement.mp4 |
5.85MB |
| 25. List all materialized views by a SELECT statement.vtt |
2.02KB |
| 25. Returning a table.mp4 |
17.05MB |
| 25. Returning a table.vtt |
5.25KB |
| 25. ROW_NUMBER() - Window with Partition datasets.mp4 |
44.15MB |
| 25. ROW_NUMBER() - Window with Partition datasets.vtt |
11.93KB |
| 25. Using multiple indexes on a single query.mp4 |
32.33MB |
| 25. Using multiple indexes on a single query.vtt |
10.05KB |
| 26. Execution plans depends on input values.mp4 |
28.31MB |
| 26. Execution plans depends on input values.vtt |
8.29KB |
| 26. List materialized views with no unique index.mp4 |
17.02MB |
| 26. List materialized views with no unique index.vtt |
5.04KB |
| 26. ROW_NUMBER() - Reverse fields with order by.mp4 |
14.12MB |
| 26. ROW_NUMBER() - Reverse fields with order by.vtt |
2.91KB |
| 26. Using RETURN NEXT.mp4 |
69.47MB |
| 26. Using RETURN NEXT.vtt |
17.10KB |
| 27. Error and exception handling.mp4 |
23.50MB |
| 27. Error and exception handling.vtt |
6.90KB |
| 27. Quick queries for materialized views.html |
771B |
| 27. ROW_NUMBER() - Find Nth record.mp4 |
15.21MB |
| 27. ROW_NUMBER() - Find Nth record.vtt |
4.44KB |
| 27. Using organized vs random data.mp4 |
99.39MB |
| 27. Using organized vs random data.vtt |
23.87KB |
| 28. Exception - Too many rows.mp4 |
22.90MB |
| 28. Exception - Too many rows.vtt |
6.75KB |
| 28. ROW_NUMBER() - Find DISTINCT with subquery.mp4 |
26.59MB |
| 28. ROW_NUMBER() - Find DISTINCT with subquery.vtt |
6.37KB |
| 28. Try to use index only scan.mp4 |
16.32MB |
| 28. Try to use index only scan.vtt |
5.24KB |
| 29. Partial indexes.mp4 |
55.69MB |
| 29. Partial indexes.vtt |
12.67KB |
| 29. ROW_NUMBER() - Pagination technique.mp4 |
35.21MB |
| 29. ROW_NUMBER() - Pagination technique.vtt |
7.72KB |
| 29. Using SQLSTATE codes for exception handling.mp4 |
23.68MB |
| 29. Using SQLSTATE codes for exception handling.vtt |
5.08KB |
| 3. 2021-07-28_17-28-45-9da980a10061e26d058c147abe85f11b.png |
121.96KB |
| 3. 2022-03-07_17-01-13-1fd24125e6dc740f0adf17fd4be7ce44.png |
240.55KB |
| 3. ACID Database.mp4 |
38.21MB |
| 3. ACID Database.vtt |
10.76KB |
| 3. Add constraints to columns.mp4 |
42.94MB |
| 3. Add constraints to columns.vtt |
10.14KB |
| 3. Adding Aliases to columns in a table.mp4 |
48.37MB |
| 3. Adding Aliases to columns in a table.vtt |
11.12KB |
| 3. Adding subtotal with ROLLUP.mp4 |
32.41MB |
| 3. Adding subtotal with ROLLUP.vtt |
9.55KB |
| 3. Bonus Courses.html |
1.22KB |
| 3. Combine CTE with a table.mp4 |
35.88MB |
| 3. Combine CTE with a table.vtt |
8.57KB |
| 3. Configure pgAdmin 4 client.mp4 |
7.53MB |
| 3. Configure pgAdmin 4 client.vtt |
2.66KB |
| 3. countries_iso_codes.csv |
11.45KB |
| 3. Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 |
13.47MB |
| 3. Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.vtt |
3.55KB |
| 3. CREATE DOMAIN - Create a postal code validation data type.mp4 |
11.16MB |
| 3. CREATE DOMAIN - Create a postal code validation data type.vtt |
3.26KB |
| 3. Create unique indexes.mp4 |
57.15MB |
| 3. Create unique indexes.vtt |
12.83KB |
| 3. Creating a crosstab report - Student Rankings.mp4 |
61.67MB |
| 3. Creating a crosstab report - Student Rankings.vtt |
18.55KB |
| 3. Creating the directors table.mp4 |
14.40MB |
| 3. Creating the directors table.vtt |
3.38KB |
| 3. Function returning no values.mp4 |
22.52MB |
| 3. Function returning no values.vtt |
6.25KB |
| 3. Get first or last record per each group.mp4 |
20.24MB |
| 3. Get first or last record per each group.vtt |
4.19KB |
| 3. Implicit to Explicit conversions.mp4 |
17.03MB |
| 3. Implicit to Explicit conversions.vtt |
5.93KB |
| 3. Import data from CSV files.mp4 |
42.66MB |
| 3. Import data from CSV files.vtt |
8.97KB |
| 3. INNER joins with filter data Part 1.mp4 |
56.80MB |
| 3. INNER joins with filter data Part 1.vtt |
11.32KB |
| 3. Insert a data that had quotes.mp4 |
7.52MB |
| 3. Insert a data that had quotes.vtt |
2.31KB |
| 3. Instance Level Security - Add users to roles.mp4 |
18.34MB |
| 3. Instance Level Security - Add users to roles.vtt |
5.50KB |
| 3. JSON and JSONB data types.mp4 |
20.43MB |
| 3. JSON and JSONB data types.vtt |
4.57KB |
| 3. Keep the data on the server!.mp4 |
26.63MB |
| 3. Keep the data on the server!.vtt |
7.67KB |
| 3. List all databases and tables.mp4 |
14.36MB |
| 3. List all databases and tables.vtt |
4.26KB |
| 3. List all tables and views.mp4 |
39.84MB |
| 3. List all tables and views.vtt |
10.94KB |
| 3. NUMERIC.mp4 |
43.09MB |
| 3. NUMERIC.vtt |
13.83KB |
| 3. Order of execution in GROUP BY clause.mp4 |
5.46MB |
| 3. Order of execution in GROUP BY clause.vtt |
1.73KB |
| 3. OR operator.mp4 |
15.67MB |
| 3. OR operator.vtt |
4.24KB |
| 3. q_creating the directors table.sql |
227B |
| 3. q_insert a data that had quotes.sql |
93B |
| 3. Quick overview of all tables Part 2.mp4 |
13.66MB |
| 3. Quick overview of all tables Part 2.vtt |
3.75KB |
| 3. Rename a view.mp4 |
18.22MB |
| 3. Rename a view.vtt |
5.31KB |
| 3. REVERSE.mp4 |
8.06MB |
| 3. REVERSE.vtt |
2.84KB |
| 3. Schema Hierarchy.mp4 |
26.65MB |
| 3. Schema Hierarchy.vtt |
8.21KB |
| 3. SIMILAR TO operator.mp4 |
28.96MB |
| 3. SIMILAR TO operator.vtt |
8.75KB |
| 3. Steps to create a cursor.mp4 |
13.49MB |
| 3. Steps to create a cursor.vtt |
3.37KB |
| 3. Structure of a PLpgSQL function.mp4 |
18.92MB |
| 3. Structure of a PLpgSQL function.vtt |
6.24KB |
| 3. Subquery with IN operator.mp4 |
19.60MB |
| 3. Subquery with IN operator.vtt |
5.68KB |
| 3. Sum with SUM function.mp4 |
37.72MB |
| 3. Sum with SUM function.vtt |
9.89KB |
| 3. Table inheritance.mp4 |
66.37MB |
| 3. Table inheritance.vtt |
21.17KB |
| 3. Time of day formats and inputs.mp4 |
24.58MB |
| 3. Time of day formats and inputs.vtt |
7.66KB |
| 3. to_date.mp4 |
28.39MB |
| 3. to_date.vtt |
7.02KB |
| 3. Total numbers of orders shipped to USA or France.mp4 |
9.17MB |
| 3. Total numbers of orders shipped to USA or France.vtt |
1.98KB |
| 3. Types of triggers.mp4 |
11.78MB |
| 3. Types of triggers.vtt |
3.13KB |
| 3. Understanding the use of stored procedures.mp4 |
25.48MB |
| 3. Understanding the use of stored procedures.vtt |
6.43KB |
| 3. UNION tables with different number of columns.mp4 |
13.76MB |
| 3. UNION tables with different number of columns.vtt |
4.06KB |
| 3. UNIQUE constraint.mp4 |
60.12MB |
| 3. UNIQUE constraint.vtt |
18.46KB |
| 3. Using aggregate functions.mp4 |
47.50MB |
| 3. Using aggregate functions.vtt |
10.54KB |
| 3. Using inclusion operators.mp4 |
34.95MB |
| 3. Using inclusion operators.vtt |
5.72KB |
| 3. Using tsquery with operators.mp4 |
149.99MB |
| 3. Using tsquery with operators.vtt |
18.55KB |
| 30. Exception with data exception errors.mp4 |
67.47MB |
| 30. Exception with data exception errors.vtt |
8.70KB |
| 30. Expression Index.mp4 |
119.84MB |
| 30. Expression Index.vtt |
18.78KB |
| 30. Using OVER() to calculate percentage.mp4 |
24.60MB |
| 30. Using OVER() to calculate percentage.vtt |
7.60KB |
| 31. Adding data while indexing.mp4 |
11.58MB |
| 31. Adding data while indexing.vtt |
3.93KB |
| 31. Calculate difference compared to average.mp4 |
25.28MB |
| 31. Calculate difference compared to average.vtt |
7.17KB |
| 32. Calculating cumulative totals.mp4 |
21.13MB |
| 32. Calculating cumulative totals.vtt |
6.76KB |
| 32. Invalidating an index.mp4 |
98.80MB |
| 32. Invalidating an index.vtt |
10.51KB |
| 33. Rebuilding an index.mp4 |
29.37MB |
| 33. Rebuilding an index.vtt |
8.95KB |
| 33. Using LEAD to compare with next values.mp4 |
21.25MB |
| 33. Using LEAD to compare with next values.vtt |
7.29KB |
| 34. Comparing with least number.mp4 |
46.89MB |
| 34. Comparing with least number.vtt |
11.20KB |
| 35. Window Function Summary.mp4 |
16.42MB |
| 35. Window Function Summary.vtt |
6.00KB |
| 36. Planning tips on using Window Functions.mp4 |
16.72MB |
| 36. Planning tips on using Window Functions.vtt |
8.62KB |
| 37. Difference between RANK and DENSE_RANK.mp4 |
12.00MB |
| 37. Difference between RANK and DENSE_RANK.vtt |
3.64KB |
| 38. Getting RANK to compute group and global ranks.mp4 |
20.62MB |
| 38. Getting RANK to compute group and global ranks.vtt |
6.00KB |
| 39. Using PARTITION BY for group averages.mp4 |
26.69MB |
| 39. Using PARTITION BY for group averages.vtt |
7.10KB |
| 4. Array constructions.mp4 |
21.23MB |
| 4. Array constructions.vtt |
6.76KB |
| 4. Combining AND, OR operators.mp4 |
32.15MB |
| 4. Combining AND, OR operators.vtt |
6.24KB |
| 4. Create a sequence using a specific data type.mp4 |
11.54MB |
| 4. Create a sequence using a specific data type.vtt |
2.54KB |
| 4. CREATE DOMAIN - Create a domain data type for an email validation.mp4 |
14.42MB |
| 4. CREATE DOMAIN - Create a domain data type for an email validation.vtt |
3.55KB |
| 4. Creating a cursor.mp4 |
35.16MB |
| 4. Creating a cursor.vtt |
11.27KB |
| 4. Creating a Database User.mp4 |
11.54MB |
| 4. Creating a Database User.vtt |
5.29KB |
| 4. Creating the movies table with a foreign key.mp4 |
20.44MB |
| 4. Creating the movies table with a foreign key.vtt |
6.29KB |
| 4. DECIMALS.mp4 |
42.40MB |
| 4. DECIMALS.vtt |
13.90KB |
| 4. DEFAULT constraint.mp4 |
22.15MB |
| 4. DEFAULT constraint.vtt |
5.54KB |
| 4. Delete a view.mp4 |
6.77MB |
| 4. Delete a view.vtt |
2.49KB |
| 4. Exploring JSON objects.mp4 |
26.58MB |
| 4. Exploring JSON objects.vtt |
8.45KB |
| 4. Export Data to CSV files.mp4 |
30.14MB |
| 4. Export Data to CSV files.vtt |
3.12KB |
| 4. Full text search within a table.mp4 |
63.36MB |
| 4. Full text search within a table.vtt |
17.76KB |
| 4. Function returning a single value.mp4 |
50.02MB |
| 4. Function returning a single value.vtt |
15.35KB |
| 4. Functions vs stored procedures.mp4 |
17.39MB |
| 4. Functions vs stored procedures.vtt |
5.29KB |
| 4. Get highest, lowest, total, and average salaries of employees.mp4 |
14.65MB |
| 4. Get highest, lowest, total, and average salaries of employees.vtt |
4.21KB |
| 4. Get the total revenues for each director.html |
732B |
| 4. GROUP BY ROLLUP.mp4 |
21.58MB |
| 4. GROUP BY ROLLUP.vtt |
6.80KB |
| 4. How to calculate cube root in PostgreSQL.mp4 |
6.83MB |
| 4. How to calculate cube root in PostgreSQL.vtt |
1.67KB |
| 4. INNER joins with filter data Part 2.mp4 |
22.33MB |
| 4. INNER joins with filter data Part 2.vtt |
4.03KB |
| 4. INTERSECT with tables.mp4 |
17.05MB |
| 4. INTERSECT with tables.vtt |
5.52KB |
| 4. List all columns from a table.mp4 |
11.85MB |
| 4. List all columns from a table.vtt |
3.40KB |
| 4. List all indexes.mp4 |
17.70MB |
| 4. List all indexes.vtt |
5.15KB |
| 4. List all table space, schemas, and indices.mp4 |
14.08MB |
| 4. List all table space, schemas, and indices.vtt |
4.27KB |
| 4. MIN and MAX functions.mp4 |
68.24MB |
| 4. MIN and MAX functions.vtt |
15.49KB |
| 4. Move a table to a new schema.mp4 |
10.83MB |
| 4. Move a table to a new schema.vtt |
3.84KB |
| 4. Orders matters in crosstab reports.mp4 |
12.43MB |
| 4. Orders matters in crosstab reports.vtt |
4.00KB |
| 4. Orders shipped to latin america.mp4 |
17.04MB |
| 4. Orders shipped to latin america.vtt |
3.88KB |
| 4. Partition types.mp4 |
12.04MB |
| 4. Partition types.vtt |
3.22KB |
| 4. PLpgSQL block structure.mp4 |
10.03MB |
| 4. PLpgSQL block structure.vtt |
2.78KB |
| 4. POSIX regular expressions.mp4 |
22.24MB |
| 4. POSIX regular expressions.vtt |
6.68KB |
| 4. q_creating the movies table with a foreign key.sql |
258B |
| 4. q_use RETURNING to get info on added rows.sql |
224B |
| 4. Returning a value.mp4 |
26.25MB |
| 4. Returning a value.vtt |
4.74KB |
| 4. SPLIT_PART.mp4 |
32.87MB |
| 4. SPLIT_PART.vtt |
8.69KB |
| 4. Strings to Dates conversions.mp4 |
60.86MB |
| 4. Strings to Dates conversions.vtt |
14.86KB |
| 4. Subquery with JOINs.mp4 |
47.32MB |
| 4. Subquery with JOINs.vtt |
10.32KB |
| 4. Table data conversion.mp4 |
29.57MB |
| 4. Table data conversion.vtt |
10.16KB |
| 4. Thank You!.mp4 |
2.40MB |
| 4. Thank You!.vtt |
929B |
| 4. to_timestamp.mp4 |
30.88MB |
| 4. to_timestamp.vtt |
5.95KB |
| 4. Transaction setup.mp4 |
9.74MB |
| 4. Transaction setup.vtt |
3.21KB |
| 4. Trigger table.mp4 |
11.14MB |
| 4. Trigger table.vtt |
3.45KB |
| 4. Use pgAdmin to create roles.mp4 |
13.98MB |
| 4. Use pgAdmin to create roles.vtt |
5.24KB |
| 4. Use RETURNING to get info on added rows.mp4 |
11.07MB |
| 4. Use RETURNING to get info on added rows.vtt |
3.36KB |
| 4. Using GROUPING with ROLLUP.mp4 |
112.38MB |
| 4. Using GROUPING with ROLLUP.vtt |
17.69KB |
| 4. Using HAVING.mp4 |
84.91MB |
| 4. Using HAVING.vtt |
13.88KB |
| 4. Using SELECT statement for expressions.mp4 |
13.45MB |
| 4. Using SELECT statement for expressions.vtt |
3.59KB |
| 40. Using WITH clause to create your own data.mp4 |
14.17MB |
| 40. Using WITH clause to create your own data.vtt |
4.88KB |
| 41. Using WITH clause to set ORDER BY values.mp4 |
25.23MB |
| 41. Using WITH clause to set ORDER BY values.vtt |
8.57KB |
| 42. DELETE and INSERT in one query using WITH.mp4 |
23.13MB |
| 42. DELETE and INSERT in one query using WITH.vtt |
6.09KB |
| 5. Array metadata functions.mp4 |
36.63MB |
| 5. Array metadata functions.vtt |
10.86KB |
| 5. CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 |
17.26MB |
| 5. CREATE DOMAIN - Create a Enum or Set of values domain data type.vtt |
4.85KB |
| 5. Create our first table with JSONB data type.mp4 |
31.66MB |
| 5. Create our first table with JSONB data type.vtt |
9.67KB |
| 5. Creating a Database.mp4 |
10.55MB |
| 5. Creating a Database.vtt |
3.39KB |
| 5. Creating a descending sequence, and CYCLE sequence.mp4 |
18.86MB |
| 5. Creating a descending sequence, and CYCLE sequence.vtt |
5.48KB |
| 5. Creating the movies_revenues table.mp4 |
13.09MB |
| 5. Creating the movies_revenues table.vtt |
3.80KB |
| 5. Database Level Security.mp4 |
23.25MB |
| 5. Database Level Security.vtt |
6.54KB |
| 5. Declaring variables.mp4 |
23.38MB |
| 5. Declaring variables.vtt |
7.61KB |
| 5. Deleting duplicate records.mp4 |
30.92MB |
| 5. Deleting duplicate records.vtt |
9.35KB |
| 5. Difference bw highest and lowest salaries by job_id.mp4 |
5.27MB |
| 5. Difference bw highest and lowest salaries by job_id.vtt |
1.41KB |
| 5. Drop a procedure.mp4 |
6.75MB |
| 5. Drop a procedure.vtt |
2.46KB |
| 5. EXCEPT with tables.mp4 |
22.24MB |
| 5. EXCEPT with tables.vtt |
7.31KB |
| 5. Function returning a single value Part 2.mp4 |
28.61MB |
| 5. Function returning a single value Part 2.vtt |
6.36KB |
| 5. Get total revenues for all 'English' films.html |
970B |
| 5. GREATEST AND LEAST functions.mp4 |
20.98MB |
| 5. GREATEST AND LEAST functions.vtt |
6.41KB |
| 5. INNER joins with filter data Part 3.mp4 |
32.43MB |
| 5. INNER joins with filter data Part 3.vtt |
5.93KB |
| 5. List all sequences, roles, data types, domain data types.mp4 |
83.40MB |
| 5. List all sequences, roles, data types, domain data types.vtt |
8.95KB |
| 5. Opening a cursor.mp4 |
42.50MB |
| 5. Opening a cursor.vtt |
11.99KB |
| 5. Order of execution in HAVING clause.mp4 |
4.08MB |
| 5. Order of execution in HAVING clause.vtt |
1.26KB |
| 5. Partition by Range.mp4 |
102.50MB |
| 5. Partition by Range.vtt |
25.99KB |
| 5. Pivoting with Rainfalls data.mp4 |
45.92MB |
| 5. Pivoting with Rainfalls data.vtt |
13.05KB |
| 5. president_speeches.csv |
1.12MB |
| 5. PRIMARY KEY Constraints.mp4 |
88.73MB |
| 5. PRIMARY KEY Constraints.vtt |
25.97KB |
| 5. Pros and Cons of triggers.mp4 |
52.74MB |
| 5. Pros and Cons of triggers.vtt |
14.07KB |
| 5. q_creating the movies_revenues table.sql |
216B |
| 5. q_update_data_in_a_table.sql |
165B |
| 5. rainfalldata.sql |
10.93KB |
| 5. ROLLUP - Grouping multiple columns.mp4 |
17.39MB |
| 5. ROLLUP - Grouping multiple columns.vtt |
4.90KB |
| 5. Schema search path.mp4 |
155.07MB |
| 5. Schema search path.vtt |
17.84KB |
| 5. Selecting Numbers data types.mp4 |
25.53MB |
| 5. Selecting Numbers data types.vtt |
7.32KB |
| 5. Setup presidents speeches data.mp4 |
46.32MB |
| 5. Setup presidents speeches data.vtt |
8.38KB |
| 5. Show total order amount for each order.mp4 |
18.71MB |
| 5. Show total order amount for each order.vtt |
4.85KB |
| 5. Simultaneously DELETE INSERT via CTE.mp4 |
32.31MB |
| 5. Simultaneously DELETE INSERT via CTE.vtt |
9.40KB |
| 5. Size of the table index.mp4 |
20.21MB |
| 5. Size of the table index.vtt |
6.01KB |
| 5. SUBSTRING with regular expressions.mp4 |
195.52MB |
| 5. SUBSTRING with regular expressions.vtt |
23.56KB |
| 5. Transaction analysis.mp4 |
56.05MB |
| 5. Transaction analysis.vtt |
19.71KB |
| 5. TRIM, BTRIM, LTRIM and RTRIM.mp4 |
27.17MB |
| 5. TRIM, BTRIM, LTRIM and RTRIM.vtt |
9.03KB |
| 5. Update data in a table.mp4 |
18.84MB |
| 5. Update data in a table.vtt |
3.58KB |
| 5. User-defined functions.mp4 |
16.48MB |
| 5. User-defined functions.vtt |
3.99KB |
| 5. Using filters with views.mp4 |
40.57MB |
| 5. Using filters with views.vtt |
8.67KB |
| 5. Using ORDER BY to sort records.mp4 |
43.20MB |
| 5. Using ORDER BY to sort records.vtt |
8.05KB |
| 5. Using TO_TIMESTAMP function.mp4 |
43.81MB |
| 5. Using TO_TIMESTAMP function.vtt |
12.28KB |
| 5. View system metadata via system information functions.mp4 |
11.03MB |
| 5. View system metadata via system information functions.vtt |
3.17KB |
| 5. What goes before and after WHERE clause.mp4 |
14.20MB |
| 5. What goes before and after WHERE clause.vtt |
3.61KB |
| 6. Alter a schema ownership.mp4 |
8.50MB |
| 6. Alter a schema ownership.vtt |
2.49KB |
| 6. Analyzing presidents speeches text data.mp4 |
42.84MB |
| 6. Analyzing presidents speeches text data.vtt |
10.06KB |
| 6. Array search functions.mp4 |
29.08MB |
| 6. Array search functions.vtt |
8.80KB |
| 6. A view with UNION of multiple tables.mp4 |
23.19MB |
| 6. A view with UNION of multiple tables.vtt |
5.36KB |
| 6. Backup your databases regularly.html |
929B |
| 6. CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 |
9.29MB |
| 6. CREATE DOMAIN - Get the list of all DOMAIN data types.vtt |
2.71KB |
| 6. Creating a Junction table with movies and actors tables.mp4 |
15.60MB |
| 6. Creating a Junction table with movies and actors tables.vtt |
4.48KB |
| 6. DateTime data types.mp4 |
15.84MB |
| 6. DateTime data types.vtt |
4.77KB |
| 6. Declaring variables via ALIAS FOR.mp4 |
6.41MB |
| 6. Declaring variables via ALIAS FOR.vtt |
1.93KB |
| 6. Delete a sequence.mp4 |
5.62MB |
| 6. Delete a sequence.vtt |
1.73KB |
| 6. Describe a table.mp4 |
3.94MB |
| 6. Describe a table.vtt |
1.27KB |
| 6. Execution order with AND, OR operators.mp4 |
9.33MB |
| 6. Execution order with AND, OR operators.vtt |
2.17KB |
| 6. First the oldest and latest order date.mp4 |
8.32MB |
| 6. First the oldest and latest order date.vtt |
2.43KB |
| 6. Formatting Dates.mp4 |
60.72MB |
| 6. Formatting Dates.vtt |
13.90KB |
| 6. Function returning a single value Part 3.mp4 |
26.30MB |
| 6. Function returning a single value Part 3.vtt |
4.05KB |
| 6. Get lowest paid salaries by each manager.mp4 |
8.32MB |
| 6. Get lowest paid salaries by each manager.vtt |
2.30KB |
| 6. GREATEST vs. MAX().html |
2.01KB |
| 6. GROUP BY CUBE.mp4 |
20.01MB |
| 6. GROUP BY CUBE.vtt |
6.34KB |
| 6. HAVING vs WHERE.mp4 |
22.76MB |
| 6. HAVING vs WHERE.vtt |
6.78KB |
| 6. How to fix aborted transaction.mp4 |
15.17MB |
| 6. How to fix aborted transaction.vtt |
4.96KB |
| 6. INNER joins with different data type columns.mp4 |
20.42MB |
| 6. INNER joins with different data type columns.vtt |
6.07KB |
| 6. List counts of all indexes.mp4 |
20.07MB |
| 6. List counts of all indexes.vtt |
5.61KB |
| 6. LPAD and RPAD.mp4 |
32.28MB |
| 6. LPAD and RPAD.vtt |
7.14KB |
| 6. Order entries in UNION without using ORDER BY.mp4 |
17.26MB |
| 6. Order entries in UNION without using ORDER BY.vtt |
5.29KB |
| 6. Partition by List.mp4 |
130.41MB |
| 6. Partition by List.vtt |
31.73KB |
| 6. Pivoting rows and columns.mp4 |
21.34MB |
| 6. Pivoting rows and columns.vtt |
5.30KB |
| 6. PRIMARY KEY Constraints on multiple columns.mp4 |
55.57MB |
| 6. PRIMARY KEY Constraints on multiple columns.vtt |
17.02KB |
| 6. q_creating a junction table with movies and actors table.sql |
184B |
| 6. q_updating_a_row_and_returning_the_updated_row.sql |
102B |
| 6. Recursive CTEs.mp4 |
19.03MB |
| 6. Recursive CTEs.vtt |
6.24KB |
| 6. REGEXP_MATCHES Function.mp4 |
39.46MB |
| 6. REGEXP_MATCHES Function.vtt |
12.82KB |
| 6. Running a query in pgAdmin tool.mp4 |
5.70MB |
| 6. Running a query in pgAdmin tool.vtt |
2.71KB |
| 6. Schema Level Security.mp4 |
48.70MB |
| 6. Schema Level Security.vtt |
13.62KB |
| 6. Structure of a function.mp4 |
11.67MB |
| 6. Structure of a function.vtt |
3.33KB |
| 6. Trigger key points.mp4 |
10.89MB |
| 6. Trigger key points.vtt |
3.46KB |
| 6. Update and Delete JSON Data.mp4 |
53.02MB |
| 6. Update and Delete JSON Data.vtt |
14.85KB |
| 6. Updating a row and returning the updated row.mp4 |
10.84MB |
| 6. Updating a row and returning the updated row.vtt |
2.60KB |
| 6. Using a cursor.mp4 |
37.38MB |
| 6. Using a cursor.vtt |
8.27KB |
| 6. Using ORDER BY with alias column name.mp4 |
13.57MB |
| 6. Using ORDER BY with alias column name.vtt |
3.41KB |
| 6. View privileges information across tables.mp4 |
48.61MB |
| 6. View privileges information across tables.vtt |
10.12KB |
| 7. Array modification functions.mp4 |
30.04MB |
| 7. Array modification functions.vtt |
8.63KB |
| 7. Attach a sequence to a table column.mp4 |
36.39MB |
| 7. Attach a sequence to a table column.vtt |
9.19KB |
| 7. Average salary for each department with more than 10 employees.mp4 |
9.95MB |
| 7. Average salary for each department with more than 10 employees.vtt |
2.61KB |
| 7. Average with AVG function.mp4 |
61.36MB |
| 7. Average with AVG function.vtt |
15.78KB |
| 7. Can we use column aliases with WHERE.mp4 |
9.13MB |
| 7. Can we use column aliases with WHERE.vtt |
2.91KB |
| 7. Connecting multiple tables with a single view.mp4 |
42.27MB |
| 7. Connecting multiple tables with a single view.vtt |
8.95KB |
| 7. CREATE DOMAIN - How to drop a domain data type.mp4 |
20.88MB |
| 7. CREATE DOMAIN - How to drop a domain data type.vtt |
6.29KB |
| 7. Create JSON from tables.mp4 |
28.29MB |
| 7. Create JSON from tables.vtt |
6.02KB |
| 7. DATE.mp4 |
25.75MB |
| 7. DATE.vtt |
7.87KB |
| 7. Date construction functions.mp4 |
26.82MB |
| 7. Date construction functions.vtt |
7.28KB |
| 7. Declaring variables in function.mp4 |
20.98MB |
| 7. Declaring variables in function.vtt |
6.35KB |
| 7. Drop a index.mp4 |
14.95MB |
| 7. Drop a index.vtt |
4.67KB |
| 7. Duplicate a schema along with all data.mp4 |
40.70MB |
| 7. Duplicate a schema along with all data.vtt |
7.86KB |
| 7. Edit SQL commands in editor.mp4 |
4.96MB |
| 7. Edit SQL commands in editor.vtt |
1.39KB |
| 7. FOREIGN KEY Constraints.mp4 |
17.48MB |
| 7. FOREIGN KEY Constraints.vtt |
7.86KB |
| 7. Function using parameters.mp4 |
75.33MB |
| 7. Function using parameters.vtt |
16.01KB |
| 7. GROUP BY GROUPING SETS.mp4 |
19.43MB |
| 7. GROUP BY GROUPING SETS.vtt |
4.68KB |
| 7. Handling NULL values with GROUP BY.mp4 |
40.73MB |
| 7. Handling NULL values with GROUP BY.vtt |
12.91KB |
| 7. How to fix transactions on crash.mp4 |
31.71MB |
| 7. How to fix transactions on crash.vtt |
7.15KB |
| 7. Install sample data files on server.mp4 |
10.51MB |
| 7. Install sample data files on server.vtt |
3.06KB |
| 7. Install sample data for 'movies' database.mp4 |
41.02MB |
| 7. Install sample data for 'movies' database.vtt |
6.97KB |
| 7. internal - view system administration functions.mp4 |
89.29MB |
| 7. internal - view system administration functions.vtt |
6.65KB |
| 7. LEFT joins Part 1.mp4 |
87.09MB |
| 7. LEFT joins Part 1.vtt |
11.31KB |
| 7. LENGTH.mp4 |
16.61MB |
| 7. LENGTH.vtt |
5.04KB |
| 7. Matrix report via a query.mp4 |
42.12MB |
| 7. Matrix report via a query.vtt |
12.31KB |
| 7. Parent-child relationship via recursive CTE.mp4 |
74.07MB |
| 7. Parent-child relationship via recursive CTE.vtt |
25.48KB |
| 7. Partition by Hash.mp4 |
62.84MB |
| 7. Partition by Hash.vtt |
19.08KB |
| 7. q_updating_all_records_in_a_table.sql |
62B |
| 7. Ranking and Normalizing text results.mp4 |
23.75MB |
| 7. Ranking and Normalizing text results.vtt |
6.47KB |
| 7. REGEXP_REPLACE Function.mp4 |
30.69MB |
| 7. REGEXP_REPLACE Function.vtt |
11.23KB |
| 7. sample_data.zip |
1.41MB |
| 7. sample_data.zip |
1.41MB |
| 7. Steps to create a trigger.mp4 |
23.35MB |
| 7. Steps to create a trigger.vtt |
6.69KB |
| 7. Subquery with an alias.mp4 |
6.90MB |
| 7. Subquery with an alias.vtt |
1.75KB |
| 7. Table Level Security.mp4 |
70.33MB |
| 7. Table Level Security.vtt |
13.24KB |
| 7. Test queries on a test database.html |
893B |
| 7. Total products in each categories.mp4 |
15.01MB |
| 7. Total products in each categories.vtt |
4.87KB |
| 7. Updating all records in a table.mp4 |
13.08MB |
| 7. Updating all records in a table.vtt |
3.55KB |
| 7. Updating data.mp4 |
7.62MB |
| 7. Updating data.vtt |
2.08KB |
| 7. Using ORDER BY to sort rows by expressions.mp4 |
15.75MB |
| 7. Using ORDER BY to sort rows by expressions.vtt |
4.02KB |
| 7. Using system Administration functions.mp4 |
27.75MB |
| 7. Using system Administration functions.vtt |
6.69KB |
| 8. 2021-04-01_15-33-06-faabd956903cfa4c427d171bb035faff.png |
98.38KB |
| 8. 2021-04-01_15-33-22-3cc7c77c6f93d169a2ca456613da1080.png |
58.46KB |
| 8. Aggregate over filter.mp4 |
57.46MB |
| 8. Aggregate over filter.vtt |
6.34KB |
| 8. Array comparison with IN, ALL, ANY and SOME.mp4 |
55.43MB |
| 8. Array comparison with IN, ALL, ANY and SOME.vtt |
17.12KB |
| 8. A SELECT without a FROM.mp4 |
10.14MB |
| 8. A SELECT without a FROM.vtt |
3.10KB |
| 8. Average salary for each post excluding programmer.mp4 |
7.75MB |
| 8. Average salary for each post excluding programmer.vtt |
1.74KB |
| 8. Closing a cursor.mp4 |
5.84MB |
| 8. Closing a cursor.vtt |
1.76KB |
| 8. Column Level Security.mp4 |
34.86MB |
| 8. Column Level Security.vtt |
10.39KB |
| 8. Combining Columns using Mathematical operators.mp4 |
44.96MB |
| 8. Combining Columns using Mathematical operators.vtt |
13.71KB |
| 8. Create a sample Database mydata.html |
1.22KB |
| 8. CREATE TYPE - Create a composite address object.mp4 |
26.88MB |
| 8. CREATE TYPE - Create a composite address object.vtt |
7.14KB |
| 8. Data auditing with a trigger.mp4 |
45.78MB |
| 8. Data auditing with a trigger.vtt |
14.20KB |
| 8. DEFAULT Partition.mp4 |
33.09MB |
| 8. DEFAULT Partition.vtt |
8.35KB |
| 8. Delete data from a table.mp4 |
13.12MB |
| 8. Delete data from a table.vtt |
3.65KB |
| 8. Display command history, run commands from a file.mp4 |
12.37MB |
| 8. Display command history, run commands from a file.vtt |
3.81KB |
| 8. Function using parameters Part 2.mp4 |
28.37MB |
| 8. Function using parameters Part 2.vtt |
6.31KB |
| 8. Install Human Resources (hr) database.mp4 |
8.17MB |
| 8. Install Human Resources (hr) database.vtt |
2.52KB |
| 8. LEFT joins Part 2.mp4 |
42.81MB |
| 8. LEFT joins Part 2.vtt |
8.54KB |
| 8. List all sequences in a database.mp4 |
5.99MB |
| 8. List all sequences in a database.vtt |
1.56KB |
| 8. List products that needs re-ordering.mp4 |
13.52MB |
| 8. List products that needs re-ordering.vtt |
4.11KB |
| 8. Not documenting your process.html |
720B |
| 8. Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 |
6.29MB |
| 8. Order of execution of WHERE, SELECT and ORDER BY clauses.vtt |
1.63KB |
| 8. Partial transaction rollback with savepoints.mp4 |
15.30MB |
| 8. Partial transaction rollback with savepoints.vtt |
4.58KB |
| 8. POSITION.mp4 |
14.70MB |
| 8. POSITION.vtt |
4.07KB |
| 8. q_delete_data_from_a_table.sql |
96B |
| 8. q_variable_initialization_timing.sql |
192B |
| 8. Query performance check.mp4 |
21.64MB |
| 8. Query performance check.vtt |
6.17KB |
| 8. Re-arrange columns in a view.mp4 |
11.96MB |
| 8. Re-arrange columns in a view.vtt |
4.22KB |
| 8. REGEXP_SPLIT_TO_TABLE Function.mp4 |
5.69MB |
| 8. REGEXP_SPLIT_TO_TABLE Function.vtt |
1.88KB |
| 8. sample_data.zip |
1.41MB |
| 8. Show all running queries.mp4 |
21.48MB |
| 8. Show all running queries.vtt |
5.31KB |
| 8. SQL Statement execution process.mp4 |
18.02MB |
| 8. SQL Statement execution process.vtt |
5.44KB |
| 8. Tables without foreign key constraints.mp4 |
51.45MB |
| 8. Tables without foreign key constraints.vtt |
8.71KB |
| 8. TIME.mp4 |
60.60MB |
| 8. TIME.vtt |
18.23KB |
| 8. Use json_agg to aggregate data.mp4 |
28.73MB |
| 8. Use json_agg to aggregate data.vtt |
6.31KB |
| 8. Using MAKE_INTERVAL function.mp4 |
37.02MB |
| 8. Using MAKE_INTERVAL function.vtt |
8.72KB |
| 8. Using ORDER BY with column name or column number.mp4 |
17.60MB |
| 8. Using ORDER BY with column name or column number.vtt |
3.97KB |
| 8. Variable initializing timing.mp4 |
8.82MB |
| 8. Variable initializing timing.vtt |
2.85KB |
| 8. What is a system catalog schema.mp4 |
26.30MB |
| 8. What is a system catalog schema.vtt |
5.86KB |
| 9. Bind a function to a table with trigger.mp4 |
35.41MB |
| 9. Bind a function to a table with trigger.vtt |
10.78KB |
| 9. Build a JSON array.mp4 |
17.30MB |
| 9. Build a JSON array.vtt |
5.81KB |
| 9. Built-in syntax reference for commands.mp4 |
4.37MB |
| 9. Built-in syntax reference for commands.vtt |
1.18KB |
| 9. Compare tables and columns in two schemas.mp4 |
47.19MB |
| 9. Compare tables and columns in two schemas.vtt |
9.86KB |
| 9. Copying data types.mp4 |
11.52MB |
| 9. Copying data types.vtt |
3.53KB |
| 9. Correlated Queries.mp4 |
51.67MB |
| 9. Correlated Queries.vtt |
16.08KB |
| 9. CREATE TYPE - Create a composite inventory_item data type.mp4 |
16.81MB |
| 9. CREATE TYPE - Create a composite inventory_item data type.vtt |
4.23KB |
| 9. Creating a PLPGSQL Cursor.mp4 |
45.64MB |
| 9. Creating a PLPGSQL Cursor.vtt |
12.98KB |
| 9. Creating foreign key constraints.mp4 |
32.19MB |
| 9. Creating foreign key constraints.vtt |
9.69KB |
| 9. Database operations and table size.mp4 |
27.78MB |
| 9. Database operations and table size.vtt |
7.07KB |
| 9. Delete a column in a view.mp4 |
7.19MB |
| 9. Delete a column in a view.vtt |
2.57KB |
| 9. Formatting and converting an array.mp4 |
36.92MB |
| 9. Formatting and converting an array.vtt |
12.02KB |
| 9. Freight analysis.mp4 |
48.15MB |
| 9. Freight analysis.vtt |
12.39KB |
| 9. Function using parameters Part 3.mp4 |
132.67MB |
| 9. Function using parameters Part 3.vtt |
16.57KB |
| 9. Install sample stocks market data.mp4 |
28.30MB |
| 9. Install sample stocks market data.vtt |
2.51KB |
| 9. LEFT joins Part 3.mp4 |
51.05MB |
| 9. LEFT joins Part 3.vtt |
10.35KB |
| 9. Maximum salary for each post where salary is at or above $5000.mp4 |
9.25MB |
| 9. Maximum salary for each post where salary is at or above $5000.vtt |
2.30KB |
| 9. Multi-level partitioning.mp4 |
62.18MB |
| 9. Multi-level partitioning.vtt |
17.76KB |
| 9. q_upsert.sql |
618B |
| 9. REGEXP_SPLIT_TO_ARRAY function.mp4 |
12.92MB |
| 9. REGEXP_SPLIT_TO_ARRAY function.vtt |
3.60KB |
| 9. Row Level Security.mp4 |
169.16MB |
| 9. Row Level Security.vtt |
17.97KB |
| 9. sample_data.zip |
1.41MB |
| 9. Share one sequence between two tables.mp4 |
16.03MB |
| 9. Share one sequence between two tables.vtt |
4.15KB |
| 9. SQL statement execution stages.mp4 |
28.05MB |
| 9. SQL statement execution stages.vtt |
7.68KB |
| 9. Static to dynamic pivots.mp4 |
28.84MB |
| 9. Static to dynamic pivots.vtt |
8.68KB |
| 9. STRPOS.mp4 |
32.50MB |
| 9. STRPOS.vtt |
6.08KB |
| 9. Terminate running and IDLE process.mp4 |
11.90MB |
| 9. Terminate running and IDLE process.vtt |
3.27KB |
| 9. TIMESTAMP and TIMESTAMPTZ.mp4 |
54.71MB |
| 9. TIMESTAMP and TIMESTAMPTZ.vtt |
15.53KB |
| 9. Using FILTER clause.mp4 |
22.29MB |
| 9. Using FILTER clause.vtt |
6.54KB |
| 9. Using Logical operators.mp4 |
90.21MB |
| 9. Using Logical operators.vtt |
19.90KB |
| 9. Using MAKE_TIMESTAMPTZ function.mp4 |
57.66MB |
| 9. Using MAKE_TIMESTAMPTZ function.vtt |
12.27KB |
| 9. Using ORDER BY with NULL values.mp4 |
22.84MB |
| 9. Using ORDER BY with NULL values.vtt |
7.49KB |
| 9. Using pgAdmin - Create and modify a table.mp4 |
21.17MB |
| 9. Using pgAdmin - Create and modify a table.vtt |
5.72KB |
| 9. Using SAVEPOINT with transaction.mp4 |
23.16MB |
| 9. Using SAVEPOINT with transaction.vtt |
7.91KB |
| 9. Using UPSERT.mp4 |
38.29MB |
| 9. Using UPSERT.vtt |
12.27KB |