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