Udemy - PostgreSQL Bootcamp Go From Beginner to Advanced, 60+hours (10.2023)

Creation Time	Sept. 24, 2025, 12:19 p.m.
Last Access Time	Sept. 25, 2025, 11:07 a.m.
File Size	19.6 GB
Keywords	hours PostgreSQL Beginner 10 - Bootcamp 60 to 2023 Go From Udemy Advanced
Total Requests	9
Total Files	1276
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

29. Using regular expressions for text patterns/5. SUBSTRING with regular expressions.mp4 195.5 MB
28. Window Functions/15. Understanding window frames.mp4 184.8 MB
44. Managing PostgreSQL security/9. Row Level Security.mp4 169.2 MB
20. PostgreSQL Schemas/5. Schema search path.mp4 155.1 MB
30. Powerful text searches in PostgreSQL/3. Using tsquery with operators.mp4 150.0 MB
33. Functions with SQL language/9. Function using parameters Part 3.mp4 132.7 MB
31. Table Partitions/6. Partition by List.mp4 130.4 MB
23. Indexes and Performance Optimization/30. Expression Index.mp4 119.8 MB
48. Extended PostgreSQL/1. Create a custom index method.mp4 119.2 MB
16. Using DATETIME functions/22. date_part function.mp4 119.0 MB
27. Grouping sets/2. Subtotals on group sets.mp4 114.5 MB
27. Grouping sets/4. Using GROUPING with ROLLUP.mp4 112.4 MB
31. Table Partitions/5. Partition by Range.mp4 102.5 MB
23. Indexes and Performance Optimization/27. Using organized vs random data.mp4 99.4 MB
23. Indexes and Performance Optimization/32. Invalidating an index.mp4 98.8 MB
28. Window Functions/2. Analyze Global Trades Data.mp4 96.6 MB
37. Using Cursors/10. Using a parametric cursor via function.mp4 92.1 MB
06. Filtering Data/9. Using Logical operators.mp4 90.2 MB
38. Creating Crosstab Reports/11. Dynamic pivot table columns.mp4 90.1 MB
46. PostgreSQL Internals/7. internal - view system administration functions.mp4 89.3 MB
12. Explore PostgreSQL Constraints/5. PRIMARY KEY Constraints.mp4 88.7 MB
06. Filtering Data/10. Using LIMIT and OFFSET.mp4 88.7 MB
06. Filtering Data/14. Using LIKE and ILIKE.mp4 87.8 MB
18. Joining Multiple Tables/7. LEFT joins Part 1.mp4 87.1 MB
31. Table Partitions/2. When a partition can be used.mp4 86.2 MB
17. Grouping Data/4. Using HAVING.mp4 84.9 MB
36. PostgreSQL Triggers/14. Creating an audit trigger.mp4 84.3 MB
06. Filtering Data/11. Using FETCH.mp4 83.7 MB
45. PostgreSQL Utilities - psql/5. List all sequences, roles, data types, domain data types.mp4 83.4 MB
18. Joining Multiple Tables/1. INNER joins.mp4 82.4 MB
22. JSON with PostgreSQL/17. Indexing on JSONB.mp4 82.0 MB
47. Managing Tables/1. Using SELECT INTO to create a new table with joins.mp4 80.6 MB
33. Functions with SQL language/10. Function using parameters Part 4.mp4 80.1 MB
28. Window Functions/13. Ordering inside window.mp4 79.1 MB
36. PostgreSQL Triggers/15. Creating conditional triggers.mp4 77.8 MB
38. Creating Crosstab Reports/12. Interactive client-side pivot.mp4 77.8 MB
23. Indexes and Performance Optimization/2. Create an index.mp4 77.6 MB
28. Window Functions/22. FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4 77.6 MB
07. PostgreSQL Data types/2. CHAR, VARCHAR and TEXT.mp4 77.0 MB
46. PostgreSQL Internals/11. File layout of PostgreSQL Tables.mp4 75.8 MB
33. Functions with SQL language/7. Function using parameters.mp4 75.3 MB
36. PostgreSQL Triggers/22. Creating an audit event trigger.mp4 75.0 MB
23. Indexes and Performance Optimization/19. The EXPLAIN statement.mp4 74.5 MB
26. Common Table Expressions (CTE)/7. Parent-child relationship via recursive CTE.mp4 74.1 MB
26. Common Table Expressions (CTE)/2. CTE query examples.mp4 73.4 MB
28. Window Functions/21. LEAD and LAG functions.mp4 72.8 MB
18. Joining Multiple Tables/20. Append tables with different columns.mp4 70.6 MB
44. Managing PostgreSQL security/7. Table Level Security.mp4 70.3 MB
44. Managing PostgreSQL security/15. Encrypted data in columns.mp4 69.6 MB
34. Functions with PLpgSQL language/26. Using RETURN NEXT.mp4 69.5 MB
06. Filtering Data/12. Using IN, NOT IN.mp4 68.4 MB
22. JSON with PostgreSQL/13. Getting information from JSON documents.mp4 68.4 MB
15. Aggregate functions/4. MIN and MAX functions.mp4 68.2 MB
33. Functions with SQL language/11. Function returning a composite.mp4 67.6 MB
34. Functions with PLpgSQL language/30. Exception with data exception errors.mp4 67.5 MB
31. Table Partitions/3. Table inheritance.mp4 66.4 MB
25. Fun with subqueries/2. Subqueries with WHERE Clause.mp4 65.8 MB
24. All about Views/24. Using materialized view for websites page analysis.mp4 63.6 MB
30. Powerful text searches in PostgreSQL/4. Full text search within a table.mp4 63.4 MB
21. Exploring array functions/17. Array vs JSONB.mp4 63.1 MB
31. Table Partitions/7. Partition by Hash.mp4 62.8 MB
31. Table Partitions/9. Multi-level partitioning.mp4 62.2 MB
38. Creating Crosstab Reports/13. Handling missing values.mp4 62.1 MB
07. PostgreSQL Data types/14. Network Addresses.mp4 61.8 MB
38. Creating Crosstab Reports/3. Creating a crosstab report - Student Rankings.mp4 61.7 MB
06. Filtering Data/2. AND operator.mp4 61.5 MB
15. Aggregate functions/7. Average with AVG function.mp4 61.4 MB
06. Filtering Data/15. Using IS NULL and IS NOT NULL keywords.mp4 61.2 MB
28. Window Functions/16. ROWS and RANGE indicators.mp4 61.2 MB
17. Grouping Data/2. Using GROUP BY with multiple columns, ORDER BY.mp4 60.9 MB
16. Using DATETIME functions/4. Strings to Dates conversions.mp4 60.9 MB
18. Joining Multiple Tables/14. Joining multiple tables.mp4 60.8 MB
16. Using DATETIME functions/6. Formatting Dates.mp4 60.7 MB
34. Functions with PLpgSQL language/16. CASE Statement.mp4 60.6 MB
07. PostgreSQL Data types/8. TIME.mp4 60.6 MB
16. Using DATETIME functions/21. How to handle timezones.mp4 60.5 MB
12. Explore PostgreSQL Constraints/3. UNIQUE constraint.mp4 60.1 MB
09. Data type conversions/2. Using CAST for data conversions.mp4 59.4 MB
23. Indexes and Performance Optimization/23. Index are not free.mp4 58.5 MB
22. JSON with PostgreSQL/11. Null Values in JSON documents.mp4 58.4 MB
47. Managing Tables/12. Recovering unused space with VACUUM.mp4 58.4 MB
16. Using DATETIME functions/9. Using MAKE_TIMESTAMPTZ function.mp4 57.7 MB
47. Managing Tables/11. PostgreSQL autovacuum proces.mp4 57.7 MB
39. Internationalization/1. Global Character Set Support.mp4 57.5 MB
38. Creating Crosstab Reports/8. Aggregate over filter.mp4 57.5 MB
23. Indexes and Performance Optimization/3. Create unique indexes.mp4 57.1 MB
39. Internationalization/2. Client and Server Encoding.mp4 57.1 MB
18. Joining Multiple Tables/3. INNER joins with filter data Part 1.mp4 56.8 MB
34. Functions with PLpgSQL language/24. Using RETURN QUERY.mp4 56.8 MB
03. Creating and Modifying Tables/11. Using pgAdmin - Rename, delete and change the data type of a column.mp4 56.7 MB
23. Indexes and Performance Optimization/22. Understanding query cost model.mp4 56.6 MB
40. PostgreSQL Transactions/5. Transaction analysis.mp4 56.1 MB
23. Indexes and Performance Optimization/29. Partial indexes.mp4 55.7 MB
17. Grouping Data/1. Using GROUP BY.mp4 55.6 MB
18. Joining Multiple Tables/17. CROSS Joins.mp4 55.6 MB
12. Explore PostgreSQL Constraints/6. PRIMARY KEY Constraints on multiple columns.mp4 55.6 MB
21. Exploring array functions/8. Array comparison with IN, ALL, ANY and SOME.mp4 55.4 MB
33. Functions with SQL language/15. Function as a table source.mp4 55.3 MB
24. All about Views/19. Changing materialized view data.mp4 55.3 MB
33. Functions with SQL language/12. Function returning multiple rows.mp4 55.0 MB
47. Managing Tables/13. Generated Columns.mp4 55.0 MB
07. PostgreSQL Data types/9. TIMESTAMP and TIMESTAMPTZ.mp4 54.7 MB
24. All about Views/2. Creating a view.mp4 54.4 MB
07. PostgreSQL Data types/1. Boolean.mp4 54.4 MB
18. Joining Multiple Tables/11. RIGHT joins.mp4 54.3 MB
19. Combining queries together/1. Combine results sets with UNION.mp4 54.3 MB
28. Window Functions/23. ROW_NUMBER function.mp4 53.7 MB
22. JSON with PostgreSQL/6. Update and Delete JSON Data.mp4 53.0 MB
36. PostgreSQL Triggers/5. Pros and Cons of triggers.mp4 52.7 MB
07. PostgreSQL Data types/13. JSON.mp4 52.4 MB
34. Functions with PLpgSQL language/23. WHILE loop.mp4 52.3 MB
30. Powerful text searches in PostgreSQL/2. Introducing tsvector.mp4 52.1 MB
25. Fun with subqueries/9. Correlated Queries.mp4 51.7 MB
12. Explore PostgreSQL Constraints/8. Tables without foreign key constraints.mp4 51.5 MB
18. Joining Multiple Tables/9. LEFT joins Part 3.mp4 51.1 MB
06. Filtering Data/13. Using BETWEEN and NOT BETWEEN.mp4 50.6 MB
07. PostgreSQL Data types/10. UUID.mp4 50.2 MB
33. Functions with SQL language/1. Creating our first SQL function.mp4 50.1 MB
33. Functions with SQL language/4. Function returning a single value.mp4 50.0 MB
18. Joining Multiple Tables/2. INNER joins with USING.mp4 50.0 MB
36. PostgreSQL Triggers/10. Modify data at INSERT event.mp4 49.3 MB
44. Managing PostgreSQL security/6. Schema Level Security.mp4 48.7 MB
46. PostgreSQL Internals/6. View privileges information across tables.mp4 48.6 MB
05. Querying Data/3. Adding Aliases to columns in a table.mp4 48.4 MB
41. Using Northwind Database/9. Freight analysis.mp4 48.2 MB
16. Using DATETIME functions/23. date_trunc function.mp4 48.1 MB
28. Window Functions/3. Using aggregate functions.mp4 47.5 MB
21. Exploring array functions/16. Using Multi-dimensional arrays.mp4 47.4 MB
25. Fun with subqueries/4. Subquery with JOINs.mp4 47.3 MB
25. Fun with subqueries/12. Using ALL with subquery.mp4 47.2 MB
20. PostgreSQL Schemas/9. Compare tables and columns in two schemas.mp4 47.2 MB
48. Extended PostgreSQL/2. Create a user-defined aggregate function.mp4 47.0 MB
28. Window Functions/34. Comparing with least number.mp4 46.9 MB
16. Using DATETIME functions/11. Using math operators with dates.mp4 46.6 MB
30. Powerful text searches in PostgreSQL/5. Setup presidents speeches data.mp4 46.3 MB
36. PostgreSQL Triggers/2. What is a trigger.mp4 46.1 MB
34. Functions with PLpgSQL language/17. Searched CASE statement.mp4 46.0 MB
38. Creating Crosstab Reports/5. Pivoting with Rainfalls data.mp4 45.9 MB
36. PostgreSQL Triggers/8. Data auditing with a trigger.mp4 45.8 MB
37. Using Cursors/9. Creating a PLPGSQL Cursor.mp4 45.6 MB
12. Explore PostgreSQL Constraints/2. NOT NULL constraint.mp4 45.2 MB
33. Functions with SQL language/17. Function parameters with default values.mp4 45.1 MB
15. Aggregate functions/8. Combining Columns using Mathematical operators.mp4 45.0 MB
19. Combining queries together/2. UNION with filters and conditions.mp4 44.6 MB
16. Using DATETIME functions/1. Datetimes data types.mp4 44.2 MB
30. Powerful text searches in PostgreSQL/1. The Good Ol' Text Search.mp4 44.2 MB
28. Window Functions/25. ROW_NUMBER() - Window with Partition datasets.mp4 44.2 MB
16. Using DATETIME functions/19. Using Date, time, timestamp in tables.mp4 43.9 MB
24. All about Views/16. What is a Materialized View.mp4 43.9 MB
10. Conversion Functions/1. to_char.mp4 43.9 MB
16. Using DATETIME functions/5. Using TO_TIMESTAMP function.mp4 43.8 MB
36. PostgreSQL Triggers/12. Disallow DELETE on a table.mp4 43.2 MB
05. Querying Data/5. Using ORDER BY to sort records.mp4 43.2 MB
07. PostgreSQL Data types/3. NUMERIC.mp4 43.1 MB
08. Modifying Table Structures, Add constraints/3. Add constraints to columns.mp4 42.9 MB
30. Powerful text searches in PostgreSQL/6. Analyzing presidents speeches text data.mp4 42.8 MB
46. PostgreSQL Internals/2. List all database and schemas.mp4 42.8 MB
18. Joining Multiple Tables/8. LEFT joins Part 2.mp4 42.8 MB
37. Using Cursors/1. Understanding row by row operations.mp4 42.8 MB
41. Using Northwind Database/14. Late shipped orders by employees.mp4 42.7 MB
47. Managing Tables/3. Import data from CSV files.mp4 42.7 MB
37. Using Cursors/5. Opening a cursor.mp4 42.5 MB
24. All about Views/14. Updatable views using WITH CHECK OPTION.mp4 42.4 MB
07. PostgreSQL Data types/4. DECIMALS.mp4 42.4 MB
24. All about Views/7. Connecting multiple tables with a single view.mp4 42.3 MB
38. Creating Crosstab Reports/7. Matrix report via a query.mp4 42.1 MB
32. Server Programming/1. PostgreSQL as a development platform.mp4 41.9 MB
12. Explore PostgreSQL Constraints/14. CHECK constraint - Add to new table.mp4 41.8 MB
23. Indexes and Performance Optimization/13. Index Nodes.mp4 41.8 MB
03. Creating and Modifying Tables/7. Install sample data for 'movies' database.mp4 41.0 MB
17. Grouping Data/7. Handling NULL values with GROUP BY.mp4 40.7 MB
20. PostgreSQL Schemas/7. Duplicate a schema along with all data.mp4 40.7 MB
24. All about Views/5. Using filters with views.mp4 40.6 MB
38. Creating Crosstab Reports/10. Dynamic pivot query via JSON.mp4 40.6 MB
14. String Functions/2. LEFT and RIGHT.mp4 40.3 MB
25. Fun with subqueries/11. Using ANY with subquery.mp4 40.3 MB
24. All about Views/15. Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 40.1 MB
34. Functions with PLpgSQL language/10. Assigning variables from query.mp4 40.0 MB
46. PostgreSQL Internals/3. List all tables and views.mp4 39.8 MB
40. PostgreSQL Transactions/1. What is a transaction.mp4 39.7 MB
12. Explore PostgreSQL Constraints/15. CHECK constraint - Add, Rename, Drop on existing table.mp4 39.6 MB
29. Using regular expressions for text patterns/6. REGEXP_MATCHES Function.mp4 39.5 MB
25. Fun with subqueries/10. SELECT.. IN (Subquery).mp4 39.2 MB
05. Querying Data/1. Select all data from a table.mp4 39.1 MB
23. Indexes and Performance Optimization/21. Using EXPLAIN ANALYZE.mp4 39.1 MB
16. Using DATETIME functions/18. Date accuracy with EPOCH.mp4 38.7 MB
31. Table Partitions/11. ALTERing the partition bounds.mp4 38.4 MB
04. Modifying Data in the tables/9. Using UPSERT.mp4 38.3 MB
40. PostgreSQL Transactions/3. ACID Database.mp4 38.2 MB
41. Using Northwind Database/13. Orders with double entry line items.mp4 38.1 MB
15. Aggregate functions/1. Counting results via COUNT function.mp4 38.0 MB
28. Window Functions/20. NTILE function.mp4 38.0 MB
15. Aggregate functions/3. Sum with SUM function.mp4 37.7 MB
24. All about Views/21. Refreshing data in materialize views.mp4 37.7 MB
41. Using Northwind Database/18. First order from each country.mp4 37.6 MB
18. Joining Multiple Tables/10. LEFT joins Part 4.mp4 37.5 MB
37. Using Cursors/6. Using a cursor.mp4 37.4 MB
29. Using regular expressions for text patterns/2. Regular expressions notations table.mp4 37.2 MB
16. Using DATETIME functions/8. Using MAKE_INTERVAL function.mp4 37.0 MB
23. Indexes and Performance Optimization/14. Join Nodes.mp4 37.0 MB
36. PostgreSQL Triggers/23. Prevent schema changes.mp4 37.0 MB
21. Exploring array functions/9. Formatting and converting an array.mp4 36.9 MB
21. Exploring array functions/5. Array metadata functions.mp4 36.6 MB
23. Indexes and Performance Optimization/12. Sequential Nodes.mp4 36.4 MB
13. PostgreSQL Sequences/7. Attach a sequence to a table column.mp4 36.4 MB
16. Using DATETIME functions/10. Date Value Extractors functions.mp4 36.1 MB
20. PostgreSQL Schemas/10. Schemas and Privileges.mp4 36.0 MB
23. Indexes and Performance Optimization/24. Indexes for sorted output.mp4 35.9 MB
26. Common Table Expressions (CTE)/3. Combine CTE with a table.mp4 35.9 MB
28. Window Functions/17. Using WINDOW.mp4 35.7 MB
36. PostgreSQL Triggers/9. Bind a function to a table with trigger.mp4 35.4 MB
18. Joining Multiple Tables/15. Self Joins Part 1.mp4 35.4 MB
28. Window Functions/29. ROW_NUMBER() - Pagination technique.mp4 35.2 MB
37. Using Cursors/4. Creating a cursor.mp4 35.2 MB
21. Exploring array functions/3. Using inclusion operators.mp4 34.9 MB
44. Managing PostgreSQL security/8. Column Level Security.mp4 34.9 MB
08. Modifying Table Structures, Add constraints/2. Modify Table Structures, AddModify Columns.mp4 34.8 MB
23. Indexes and Performance Optimization/10. The query optimizer.mp4 34.7 MB
34. Functions with PLpgSQL language/15. Using IF with table data.mp4 34.4 MB
12. Explore PostgreSQL Constraints/10. Foreign keys maintains referential data integrity.mp4 34.1 MB
21. Exploring array functions/2. Using comparison operators.mp4 34.1 MB
06. Filtering Data/16. Concatenation techniques.mp4 34.0 MB
35. Exploring Stored Procedures/2. Create a transactions.mp4 34.0 MB
22. JSON with PostgreSQL/2. JSON Syntax.mp4 33.8 MB
24. All about Views/1. Introduction to views.mp4 33.8 MB
41. Using Northwind Database/17. Customers with multiple orders.mp4 33.7 MB
31. Table Partitions/8. DEFAULT Partition.mp4 33.1 MB
14. String Functions/4. SPLIT_PART.mp4 32.9 MB
34. Functions with PLpgSQL language/14. Control Structures - IF statement.mp4 32.6 MB
33. Functions with SQL language/18. Function based on views.mp4 32.6 MB
14. String Functions/9. STRPOS.mp4 32.5 MB
18. Joining Multiple Tables/5. INNER joins with filter data Part 3.mp4 32.4 MB
31. Table Partitions/14. Determining a field for partition over.mp4 32.4 MB
27. Grouping sets/3. Adding subtotal with ROLLUP.mp4 32.4 MB
23. Indexes and Performance Optimization/25. Using multiple indexes on a single query.mp4 32.3 MB
26. Common Table Expressions (CTE)/5. Simultaneously DELETE INSERT via CTE.mp4 32.3 MB
34. Functions with PLpgSQL language/13. How to return query results.mp4 32.3 MB
14. String Functions/6. LPAD and RPAD.mp4 32.3 MB
12. Explore PostgreSQL Constraints/9. Creating foreign key constraints.mp4 32.2 MB
11. User-defined Data Types/13. Update an ENUM data in production server.mp4 32.2 MB
06. Filtering Data/4. Combining AND, OR operators.mp4 32.1 MB
42. Using Human Resource (hr) database/13. Discard characters from employees email address.mp4 32.1 MB
28. Window Functions/14. Sliding dynamic windows.mp4 31.9 MB
21. Exploring array functions/1. Constructing arrays and ranges.mp4 31.7 MB
40. PostgreSQL Transactions/7. How to fix transactions on crash.mp4 31.7 MB
22. JSON with PostgreSQL/5. Create our first table with JSONB data type.mp4 31.7 MB
07. PostgreSQL Data types/12. hstore.mp4 31.6 MB
13. PostgreSQL Sequences/10. Create an alphanumeric sequence.mp4 31.6 MB
31. Table Partitions/12. Partition Indexes.mp4 31.6 MB
02. Introduction to PostgreSQL/10. Install northwind database.mp4 31.6 MB
47. Managing Tables/10. Tracking table size.mp4 31.3 MB
09. Data type conversions/1. What is a data type conversion.mp4 31.1 MB
47. Managing Tables/5. Deleting duplicate records.mp4 30.9 MB
10. Conversion Functions/4. to_timestamp.mp4 30.9 MB
29. Using regular expressions for text patterns/7. REGEXP_REPLACE Function.mp4 30.7 MB
47. Managing Tables/4. Export Data to CSV files.mp4 30.1 MB
13. PostgreSQL Sequences/1. Create a sequence, advance a sequence, get current value, set value.mp4 30.1 MB
21. Exploring array functions/7. Array modification functions.mp4 30.0 MB
36. PostgreSQL Triggers/13. Disallow TRUNCATE on a table.mp4 29.9 MB
07. PostgreSQL Data types/11. Array.mp4 29.7 MB
09. Data type conversions/4. Table data conversion.mp4 29.6 MB
23. Indexes and Performance Optimization/33. Rebuilding an index.mp4 29.4 MB
24. All about Views/13. An updatable view with CRUD operations.mp4 29.2 MB
21. Exploring array functions/6. Array search functions.mp4 29.1 MB
29. Using regular expressions for text patterns/3. SIMILAR TO operator.mp4 29.0 MB
38. Creating Crosstab Reports/9. Static to dynamic pivots.mp4 28.8 MB
21. Exploring array functions/12. Query array data.mp4 28.8 MB
22. JSON with PostgreSQL/8. Use json_agg to aggregate data.mp4 28.7 MB
11. User-defined Data Types/1. CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 28.7 MB
33. Functions with SQL language/5. Function returning a single value Part 2.mp4 28.6 MB
10. Conversion Functions/3. to_date.mp4 28.4 MB
33. Functions with SQL language/8. Function using parameters Part 2.mp4 28.4 MB
23. Indexes and Performance Optimization/26. Execution plans depends on input values.mp4 28.3 MB
02. Introduction to PostgreSQL/9. Install sample stocks market data.mp4 28.3 MB
22. JSON with PostgreSQL/7. Create JSON from tables.mp4 28.3 MB
20. PostgreSQL Schemas/2. Schema Operations (AddAlterDelete schemas).mp4 28.1 MB
23. Indexes and Performance Optimization/9. SQL statement execution stages.mp4 28.0 MB
47. Managing Tables/9. Database operations and table size.mp4 27.8 MB
22. JSON with PostgreSQL/10. Creating a document from data.mp4 27.8 MB
46. PostgreSQL Internals/7. Using system Administration functions.mp4 27.8 MB
28. Window Functions/11. Partitioning the data.mp4 27.7 MB
20. PostgreSQL Schemas/1. What is a Schema.mp4 27.2 MB
14. String Functions/5. TRIM, BTRIM, LTRIM and RTRIM.mp4 27.2 MB
11. User-defined Data Types/8. CREATE TYPE - Create a composite address object.mp4 26.9 MB
31. Table Partitions/1. What is a partition.mp4 26.8 MB
16. Using DATETIME functions/7. Date construction functions.mp4 26.8 MB
16. Using DATETIME functions/13. Date Time Functions.mp4 26.7 MB
28. Window Functions/39. Using PARTITION BY for group averages.mp4 26.7 MB
31. Table Partitions/10. Partition maintenance.mp4 26.7 MB
20. PostgreSQL Schemas/3. Schema Hierarchy.mp4 26.6 MB
32. Server Programming/3. Keep the data on the server!.mp4 26.6 MB
28. Window Functions/28. ROW_NUMBER() - Find DISTINCT with subquery.mp4 26.6 MB
22. JSON with PostgreSQL/4. Exploring JSON objects.mp4 26.6 MB
20. PostgreSQL Schemas/8. What is a system catalog schema.mp4 26.3 MB
33. Functions with SQL language/6. Function returning a single value Part 3.mp4 26.3 MB
35. Exploring Stored Procedures/4. Returning a value.mp4 26.3 MB
05. Querying Data/10. Using DISTINCT for selecting distinct values.mp4 26.0 MB
07. PostgreSQL Data types/7. DATE.mp4 25.8 MB
02. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.mp4 25.7 MB
07. PostgreSQL Data types/5. Selecting Numbers data types.mp4 25.5 MB
35. Exploring Stored Procedures/3. Understanding the use of stored procedures.mp4 25.5 MB
44. Managing PostgreSQL security/10. Using CURRENT_USER with RLS.mp4 25.5 MB
28. Window Functions/31. Calculate difference compared to average.mp4 25.3 MB
28. Window Functions/41. Using WITH clause to set ORDER BY values.mp4 25.2 MB
26. Common Table Expressions (CTE)/1. Introduction to CTEs.mp4 24.7 MB
28. Window Functions/30. Using OVER() to calculate percentage.mp4 24.6 MB
16. Using DATETIME functions/3. Time of day formats and inputs.mp4 24.6 MB
35. Exploring Stored Procedures/1. Functions vs Stored Procedures.mp4 24.6 MB
44. Managing PostgreSQL security/13. Inspecting permissions.mp4 24.4 MB
23. Indexes and Performance Optimization/16. Hash Index.mp4 24.2 MB
43. Exploring Stock Markets Data/2. Select first or last records in a table.mp4 24.1 MB
18. Joining Multiple Tables/18. Natural Joins Part 1.mp4 24.0 MB
30. Powerful text searches in PostgreSQL/7. Ranking and Normalizing text results.mp4 23.8 MB
34. Functions with PLpgSQL language/29. Using SQLSTATE codes for exception handling.mp4 23.7 MB
29. Using regular expressions for text patterns/1. Text to structured data.mp4 23.6 MB
34. Functions with PLpgSQL language/27. Error and exception handling.mp4 23.5 MB
34. Functions with PLpgSQL language/5. Declaring variables.mp4 23.4 MB
21. Exploring array functions/11. Insert data into arrays.mp4 23.4 MB
37. Using Cursors/2. Cursors and procedural languages.mp4 23.4 MB
34. Functions with PLpgSQL language/20. FOR Loops iterate over result set.mp4 23.4 MB
36. PostgreSQL Triggers/7. Steps to create a trigger.mp4 23.3 MB
34. Functions with PLpgSQL language/18. LOOP statement.mp4 23.3 MB
41. Using Northwind Database/16. Countries with customers or suppliers - Using CTE.mp4 23.3 MB
44. Managing PostgreSQL security/5. Database Level Security.mp4 23.2 MB
36. PostgreSQL Triggers/16. Disallow data change on primary key.mp4 23.2 MB
24. All about Views/6. A view with UNION of multiple tables.mp4 23.2 MB
40. PostgreSQL Transactions/9. Using SAVEPOINT with transaction.mp4 23.2 MB
28. Window Functions/42. DELETE and INSERT in one query using WITH.mp4 23.1 MB
44. Managing PostgreSQL security/11. Row level policy for application users.mp4 22.9 MB
34. Functions with PLpgSQL language/28. Exception - Too many rows.mp4 22.9 MB
44. Managing PostgreSQL security/2. Instance Level Security.mp4 22.9 MB
10. Conversion Functions/2. to_number.mp4 22.8 MB
05. Querying Data/9. Using ORDER BY with NULL values.mp4 22.8 MB
40. PostgreSQL Transactions/2. How SQL protect database during transaction.mp4 22.8 MB
17. Grouping Data/6. HAVING vs WHERE.mp4 22.8 MB
23. Indexes and Performance Optimization/11. Optimizer node types.mp4 22.7 MB
36. PostgreSQL Triggers/11. View triggers variables.mp4 22.7 MB
41. Using Northwind Database/10. Customers with no orders.mp4 22.7 MB
34. Functions with PLpgSQL language/19. FOR Loops.mp4 22.6 MB
28. Window Functions/24. Finding Correlations.mp4 22.6 MB
31. Table Partitions/15. Sizing the partition.mp4 22.6 MB
41. Using Northwind Database/11. Top customers with total orders amount.mp4 22.5 MB
33. Functions with SQL language/3. Function returning no values.mp4 22.5 MB
18. Joining Multiple Tables/4. INNER joins with filter data Part 2.mp4 22.3 MB
28. Window Functions/9. Using FILTER clause.mp4 22.3 MB
19. Combining queries together/5. EXCEPT with tables.mp4 22.2 MB
29. Using regular expressions for text patterns/4. POSIX regular expressions.mp4 22.2 MB
12. Explore PostgreSQL Constraints/4. DEFAULT constraint.mp4 22.1 MB
31. Table Partitions/16. Partitioning Advantages.mp4 22.0 MB
18. Joining Multiple Tables/13. FULL Joins.mp4 22.0 MB
32. Server Programming/2. Procedural languages.mp4 21.9 MB
28. Window Functions/8. Query performance check.mp4 21.6 MB
31. Table Partitions/17. Common partitioning mistakes.mp4 21.6 MB
03. Creating and Modifying Tables/10. Using pgAdmin - View table structure, and create column.mp4 21.6 MB
28. Window Functions/4. GROUP BY ROLLUP.mp4 21.6 MB
46. PostgreSQL Internals/8. Show all running queries.mp4 21.5 MB
38. Creating Crosstab Reports/6. Pivoting rows and columns.mp4 21.3 MB
28. Window Functions/33. Using LEAD to compare with next values.mp4 21.3 MB
21. Exploring array functions/4. Array constructions.mp4 21.2 MB
03. Creating and Modifying Tables/9. Using pgAdmin - Create and modify a table.mp4 21.2 MB
28. Window Functions/32. Calculating cumulative totals.mp4 21.1 MB
28. Window Functions/10. Using Window Functions.mp4 21.0 MB
34. Functions with PLpgSQL language/7. Declaring variables in function.mp4 21.0 MB
15. Aggregate functions/5. GREATEST AND LEAST functions.mp4 21.0 MB
11. User-defined Data Types/7. CREATE DOMAIN - How to drop a domain data type.mp4 20.9 MB
28. Window Functions/19. RANK and DENSE_RANK functions.mp4 20.8 MB
22. JSON with PostgreSQL/1. What is JSON.mp4 20.7 MB
28. Window Functions/38. Getting RANK to compute group and global ranks.mp4 20.6 MB
03. Creating and Modifying Tables/2. Creating the movie database and a actors table.mp4 20.5 MB
36. PostgreSQL Triggers/20. Creating event triggers.mp4 20.5 MB
03. Creating and Modifying Tables/4. Creating the movies table with a foreign key.mp4 20.4 MB
22. JSON with PostgreSQL/3. JSON and JSONB data types.mp4 20.4 MB
18. Joining Multiple Tables/6. INNER joins with different data type columns.mp4 20.4 MB
25. Fun with subqueries/13. Subquery using EXISTS.mp4 20.4 MB
44. Managing PostgreSQL security/14. Row Level Security Performance.mp4 20.3 MB
43. Exploring Stock Markets Data/3. Get first or last record per each group.mp4 20.2 MB
23. Indexes and Performance Optimization/5. Size of the table index.mp4 20.2 MB
23. Indexes and Performance Optimization/6. List counts of all indexes.mp4 20.1 MB
14. String Functions/1. UPPER, LOWER and INITCAP.mp4 20.0 MB
28. Window Functions/6. GROUP BY CUBE.mp4 20.0 MB
42. Using Human Resource (hr) database/2. Quick overview of all tables.mp4 20.0 MB
38. Creating Crosstab Reports/1. What is a crosstab report.mp4 19.7 MB
36. PostgreSQL Triggers/21. Event trigger events and variables.mp4 19.6 MB
34. Functions with PLpgSQL language/21. CONTINUE statement.mp4 19.6 MB
25. Fun with subqueries/3. Subquery with IN operator.mp4 19.6 MB
21. Exploring array functions/10. Using arrays in tables.mp4 19.6 MB
28. Window Functions/7. GROUP BY GROUPING SETS.mp4 19.4 MB
23. Indexes and Performance Optimization/15. Index Types - B-Tree Index.mp4 19.4 MB
26. Common Table Expressions (CTE)/6. Recursive CTEs.mp4 19.0 MB
34. Functions with PLpgSQL language/12. Variables in block and subblock.mp4 19.0 MB
34. Functions with PLpgSQL language/3. Structure of a PLpgSQL function.mp4 18.9 MB
13. PostgreSQL Sequences/5. Creating a descending sequence, and CYCLE sequence.mp4 18.9 MB
04. Modifying Data in the tables/5. Update data in a table.mp4 18.8 MB
16. Using DATETIME functions/17. CURRENT_TIME function.mp4 18.8 MB
41. Using Northwind Database/5. Show total order amount for each order.mp4 18.7 MB
16. Using DATETIME functions/14. PostgreSQL Date Time Functions.mp4 18.6 MB
24. All about Views/17. Creating a materialized view.mp4 18.6 MB
22. JSON with PostgreSQL/16. JSON search with PostgreSQL functions.mp4 18.4 MB
33. Functions with SQL language/19. Drop a function.mp4 18.4 MB
44. Managing PostgreSQL security/3. Instance Level Security - Add users to roles.mp4 18.3 MB
34. Functions with PLpgSQL language/11. Using IN, OUT without RETURNS.mp4 18.3 MB
04. Modifying Data in the tables/1. Insert a data into table.mp4 18.3 MB
21. Exploring array functions/14. Array Dimensions are ignored!.mp4 18.3 MB
24. All about Views/3. Rename a view.mp4 18.2 MB
23. Indexes and Performance Optimization/1. What is an index.mp4 18.2 MB
28. Window Functions/18. Using WINDOW with ROWS BETWEEN.mp4 18.1 MB
06. Filtering Data/17. Concatenation with , CONCAT and CONCAT_WS.mp4 18.1 MB
23. Indexes and Performance Optimization/8. SQL Statement execution process.mp4 18.0 MB
24. All about Views/22. Why not use a table instead of materialized view.mp4 18.0 MB
31. Table Partitions/13. Partition pruning.mp4 18.0 MB
12. Explore PostgreSQL Constraints/1. Introduction to constraints.mp4 17.9 MB
13. PostgreSQL Sequences/2. Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 17.8 MB
46. PostgreSQL Internals/1. List database users, and database sizes with and without indexes.mp4 17.7 MB
23. Indexes and Performance Optimization/4. List all indexes.mp4 17.7 MB
05. Querying Data/8. Using ORDER BY with column name or column number.mp4 17.6 MB
12. Explore PostgreSQL Constraints/7. FOREIGN KEY Constraints.mp4 17.5 MB
28. Window Functions/5. ROLLUP - Grouping multiple columns.mp4 17.4 MB
32. Server Programming/4. Functions vs stored procedures.mp4 17.4 MB
11. User-defined Data Types/11. ALTER TYPE - Alter a composite data type, change schema and more.mp4 17.3 MB
22. JSON with PostgreSQL/9. Build a JSON array.mp4 17.3 MB
08. Modifying Table Structures, Add constraints/1. Creating sample database 'mydata', adding columns.mp4 17.3 MB
11. User-defined Data Types/5. CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 17.3 MB
25. Fun with subqueries/6. Order entries in UNION without using ORDER BY.mp4 17.3 MB
11. User-defined Data Types/14. An ENUM with a DEFAULT value in a table.mp4 17.2 MB
14. String Functions/12. REPLACE.mp4 17.1 MB
34. Functions with PLpgSQL language/25. Returning a table.mp4 17.1 MB
19. Combining queries together/4. INTERSECT with tables.mp4 17.1 MB
41. Using Northwind Database/4. Orders shipped to latin america.mp4 17.0 MB
09. Data type conversions/3. Implicit to Explicit conversions.mp4 17.0 MB
24. All about Views/26. List materialized views with no unique index.mp4 17.0 MB
45. PostgreSQL Utilities - psql/14. Turn on query execution time.mp4 17.0 MB
14. String Functions/10. SUBSTRING.mp4 17.0 MB
22. JSON with PostgreSQL/15. The Containment Operator.mp4 16.9 MB
11. User-defined Data Types/9. CREATE TYPE - Create a composite inventory_item data type.mp4 16.8 MB
11. User-defined Data Types/10. CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 16.8 MB
28. Window Functions/36. Planning tips on using Window Functions.mp4 16.7 MB
33. Functions with SQL language/14. Function - order matters!.mp4 16.6 MB
33. Functions with SQL language/16. Function parameter modes.mp4 16.6 MB
14. String Functions/7. LENGTH.mp4 16.6 MB
32. Server Programming/5. User-defined functions.mp4 16.5 MB
28. Window Functions/35. Window Function Summary.mp4 16.4 MB
23. Indexes and Performance Optimization/28. Try to use index only scan.mp4 16.3 MB
16. Using DATETIME functions/12. OVERLAPS Operator.mp4 16.2 MB
33. Functions with SQL language/2. Introducing dollar quoting.mp4 16.1 MB
13. PostgreSQL Sequences/9. Share one sequence between two tables.mp4 16.0 MB
27. Grouping sets/1. Introduction to summarization.mp4 16.0 MB
45. PostgreSQL Utilities - psql/10. Represent NULL values on psql terminal.mp4 16.0 MB
45. PostgreSQL Utilities - psql/13. Represent NULL Visibly.mp4 16.0 MB
24. All about Views/23. The downsides of using materialized views.mp4 15.9 MB
24. All about Views/12. What is an updatable view.mp4 15.9 MB
21. Exploring array functions/15. Display all array elements.mp4 15.9 MB
05. Querying Data/2. Selecting specific columns from a table.mp4 15.9 MB
07. PostgreSQL Data types/6. DateTime data types.mp4 15.8 MB
05. Querying Data/7. Using ORDER BY to sort rows by expressions.mp4 15.7 MB
45. PostgreSQL Utilities - psql/1. Connect to local or remote database.mp4 15.7 MB
06. Filtering Data/3. OR operator.mp4 15.7 MB
03. Creating and Modifying Tables/6. Creating a Junction table with movies and actors tables.mp4 15.6 MB
24. All about Views/18. Drop a materialized view.mp4 15.6 MB
40. PostgreSQL Transactions/8. Partial transaction rollback with savepoints.mp4 15.3 MB
28. Window Functions/27. ROW_NUMBER() - Find Nth record.mp4 15.2 MB
40. PostgreSQL Transactions/6. How to fix aborted transaction.mp4 15.2 MB
34. Functions with PLpgSQL language/22. FOREACH loop with arrays.mp4 15.0 MB
18. Joining Multiple Tables/12. RIGHT joins Part 2.mp4 15.0 MB
41. Using Northwind Database/7. Total products in each categories.mp4 15.0 MB
16. Using DATETIME functions/20. View and set timezones.mp4 15.0 MB
23. Indexes and Performance Optimization/7. Drop a index.mp4 14.9 MB
14. String Functions/8. POSITION.mp4 14.7 MB
33. Functions with SQL language/13. Function returning a table.mp4 14.7 MB
42. Using Human Resource (hr) database/4. Get highest, lowest, total, and average salaries of employees.mp4 14.7 MB
11. User-defined Data Types/4. CREATE DOMAIN - Create a domain data type for an email validation.mp4 14.4 MB
03. Creating and Modifying Tables/3. Creating the directors table.mp4 14.4 MB
45. PostgreSQL Utilities - psql/3. List all databases and tables.mp4 14.4 MB
06. Filtering Data/5. What goes before and after WHERE clause.mp4 14.2 MB
28. Window Functions/40. Using WITH clause to create your own data.mp4 14.2 MB
36. PostgreSQL Triggers/17. Use triggers very cautiously.mp4 14.2 MB
28. Window Functions/26. ROW_NUMBER() - Reverse fields with order by.mp4 14.1 MB
36. PostgreSQL Triggers/19. Event triggers usage scenarios.mp4 14.1 MB
16. Using DATETIME functions/15. AGE function.mp4 14.1 MB
45. PostgreSQL Utilities - psql/4. List all table space, schemas, and indices.mp4 14.1 MB
44. Managing PostgreSQL security/4. Use pgAdmin to create roles.mp4 14.0 MB
42. Using Human Resource (hr) database/19. Select employees not in range.mp4 13.9 MB
19. Combining queries together/3. UNION tables with different number of columns.mp4 13.8 MB
11. User-defined Data Types/12. ALTER TYPE - Alter an ENUM data type.mp4 13.7 MB
24. All about Views/11. Regular views are dynamic.mp4 13.7 MB
42. Using Human Resource (hr) database/3. Quick overview of all tables Part 2.mp4 13.7 MB
05. Querying Data/6. Using ORDER BY with alias column name.mp4 13.6 MB
02. Introduction to PostgreSQL/11. Drop a database.mp4 13.5 MB
41. Using Northwind Database/8. List products that needs re-ordering.mp4 13.5 MB
37. Using Cursors/3. Steps to create a cursor.mp4 13.5 MB
13. PostgreSQL Sequences/3. Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 13.5 MB
05. Querying Data/4. Using SELECT statement for expressions.mp4 13.4 MB
47. Managing Tables/2. Duplicate a table with or without data.mp4 13.3 MB
04. Modifying Data in the tables/8. Delete data from a table.mp4 13.1 MB
18. Joining Multiple Tables/19. Natural Joins Part 2.mp4 13.1 MB
03. Creating and Modifying Tables/5. Creating the movies_revenues table.mp4 13.1 MB
04. Modifying Data in the tables/7. Updating all records in a table.mp4 13.1 MB
29. Using regular expressions for text patterns/9. REGEXP_SPLIT_TO_ARRAY function.mp4 12.9 MB
18. Joining Multiple Tables/16. Self Joins Part 2.mp4 12.9 MB
16. Using DATETIME functions/2. System Month Date settings.mp4 12.8 MB
21. Exploring array functions/13. Modifying array data.mp4 12.8 MB
42. Using Human Resource (hr) database/14. List all employees with first_name starts with letters A, C or M.mp4 12.6 MB
42. Using Human Resource (hr) database/1. Human Resources Database Structure.mp4 12.5 MB
38. Creating Crosstab Reports/4. Orders matters in crosstab reports.mp4 12.4 MB
45. PostgreSQL Utilities - psql/8. Display command history, run commands from a file.mp4 12.4 MB
22. JSON with PostgreSQL/14. The Existence Operator.mp4 12.4 MB
42. Using Human Resource (hr) database/11. Compute 15% of salary for all employees.mp4 12.2 MB
03. Creating and Modifying Tables/1. Movie Database Structure.mp4 12.2 MB
45. PostgreSQL Utilities - psql/11. Make table layout funkey!.mp4 12.1 MB
31. Table Partitions/4. Partition types.mp4 12.0 MB
28. Window Functions/37. Difference between RANK and DENSE_RANK.mp4 12.0 MB
24. All about Views/8. Re-arrange columns in a view.mp4 12.0 MB
46. PostgreSQL Internals/9. Terminate running and IDLE process.mp4 11.9 MB
23. Indexes and Performance Optimization/20. EXPLAIN output options.mp4 11.9 MB
46. PostgreSQL Internals/4. List all columns from a table.mp4 11.9 MB
24. All about Views/20. How to check if a materialized view is populated or not.mp4 11.8 MB
36. PostgreSQL Triggers/3. Types of triggers.mp4 11.8 MB
44. Managing PostgreSQL security/1. Security concepts and and levels.mp4 11.8 MB
12. Explore PostgreSQL Constraints/12. Add or update foreign key constraint on existing table.mp4 11.7 MB
32. Server Programming/6. Structure of a function.mp4 11.7 MB
23. Indexes and Performance Optimization/31. Adding data while indexing.mp4 11.6 MB
02. Introduction to PostgreSQL/4. Creating a Database User.mp4 11.5 MB
13. PostgreSQL Sequences/4. Create a sequence using a specific data type.mp4 11.5 MB
34. Functions with PLpgSQL language/9. Copying data types.mp4 11.5 MB
42. Using Human Resource (hr) database/21. Update phone_number with your strings.mp4 11.5 MB
11. User-defined Data Types/3. CREATE DOMAIN - Create a postal code validation data type.mp4 11.2 MB
36. PostgreSQL Triggers/4. Trigger table.mp4 11.1 MB
04. Modifying Data in the tables/4. Use RETURNING to get info on added rows.mp4 11.1 MB
46. PostgreSQL Internals/5. View system metadata via system information functions.mp4 11.0 MB
28. Window Functions/12. Set data into millions format.mp4 11.0 MB
36. PostgreSQL Triggers/6. Trigger key points.mp4 10.9 MB
04. Modifying Data in the tables/6. Updating a row and returning the updated row.mp4 10.8 MB
20. PostgreSQL Schemas/4. Move a table to a new schema.mp4 10.8 MB
34. Functions with PLpgSQL language/2. PLpgSQL vs SQL.mp4 10.7 MB
02. Introduction to PostgreSQL/5. Creating a Database.mp4 10.5 MB
41. Using Northwind Database/12. Orders with many lines of ordered items.mp4 10.5 MB
02. Introduction to PostgreSQL/7. Install sample data files on server.mp4 10.5 MB
41. Using Northwind Database/15. Countries with customers or suppliers.mp4 10.2 MB
42. Using Human Resource (hr) database/20. Find Letter C in last_name at 3rd or greater position.mp4 10.2 MB
25. Fun with subqueries/8. A SELECT without a FROM.mp4 10.1 MB
34. Functions with PLpgSQL language/4. PLpgSQL block structure.mp4 10.0 MB
44. Managing PostgreSQL security/12. DROP a policy.mp4 10.0 MB
42. Using Human Resource (hr) database/7. Average salary for each department with more than 10 employees.mp4 9.9 MB
45. PostgreSQL Utilities - psql/12. Repeatedly Execute a Query.mp4 9.8 MB
40. PostgreSQL Transactions/4. Transaction setup.mp4 9.7 MB
03. Creating and Modifying Tables/12. Deleting tables from a database.mp4 9.6 MB
04. Modifying Data in the tables/2. Insert multiple records into a table.mp4 9.6 MB
06. Filtering Data/6. Execution order with AND, OR operators.mp4 9.3 MB
11. User-defined Data Types/6. CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 9.3 MB
42. Using Human Resource (hr) database/9. Maximum salary for each post where salary is at or above $5000.mp4 9.3 MB
41. Using Northwind Database/3. Total numbers of orders shipped to USA or France.mp4 9.2 MB
41. Using Northwind Database/2. Orders shipping to USA or France.mp4 9.1 MB
06. Filtering Data/7. Can we use column aliases with WHERE.mp4 9.1 MB
42. Using Human Resource (hr) database/18. Select employees with particular department id only.mp4 8.9 MB
23. Indexes and Performance Optimization/17. BRIN index.mp4 8.9 MB
34. Functions with PLpgSQL language/8. Variable initializing timing.mp4 8.8 MB
24. All about Views/10. Add a column in a view.mp4 8.7 MB
14. String Functions/11. REPEAT.mp4 8.7 MB
42. Using Human Resource (hr) database/22. Get the monthly salary of each employees.mp4 8.7 MB
42. Using Human Resource (hr) database/24. find employees whose names contains exactly six characters.mp4 8.6 MB
42. Using Human Resource (hr) database/17. Get unique designations in employees table.mp4 8.6 MB
11. User-defined Data Types/2. CREATE DOMAIN - Create a data type for a positive number.mp4 8.6 MB
06. Filtering Data/1. Comparison, Logical and Arithmetic operators.mp4 8.5 MB
20. PostgreSQL Schemas/6. Alter a schema ownership.mp4 8.5 MB
41. Using Northwind Database/6. First the oldest and latest order date.mp4 8.3 MB
42. Using Human Resource (hr) database/6. Get lowest paid salaries by each manager.mp4 8.3 MB
02. Introduction to PostgreSQL/8. Install Human Resources (hr) database.mp4 8.2 MB
34. Functions with PLpgSQL language/1. Introduction to PLpgSQL language.mp4 8.2 MB
11. User-defined Data Types/15. Create a type if not exists using a PLpgSQL function.mp4 8.1 MB
14. String Functions/3. REVERSE.mp4 8.1 MB
38. Creating Crosstab Reports/2. Installing the tablefunc extension.mp4 7.8 MB
42. Using Human Resource (hr) database/8. Average salary for each post excluding programmer.mp4 7.8 MB
37. Using Cursors/7. Updating data.mp4 7.6 MB
12. Explore PostgreSQL Constraints/11. Drop a constraint.mp4 7.6 MB
02. Introduction to PostgreSQL/3. Configure pgAdmin 4 client.mp4 7.5 MB
04. Modifying Data in the tables/3. Insert a data that had quotes.mp4 7.5 MB
36. PostgreSQL Triggers/18. What is an event trigger.mp4 7.5 MB
24. All about Views/9. Delete a column in a view.mp4 7.2 MB
42. Using Human Resource (hr) database/15. String manipulation with upper, lower and initcap functions.mp4 7.1 MB
23. Indexes and Performance Optimization/18. GIN Index.mp4 7.0 MB
25. Fun with subqueries/7. Subquery with an alias.mp4 6.9 MB
43. Exploring Stock Markets Data/4. How to calculate cube root in PostgreSQL.mp4 6.8 MB
42. Using Human Resource (hr) database/10. Using an alias name with columns.mp4 6.8 MB
24. All about Views/4. Delete a view.mp4 6.8 MB
35. Exploring Stored Procedures/5. Drop a procedure.mp4 6.7 MB
45. PostgreSQL Utilities - psql/2. Switch connection to a new database.mp4 6.7 MB
46. PostgreSQL Internals/10. How to check live and dead rows in tables.mp4 6.7 MB
42. Using Human Resource (hr) database/23. Calculate average salary with total number of employees.mp4 6.7 MB
34. Functions with PLpgSQL language/6. Declaring variables via ALIAS FOR.mp4 6.4 MB
06. Filtering Data/8. Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 6.3 MB
28. Window Functions/1. Introduction to Window Functions.mp4 6.2 MB
13. PostgreSQL Sequences/8. List all sequences in a database.mp4 6.0 MB
24. All about Views/25. List all materialized views by a SELECT statement.mp4 5.9 MB
37. Using Cursors/8. Closing a cursor.mp4 5.8 MB
02. Introduction to PostgreSQL/6. Running a query in pgAdmin tool.mp4 5.7 MB
29. Using regular expressions for text patterns/8. REGEXP_SPLIT_TO_TABLE Function.mp4 5.7 MB
13. PostgreSQL Sequences/6. Delete a sequence.mp4 5.6 MB
17. Grouping Data/3. Order of execution in GROUP BY clause.mp4 5.5 MB
02. Introduction to PostgreSQL/1. Installing PostgreSQL on Mac.mp4 5.3 MB
42. Using Human Resource (hr) database/5. Difference bw highest and lowest salaries by job_id.mp4 5.3 MB
42. Using Human Resource (hr) database/12. To list all employees IDs within each job_id group.mp4 5.1 MB
45. PostgreSQL Utilities - psql/7. Edit SQL commands in editor.mp4 5.0 MB
12. Explore PostgreSQL Constraints/13. CHECK constraint - An Introduction.mp4 4.9 MB
16. Using DATETIME functions/16. CURRENT_DATE function.mp4 4.6 MB
45. PostgreSQL Utilities - psql/9. Built-in syntax reference for commands.mp4 4.4 MB
17. Grouping Data/5. Order of execution in HAVING clause.mp4 4.1 MB
41. Using Northwind Database/1. Using Northwind database.mp4 4.0 MB
45. PostgreSQL Utilities - psql/6. Describe a table.mp4 3.9 MB
36. PostgreSQL Triggers/24. Dropping a trigger.mp4 3.9 MB
42. Using Human Resource (hr) database/16. Using SUBSTRING to get portion of string data.mp4 2.8 MB
49. Thank You!/4. Thank You!.mp4 2.4 MB
01. Welcome/1. Course Introduction.mp4 2.1 MB
01. Welcome/2. sample_data.zip 1.4 MB
02. Introduction to PostgreSQL/7. sample_data.zip 1.4 MB
02. Introduction to PostgreSQL/8. sample_data.zip 1.4 MB
02. Introduction to PostgreSQL/9. sample_data.zip 1.4 MB
03. Creating and Modifying Tables/7. sample_data.zip 1.4 MB
30. Powerful text searches in PostgreSQL/5. president_speeches.csv 1.1 MB
01. Welcome/2. trades.sql 510.2 KB
28. Window Functions/2. trades.sql 510.2 KB
01. Welcome/2. northwind.sql 341.5 KB
02. Introduction to PostgreSQL/10. northwind.sql 341.5 KB
49. Thank You!/3. 2022-03-07_17-01-13-1fd24125e6dc740f0adf17fd4be7ce44.png 240.5 KB
49. Thank You!/3. 2021-07-28_17-28-45-9da980a10061e26d058c147abe85f11b.png 122.0 KB
03. Creating and Modifying Tables/8. 2021-04-01_15-33-06-faabd956903cfa4c427d171bb035faff.png 98.4 KB
03. Creating and Modifying Tables/8. 2021-04-01_15-33-22-3cc7c77c6f93d169a2ca456613da1080.png 58.5 KB
31. Table Partitions/6. Partition by List.vtt 31.7 KB
28. Window Functions/15. Understanding window frames.vtt 28.9 KB
36. PostgreSQL Triggers/14. Creating an audit trigger.vtt 26.5 KB
31. Table Partitions/5. Partition by Range.vtt 26.0 KB
12. Explore PostgreSQL Constraints/5. PRIMARY KEY Constraints.vtt 26.0 KB
26. Common Table Expressions (CTE)/7. Parent-child relationship via recursive CTE.vtt 25.5 KB
48. Extended PostgreSQL/1. Create a custom index method.vtt 25.4 KB
18. Joining Multiple Tables/1. INNER joins.vtt 25.1 KB
07. PostgreSQL Data types/2. CHAR, VARCHAR and TEXT.vtt 24.7 KB
23. Indexes and Performance Optimization/27. Using organized vs random data.vtt 23.9 KB
29. Using regular expressions for text patterns/5. SUBSTRING with regular expressions.vtt 23.6 KB
06. Filtering Data/14. Using LIKE and ILIKE.vtt 21.5 KB
06. Filtering Data/10. Using LIMIT and OFFSET.vtt 21.3 KB
31. Table Partitions/3. Table inheritance.vtt 21.2 KB
31. Table Partitions/2. When a partition can be used.vtt 20.8 KB
23. Indexes and Performance Optimization/2. Create an index.vtt 20.0 KB
38. Creating Crosstab Reports/11. Dynamic pivot table columns.vtt 20.0 KB
06. Filtering Data/9. Using Logical operators.vtt 19.9 KB
28. Window Functions/22. FIRST_VALUE, LAST_VALUE and NTH_value functions.vtt 19.8 KB
40. PostgreSQL Transactions/5. Transaction analysis.vtt 19.7 KB
26. Common Table Expressions (CTE)/2. CTE query examples.vtt 19.5 KB
23. Indexes and Performance Optimization/19. The EXPLAIN statement.vtt 19.4 KB
31. Table Partitions/7. Partition by Hash.vtt 19.1 KB
23. Indexes and Performance Optimization/30. Expression Index.vtt 18.8 KB
36. PostgreSQL Triggers/15. Creating conditional triggers.vtt 18.7 KB
28. Window Functions/21. LEAD and LAG functions.vtt 18.6 KB
30. Powerful text searches in PostgreSQL/3. Using tsquery with operators.vtt 18.6 KB
38. Creating Crosstab Reports/3. Creating a crosstab report - Student Rankings.vtt 18.5 KB
12. Explore PostgreSQL Constraints/3. UNIQUE constraint.vtt 18.5 KB
17. Grouping Data/2. Using GROUP BY with multiple columns, ORDER BY.vtt 18.4 KB
36. PostgreSQL Triggers/22. Creating an audit event trigger.vtt 18.3 KB
07. PostgreSQL Data types/8. TIME.vtt 18.2 KB
44. Managing PostgreSQL security/9. Row Level Security.vtt 18.0 KB
21. Exploring array functions/17. Array vs JSONB.vtt 17.9 KB
20. PostgreSQL Schemas/5. Schema search path.vtt 17.8 KB
31. Table Partitions/9. Multi-level partitioning.vtt 17.8 KB
30. Powerful text searches in PostgreSQL/4. Full text search within a table.vtt 17.8 KB
27. Grouping sets/4. Using GROUPING with ROLLUP.vtt 17.7 KB
21. Exploring array functions/8. Array comparison with IN, ALL, ANY and SOME.vtt 17.1 KB
34. Functions with PLpgSQL language/26. Using RETURN NEXT.vtt 17.1 KB
12. Explore PostgreSQL Constraints/6. PRIMARY KEY Constraints on multiple columns.vtt 17.0 KB
07. PostgreSQL Data types/14. Network Addresses.vtt 17.0 KB
37. Using Cursors/10. Using a parametric cursor via function.vtt 17.0 KB
07. PostgreSQL Data types/1. Boolean.vtt 16.8 KB
33. Functions with SQL language/9. Function using parameters Part 3.vtt 16.6 KB
23. Indexes and Performance Optimization/22. Understanding query cost model.vtt 16.5 KB
33. Functions with SQL language/10. Function using parameters Part 4.vtt 16.5 KB
09. Data type conversions/2. Using CAST for data conversions.vtt 16.2 KB
25. Fun with subqueries/9. Correlated Queries.vtt 16.1 KB
33. Functions with SQL language/7. Function using parameters.vtt 16.0 KB
18. Joining Multiple Tables/20. Append tables with different columns.vtt 15.9 KB
15. Aggregate functions/7. Average with AVG function.vtt 15.8 KB
07. PostgreSQL Data types/9. TIMESTAMP and TIMESTAMPTZ.vtt 15.5 KB
15. Aggregate functions/4. MIN and MAX functions.vtt 15.5 KB
33. Functions with SQL language/4. Function returning a single value.vtt 15.4 KB
06. Filtering Data/15. Using IS NULL and IS NOT NULL keywords.vtt 15.3 KB
34. Functions with PLpgSQL language/23. WHILE loop.vtt 15.3 KB
23. Indexes and Performance Optimization/23. Index are not free.vtt 15.0 KB
25. Fun with subqueries/2. Subqueries with WHERE Clause.vtt 15.0 KB
27. Grouping sets/2. Subtotals on group sets.vtt 15.0 KB
30. Powerful text searches in PostgreSQL/2. Introducing tsvector.vtt 14.9 KB
36. PostgreSQL Triggers/10. Modify data at INSERT event.vtt 14.9 KB
16. Using DATETIME functions/4. Strings to Dates conversions.vtt 14.9 KB
22. JSON with PostgreSQL/6. Update and Delete JSON Data.vtt 14.8 KB
33. Functions with SQL language/11. Function returning a composite.vtt 14.8 KB
16. Using DATETIME functions/22. date_part function.vtt 14.7 KB
07. PostgreSQL Data types/13. JSON.vtt 14.7 KB
22. JSON with PostgreSQL/17. Indexing on JSONB.vtt 14.7 KB
48. Extended PostgreSQL/2. Create a user-defined aggregate function.vtt 14.4 KB
47. Managing Tables/1. Using SELECT INTO to create a new table with joins.vtt 14.2 KB
21. Exploring array functions/16. Using Multi-dimensional arrays.vtt 14.2 KB
36. PostgreSQL Triggers/8. Data auditing with a trigger.vtt 14.2 KB
36. PostgreSQL Triggers/5. Pros and Cons of triggers.vtt 14.1 KB
17. Grouping Data/1. Using GROUP BY.vtt 14.0 KB
33. Functions with SQL language/17. Function parameters with default values.vtt 14.0 KB
24. All about Views/24. Using materialized view for websites page analysis.vtt 13.9 KB
16. Using DATETIME functions/6. Formatting Dates.vtt 13.9 KB
39. Internationalization/2. Client and Server Encoding.vtt 13.9 KB
07. PostgreSQL Data types/4. DECIMALS.vtt 13.9 KB
17. Grouping Data/4. Using HAVING.vtt 13.9 KB
07. PostgreSQL Data types/3. NUMERIC.vtt 13.8 KB
34. Functions with PLpgSQL language/17. Searched CASE statement.vtt 13.8 KB
47. Managing Tables/13. Generated Columns.vtt 13.8 KB
28. Window Functions/16. ROWS and RANGE indicators.vtt 13.7 KB
15. Aggregate functions/8. Combining Columns using Mathematical operators.vtt 13.7 KB
41. Using Northwind Database/14. Late shipped orders by employees.vtt 13.7 KB
36. PostgreSQL Triggers/2. What is a trigger.vtt 13.7 KB
44. Managing PostgreSQL security/6. Schema Level Security.vtt 13.6 KB
34. Functions with PLpgSQL language/16. CASE Statement.vtt 13.6 KB
16. Using DATETIME functions/21. How to handle timezones.vtt 13.6 KB
24. All about Views/2. Creating a view.vtt 13.4 KB
07. PostgreSQL Data types/10. UUID.vtt 13.4 KB
12. Explore PostgreSQL Constraints/2. NOT NULL constraint.vtt 13.3 KB
34. Functions with PLpgSQL language/24. Using RETURN QUERY.vtt 13.2 KB
44. Managing PostgreSQL security/7. Table Level Security.vtt 13.2 KB
36. PostgreSQL Triggers/12. Disallow DELETE on a table.vtt 13.2 KB
38. Creating Crosstab Reports/13. Handling missing values.vtt 13.2 KB
41. Using Northwind Database/13. Orders with double entry line items.vtt 13.2 KB
18. Joining Multiple Tables/17. CROSS Joins.vtt 13.2 KB
33. Functions with SQL language/1. Creating our first SQL function.vtt 13.1 KB
47. Managing Tables/12. Recovering unused space with VACUUM.vtt 13.1 KB
38. Creating Crosstab Reports/5. Pivoting with Rainfalls data.vtt 13.0 KB
18. Joining Multiple Tables/11. RIGHT joins.vtt 13.0 KB
37. Using Cursors/9. Creating a PLPGSQL Cursor.vtt 13.0 KB
17. Grouping Data/7. Handling NULL values with GROUP BY.vtt 12.9 KB
23. Indexes and Performance Optimization/3. Create unique indexes.vtt 12.8 KB
29. Using regular expressions for text patterns/6. REGEXP_MATCHES Function.vtt 12.8 KB
39. Internationalization/1. Global Character Set Support.vtt 12.8 KB
19. Combining queries together/2. UNION with filters and conditions.vtt 12.7 KB
23. Indexes and Performance Optimization/29. Partial indexes.vtt 12.7 KB
47. Managing Tables/11. PostgreSQL autovacuum proces.vtt 12.7 KB
41. Using Northwind Database/9. Freight analysis.vtt 12.4 KB
19. Combining queries together/1. Combine results sets with UNION.vtt 12.4 KB
32. Server Programming/1. PostgreSQL as a development platform.vtt 12.3 KB
38. Creating Crosstab Reports/7. Matrix report via a query.vtt 12.3 KB
06. Filtering Data/11. Using FETCH.vtt 12.3 KB
23. Indexes and Performance Optimization/21. Using EXPLAIN ANALYZE.vtt 12.3 KB
16. Using DATETIME functions/5. Using TO_TIMESTAMP function.vtt 12.3 KB
04. Modifying Data in the tables/9. Using UPSERT.vtt 12.3 KB
16. Using DATETIME functions/9. Using MAKE_TIMESTAMPTZ function.vtt 12.3 KB
06. Filtering Data/13. Using BETWEEN and NOT BETWEEN.vtt 12.2 KB
16. Using DATETIME functions/11. Using math operators with dates.vtt 12.2 KB
33. Functions with SQL language/15. Function as a table source.vtt 12.1 KB
21. Exploring array functions/9. Formatting and converting an array.vtt 12.0 KB
37. Using Cursors/5. Opening a cursor.vtt 12.0 KB
16. Using DATETIME functions/1. Datetimes data types.vtt 11.9 KB
28. Window Functions/25. ROW_NUMBER() - Window with Partition datasets.vtt 11.9 KB
28. Window Functions/23. ROW_NUMBER function.vtt 11.9 KB
22. JSON with PostgreSQL/2. JSON Syntax.vtt 11.8 KB
28. Window Functions/20. NTILE function.vtt 11.8 KB
24. All about Views/16. What is a Materialized View.vtt 11.7 KB
29. Using regular expressions for text patterns/2. Regular expressions notations table.vtt 11.6 KB
46. PostgreSQL Internals/11. File layout of PostgreSQL Tables.vtt 11.5 KB
01. Welcome/2. countries_iso_codes.csv 11.5 KB
47. Managing Tables/3. countries_iso_codes.csv 11.5 KB
18. Joining Multiple Tables/3. INNER joins with filter data Part 1.vtt 11.3 KB
18. Joining Multiple Tables/7. LEFT joins Part 1.vtt 11.3 KB
37. Using Cursors/4. Creating a cursor.vtt 11.3 KB
16. Using DATETIME functions/23. date_trunc function.vtt 11.3 KB
06. Filtering Data/12. Using IN, NOT IN.vtt 11.2 KB
29. Using regular expressions for text patterns/7. REGEXP_REPLACE Function.vtt 11.2 KB
28. Window Functions/34. Comparing with least number.vtt 11.2 KB
34. Functions with PLpgSQL language/10. Assigning variables from query.vtt 11.2 KB
05. Querying Data/3. Adding Aliases to columns in a table.vtt 11.1 KB
24. All about Views/15. Updatable views using WITH LOCAL and CASCADED CHECK OPTION.vtt 11.1 KB
31. Table Partitions/11. ALTERing the partition bounds.vtt 11.1 KB
28. Window Functions/17. Using WINDOW.vtt 10.9 KB
46. PostgreSQL Internals/3. List all tables and views.vtt 10.9 KB
38. Creating Crosstab Reports/5. rainfalldata.sql 10.9 KB
21. Exploring array functions/5. Array metadata functions.vtt 10.9 KB
16. Using DATETIME functions/19. Using Date, time, timestamp in tables.vtt 10.8 KB
23. Indexes and Performance Optimization/24. Indexes for sorted output.vtt 10.8 KB
36. PostgreSQL Triggers/9. Bind a function to a table with trigger.vtt 10.8 KB
40. PostgreSQL Transactions/3. ACID Database.vtt 10.8 KB
30. Powerful text searches in PostgreSQL/1. The Good Ol' Text Search.vtt 10.6 KB
23. Indexes and Performance Optimization/10. The query optimizer.vtt 10.6 KB
33. Functions with SQL language/12. Function returning multiple rows.vtt 10.6 KB
28. Window Functions/3. Using aggregate functions.vtt 10.5 KB
23. Indexes and Performance Optimization/32. Invalidating an index.vtt 10.5 KB
18. Joining Multiple Tables/14. Joining multiple tables.vtt 10.5 KB
44. Managing PostgreSQL security/8. Column Level Security.vtt 10.4 KB
14. String Functions/2. LEFT and RIGHT.vtt 10.4 KB
18. Joining Multiple Tables/2. INNER joins with USING.vtt 10.4 KB
18. Joining Multiple Tables/9. LEFT joins Part 3.vtt 10.4 KB
25. Fun with subqueries/4. Subquery with JOINs.vtt 10.3 KB
10. Conversion Functions/1. to_char.vtt 10.3 KB
36. PostgreSQL Triggers/23. Prevent schema changes.vtt 10.3 KB
12. Explore PostgreSQL Constraints/15. CHECK constraint - Add, Rename, Drop on existing table.vtt 10.2 KB
18. Joining Multiple Tables/15. Self Joins Part 1.vtt 10.2 KB
09. Data type conversions/4. Table data conversion.vtt 10.2 KB
08. Modifying Table Structures, Add constraints/3. Add constraints to columns.vtt 10.1 KB
46. PostgreSQL Internals/6. View privileges information across tables.vtt 10.1 KB
30. Powerful text searches in PostgreSQL/6. Analyzing presidents speeches text data.vtt 10.1 KB
23. Indexes and Performance Optimization/25. Using multiple indexes on a single query.vtt 10.0 KB
31. Table Partitions/14. Determining a field for partition over.vtt 10.0 KB
21. Exploring array functions/2. Using comparison operators.vtt 10.0 KB
12. Explore PostgreSQL Constraints/14. CHECK constraint - Add to new table.vtt 10.0 KB
34. Functions with PLpgSQL language/14. Control Structures - IF statement.vtt 9.9 KB
15. Aggregate functions/3. Sum with SUM function.vtt 9.9 KB
28. Window Functions/13. Ordering inside window.vtt 9.9 KB
24. All about Views/14. Updatable views using WITH CHECK OPTION.vtt 9.9 KB
20. PostgreSQL Schemas/9. Compare tables and columns in two schemas.vtt 9.9 KB
40. PostgreSQL Transactions/1. What is a transaction.vtt 9.8 KB
28. Window Functions/2. Analyze Global Trades Data.vtt 9.8 KB
35. Exploring Stored Procedures/2. Create a transactions.vtt 9.8 KB
25. Fun with subqueries/12. Using ALL with subquery.vtt 9.8 KB
12. Explore PostgreSQL Constraints/9. Creating foreign key constraints.vtt 9.7 KB
12. Explore PostgreSQL Constraints/10. Foreign keys maintains referential data integrity.vtt 9.7 KB
21. Exploring array functions/1. Constructing arrays and ranges.vtt 9.7 KB
22. JSON with PostgreSQL/5. Create our first table with JSONB data type.vtt 9.7 KB
23. Indexes and Performance Optimization/13. Index Nodes.vtt 9.7 KB
47. Managing Tables/10. Tracking table size.vtt 9.6 KB
28. Window Functions/14. Sliding dynamic windows.vtt 9.6 KB
27. Grouping sets/3. Adding subtotal with ROLLUP.vtt 9.5 KB
44. Managing PostgreSQL security/15. Encrypted data in columns.vtt 9.5 KB
21. Exploring array functions/12. Query array data.vtt 9.5 KB
06. Filtering Data/2. AND operator.vtt 9.5 KB
26. Common Table Expressions (CTE)/5. Simultaneously DELETE INSERT via CTE.vtt 9.4 KB
41. Using Northwind Database/18. First order from each country.vtt 9.4 KB
47. Managing Tables/5. Deleting duplicate records.vtt 9.3 KB
25. Fun with subqueries/11. Using ANY with subquery.vtt 9.3 KB
20. PostgreSQL Schemas/2. Schema Operations (AddAlterDelete schemas).vtt 9.3 KB
31. Table Partitions/12. Partition Indexes.vtt 9.2 KB
13. PostgreSQL Sequences/7. Attach a sequence to a table column.vtt 9.2 KB
14. String Functions/5. TRIM, BTRIM, LTRIM and RTRIM.vtt 9.0 KB
41. Using Northwind Database/17. Customers with multiple orders.vtt 9.0 KB
47. Managing Tables/3. Import data from CSV files.vtt 9.0 KB
45. PostgreSQL Utilities - psql/5. List all sequences, roles, data types, domain data types.vtt 9.0 KB
23. Indexes and Performance Optimization/33. Rebuilding an index.vtt 9.0 KB
24. All about Views/7. Connecting multiple tables with a single view.vtt 8.9 KB
16. Using DATETIME functions/18. Date accuracy with EPOCH.vtt 8.9 KB
24. All about Views/1. Introduction to views.vtt 8.8 KB
07. PostgreSQL Data types/11. Array.vtt 8.8 KB
06. Filtering Data/16. Concatenation techniques.vtt 8.8 KB
21. Exploring array functions/6. Array search functions.vtt 8.8 KB
29. Using regular expressions for text patterns/3. SIMILAR TO operator.vtt 8.7 KB
16. Using DATETIME functions/8. Using MAKE_INTERVAL function.vtt 8.7 KB
12. Explore PostgreSQL Constraints/8. Tables without foreign key constraints.vtt 8.7 KB
34. Functions with PLpgSQL language/30. Exception with data exception errors.vtt 8.7 KB
14. String Functions/4. SPLIT_PART.vtt 8.7 KB
38. Creating Crosstab Reports/9. Static to dynamic pivots.vtt 8.7 KB
24. All about Views/5. Using filters with views.vtt 8.7 KB
13. PostgreSQL Sequences/10. Create an alphanumeric sequence.vtt 8.7 KB
38. Creating Crosstab Reports/10. Dynamic pivot query via JSON.vtt 8.6 KB
21. Exploring array functions/7. Array modification functions.vtt 8.6 KB
28. Window Functions/36. Planning tips on using Window Functions.vtt 8.6 KB
26. Common Table Expressions (CTE)/3. Combine CTE with a table.vtt 8.6 KB
28. Window Functions/41. Using WITH clause to set ORDER BY values.vtt 8.6 KB
18. Joining Multiple Tables/8. LEFT joins Part 2.vtt 8.5 KB
11. User-defined Data Types/13. Update an ENUM data in production server.vtt 8.5 KB
08. Modifying Table Structures, Add constraints/2. Modify Table Structures, AddModify Columns.vtt 8.5 KB
37. Using Cursors/1. Understanding row by row operations.vtt 8.5 KB
25. Fun with subqueries/10. SELECT.. IN (Subquery).vtt 8.5 KB
22. JSON with PostgreSQL/4. Exploring JSON objects.vtt 8.4 KB
30. Powerful text searches in PostgreSQL/5. Setup presidents speeches data.vtt 8.4 KB
31. Table Partitions/8. DEFAULT Partition.vtt 8.3 KB
20. PostgreSQL Schemas/10. Schemas and Privileges.vtt 8.3 KB
23. Indexes and Performance Optimization/26. Execution plans depends on input values.vtt 8.3 KB
07. PostgreSQL Data types/12. hstore.vtt 8.3 KB
37. Using Cursors/6. Using a cursor.vtt 8.3 KB
20. PostgreSQL Schemas/3. Schema Hierarchy.vtt 8.2 KB
05. Querying Data/5. Using ORDER BY to sort records.vtt 8.1 KB
23. Indexes and Performance Optimization/14. Join Nodes.vtt 8.0 KB
03. Creating and Modifying Tables/11. Using pgAdmin - Rename, delete and change the data type of a column.vtt 8.0 KB
40. PostgreSQL Transactions/9. Using SAVEPOINT with transaction.vtt 7.9 KB
13. PostgreSQL Sequences/1. Create a sequence, advance a sequence, get current value, set value.vtt 7.9 KB
33. Functions with SQL language/18. Function based on views.vtt 7.9 KB
07. PostgreSQL Data types/7. DATE.vtt 7.9 KB
12. Explore PostgreSQL Constraints/7. FOREIGN KEY Constraints.vtt 7.9 KB
31. Table Partitions/15. Sizing the partition.vtt 7.9 KB
20. PostgreSQL Schemas/1. What is a Schema.vtt 7.9 KB
20. PostgreSQL Schemas/7. Duplicate a schema along with all data.vtt 7.9 KB
41. Using Northwind Database/16. Countries with customers or suppliers - Using CTE.vtt 7.8 KB
29. Using regular expressions for text patterns/1. Text to structured data.vtt 7.8 KB
21. Exploring array functions/11. Insert data into arrays.vtt 7.8 KB
24. All about Views/19. Changing materialized view data.vtt 7.8 KB
38. Creating Crosstab Reports/12. Interactive client-side pivot.vtt 7.8 KB
16. Using DATETIME functions/10. Date Value Extractors functions.vtt 7.8 KB
44. Managing PostgreSQL security/10. Using CURRENT_USER with RLS.vtt 7.7 KB
28. Window Functions/29. ROW_NUMBER() - Pagination technique.vtt 7.7 KB
09. Data type conversions/1. What is a data type conversion.vtt 7.7 KB
23. Indexes and Performance Optimization/9. SQL statement execution stages.vtt 7.7 KB
22. JSON with PostgreSQL/13. Getting information from JSON documents.vtt 7.7 KB
32. Server Programming/3. Keep the data on the server!.vtt 7.7 KB
16. Using DATETIME functions/3. Time of day formats and inputs.vtt 7.7 KB
44. Managing PostgreSQL security/2. Instance Level Security.vtt 7.6 KB
34. Functions with PLpgSQL language/19. FOR Loops.vtt 7.6 KB
34. Functions with PLpgSQL language/18. LOOP statement.vtt 7.6 KB
34. Functions with PLpgSQL language/5. Declaring variables.vtt 7.6 KB
28. Window Functions/30. Using OVER() to calculate percentage.vtt 7.6 KB
24. All about Views/21. Refreshing data in materialize views.vtt 7.6 KB
11. User-defined Data Types/1. CREATE DOMAIN - Create a DOMAIN data type, create an address.vtt 7.5 KB
15. Aggregate functions/1. Counting results via COUNT function.vtt 7.5 KB
05. Querying Data/9. Using ORDER BY with NULL values.vtt 7.5 KB
23. Indexes and Performance Optimization/12. Sequential Nodes.vtt 7.5 KB
05. Querying Data/1. Select all data from a table.vtt 7.5 KB
10. Conversion Functions/2. to_number.vtt 7.4 KB
28. Window Functions/24. Finding Correlations.vtt 7.4 KB
07. PostgreSQL Data types/5. Selecting Numbers data types.vtt 7.3 KB
19. Combining queries together/5. EXCEPT with tables.vtt 7.3 KB
28. Window Functions/33. Using LEAD to compare with next values.vtt 7.3 KB
16. Using DATETIME functions/7. Date construction functions.vtt 7.3 KB
36. PostgreSQL Triggers/16. Disallow data change on primary key.vtt 7.3 KB
18. Joining Multiple Tables/18. Natural Joins Part 1.vtt 7.2 KB
02. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.vtt 7.2 KB
22. JSON with PostgreSQL/10. Creating a document from data.vtt 7.2 KB
28. Window Functions/31. Calculate difference compared to average.vtt 7.2 KB
18. Joining Multiple Tables/10. LEFT joins Part 4.vtt 7.2 KB
35. Exploring Stored Procedures/1. Functions vs Stored Procedures.vtt 7.2 KB
40. PostgreSQL Transactions/7. How to fix transactions on crash.vtt 7.2 KB
41. Using Northwind Database/10. Customers with no orders.vtt 7.1 KB
11. User-defined Data Types/8. CREATE TYPE - Create a composite address object.vtt 7.1 KB
14. String Functions/6. LPAD and RPAD.vtt 7.1 KB
28. Window Functions/39. Using PARTITION BY for group averages.vtt 7.1 KB
47. Managing Tables/9. Database operations and table size.vtt 7.1 KB
02. Introduction to PostgreSQL/10. Install northwind database.vtt 7.0 KB
10. Conversion Functions/3. to_date.vtt 7.0 KB
03. Creating and Modifying Tables/7. Install sample data for 'movies' database.vtt 7.0 KB
05. Querying Data/10. Using DISTINCT for selecting distinct values.vtt 6.9 KB
26. Common Table Expressions (CTE)/1. Introduction to CTEs.vtt 6.9 KB
36. PostgreSQL Triggers/13. Disallow TRUNCATE on a table.vtt 6.9 KB
34. Functions with PLpgSQL language/27. Error and exception handling.vtt 6.9 KB
24. All about Views/13. An updatable view with CRUD operations.vtt 6.8 KB
40. PostgreSQL Transactions/2. How SQL protect database during transaction.vtt 6.8 KB
28. Window Functions/4. GROUP BY ROLLUP.vtt 6.8 KB
23. Indexes and Performance Optimization/11. Optimizer node types.vtt 6.8 KB
17. Grouping Data/6. HAVING vs WHERE.vtt 6.8 KB
28. Window Functions/32. Calculating cumulative totals.vtt 6.8 KB
21. Exploring array functions/4. Array constructions.vtt 6.8 KB
31. Table Partitions/1. What is a partition.vtt 6.8 KB
34. Functions with PLpgSQL language/28. Exception - Too many rows.vtt 6.7 KB
03. Creating and Modifying Tables/2. Creating the movie database and a actors table.vtt 6.7 KB
34. Functions with PLpgSQL language/15. Using IF with table data.vtt 6.7 KB
36. PostgreSQL Triggers/7. Steps to create a trigger.vtt 6.7 KB
46. PostgreSQL Internals/7. Using system Administration functions.vtt 6.7 KB
29. Using regular expressions for text patterns/4. POSIX regular expressions.vtt 6.7 KB
46. PostgreSQL Internals/7. internal - view system administration functions.vtt 6.6 KB
34. Functions with PLpgSQL language/21. CONTINUE statement.vtt 6.6 KB
03. Creating and Modifying Tables/10. Using pgAdmin - View table structure, and create column.vtt 6.5 KB
44. Managing PostgreSQL security/5. Database Level Security.vtt 6.5 KB
28. Window Functions/9. Using FILTER clause.vtt 6.5 KB
42. Using Human Resource (hr) database/2. Quick overview of all tables.vtt 6.5 KB
16. Using DATETIME functions/13. Date Time Functions.vtt 6.5 KB
30. Powerful text searches in PostgreSQL/7. Ranking and Normalizing text results.vtt 6.5 KB
28. Window Functions/19. RANK and DENSE_RANK functions.vtt 6.4 KB
35. Exploring Stored Procedures/3. Understanding the use of stored procedures.vtt 6.4 KB
15. Aggregate functions/5. GREATEST AND LEAST functions.vtt 6.4 KB
28. Window Functions/28. ROW_NUMBER() - Find DISTINCT with subquery.vtt 6.4 KB
33. Functions with SQL language/5. Function returning a single value Part 2.vtt 6.4 KB
34. Functions with PLpgSQL language/7. Declaring variables in function.vtt 6.4 KB
38. Creating Crosstab Reports/8. Aggregate over filter.vtt 6.3 KB
28. Window Functions/6. GROUP BY CUBE.vtt 6.3 KB
36. PostgreSQL Triggers/11. View triggers variables.vtt 6.3 KB
28. Window Functions/10. Using Window Functions.vtt 6.3 KB
33. Functions with SQL language/8. Function using parameters Part 2.vtt 6.3 KB
22. JSON with PostgreSQL/8. Use json_agg to aggregate data.vtt 6.3 KB
11. User-defined Data Types/7. CREATE DOMAIN - How to drop a domain data type.vtt 6.3 KB
03. Creating and Modifying Tables/4. Creating the movies table with a foreign key.vtt 6.3 KB
33. Functions with SQL language/3. Function returning no values.vtt 6.3 KB
34. Functions with PLpgSQL language/3. Structure of a PLpgSQL function.vtt 6.2 KB
26. Common Table Expressions (CTE)/6. Recursive CTEs.vtt 6.2 KB
06. Filtering Data/4. Combining AND, OR operators.vtt 6.2 KB
28. Window Functions/8. Query performance check.vtt 6.2 KB
37. Using Cursors/2. Cursors and procedural languages.vtt 6.2 KB
31. Table Partitions/17. Common partitioning mistakes.vtt 6.1 KB
18. Joining Multiple Tables/13. FULL Joins.vtt 6.1 KB
42. Using Human Resource (hr) database/13. Discard characters from employees email address.vtt 6.1 KB
22. JSON with PostgreSQL/11. Null Values in JSON documents.vtt 6.1 KB
28. Window Functions/42. DELETE and INSERT in one query using WITH.vtt 6.1 KB
14. String Functions/9. STRPOS.vtt 6.1 KB
34. Functions with PLpgSQL language/12. Variables in block and subblock.vtt 6.1 KB
18. Joining Multiple Tables/6. INNER joins with different data type columns.vtt 6.1 KB
33. Functions with SQL language/19. Drop a function.vtt 6.0 KB
31. Table Partitions/16. Partitioning Advantages.vtt 6.0 KB
22. JSON with PostgreSQL/7. Create JSON from tables.vtt 6.0 KB
23. Indexes and Performance Optimization/5. Size of the table index.vtt 6.0 KB
44. Managing PostgreSQL security/11. Row level policy for application users.vtt 6.0 KB
28. Window Functions/38. Getting RANK to compute group and global ranks.vtt 6.0 KB
28. Window Functions/35. Window Function Summary.vtt 6.0 KB
14. String Functions/1. UPPER, LOWER and INITCAP.vtt 6.0 KB
10. Conversion Functions/4. to_timestamp.vtt 6.0 KB
06. Filtering Data/17. Concatenation with , CONCAT and CONCAT_WS.vtt 5.9 KB
09. Data type conversions/3. Implicit to Explicit conversions.vtt 5.9 KB
18. Joining Multiple Tables/5. INNER joins with filter data Part 3.vtt 5.9 KB
31. Table Partitions/10. Partition maintenance.vtt 5.9 KB
20. PostgreSQL Schemas/8. What is a system catalog schema.vtt 5.9 KB
34. Functions with PLpgSQL language/13. How to return query results.vtt 5.8 KB
25. Fun with subqueries/13. Subquery using EXISTS.vtt 5.8 KB
22. JSON with PostgreSQL/9. Build a JSON array.vtt 5.8 KB
34. Functions with PLpgSQL language/20. FOR Loops iterate over result set.vtt 5.8 KB
32. Server Programming/2. Procedural languages.vtt 5.8 KB
24. All about Views/17. Creating a materialized view.vtt 5.8 KB
46. PostgreSQL Internals/2. List all database and schemas.vtt 5.7 KB
36. PostgreSQL Triggers/20. Creating event triggers.vtt 5.7 KB
03. Creating and Modifying Tables/9. Using pgAdmin - Create and modify a table.vtt 5.7 KB
21. Exploring array functions/3. Using inclusion operators.vtt 5.7 KB
25. Fun with subqueries/3. Subquery with IN operator.vtt 5.7 KB
28. Window Functions/11. Partitioning the data.vtt 5.7 KB
34. Functions with PLpgSQL language/11. Using IN, OUT without RETURNS.vtt 5.7 KB
41. Using Northwind Database/11. Top customers with total orders amount.vtt 5.6 KB
23. Indexes and Performance Optimization/6. List counts of all indexes.vtt 5.6 KB
16. Using DATETIME functions/14. PostgreSQL Date Time Functions.vtt 5.6 KB
23. Indexes and Performance Optimization/15. Index Types - B-Tree Index.vtt 5.6 KB
14. String Functions/10. SUBSTRING.vtt 5.6 KB
21. Exploring array functions/10. Using arrays in tables.vtt 5.6 KB
24. All about Views/22. Why not use a table instead of materialized view.vtt 5.6 KB
12. Explore PostgreSQL Constraints/4. DEFAULT constraint.vtt 5.5 KB
19. Combining queries together/4. INTERSECT with tables.vtt 5.5 KB
44. Managing PostgreSQL security/3. Instance Level Security - Add users to roles.vtt 5.5 KB
13. PostgreSQL Sequences/5. Creating a descending sequence, and CYCLE sequence.vtt 5.5 KB
16. Using DATETIME functions/14. PostgreSQL Date Time Functions.vtt 5.4 KB
23. Indexes and Performance Optimization/8. SQL Statement execution process.vtt 5.4 KB
23. Indexes and Performance Optimization/16. Hash Index.vtt 5.4 KB
36. PostgreSQL Triggers/21. Event trigger events and variables.vtt 5.4 KB
22. JSON with PostgreSQL/15. The Containment Operator.vtt 5.4 KB
24. All about Views/6. A view with UNION of multiple tables.vtt 5.4 KB
24. All about Views/3. Rename a view.vtt 5.3 KB
46. PostgreSQL Internals/8. Show all running queries.vtt 5.3 KB
21. Exploring array functions/14. Array Dimensions are ignored!.vtt 5.3 KB
38. Creating Crosstab Reports/6. Pivoting rows and columns.vtt 5.3 KB
25. Fun with subqueries/6. Order entries in UNION without using ORDER BY.vtt 5.3 KB
02. Introduction to PostgreSQL/4. Creating a Database User.vtt 5.3 KB
32. Server Programming/4. Functions vs stored procedures.vtt 5.3 KB
34. Functions with PLpgSQL language/25. Returning a table.vtt 5.2 KB
44. Managing PostgreSQL security/4. Use pgAdmin to create roles.vtt 5.2 KB
23. Indexes and Performance Optimization/28. Try to use index only scan.vtt 5.2 KB
04. Modifying Data in the tables/1. Insert a data into table.vtt 5.2 KB
44. Managing PostgreSQL security/1. Security concepts and and levels.vtt 5.2 KB
22. JSON with PostgreSQL/16. JSON search with PostgreSQL functions.vtt 5.2 KB
23. Indexes and Performance Optimization/4. List all indexes.vtt 5.2 KB
16. Using DATETIME functions/12. OVERLAPS Operator.vtt 5.1 KB
34. Functions with PLpgSQL language/29. Using SQLSTATE codes for exception handling.vtt 5.1 KB
34. Functions with PLpgSQL language/22. FOREACH loop with arrays.vtt 5.1 KB
46. PostgreSQL Internals/1. List database users, and database sizes with and without indexes.vtt 5.1 KB
14. String Functions/7. LENGTH.vtt 5.0 KB
24. All about Views/26. List materialized views with no unique index.vtt 5.0 KB
44. Managing PostgreSQL security/14. Row Level Security Performance.vtt 5.0 KB
14. String Functions/12. REPLACE.vtt 5.0 KB
21. Exploring array functions/15. Display all array elements.vtt 5.0 KB
45. PostgreSQL Utilities - psql/1. Connect to local or remote database.vtt 5.0 KB
40. PostgreSQL Transactions/6. How to fix aborted transaction.vtt 5.0 KB
28. Window Functions/5. ROLLUP - Grouping multiple columns.vtt 4.9 KB
28. Window Functions/40. Using WITH clause to create your own data.vtt 4.9 KB
41. Using Northwind Database/7. Total products in each categories.vtt 4.9 KB
38. Creating Crosstab Reports/1. What is a crosstab report.vtt 4.9 KB
11. User-defined Data Types/5. CREATE DOMAIN - Create a Enum or Set of values domain data type.vtt 4.9 KB
41. Using Northwind Database/5. Show total order amount for each order.vtt 4.9 KB
31. Table Partitions/13. Partition pruning.vtt 4.8 KB
23. Indexes and Performance Optimization/1. What is an index.vtt 4.8 KB
07. PostgreSQL Data types/6. DateTime data types.vtt 4.8 KB
35. Exploring Stored Procedures/4. Returning a value.vtt 4.7 KB
28. Window Functions/7. GROUP BY GROUPING SETS.vtt 4.7 KB
23. Indexes and Performance Optimization/7. Drop a index.vtt 4.7 KB
45. PostgreSQL Utilities - psql/10. Represent NULL values on psql terminal.vtt 4.7 KB
45. PostgreSQL Utilities - psql/13. Represent NULL Visibly.vtt 4.7 KB
33. Functions with SQL language/2. Introducing dollar quoting.vtt 4.7 KB
24. All about Views/12. What is an updatable view.vtt 4.6 KB
13. PostgreSQL Sequences/2. Restart, rename a sequence, and use pgAdmin to alter a sequence.vtt 4.6 KB
16. Using DATETIME functions/20. View and set timezones.vtt 4.6 KB
40. PostgreSQL Transactions/8. Partial transaction rollback with savepoints.vtt 4.6 KB
22. JSON with PostgreSQL/3. JSON and JSONB data types.vtt 4.6 KB
02. Introduction to PostgreSQL/11. Drop a database.vtt 4.5 KB
03. Creating and Modifying Tables/6. Creating a Junction table with movies and actors tables.vtt 4.5 KB
28. Window Functions/18. Using WINDOW with ROWS BETWEEN.vtt 4.5 KB
28. Window Functions/1. Introduction to Window Functions.vtt 4.5 KB
16. Using DATETIME functions/15. AGE function.vtt 4.4 KB
28. Window Functions/27. ROW_NUMBER() - Find Nth record.vtt 4.4 KB
12. Explore PostgreSQL Constraints/1. Introduction to constraints.vtt 4.4 KB
03. Creating and Modifying Tables/1. Movie Database Structure.vtt 4.4 KB
08. Modifying Table Structures, Add constraints/1. Creating sample database 'mydata', adding columns.vtt 4.4 KB
11. User-defined Data Types/10. CREATE TYPE - Create an ENUM data type and see how to drop a data type.vtt 4.4 KB
22. JSON with PostgreSQL/1. What is JSON.vtt 4.3 KB
43. Exploring Stock Markets Data/2. Select first or last records in a table.vtt 4.3 KB
16. Using DATETIME functions/17. CURRENT_TIME function.vtt 4.3 KB
05. Querying Data/2. Selecting specific columns from a table.vtt 4.3 KB
45. PostgreSQL Utilities - psql/4. List all table space, schemas, and indices.vtt 4.3 KB
45. PostgreSQL Utilities - psql/3. List all databases and tables.vtt 4.3 KB
06. Filtering Data/3. OR operator.vtt 4.2 KB
11. User-defined Data Types/9. CREATE TYPE - Create a composite inventory_item data type.vtt 4.2 KB
24. All about Views/8. Re-arrange columns in a view.vtt 4.2 KB
42. Using Human Resource (hr) database/4. Get highest, lowest, total, and average salaries of employees.vtt 4.2 KB
43. Exploring Stock Markets Data/3. Get first or last record per each group.vtt 4.2 KB
13. PostgreSQL Sequences/9. Share one sequence between two tables.vtt 4.2 KB
41. Using Northwind Database/8. List products that needs re-ordering.vtt 4.1 KB
18. Joining Multiple Tables/12. RIGHT joins Part 2.vtt 4.1 KB
27. Grouping sets/1. Introduction to summarization.vtt 4.1 KB
14. String Functions/8. POSITION.vtt 4.1 KB
19. Combining queries together/3. UNION tables with different number of columns.vtt 4.1 KB
33. Functions with SQL language/6. Function returning a single value Part 3.vtt 4.0 KB
36. PostgreSQL Triggers/17. Use triggers very cautiously.vtt 4.0 KB
21. Exploring array functions/13. Modifying array data.vtt 4.0 KB
18. Joining Multiple Tables/4. INNER joins with filter data Part 2.vtt 4.0 KB
05. Querying Data/7. Using ORDER BY to sort rows by expressions.vtt 4.0 KB
38. Creating Crosstab Reports/4. Orders matters in crosstab reports.vtt 4.0 KB
32. Server Programming/5. User-defined functions.vtt 4.0 KB
18. Joining Multiple Tables/16. Self Joins Part 2.vtt 4.0 KB
05. Querying Data/8. Using ORDER BY with column name or column number.vtt 4.0 KB
24. All about Views/18. Drop a materialized view.vtt 4.0 KB
42. Using Human Resource (hr) database/1. Human Resources Database Structure.vtt 4.0 KB
11. User-defined Data Types/11. ALTER TYPE - Alter a composite data type, change schema and more.vtt 4.0 KB
23. Indexes and Performance Optimization/31. Adding data while indexing.vtt 3.9 KB
41. Using Northwind Database/4. Orders shipped to latin america.vtt 3.9 KB
42. Using Human Resource (hr) database/19. Select employees not in range.vtt 3.9 KB
20. PostgreSQL Schemas/4. Move a table to a new schema.vtt 3.8 KB
24. All about Views/23. The downsides of using materialized views.vtt 3.8 KB
41. Using Northwind Database/15. Countries with customers or suppliers.vtt 3.8 KB
45. PostgreSQL Utilities - psql/8. Display command history, run commands from a file.vtt 3.8 KB
16. Using DATETIME functions/2. System Month Date settings.vtt 3.8 KB
03. Creating and Modifying Tables/5. Creating the movies_revenues table.vtt 3.8 KB
22. JSON with PostgreSQL/14. The Existence Operator.vtt 3.8 KB
42. Using Human Resource (hr) database/3. Quick overview of all tables Part 2.vtt 3.8 KB
11. User-defined Data Types/14. An ENUM with a DEFAULT value in a table.vtt 3.7 KB
33. Functions with SQL language/14. Function - order matters!.vtt 3.7 KB
33. Functions with SQL language/16. Function parameter modes.vtt 3.7 KB
36. PostgreSQL Triggers/19. Event triggers usage scenarios.vtt 3.7 KB
04. Modifying Data in the tables/8. Delete data from a table.vtt 3.6 KB
28. Window Functions/37. Difference between RANK and DENSE_RANK.vtt 3.6 KB
11. User-defined Data Types/12. ALTER TYPE - Alter an ENUM data type.vtt 3.6 KB
23. Indexes and Performance Optimization/20. EXPLAIN output options.vtt 3.6 KB
06. Filtering Data/5. What goes before and after WHERE clause.vtt 3.6 KB
42. Using Human Resource (hr) database/14. List all employees with first_name starts with letters A, C or M.vtt 3.6 KB
29. Using regular expressions for text patterns/9. REGEXP_SPLIT_TO_ARRAY function.vtt 3.6 KB
05. Querying Data/4. Using SELECT statement for expressions.vtt 3.6 KB
04. Modifying Data in the tables/5. Update data in a table.vtt 3.6 KB
47. Managing Tables/2. Duplicate a table with or without data.vtt 3.6 KB
11. User-defined Data Types/4. CREATE DOMAIN - Create a domain data type for an email validation.vtt 3.6 KB
04. Modifying Data in the tables/7. Updating all records in a table.vtt 3.6 KB
13. PostgreSQL Sequences/3. Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.vtt 3.6 KB
34. Functions with PLpgSQL language/9. Copying data types.vtt 3.5 KB
33. Functions with SQL language/13. Function returning a table.vtt 3.5 KB
24. All about Views/11. Regular views are dynamic.vtt 3.5 KB
42. Using Human Resource (hr) database/21. Update phone_number with your strings.vtt 3.5 KB
36. PostgreSQL Triggers/6. Trigger key points.vtt 3.5 KB
36. PostgreSQL Triggers/4. Trigger table.vtt 3.5 KB
12. Explore PostgreSQL Constraints/12. Add or update foreign key constraint on existing table.vtt 3.5 KB
41. Using Northwind Database/12. Orders with many lines of ordered items.vtt 3.4 KB
44. Managing PostgreSQL security/13. Inspecting permissions.vtt 3.4 KB
05. Querying Data/6. Using ORDER BY with alias column name.vtt 3.4 KB
46. PostgreSQL Internals/4. List all columns from a table.vtt 3.4 KB
02. Introduction to PostgreSQL/5. Creating a Database.vtt 3.4 KB
03. Creating and Modifying Tables/3. Creating the directors table.vtt 3.4 KB
37. Using Cursors/3. Steps to create a cursor.vtt 3.4 KB
04. Modifying Data in the tables/4. Use RETURNING to get info on added rows.vtt 3.4 KB
32. Server Programming/6. Structure of a function.vtt 3.3 KB
28. Window Functions/12. Set data into millions format.vtt 3.3 KB
46. PostgreSQL Internals/9. Terminate running and IDLE process.vtt 3.3 KB
11. User-defined Data Types/3. CREATE DOMAIN - Create a postal code validation data type.vtt 3.3 KB
24. All about Views/20. How to check if a materialized view is populated or not.vtt 3.2 KB
31. Table Partitions/4. Partition types.vtt 3.2 KB
40. PostgreSQL Transactions/4. Transaction setup.vtt 3.2 KB
24. All about Views/10. Add a column in a view.vtt 3.2 KB
46. PostgreSQL Internals/5. View system metadata via system information functions.vtt 3.2 KB
14. String Functions/11. REPEAT.vtt 3.2 KB
36. PostgreSQL Triggers/3. Types of triggers.vtt 3.1 KB
47. Managing Tables/4. Export Data to CSV files.vtt 3.1 KB
03. Creating and Modifying Tables/12. Deleting tables from a database.vtt 3.1 KB
25. Fun with subqueries/8. A SELECT without a FROM.vtt 3.1 KB
02. Introduction to PostgreSQL/7. Install sample data files on server.vtt 3.1 KB
45. PostgreSQL Utilities - psql/14. Turn on query execution time.vtt 3.1 KB
34. Functions with PLpgSQL language/2. PLpgSQL vs SQL.vtt 3.0 KB
04. Modifying Data in the tables/2. Insert multiple records into a table.vtt 3.0 KB
28. Window Functions/26. ROW_NUMBER() - Reverse fields with order by.vtt 2.9 KB
06. Filtering Data/7. Can we use column aliases with WHERE.vtt 2.9 KB
42. Using Human Resource (hr) database/24. find employees whose names contains exactly six characters.vtt 2.9 KB
34. Functions with PLpgSQL language/8. Variable initializing timing.vtt 2.9 KB
12. Explore PostgreSQL Constraints/11. Drop a constraint.vtt 2.9 KB
42. Using Human Resource (hr) database/20. Find Letter C in last_name at 3rd or greater position.vtt 2.8 KB
44. Managing PostgreSQL security/12. DROP a policy.vtt 2.8 KB
14. String Functions/3. REVERSE.vtt 2.8 KB
18. Joining Multiple Tables/19. Natural Joins Part 2.vtt 2.8 KB
21. Exploring array functions/18. Single and Multi-dimensional arrays.html 2.8 KB
34. Functions with PLpgSQL language/4. PLpgSQL block structure.vtt 2.8 KB
02. Introduction to PostgreSQL/6. Running a query in pgAdmin tool.vtt 2.7 KB
11. User-defined Data Types/6. CREATE DOMAIN - Get the list of all DOMAIN data types.vtt 2.7 KB
42. Using Human Resource (hr) database/11. Compute 15% of salary for all employees.vtt 2.7 KB
02. Introduction to PostgreSQL/3. Configure pgAdmin 4 client.vtt 2.7 KB
42. Using Human Resource (hr) database/18. Select employees with particular department id only.vtt 2.7 KB
42. Using Human Resource (hr) database/7. Average salary for each department with more than 10 employees.vtt 2.6 KB
23. Indexes and Performance Optimization/17. BRIN index.vtt 2.6 KB
06. Filtering Data/1. Comparison, Logical and Arithmetic operators.vtt 2.6 KB
04. Modifying Data in the tables/6. Updating a row and returning the updated row.vtt 2.6 KB
02. Introduction to PostgreSQL/1. Installing PostgreSQL on Mac.vtt 2.6 KB
24. All about Views/9. Delete a column in a view.vtt 2.6 KB
42. Using Human Resource (hr) database/22. Get the monthly salary of each employees.vtt 2.6 KB
13. PostgreSQL Sequences/4. Create a sequence using a specific data type.vtt 2.5 KB
34. Functions with PLpgSQL language/1. Introduction to PLpgSQL language.vtt 2.5 KB
02. Introduction to PostgreSQL/8. Install Human Resources (hr) database.vtt 2.5 KB
02. Introduction to PostgreSQL/9. Install sample stocks market data.vtt 2.5 KB
24. All about Views/4. Delete a view.vtt 2.5 KB
20. PostgreSQL Schemas/6. Alter a schema ownership.vtt 2.5 KB
35. Exploring Stored Procedures/5. Drop a procedure.vtt 2.5 KB
41. Using Northwind Database/6. First the oldest and latest order date.vtt 2.4 KB
45. PostgreSQL Utilities - psql/11. Make table layout funkey!.vtt 2.4 KB
11. User-defined Data Types/15. Create a type if not exists using a PLpgSQL function.vtt 2.4 KB
04. Modifying Data in the tables/3. Insert a data that had quotes.vtt 2.3 KB
11. User-defined Data Types/2. CREATE DOMAIN - Create a data type for a positive number.vtt 2.3 KB
42. Using Human Resource (hr) database/6. Get lowest paid salaries by each manager.vtt 2.3 KB
42. Using Human Resource (hr) database/9. Maximum salary for each post where salary is at or above $5000.vtt 2.3 KB
41. Using Northwind Database/2. Orders shipping to USA or France.vtt 2.3 KB
45. PostgreSQL Utilities - psql/2. Switch connection to a new database.vtt 2.2 KB
38. Creating Crosstab Reports/2. Installing the tablefunc extension.vtt 2.2 KB
23. Indexes and Performance Optimization/18. GIN Index.vtt 2.2 KB
06. Filtering Data/6. Execution order with AND, OR operators.vtt 2.2 KB
42. Using Human Resource (hr) database/15. String manipulation with upper, lower and initcap functions.vtt 2.2 KB
42. Using Human Resource (hr) database/17. Get unique designations in employees table.vtt 2.1 KB
36. PostgreSQL Triggers/18. What is an event trigger.vtt 2.1 KB
37. Using Cursors/7. Updating data.vtt 2.1 KB
24. All about Views/25. List all materialized views by a SELECT statement.vtt 2.0 KB
15. Aggregate functions/6. GREATEST vs. MAX().html 2.0 KB
45. PostgreSQL Utilities - psql/12. Repeatedly Execute a Query.vtt 2.0 KB
41. Using Northwind Database/3. Total numbers of orders shipped to USA or France.vtt 2.0 KB
46. PostgreSQL Internals/10. How to check live and dead rows in tables.vtt 2.0 KB
34. Functions with PLpgSQL language/6. Declaring variables via ALIAS FOR.vtt 1.9 KB
25. Fun with subqueries/1. Introduction to subqueries.html 1.9 KB
42. Using Human Resource (hr) database/10. Using an alias name with columns.vtt 1.9 KB
29. Using regular expressions for text patterns/8. REGEXP_SPLIT_TO_TABLE Function.vtt 1.9 KB
12. Explore PostgreSQL Constraints/13. CHECK constraint - An Introduction.vtt 1.8 KB
42. Using Human Resource (hr) database/23. Calculate average salary with total number of employees.vtt 1.8 KB
37. Using Cursors/8. Closing a cursor.vtt 1.8 KB
25. Fun with subqueries/7. Subquery with an alias.vtt 1.8 KB
42. Using Human Resource (hr) database/8. Average salary for each post excluding programmer.vtt 1.7 KB
17. Grouping Data/3. Order of execution in GROUP BY clause.vtt 1.7 KB
16. Using DATETIME functions/16. CURRENT_DATE function.vtt 1.7 KB
13. PostgreSQL Sequences/6. Delete a sequence.vtt 1.7 KB
43. Exploring Stock Markets Data/4. How to calculate cube root in PostgreSQL.vtt 1.7 KB
06. Filtering Data/8. Order of execution of WHERE, SELECT and ORDER BY clauses.vtt 1.6 KB
13. PostgreSQL Sequences/8. List all sequences in a database.vtt 1.6 KB
01. Welcome/1. Course Introduction.vtt 1.5 KB
42. Using Human Resource (hr) database/5. Difference bw highest and lowest salaries by job_id.vtt 1.4 KB
41. Using Northwind Database/1. Using Northwind database.vtt 1.4 KB
45. PostgreSQL Utilities - psql/7. Edit SQL commands in editor.vtt 1.4 KB
15. Aggregate functions/2. COUNT(), COUNT() and COUNT(1).html 1.3 KB
45. PostgreSQL Utilities - psql/6. Describe a table.vtt 1.3 KB
17. Grouping Data/5. Order of execution in HAVING clause.vtt 1.3 KB
49. Thank You!/3. Bonus Courses.html 1.2 KB
03. Creating and Modifying Tables/8. Create a sample Database mydata.html 1.2 KB
45. PostgreSQL Utilities - psql/9. Built-in syntax reference for commands.vtt 1.2 KB
36. PostgreSQL Triggers/24. Dropping a trigger.vtt 1.2 KB
42. Using Human Resource (hr) database/12. To list all employees IDs within each job_id group.vtt 1.1 KB
36. PostgreSQL Triggers/1. Introduction to triggers.html 1.1 KB
18. Joining Multiple Tables/21. ON versus WHERE.html 1.1 KB
42. Using Human Resource (hr) database/16. Using SUBSTRING to get portion of string data.vtt 1013 bytes
25. Fun with subqueries/5. Get total revenues for all 'English' films.html 970 bytes
38. Creating Crosstab Reports/11. pivotcode.sql 948 bytes
47. Managing Tables/6. Backup your databases regularly.html 929 bytes
49. Thank You!/4. Thank You!.vtt 929 bytes
47. Managing Tables/7. Test queries on a test database.html 893 bytes
24. All about Views/27. Quick queries for materialized views.html 771 bytes
26. Common Table Expressions (CTE)/4. Get the total revenues for each director.html 732 bytes
47. Managing Tables/8. Not documenting your process.html 720 bytes
22. JSON with PostgreSQL/12. JSON nulls and SQL nulls.html 708 bytes
49. Thank You!/1. Your feedback is very valuable.html 662 bytes
04. Modifying Data in the tables/9. q_upsert.sql 618 bytes
43. Exploring Stock Markets Data/1. Introduction To stock market data.html 612 bytes
01. Welcome/2. Sample Data Files.html 492 bytes
49. Thank You!/2. Upcoming course - Advanced Time Series Analysis.html 454 bytes
04. Modifying Data in the tables/1. q_insert data into table.sql 267 bytes
03. Creating and Modifying Tables/4. q_creating the movies table with a foreign key.sql 258 bytes
03. Creating and Modifying Tables/3. q_creating the directors table.sql 227 bytes
04. Modifying Data in the tables/4. q_use RETURNING to get info on added rows.sql 224 bytes
03. Creating and Modifying Tables/5. q_creating the movies_revenues table.sql 216 bytes
34. Functions with PLpgSQL language/8. q_variable_initialization_timing.sql 192 bytes
03. Creating and Modifying Tables/2. q_creating movies database and actors table.sql 186 bytes
03. Creating and Modifying Tables/6. q_creating a junction table with movies and actors table.sql 184 bytes
04. Modifying Data in the tables/5. q_update_data_in_a_table.sql 165 bytes
04. Modifying Data in the tables/2. q_insert multiple records into a table.sql 137 bytes
03. Creating and Modifying Tables/12. q_deleting tables from a database.sql 119 bytes
04. Modifying Data in the tables/6. q_updating_a_row_and_returning_the_updated_row.sql 102 bytes
04. Modifying Data in the tables/8. q_delete_data_from_a_table.sql 96 bytes
04. Modifying Data in the tables/3. q_insert a data that had quotes.sql 93 bytes
04. Modifying Data in the tables/7. q_updating_all_records_in_a_table.sql 62 bytes

Udemy - PostgreSQL Bootcamp Go From Beginner to Advanced, 60+hours (10.2023)

File List

Download Torrent

Related Resources

Copyright Infringement