[Udemy] PostgreSQL Bootcamp Go From Beginner to Advanced (2021) [En] -移花宫-武林禁地，闲人禁止入内

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

磁力链接/BT种子名称

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

磁力链接/BT种子简介

种子哈希：b2e0c657eb287dfd4133f18cb80b69e4d3ba87bf
文件大小： 19.7G
已经下载：2936次
下载速度：极快
收录时间：2022-01-18
最近下载：2024-12-25

移花宫入口

移花宫.com 邀月.com 怜星.com 花无缺.com yhgbt.icu yhgbt.top

磁力链接下载

magnet:?xt=urn:btih:B2E0C657EB287DFD4133F18CB80B69E4D3BA87BF
推荐使用PIKPAK网盘下载资源，10TB超大空间，不限制资源，无限次数离线下载，视频在线观看

下载BT种子文件

磁力链接迅雷下载 PIKPAK在线播放 91视频含羞草欲漫涩逼哩逼哩成人快手 51品茶抖阴破解版暗网禁地 91短视频 TikTok成人版 PornHub 草榴社区乱伦社区少女初夜萝莉岛

文件列表

29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.mp4 205.3 MB
28 Window Functions/015 Understanding window frames.mp4 194.1 MB
44 Managing PostgreSQL security/009 Row Level Security.mp4 177.6 MB
20 PostgreSQL Schemas/005 Schema search path.mp4 162.8 MB
30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.mp4 157.5 MB
33 Functions with SQL language/009 Function using parameters Part 3.mp4 139.3 MB
31 Table Partitions/006 Partition by List.mp4 137.1 MB
23 Indexes and Performance Optimization/030 Expression Index.mp4 125.9 MB
48 Extended PostgreSQL/001 Create a custom index method.mp4 125.3 MB
16 Using DATE_TIME functions/022 date_part function.mp4 125.0 MB
27 Grouping sets/002 Subtotals on group sets.mp4 120.2 MB
27 Grouping sets/004 Using GROUPING with ROLLUP.mp4 118.0 MB
31 Table Partitions/005 Partition by Range.mp4 107.7 MB
23 Indexes and Performance Optimization/027 Using organized vs random data.mp4 104.5 MB
23 Indexes and Performance Optimization/032 Invalidating an index.mp4 103.7 MB
28 Window Functions/002 Analyze Global Trades Data.mp4 101.4 MB
37 Using Cursors/010 Using a parametric cursor via function.mp4 96.7 MB
06 Filtering Data/009 Using Logical operators.mp4 94.8 MB
38 Creating Crosstab Reports/011 Dynamic pivot table columns.mp4 94.7 MB
46 PostgreSQL Internals/604 internal - view system administration functions.mp4 93.6 MB
12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.mp4 93.3 MB
06 Filtering Data/010 Using LIMIT and OFFSET.mp4 93.3 MB
06 Filtering Data/014 Using LIKE and ILIKE.mp4 92.3 MB
18 Joining Multiple Tables/007 LEFT joins Part 1.mp4 91.5 MB
31 Table Partitions/002 When a partition can be used_.mp4 90.6 MB
17 Grouping Data/004 Using HAVING.mp4 89.2 MB
36 PostgreSQL Triggers/014 Creating an audit trigger.mp4 88.7 MB
06 Filtering Data/011 Using FETCH.mp4 87.9 MB
45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.mp4 87.6 MB
18 Joining Multiple Tables/001 INNER joins.mp4 86.7 MB
22 JSON with PostgreSQL/017 Indexing on JSONB.mp4 86.1 MB
33 Functions with SQL language/010 Function using parameters Part 4.mp4 84.2 MB
47 Managing Tables/001 Using SELECT INTO to create a new table with joins.mp4 84.1 MB
28 Window Functions/013 Ordering inside window.mp4 83.1 MB
36 PostgreSQL Triggers/015 Creating conditional triggers.mp4 81.8 MB
38 Creating Crosstab Reports/012 Interactive client-side pivot.mp4 81.7 MB
23 Indexes and Performance Optimization/002 Create an index.mp4 81.6 MB
28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.mp4 81.5 MB
07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.mp4 81.0 MB
46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.mp4 79.6 MB
33 Functions with SQL language/007 Function using parameters.mp4 79.2 MB
36 PostgreSQL Triggers/022 Creating an audit event trigger.mp4 78.9 MB
23 Indexes and Performance Optimization/019 The EXPLAIN statement.mp4 78.4 MB
26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.mp4 77.9 MB
26 Common Table Expressions (CTE)/002 CTE query examples.mp4 77.2 MB
28 Window Functions/021 LEAD and LAG functions.mp4 76.5 MB
18 Joining Multiple Tables/020 Append tables with different columns.mp4 74.2 MB
44 Managing PostgreSQL security/007 Table Level Security.mp4 73.9 MB
44 Managing PostgreSQL security/015 Encrypted data in columns.mp4 73.1 MB
34 Functions with PL_pgSQL language/026 Using RETURN NEXT.mp4 73.0 MB
06 Filtering Data/012 Using IN, NOT IN.mp4 71.9 MB
22 JSON with PostgreSQL/013 Getting information from JSON documents.mp4 71.8 MB
15 Aggregate functions/003 MIN and MAX functions.mp4 71.7 MB
33 Functions with SQL language/011 Function returning a composite.mp4 71.1 MB
34 Functions with PL_pgSQL language/030 Exception with data exception errors.mp4 70.9 MB
31 Table Partitions/003 Table inheritance.mp4 69.8 MB
25 Fun with subqueries/002 Subqueries with WHERE Clause.mp4 69.2 MB
24 All about Views/024 Using materialized view for websites page analysis.mp4 66.8 MB
30 Powerful text searches in PostgreSQL/004 Full text search within a table.mp4 66.6 MB
21 Exploring array functions/017 Array vs JSONB.mp4 66.4 MB
31 Table Partitions/007 Partition by Hash.mp4 66.1 MB
31 Table Partitions/009 Multi-level partitioning.mp4 65.4 MB
38 Creating Crosstab Reports/013 Handling missing values.mp4 65.3 MB
07 PostgreSQL Data types/014 Network Addresses.mp4 65.0 MB
38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.mp4 64.9 MB
06 Filtering Data/002 AND operator.mp4 64.6 MB
15 Aggregate functions/005 Average with AVG function.mp4 64.5 MB
06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.mp4 64.4 MB
28 Window Functions/016 ROWS and RANGE indicators.mp4 64.3 MB
17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.mp4 64.1 MB
16 Using DATE_TIME functions/004 Strings to Dates conversions.mp4 64.0 MB
18 Joining Multiple Tables/014 Joining multiple tables.mp4 63.9 MB
16 Using DATE_TIME functions/006 Formatting Dates.mp4 63.8 MB
34 Functions with PL_pgSQL language/016 CASE Statement.mp4 63.8 MB
07 PostgreSQL Data types/008 TIME.mp4 63.8 MB
16 Using DATE_TIME functions/021 How to handle timezones.mp4 63.6 MB
12 Explore PostgreSQL Constraints/003 UNIQUE constraint.mp4 63.2 MB
09 Data type conversions/002 Using CAST for data conversions.mp4 62.4 MB
23 Indexes and Performance Optimization/023 Index are not free.mp4 61.5 MB
47 Managing Tables/012 Recovering unused space with VACUUM.mp4 61.4 MB
22 JSON with PostgreSQL/011 Null Values in JSON documents.mp4 61.3 MB
47 Managing Tables/011 PostgreSQL autovacuum proces.mp4 60.6 MB
16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.mp4 60.6 MB
39 Internationalization/001 Global Character Set Support.mp4 60.5 MB
38 Creating Crosstab Reports/008 Aggregate over filter.mp4 60.3 MB
23 Indexes and Performance Optimization/003 Create unique indexes.mp4 60.1 MB
39 Internationalization/002 Client and Server Encoding.mp4 60.0 MB
34 Functions with PL_pgSQL language/024 Using RETURN QUERY.mp4 59.7 MB
18 Joining Multiple Tables/003 INNER joins with filter data Part 1.mp4 59.7 MB
03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.mp4 59.6 MB
23 Indexes and Performance Optimization/022 Understanding query cost model.mp4 59.3 MB
40 PostgreSQL Transactions/005 Transaction analysis.mp4 59.0 MB
23 Indexes and Performance Optimization/029 Partial indexes.mp4 58.5 MB
17 Grouping Data/001 Using GROUP BY.mp4 58.5 MB
12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.mp4 58.5 MB
18 Joining Multiple Tables/017 CROSS Joins.mp4 58.5 MB
21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.mp4 58.3 MB
33 Functions with SQL language/015 Function as a table source.mp4 58.1 MB
24 All about Views/019 Changing materialized view data.mp4 58.0 MB
33 Functions with SQL language/012 Function returning multiple rows.mp4 57.9 MB
47 Managing Tables/013 Generated Columns.mp4 57.8 MB
07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.mp4 57.5 MB
24 All about Views/002 Creating a view.mp4 57.2 MB
07 PostgreSQL Data types/001 Boolean.mp4 57.2 MB
18 Joining Multiple Tables/011 RIGHT joins.mp4 57.1 MB
19 Combining queries together/001 Combine results sets with UNION.mp4 57.0 MB
28 Window Functions/023 ROW_NUMBER function.mp4 56.4 MB
22 JSON with PostgreSQL/006 Update and Delete JSON Data.mp4 55.8 MB
36 PostgreSQL Triggers/005 Pros and Cons of triggers.mp4 55.4 MB
34 Functions with PL_pgSQL language/023 WHILE loop.mp4 55.0 MB
07 PostgreSQL Data types/013 JSON.mp4 54.9 MB
30 Powerful text searches in PostgreSQL/002 Introducing tsvector.mp4 54.8 MB
25 Fun with subqueries/009 Correlated Queries.mp4 54.3 MB
12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.mp4 54.1 MB
18 Joining Multiple Tables/009 LEFT joins Part 3.mp4 53.6 MB
06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.mp4 53.2 MB
07 PostgreSQL Data types/010 UUID.mp4 52.8 MB
33 Functions with SQL language/001 Creating our first SQL function.mp4 52.6 MB
33 Functions with SQL language/004 Function returning a single value.mp4 52.6 MB
18 Joining Multiple Tables/002 INNER joins with USING.mp4 52.6 MB
36 PostgreSQL Triggers/010 Modify data at INSERT event.mp4 51.9 MB
44 Managing PostgreSQL security/006 Schema Level Security.mp4 51.2 MB
46 PostgreSQL Internals/006 View privileges information across tables.mp4 51.1 MB
05 Querying Data/003 Adding Aliases to columns in a table.mp4 50.8 MB
41 Using Northwind Database/009 Freight analysis.mp4 50.6 MB
16 Using DATE_TIME functions/023 date_trunc function.mp4 50.6 MB
28 Window Functions/003 Using aggregate functions.mp4 49.9 MB
21 Exploring array functions/016 Using Multi-dimensional arrays.mp4 49.9 MB
25 Fun with subqueries/004 Subquery with JOINs.mp4 49.7 MB
25 Fun with subqueries/012 Using ALL with subquery.mp4 49.6 MB
20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.mp4 49.6 MB
48 Extended PostgreSQL/002 Create a user-defined aggregate function.mp4 49.4 MB
28 Window Functions/034 Comparing with least number.mp4 49.3 MB
16 Using DATE_TIME functions/011 Using math operators with dates.mp4 49.0 MB
30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.mp4 48.7 MB
36 PostgreSQL Triggers/002 What is a trigger.mp4 48.5 MB
34 Functions with PL_pgSQL language/017 Searched CASE statement.mp4 48.4 MB
38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.mp4 48.3 MB
36 PostgreSQL Triggers/008 Data auditing with a trigger.mp4 48.2 MB
37 Using Cursors/009 Creating a PL_PGSQL Cursor.mp4 48.0 MB
12 Explore PostgreSQL Constraints/002 NOT NULL constraint.mp4 47.6 MB
33 Functions with SQL language/017 Function parameters with default values.mp4 47.4 MB
15 Aggregate functions/006 Combining Columns using Mathematical operators.mp4 47.3 MB
19 Combining queries together/002 UNION with filters and conditions.mp4 46.9 MB
16 Using DATE_TIME functions/001 Datetimes data types.mp4 46.4 MB
30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.mp4 46.4 MB
28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.mp4 46.3 MB
24 All about Views/016 What is a Materialized View.mp4 46.2 MB
16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.mp4 46.2 MB
10 Conversion Functions/001 to_char.mp4 46.1 MB
16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.mp4 46.1 MB
36 PostgreSQL Triggers/012 Disallow DELETE on a table.mp4 45.5 MB
05 Querying Data/005 Using ORDER BY to sort records.mp4 45.4 MB
07 PostgreSQL Data types/003 NUMERIC.mp4 45.3 MB
08 Modifying Table Structures, Add constraints/003 Add constraints to columns.mp4 45.2 MB
30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.mp4 45.0 MB
18 Joining Multiple Tables/008 LEFT joins Part 2.mp4 45.0 MB
46 PostgreSQL Internals/002 List all database and schemas.mp4 45.0 MB
41 Using Northwind Database/014 Late shipped orders by employees.mp4 44.9 MB
37 Using Cursors/001 Understanding row by row operations.mp4 44.9 MB
47 Managing Tables/003 Import data from CSV files.mp4 44.8 MB
37 Using Cursors/005 Opening a cursor.mp4 44.7 MB
07 PostgreSQL Data types/004 DECIMALS.mp4 44.6 MB
24 All about Views/014 Updatable views using WITH CHECK OPTION.mp4 44.6 MB
24 All about Views/007 Connecting multiple tables with a single view.mp4 44.4 MB
38 Creating Crosstab Reports/007 Matrix report via a query.mp4 44.3 MB
32 Server Programming/001 PostgreSQL as a development platform_.mp4 44.1 MB
12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.mp4 44.0 MB
23 Indexes and Performance Optimization/013 Index Nodes.mp4 43.9 MB
03 Creating and Modifying Tables/007 Install sample data for 'movies' database.mp4 43.0 MB
17 Grouping Data/007 Handling NULL values with GROUP BY.mp4 42.8 MB
20 PostgreSQL Schemas/007 Duplicate a schema along with all data.mp4 42.8 MB
24 All about Views/005 Using filters with views.mp4 42.6 MB
38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.mp4 42.6 MB
14 String Functions/002 LEFT and RIGHT.mp4 42.4 MB
25 Fun with subqueries/011 Using ANY with subquery.mp4 42.4 MB
24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 42.2 MB
34 Functions with PL_pgSQL language/010 Assigning variables from query.mp4 42.1 MB
46 PostgreSQL Internals/003 List all tables and views.mp4 41.9 MB
40 PostgreSQL Transactions/001 What is a transaction_.mp4 41.7 MB
12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.mp4 41.6 MB
29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.mp4 41.5 MB
25 Fun with subqueries/010 SELECT.. IN (Subquery).mp4 41.2 MB
05 Querying Data/001 Select all data from a table.mp4 41.1 MB
23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.mp4 41.1 MB
16 Using DATE_TIME functions/018 Date accuracy with EPOCH.mp4 40.7 MB
31 Table Partitions/011 ALTERing the partition bounds.mp4 40.4 MB
04 Modifying Data in the tables/009 Using UPSERT.mp4 40.3 MB
40 PostgreSQL Transactions/003 ACID Database.mp4 40.2 MB
41 Using Northwind Database/013 Orders with double entry line items.mp4 40.1 MB
28 Window Functions/020 NTILE function.mp4 39.9 MB
15 Aggregate functions/001 Counting results via COUNT function.mp4 39.9 MB
15 Aggregate functions/002 Sum with SUM function.mp4 39.7 MB
24 All about Views/021 Refreshing data in materialize views.mp4 39.6 MB
41 Using Northwind Database/018 First order from each country.mp4 39.5 MB
18 Joining Multiple Tables/010 LEFT joins Part 4.mp4 39.4 MB
37 Using Cursors/006 Using a cursor.mp4 39.3 MB
29 Using regular expressions for text patterns/002 Regular expressions notations table.mp4 39.1 MB
23 Indexes and Performance Optimization/014 Join Nodes.mp4 38.9 MB
16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.mp4 38.9 MB
36 PostgreSQL Triggers/023 Prevent schema changes.mp4 38.9 MB
21 Exploring array functions/009 Formatting and converting an array.mp4 38.8 MB
21 Exploring array functions/005 Array metadata functions.mp4 38.5 MB
13 PostgreSQL Sequences/007 Attach a sequence to a table column.mp4 38.3 MB
23 Indexes and Performance Optimization/012 Sequential Nodes.mp4 38.3 MB
16 Using DATE_TIME functions/010 Date Value Extractors functions.mp4 38.0 MB
23 Indexes and Performance Optimization/024 Indexes for sorted output.mp4 37.8 MB
20 PostgreSQL Schemas/010 Schemas and Privileges.mp4 37.7 MB
26 Common Table Expressions (CTE)/003 Combine CTE with a table.mp4 37.7 MB
28 Window Functions/017 Using WINDOW.mp4 37.5 MB
36 PostgreSQL Triggers/009 Bind a function to a table with trigger.mp4 37.2 MB
18 Joining Multiple Tables/015 Self Joins Part 1.mp4 37.2 MB
28 Window Functions/029 ROW_NUMBER() - Pagination technique.mp4 37.0 MB
37 Using Cursors/004 Creating a cursor.mp4 37.0 MB
21 Exploring array functions/003 Using inclusion operators.mp4 36.7 MB
44 Managing PostgreSQL security/008 Column Level Security.mp4 36.7 MB
08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.mp4 36.6 MB
23 Indexes and Performance Optimization/010 The query optimizer.mp4 36.5 MB
34 Functions with PL_pgSQL language/015 Using IF with table data.mp4 36.1 MB
12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.mp4 35.9 MB
21 Exploring array functions/002 Using comparison operators.mp4 35.9 MB
06 Filtering Data/016 Concatenation techniques.mp4 35.7 MB
35 Exploring Stored Procedures/002 Create a transactions.mp4 35.7 MB
22 JSON with PostgreSQL/002 JSON Syntax.mp4 35.6 MB
24 All about Views/001 Introduction to views.mp4 35.5 MB
41 Using Northwind Database/017 Customers with multiple orders.mp4 35.5 MB
31 Table Partitions/008 DEFAULT Partition.mp4 34.8 MB
14 String Functions/004 SPLIT_PART.mp4 34.6 MB
34 Functions with PL_pgSQL language/014 Control Structures - IF statement.mp4 34.3 MB
33 Functions with SQL language/018 Function based on views.mp4 34.2 MB
14 String Functions/009 STRPOS.mp4 34.1 MB
31 Table Partitions/014 Determining a field for partition over.mp4 34.1 MB
27 Grouping sets/003 Adding subtotal with ROLLUP.mp4 34.1 MB
18 Joining Multiple Tables/005 INNER joins with filter data Part 3.mp4 34.1 MB
23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.mp4 34.0 MB
26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.mp4 34.0 MB
34 Functions with PL_pgSQL language/013 How to return query results.mp4 33.9 MB
14 String Functions/006 LPAD and RPAD.mp4 33.9 MB
12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.mp4 33.9 MB
11 User-defined Data Types/013 Update an ENUM data in production server.mp4 33.8 MB
06 Filtering Data/004 Combining AND, OR operators.mp4 33.8 MB
42 Using Human Resource (hr) database/013 Discard characters from employees email address.mp4 33.7 MB
28 Window Functions/014 Sliding dynamic windows.mp4 33.5 MB
21 Exploring array functions/001 Constructing arrays and ranges.mp4 33.3 MB
40 PostgreSQL Transactions/007 How to fix transactions on crash.mp4 33.3 MB
22 JSON with PostgreSQL/005 Create our first table with JSONB data type.mp4 33.3 MB
07 PostgreSQL Data types/012 hstore.mp4 33.3 MB
13 PostgreSQL Sequences/010 Create an alphanumeric sequence.mp4 33.2 MB
31 Table Partitions/012 Partition Indexes.mp4 33.2 MB
02 Introduction to PostgreSQL/010 Install northwind database.mp4 33.2 MB
47 Managing Tables/010 Tracking table size.mp4 32.9 MB
09 Data type conversions/001 What is a data type conversion.mp4 32.7 MB
47 Managing Tables/005 Deleting duplicate records.mp4 32.5 MB
10 Conversion Functions/004 to_timestamp.mp4 32.4 MB
29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.mp4 32.3 MB
13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.mp4 31.7 MB
47 Managing Tables/004 Export Data to CSV files.mp4 31.6 MB
21 Exploring array functions/007 Array modification functions.mp4 31.6 MB
36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.mp4 31.5 MB
07 PostgreSQL Data types/011 Array.mp4 31.2 MB
09 Data type conversions/004 Table data conversion.mp4 31.1 MB
23 Indexes and Performance Optimization/033 Rebuilding an index.mp4 30.9 MB
24 All about Views/013 An updatable view with CRUD operations.mp4 30.7 MB
21 Exploring array functions/006 Array search functions.mp4 30.6 MB
29 Using regular expressions for text patterns/003 SIMILAR TO operator.mp4 30.5 MB
21 Exploring array functions/012 Query array data.mp4 30.3 MB
38 Creating Crosstab Reports/009 Static to dynamic pivots.mp4 30.3 MB
22 JSON with PostgreSQL/008 Use json_agg to aggregate data.mp4 30.2 MB
11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 30.2 MB
33 Functions with SQL language/005 Function returning a single value Part 2.mp4 30.1 MB
10 Conversion Functions/003 to_date.mp4 29.9 MB
33 Functions with SQL language/008 Function using parameters Part 2.mp4 29.8 MB
23 Indexes and Performance Optimization/026 Execution plans depends on input values.mp4 29.8 MB
22 JSON with PostgreSQL/007 Create JSON from tables.mp4 29.7 MB
02 Introduction to PostgreSQL/009 Install sample stocks market data.mp4 29.7 MB
20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).mp4 29.6 MB
23 Indexes and Performance Optimization/009 SQL statement execution stages.mp4 29.5 MB
47 Managing Tables/009 Database operations and table size.mp4 29.2 MB
22 JSON with PostgreSQL/010 Creating a document from data.mp4 29.2 MB
46 PostgreSQL Internals/007 Using system Administration functions.mp4 29.2 MB
28 Window Functions/011 Partitioning the data.mp4 29.1 MB
20 PostgreSQL Schemas/001 What is a Schema_.mp4 28.6 MB
14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.mp4 28.6 MB
11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.mp4 28.3 MB
16 Using DATE_TIME functions/007 Date construction functions.mp4 28.2 MB
31 Table Partitions/001 What is a partition.mp4 28.1 MB
28 Window Functions/039 Using PARTITION BY for group averages.mp4 28.1 MB
16 Using DATE_TIME functions/013 Date _ Time Functions.mp4 28.1 MB
20 PostgreSQL Schemas/003 Schema Hierarchy.mp4 28.0 MB
31 Table Partitions/010 Partition maintenance.mp4 28.0 MB
32 Server Programming/003 Keep the data on the server!.mp4 28.0 MB
22 JSON with PostgreSQL/004 Exploring JSON objects.mp4 28.0 MB
28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.mp4 28.0 MB
20 PostgreSQL Schemas/008 What is a system catalog schema_.mp4 27.7 MB
33 Functions with SQL language/006 Function returning a single value Part 3.mp4 27.6 MB
35 Exploring Stored Procedures/004 Returning a value.mp4 27.6 MB
05 Querying Data/010 Using DISTINCT for selecting distinct values.mp4 27.3 MB
07 PostgreSQL Data types/007 DATE.mp4 27.1 MB
02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.mp4 27.0 MB
07 PostgreSQL Data types/005 Selecting Numbers data types.mp4 26.9 MB
35 Exploring Stored Procedures/003 Understanding the use of stored procedures.mp4 26.8 MB
44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.mp4 26.8 MB
28 Window Functions/031 Calculate difference compared to average.mp4 26.6 MB
28 Window Functions/041 Using WITH clause to set ORDER BY values.mp4 26.6 MB
28 Window Functions/030 Using OVER() to calculate percentage.mp4 25.9 MB
16 Using DATE_TIME functions/003 Time of day formats and inputs.mp4 25.9 MB
26 Common Table Expressions (CTE)/001 Introduction to CTEs.mp4 25.9 MB
35 Exploring Stored Procedures/001 Functions vs Stored Procedures.mp4 25.8 MB
44 Managing PostgreSQL security/013 Inspecting permissions.mp4 25.6 MB
23 Indexes and Performance Optimization/016 Hash Index.mp4 25.4 MB
43 Exploring Stock Markets Data/002 Select first or last records in a table.mp4 25.4 MB
18 Joining Multiple Tables/018 Natural Joins Part 1.mp4 25.2 MB
30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.mp4 25.0 MB
34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.mp4 24.9 MB
29 Using regular expressions for text patterns/001 Text to structured data.mp4 24.8 MB
34 Functions with PL_pgSQL language/027 Error and exception handling.mp4 24.7 MB
34 Functions with PL_pgSQL language/005 Declaring variables.mp4 24.6 MB
21 Exploring array functions/011 Insert data into arrays.mp4 24.6 MB
37 Using Cursors/002 Cursors and procedural languages.mp4 24.6 MB
34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.mp4 24.6 MB
34 Functions with PL_pgSQL language/018 LOOP statement.mp4 24.6 MB
36 PostgreSQL Triggers/007 Steps to create a trigger.mp4 24.6 MB
41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.mp4 24.5 MB
44 Managing PostgreSQL security/005 Database Level Security.mp4 24.5 MB
36 PostgreSQL Triggers/016 Disallow data change on primary key.mp4 24.4 MB
24 All about Views/006 A view with UNION of multiple tables.mp4 24.4 MB
40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.mp4 24.4 MB
28 Window Functions/042 DELETE and INSERT in one query using WITH.mp4 24.3 MB
34 Functions with PL_pgSQL language/028 Exception - Too many rows.mp4 24.1 MB
44 Managing PostgreSQL security/011 Row level policy for application users.mp4 24.1 MB
44 Managing PostgreSQL security/002 Instance Level Security.mp4 24.1 MB
05 Querying Data/009 Using ORDER BY with NULL values.mp4 24.0 MB
10 Conversion Functions/002 to_number.mp4 24.0 MB
40 PostgreSQL Transactions/002 How SQL protect database during transaction.mp4 24.0 MB
17 Grouping Data/006 HAVING vs WHERE.mp4 23.9 MB
23 Indexes and Performance Optimization/011 Optimizer node types.mp4 23.9 MB
41 Using Northwind Database/010 Customers with no orders.mp4 23.8 MB
36 PostgreSQL Triggers/011 View triggers variables.mp4 23.8 MB
34 Functions with PL_pgSQL language/019 FOR Loops.mp4 23.8 MB
28 Window Functions/024 Finding Correlations.mp4 23.8 MB
31 Table Partitions/015 Sizing the partition.mp4 23.7 MB
41 Using Northwind Database/011 Top customers with total orders amount.mp4 23.7 MB
33 Functions with SQL language/003 Function returning no values.mp4 23.7 MB
18 Joining Multiple Tables/004 INNER joins with filter data Part 2.mp4 23.5 MB
28 Window Functions/009 Using FILTER clause.mp4 23.4 MB
29 Using regular expressions for text patterns/004 POSIX regular expressions.mp4 23.4 MB
19 Combining queries together/005 EXCEPT with tables.mp4 23.3 MB
12 Explore PostgreSQL Constraints/004 DEFAULT constraint.mp4 23.3 MB
31 Table Partitions/016 Partitioning Advantages.mp4 23.2 MB
18 Joining Multiple Tables/013 FULL Joins.mp4 23.2 MB
32 Server Programming/002 Procedural languages.mp4 23.1 MB
28 Window Functions/008 Query performance check.mp4 22.8 MB
03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.mp4 22.7 MB
28 Window Functions/004 GROUP BY ROLLUP.mp4 22.7 MB
31 Table Partitions/017 Common partitioning mistakes.mp4 22.7 MB
46 PostgreSQL Internals/008 Show all running queries.mp4 22.6 MB
38 Creating Crosstab Reports/006 Pivoting rows and columns.mp4 22.4 MB
21 Exploring array functions/004 Array constructions.mp4 22.3 MB
28 Window Functions/033 Using LEAD to compare with next values.mp4 22.3 MB
03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.mp4 22.3 MB
28 Window Functions/032 Calculating cumulative totals.mp4 22.2 MB
28 Window Functions/010 Using Window Functions.mp4 22.1 MB
34 Functions with PL_pgSQL language/007 Declaring variables in function.mp4 22.1 MB
15 Aggregate functions/004 GREATEST AND LEAST functions.mp4 22.1 MB
11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.mp4 22.0 MB
28 Window Functions/019 RANK and DENSE_RANK functions.mp4 21.9 MB
02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.mp4 21.9 MB
22 JSON with PostgreSQL/001 What is JSON_.mp4 21.8 MB
28 Window Functions/038 Getting RANK to compute group and global ranks.mp4 21.7 MB
03 Creating and Modifying Tables/002 Creating the movie database and a actors table.mp4 21.6 MB
36 PostgreSQL Triggers/020 Creating event triggers.mp4 21.5 MB
03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.mp4 21.5 MB
22 JSON with PostgreSQL/003 JSON and JSONB data types.mp4 21.5 MB
18 Joining Multiple Tables/006 INNER joins with different data type columns.mp4 21.5 MB
25 Fun with subqueries/013 Subquery using EXISTS.mp4 21.4 MB
44 Managing PostgreSQL security/014 Row Level Security Performance.mp4 21.3 MB
43 Exploring Stock Markets Data/003 Get first or last record per each group.mp4 21.3 MB
23 Indexes and Performance Optimization/005 Size of the table index.mp4 21.3 MB
23 Indexes and Performance Optimization/006 List counts of all indexes.mp4 21.1 MB
14 String Functions/001 UPPER, LOWER and INITCAP.mp4 21.1 MB
42 Using Human Resource (hr) database/002 Quick overview of all tables.mp4 21.1 MB
28 Window Functions/006 GROUP BY CUBE.mp4 21.1 MB
36 PostgreSQL Triggers/021 Event trigger events and variables.mp4 20.7 MB
34 Functions with PL_pgSQL language/021 CONTINUE statement.mp4 20.7 MB
38 Creating Crosstab Reports/001 What is a crosstab report.mp4 20.6 MB
25 Fun with subqueries/003 Subquery with IN operator.mp4 20.6 MB
21 Exploring array functions/010 Using arrays in tables.mp4 20.6 MB
28 Window Functions/007 GROUP BY GROUPING SETS.mp4 20.4 MB
23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.mp4 20.4 MB
26 Common Table Expressions (CTE)/006 Recursive CTEs.mp4 20.0 MB
34 Functions with PL_pgSQL language/012 Variables in block and subblock.mp4 20.0 MB
34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.mp4 19.9 MB
13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.mp4 19.8 MB
04 Modifying Data in the tables/005 Update data in a table.mp4 19.8 MB
16 Using DATE_TIME functions/017 CURRENT_TIME function.mp4 19.7 MB
41 Using Northwind Database/005 Show total order amount for each order.mp4 19.7 MB
16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.mp4 19.6 MB
24 All about Views/017 Creating a materialized view.mp4 19.5 MB
22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.mp4 19.4 MB
33 Functions with SQL language/019 Drop a function.mp4 19.4 MB
44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.mp4 19.3 MB
34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.mp4 19.3 MB
04 Modifying Data in the tables/001 Insert a data into table.mp4 19.3 MB
21 Exploring array functions/014 Array Dimensions are ignored!.mp4 19.2 MB
24 All about Views/003 Rename a view.mp4 19.2 MB
23 Indexes and Performance Optimization/001 What is an index_.mp4 19.1 MB
28 Window Functions/018 Using WINDOW with ROWS BETWEEN.mp4 19.1 MB
06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.mp4 19.0 MB
23 Indexes and Performance Optimization/008 SQL Statement execution process.mp4 19.0 MB
24 All about Views/022 Why not use a table instead of materialized view_.mp4 18.9 MB
31 Table Partitions/013 Partition pruning.mp4 18.9 MB
12 Explore PostgreSQL Constraints/001 Introduction to constraints.mp4 18.9 MB
13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 18.7 MB
46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.mp4 18.6 MB
23 Indexes and Performance Optimization/004 List all indexes.mp4 18.6 MB
05 Querying Data/008 Using ORDER BY with column name or column number.mp4 18.5 MB
12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.mp4 18.4 MB
28 Window Functions/005 ROLLUP - Grouping multiple columns.mp4 18.3 MB
32 Server Programming/004 Functions vs stored procedures.mp4 18.3 MB
11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.mp4 18.2 MB
22 JSON with PostgreSQL/009 Build a JSON array.mp4 18.2 MB
08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.mp4 18.2 MB
11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 18.2 MB
25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.mp4 18.2 MB
11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.mp4 18.0 MB
14 String Functions/012 REPLACE.mp4 18.0 MB
34 Functions with PL_pgSQL language/025 Returning a table.mp4 17.9 MB
19 Combining queries together/004 INTERSECT with tables.mp4 17.9 MB
09 Data type conversions/003 Implicit to Explicit conversions.mp4 17.9 MB
41 Using Northwind Database/004 Orders shipped to latin america.mp4 17.9 MB
24 All about Views/026 List materialized views with no unique index.mp4 17.9 MB
45 PostgreSQL Utilities - psql/014 Turn on query execution time.mp4 17.9 MB
14 String Functions/010 SUBSTRING.mp4 17.8 MB
22 JSON with PostgreSQL/015 The Containment Operator.mp4 17.8 MB
11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.mp4 17.7 MB
11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 17.7 MB
28 Window Functions/036 Planning tips on using Window Functions.mp4 17.6 MB
33 Functions with SQL language/013 Function - order matters!.mp4 17.5 MB
33 Functions with SQL language/016 Function parameter modes.mp4 17.5 MB
14 String Functions/007 LENGTH.mp4 17.5 MB
32 Server Programming/005 User-defined functions.mp4 17.3 MB
28 Window Functions/035 Window Function Summary.mp4 17.3 MB
23 Indexes and Performance Optimization/028 Try to use index only scan.mp4 17.2 MB
16 Using DATE_TIME functions/012 OVERLAPS Operator.mp4 17.0 MB
33 Functions with SQL language/002 Introducing dollar quoting.mp4 17.0 MB
13 PostgreSQL Sequences/009 Share one sequence between two tables.mp4 16.9 MB
45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.mp4 16.8 MB
45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.mp4 16.8 MB
27 Grouping sets/001 Introduction to summarization.mp4 16.8 MB
24 All about Views/023 The downsides of using materialized views.mp4 16.8 MB
24 All about Views/012 What is an updatable view_.mp4 16.8 MB
21 Exploring array functions/015 Display all array elements.mp4 16.7 MB
05 Querying Data/002 Selecting specific columns from a table.mp4 16.7 MB
07 PostgreSQL Data types/006 Date_Time data types.mp4 16.7 MB
05 Querying Data/007 Using ORDER BY to sort rows by expressions.mp4 16.6 MB
45 PostgreSQL Utilities - psql/001 Connect to local or remote database.mp4 16.5 MB
06 Filtering Data/003 OR operator.mp4 16.5 MB
03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.mp4 16.4 MB
24 All about Views/018 Drop a materialized view.mp4 16.4 MB
40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.mp4 16.1 MB
28 Window Functions/027 ROW_NUMBER() - Find Nth record.mp4 16.0 MB
40 PostgreSQL Transactions/006 How to fix aborted transaction.mp4 16.0 MB
34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.mp4 15.8 MB
18 Joining Multiple Tables/012 RIGHT joins Part 2.mp4 15.8 MB
41 Using Northwind Database/007 Total products in each categories.mp4 15.8 MB
16 Using DATE_TIME functions/020 View and set timezones.mp4 15.8 MB
23 Indexes and Performance Optimization/007 Drop a index.mp4 15.7 MB
14 String Functions/008 POSITION.mp4 15.5 MB
42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.mp4 15.4 MB
33 Functions with SQL language/014 Function returning a table.mp4 15.4 MB
11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.mp4 15.2 MB
03 Creating and Modifying Tables/003 Creating the directors table.mp4 15.2 MB
45 PostgreSQL Utilities - psql/003 List all databases and tables.mp4 15.1 MB
06 Filtering Data/005 What goes before and after WHERE clause.mp4 14.9 MB
28 Window Functions/040 Using WITH clause to create your own data.mp4 14.9 MB
36 PostgreSQL Triggers/017 Use triggers very cautiously.mp4 14.9 MB
28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.mp4 14.8 MB
36 PostgreSQL Triggers/019 Event triggers usage scenarios.mp4 14.8 MB
16 Using DATE_TIME functions/015 AGE function.mp4 14.8 MB
45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.mp4 14.8 MB
44 Managing PostgreSQL security/004 Use pgAdmin to create roles.mp4 14.7 MB
42 Using Human Resource (hr) database/019 Select employees not in range.mp4 14.6 MB
19 Combining queries together/003 UNION tables with different number of columns.mp4 14.5 MB
11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.mp4 14.4 MB
24 All about Views/011 Regular views are dynamic.mp4 14.4 MB
42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.mp4 14.4 MB
05 Querying Data/006 Using ORDER BY with alias column name.mp4 14.3 MB
02 Introduction to PostgreSQL/011 Drop a database.mp4 14.3 MB
41 Using Northwind Database/008 List products that needs re-ordering.mp4 14.2 MB
37 Using Cursors/003 Steps to create a cursor.mp4 14.2 MB
13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 14.2 MB
05 Querying Data/004 Using SELECT statement for expressions.mp4 14.1 MB
47 Managing Tables/002 Duplicate a table with or without data.mp4 13.9 MB
04 Modifying Data in the tables/008 Delete data from a table.mp4 13.8 MB
18 Joining Multiple Tables/019 Natural Joins Part 2.mp4 13.8 MB
03 Creating and Modifying Tables/005 Creating the movies_revenues table.mp4 13.8 MB
04 Modifying Data in the tables/007 Updating all records in a table.mp4 13.8 MB
29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.mp4 13.6 MB
18 Joining Multiple Tables/016 Self Joins Part 2.mp4 13.6 MB
16 Using DATE_TIME functions/002 System Month Date settings.mp4 13.5 MB
21 Exploring array functions/013 Modifying array data.mp4 13.4 MB
42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.mp4 13.2 MB
42 Using Human Resource (hr) database/001 Human Resources Database Structure.mp4 13.1 MB
38 Creating Crosstab Reports/004 Orders matters in crosstab reports.mp4 13.1 MB
45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.mp4 13.0 MB
22 JSON with PostgreSQL/014 The Existence Operator.mp4 13.0 MB
42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.mp4 12.8 MB
03 Creating and Modifying Tables/001 Movie Database Structure.mp4 12.8 MB
45 PostgreSQL Utilities - psql/011 Make table layout funkey!.mp4 12.7 MB
31 Table Partitions/004 Partition types.mp4 12.7 MB
28 Window Functions/037 Difference between RANK and DENSE_RANK.mp4 12.6 MB
24 All about Views/008 Re-arrange columns in a view.mp4 12.6 MB
46 PostgreSQL Internals/009 Terminate running and IDLE process.mp4 12.5 MB
23 Indexes and Performance Optimization/020 EXPLAIN output options.mp4 12.5 MB
46 PostgreSQL Internals/004 List all columns from a table.mp4 12.5 MB
44 Managing PostgreSQL security/001 Security concepts and and levels.mp4 12.4 MB
36 PostgreSQL Triggers/003 Types of triggers.mp4 12.4 MB
24 All about Views/020 How to check if a materialized view is populated or not_.mp4 12.3 MB
12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.mp4 12.3 MB
32 Server Programming/006 Structure of a function.mp4 12.3 MB
23 Indexes and Performance Optimization/031 Adding data while indexing.mp4 12.2 MB
02 Introduction to PostgreSQL/004 Creating a Database User.mp4 12.2 MB
13 PostgreSQL Sequences/004 Create a sequence using a specific data type.mp4 12.1 MB
34 Functions with PL_pgSQL language/009 Copying data types.mp4 12.1 MB
42 Using Human Resource (hr) database/021 Update phone_number with your strings.mp4 12.1 MB
11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.mp4 11.7 MB
36 PostgreSQL Triggers/004 Trigger table.mp4 11.7 MB
04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.mp4 11.6 MB
46 PostgreSQL Internals/005 View system metadata via system information functions.mp4 11.6 MB
28 Window Functions/012 Set data into millions format.mp4 11.5 MB
36 PostgreSQL Triggers/006 Trigger key points.mp4 11.5 MB
20 PostgreSQL Schemas/004 Move a table to a new schema.mp4 11.4 MB
04 Modifying Data in the tables/006 Updating a row and returning the updated row.mp4 11.4 MB
34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.mp4 11.3 MB
02 Introduction to PostgreSQL/005 Creating a Database.mp4 11.1 MB
41 Using Northwind Database/012 Orders with many lines of ordered items.mp4 11.1 MB
02 Introduction to PostgreSQL/007 Install sample data files on server.mp4 11.1 MB
41 Using Northwind Database/015 Countries with customers or suppliers.mp4 10.7 MB
42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.mp4 10.7 MB
25 Fun with subqueries/008 A SELECT without a FROM.mp4 10.7 MB
34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.mp4 10.5 MB
44 Managing PostgreSQL security/012 DROP a policy.mp4 10.5 MB
42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.mp4 10.5 MB
40 PostgreSQL Transactions/004 Transaction setup.mp4 10.2 MB
45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.mp4 10.2 MB
03 Creating and Modifying Tables/012 Deleting tables from a database.mp4 10.2 MB
04 Modifying Data in the tables/002 Insert multiple records into a table.mp4 10.1 MB
06 Filtering Data/006 Execution order with AND, OR operators.mp4 9.8 MB
11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 9.8 MB
42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.mp4 9.7 MB
41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.mp4 9.6 MB
41 Using Northwind Database/002 Orders shipping to USA or France.mp4 9.6 MB
06 Filtering Data/007 Can we use column aliases with WHERE_.mp4 9.6 MB
42 Using Human Resource (hr) database/018 Select employees with particular department id only.mp4 9.4 MB
23 Indexes and Performance Optimization/017 BRIN index.mp4 9.4 MB
34 Functions with PL_pgSQL language/008 Variable initializing timing.mp4 9.3 MB
24 All about Views/010 Add a column in a view.mp4 9.2 MB
14 String Functions/011 REPEAT.mp4 9.1 MB
42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.mp4 9.1 MB
42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.mp4 9.0 MB
42 Using Human Resource (hr) database/017 Get unique designations in employees table.mp4 9.0 MB
11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.mp4 9.0 MB
06 Filtering Data/001 Comparison, Logical and Arithmetic operators.mp4 9.0 MB
20 PostgreSQL Schemas/006 Alter a schema ownership.mp4 8.9 MB
41 Using Northwind Database/006 First the oldest and latest order date.mp4 8.8 MB
42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.mp4 8.8 MB
02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.mp4 8.6 MB
34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.mp4 8.6 MB
11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.mp4 8.5 MB
14 String Functions/003 REVERSE.mp4 8.5 MB
38 Creating Crosstab Reports/002 Installing the tablefunc extension.mp4 8.2 MB
42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.mp4 8.2 MB
37 Using Cursors/007 Updating data.mp4 8.0 MB
12 Explore PostgreSQL Constraints/011 Drop a constraint.mp4 8.0 MB
02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.mp4 7.9 MB
04 Modifying Data in the tables/003 Insert a data that had quotes.mp4 7.9 MB
36 PostgreSQL Triggers/018 What is an event trigger.mp4 7.8 MB
24 All about Views/009 Delete a column in a view.mp4 7.6 MB
42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.mp4 7.5 MB
23 Indexes and Performance Optimization/018 GIN Index.mp4 7.4 MB
25 Fun with subqueries/007 Subquery with an alias.mp4 7.3 MB
43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.mp4 7.2 MB
42 Using Human Resource (hr) database/010 Using an alias name with columns.mp4 7.1 MB
24 All about Views/004 Delete a view.mp4 7.1 MB
35 Exploring Stored Procedures/005 Drop a procedure.mp4 7.1 MB
45 PostgreSQL Utilities - psql/002 Switch connection to a new database.mp4 7.1 MB
46 PostgreSQL Internals/010 How to check live and dead rows in tables.mp4 7.0 MB
42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.mp4 7.0 MB
34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.mp4 6.7 MB
06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 6.6 MB
28 Window Functions/001 Introduction to Window Functions.mp4 6.6 MB
13 PostgreSQL Sequences/008 List all sequences in a database.mp4 6.3 MB
24 All about Views/025 List all materialized views by a SELECT statement.mp4 6.2 MB
37 Using Cursors/008 Closing a cursor.mp4 6.1 MB
02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.mp4 6.0 MB
29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.mp4 6.0 MB
13 PostgreSQL Sequences/006 Delete a sequence.mp4 5.9 MB
01 Welcome/001 Course Introduction.mp4 5.8 MB
17 Grouping Data/003 Order of execution in GROUP BY clause.mp4 5.7 MB
42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.mp4 5.5 MB
42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.mp4 5.4 MB
45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.mp4 5.2 MB
12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.mp4 5.1 MB
16 Using DATE_TIME functions/016 CURRENT_DATE function.mp4 4.9 MB
45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.mp4 4.6 MB
17 Grouping Data/005 Order of execution in HAVING clause.mp4 4.3 MB
41 Using Northwind Database/001 Using Northwind database.mp4 4.3 MB
45 PostgreSQL Utilities - psql/006 Describe a table.mp4 4.1 MB
36 PostgreSQL Triggers/024 Dropping a trigger.mp4 4.1 MB
42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.mp4 3.0 MB
49 Thank You!/003 Thank You!.mp4 2.5 MB
01 Welcome/002 sample_data.zip 1.5 MB
02 Introduction to PostgreSQL/010 sample_data.zip 1.5 MB
02 Introduction to PostgreSQL/011 sample_data.zip 1.5 MB
30 Powerful text searches in PostgreSQL/385 president_speeches.csv 1.2 MB
01 Welcome/002 trades.sql 522.4 kB
28 Window Functions/331 trades.sql 522.4 kB
01 Welcome/002 northwind.sql 349.7 kB
02 Introduction to PostgreSQL/012 northwind.sql 349.7 kB
31 Table Partitions/006 Partition by List.en.srt 37.8 kB
28 Window Functions/015 Understanding window frames.en.srt 33.9 kB
36 PostgreSQL Triggers/014 Creating an audit trigger.en.srt 31.4 kB
31 Table Partitions/005 Partition by Range.en.srt 30.9 kB
12 Explore PostgreSQL Constraints/005 PRIMARY KEY Constraints.en.srt 30.7 kB
18 Joining Multiple Tables/001 INNER joins.en.srt 29.9 kB
26 Common Table Expressions (CTE)/007 Parent-child relationship via recursive CTE.en.srt 29.8 kB
48 Extended PostgreSQL/001 Create a custom index method.en.srt 29.4 kB
07 PostgreSQL Data types/002 CHAR, VARCHAR and TEXT.en.srt 29.1 kB
31 Table Partitions/002 When a partition can be used_.en.srt 28.7 kB
29 Using regular expressions for text patterns/005 SUBSTRING with regular expressions.en.srt 28.6 kB
23 Indexes and Performance Optimization/027 Using organized vs random data.en.srt 28.5 kB
06 Filtering Data/014 Using LIKE and ILIKE.en.srt 26.2 kB
06 Filtering Data/010 Using LIMIT and OFFSET.en.srt 25.6 kB
38 Creating Crosstab Reports/011 Dynamic pivot table columns.en.srt 24.9 kB
31 Table Partitions/003 Table inheritance.en.srt 24.5 kB
06 Filtering Data/009 Using Logical operators.en.srt 24.1 kB
26 Common Table Expressions (CTE)/002 CTE query examples.en.srt 23.7 kB
40 PostgreSQL Transactions/005 Transaction analysis.en.srt 23.5 kB
23 Indexes and Performance Optimization/002 Create an index.en.srt 23.4 kB
23 Indexes and Performance Optimization/019 The EXPLAIN statement.en.srt 23.1 kB
12 Explore PostgreSQL Constraints/003 UNIQUE constraint.en.srt 22.7 kB
23 Indexes and Performance Optimization/030 Expression Index.en.srt 22.7 kB
31 Table Partitions/007 Partition by Hash.en.srt 22.7 kB
28 Window Functions/021 LEAD and LAG functions.en.srt 22.3 kB
30 Powerful text searches in PostgreSQL/003 Using tsquery with operators.en.srt 22.2 kB
36 PostgreSQL Triggers/022 Creating an audit event trigger.en.srt 22.1 kB
38 Creating Crosstab Reports/003 Creating a crosstab report - Student Rankings.en.srt 22.0 kB
27 Grouping sets/004 Using GROUPING with ROLLUP.en.srt 21.8 kB
07 PostgreSQL Data types/008 TIME.en.srt 21.6 kB
28 Window Functions/022 FIRST_VALUE, LAST_VALUE and NTH_value functions.en.srt 21.5 kB
21 Exploring array functions/017 Array vs JSONB.en.srt 21.5 kB
21 Exploring array functions/008 Array comparison with IN, ALL, ANY and SOME.en.srt 21.5 kB
36 PostgreSQL Triggers/015 Creating conditional triggers.en.srt 21.4 kB
31 Table Partitions/009 Multi-level partitioning.en.srt 21.2 kB
17 Grouping Data/002 Using GROUP BY with multiple columns, ORDER BY.en.srt 21.1 kB
44 Managing PostgreSQL security/009 Row Level Security.en.srt 21.1 kB
20 PostgreSQL Schemas/005 Schema search path.en.srt 20.9 kB
07 PostgreSQL Data types/014 Network Addresses.en.srt 20.9 kB
30 Powerful text searches in PostgreSQL/004 Full text search within a table.en.srt 20.9 kB
37 Using Cursors/010 Using a parametric cursor via function.en.srt 20.5 kB
33 Functions with SQL language/007 Function using parameters.en.srt 20.2 kB
33 Functions with SQL language/009 Function using parameters Part 3.en.srt 20.1 kB
23 Indexes and Performance Optimization/022 Understanding query cost model.en.srt 20.0 kB
07 PostgreSQL Data types/001 Boolean.en.srt 19.9 kB
12 Explore PostgreSQL Constraints/006 PRIMARY KEY Constraints on multiple columns.en.srt 19.9 kB
34 Functions with PL_pgSQL language/026 Using RETURN NEXT.en.srt 19.8 kB
15 Aggregate functions/005 Average with AVG function.en.srt 19.2 kB
09 Data type conversions/002 Using CAST for data conversions.en.srt 19.1 kB
33 Functions with SQL language/010 Function using parameters Part 4.en.srt 19.0 kB
18 Joining Multiple Tables/020 Append tables with different columns.en.srt 18.8 kB
25 Fun with subqueries/009 Correlated Queries.en.srt 18.5 kB
25 Fun with subqueries/002 Subqueries with WHERE Clause.en.srt 18.5 kB
07 PostgreSQL Data types/009 TIMESTAMP and TIMESTAMPTZ.en.srt 18.3 kB
33 Functions with SQL language/011 Function returning a composite.en.srt 18.3 kB
15 Aggregate functions/003 MIN and MAX functions.en.srt 18.3 kB
33 Functions with SQL language/004 Function returning a single value.en.srt 18.2 kB
48 Extended PostgreSQL/002 Create a user-defined aggregate function.en.srt 18.1 kB
23 Indexes and Performance Optimization/023 Index are not free.en.srt 18.0 kB
16 Using DATE_TIME functions/004 Strings to Dates conversions.en.srt 18.0 kB
27 Grouping sets/002 Subtotals on group sets.en.srt 18.0 kB
22 JSON with PostgreSQL/006 Update and Delete JSON Data.en.srt 17.9 kB
22 JSON with PostgreSQL/017 Indexing on JSONB.en.srt 17.9 kB
07 PostgreSQL Data types/013 JSON.en.srt 17.8 kB
30 Powerful text searches in PostgreSQL/002 Introducing tsvector.en.srt 17.8 kB
34 Functions with PL_pgSQL language/023 WHILE loop.en.srt 17.7 kB
16 Using DATE_TIME functions/022 date_part function.en.srt 17.4 kB
06 Filtering Data/015 Using IS NULL and IS NOT NULL keywords.en.srt 17.3 kB
47 Managing Tables/001 Using SELECT INTO to create a new table with joins.en.srt 17.3 kB
34 Functions with PL_pgSQL language/017 Searched CASE statement.en.srt 17.2 kB
21 Exploring array functions/016 Using Multi-dimensional arrays.en.srt 17.0 kB
17 Grouping Data/004 Using HAVING.en.srt 17.0 kB
36 PostgreSQL Triggers/010 Modify data at INSERT event.en.srt 17.0 kB
24 All about Views/024 Using materialized view for websites page analysis.en.srt 16.9 kB
39 Internationalization/002 Client and Server Encoding.en.srt 16.9 kB
34 Functions with PL_pgSQL language/016 CASE Statement.en.srt 16.9 kB
33 Functions with SQL language/017 Function parameters with default values.en.srt 16.8 kB
19 Combining queries together/001 Combine results sets with UNION.en.srt 16.8 kB
36 PostgreSQL Triggers/005 Pros and Cons of triggers.en.srt 16.8 kB
44 Managing PostgreSQL security/006 Schema Level Security.en.srt 16.7 kB
36 PostgreSQL Triggers/008 Data auditing with a trigger.en.srt 16.7 kB
34 Functions with PL_pgSQL language/024 Using RETURN QUERY.en.srt 16.5 kB
16 Using DATE_TIME functions/006 Formatting Dates.en.srt 16.5 kB
17 Grouping Data/001 Using GROUP BY.en.srt 16.4 kB
07 PostgreSQL Data types/003 NUMERIC.en.srt 16.4 kB
24 All about Views/002 Creating a view.en.srt 16.4 kB
07 PostgreSQL Data types/004 DECIMALS.en.srt 16.4 kB
15 Aggregate functions/006 Combining Columns using Mathematical operators.en.srt 16.3 kB
41 Using Northwind Database/014 Late shipped orders by employees.en.srt 16.3 kB
28 Window Functions/016 ROWS and RANGE indicators.en.srt 16.2 kB
47 Managing Tables/013 Generated Columns.en.srt 16.2 kB
38 Creating Crosstab Reports/013 Handling missing values.en.srt 16.1 kB
36 PostgreSQL Triggers/012 Disallow DELETE on a table.en.srt 15.9 kB
16 Using DATE_TIME functions/021 How to handle timezones.en.srt 15.9 kB
36 PostgreSQL Triggers/002 What is a trigger.en.srt 15.9 kB
07 PostgreSQL Data types/010 UUID.en.srt 15.8 kB
12 Explore PostgreSQL Constraints/002 NOT NULL constraint.en.srt 15.8 kB
44 Managing PostgreSQL security/007 Table Level Security.en.srt 15.8 kB
33 Functions with SQL language/001 Creating our first SQL function.en.srt 15.8 kB
39 Internationalization/001 Global Character Set Support.en.srt 15.7 kB
38 Creating Crosstab Reports/005 Pivoting with Rainfalls data.en.srt 15.7 kB
16 Using DATE_TIME functions/011 Using math operators with dates.en.srt 15.6 kB
41 Using Northwind Database/013 Orders with double entry line items.en.srt 15.6 kB
47 Managing Tables/012 Recovering unused space with VACUUM.en.srt 15.5 kB
37 Using Cursors/009 Creating a PL_PGSQL Cursor.en.srt 15.3 kB
23 Indexes and Performance Optimization/029 Partial indexes.en.srt 15.2 kB
16 Using DATE_TIME functions/009 Using MAKE_TIMESTAMPTZ function.en.srt 15.2 kB
16 Using DATE_TIME functions/005 Using TO_TIMESTAMP function.en.srt 15.1 kB
17 Grouping Data/007 Handling NULL values with GROUP BY.en.srt 15.1 kB
06 Filtering Data/013 Using BETWEEN and NOT BETWEEN.en.srt 15.0 kB
23 Indexes and Performance Optimization/003 Create unique indexes.en.srt 15.0 kB
47 Managing Tables/011 PostgreSQL autovacuum proces.en.srt 14.9 kB
32 Server Programming/001 PostgreSQL as a development platform_.en.srt 14.9 kB
29 Using regular expressions for text patterns/006 REGEXP_MATCHES Function.en.srt 14.9 kB
18 Joining Multiple Tables/017 CROSS Joins.en.srt 14.8 kB
41 Using Northwind Database/009 Freight analysis.en.srt 14.7 kB
18 Joining Multiple Tables/011 RIGHT joins.en.srt 14.7 kB
23 Indexes and Performance Optimization/021 Using EXPLAIN ANALYZE.en.srt 14.6 kB
38 Creating Crosstab Reports/007 Matrix report via a query.en.srt 14.6 kB
28 Window Functions/025 ROW_NUMBER() - Window with Partition datasets.en.srt 14.6 kB
37 Using Cursors/005 Opening a cursor.en.srt 14.4 kB
16 Using DATE_TIME functions/001 Datetimes data types.en.srt 14.4 kB
19 Combining queries together/002 UNION with filters and conditions.en.srt 14.3 kB
04 Modifying Data in the tables/009 Using UPSERT.en.srt 14.3 kB
22 JSON with PostgreSQL/002 JSON Syntax.en.srt 14.3 kB
33 Functions with SQL language/015 Function as a table source.en.srt 14.3 kB
06 Filtering Data/011 Using FETCH.en.srt 14.2 kB
46 PostgreSQL Internals/011 File layout of PostgreSQL Tables.en.srt 14.2 kB
21 Exploring array functions/009 Formatting and converting an array.en.srt 14.0 kB
28 Window Functions/023 ROW_NUMBER function.en.srt 14.0 kB
28 Window Functions/020 NTILE function.en.srt 13.8 kB
28 Window Functions/017 Using WINDOW.en.srt 13.7 kB
28 Window Functions/034 Comparing with least number.en.srt 13.7 kB
24 All about Views/015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.en.srt 13.5 kB
29 Using regular expressions for text patterns/002 Regular expressions notations table.en.srt 13.5 kB
24 All about Views/016 What is a Materialized View.en.srt 13.4 kB
16 Using DATE_TIME functions/023 date_trunc function.en.srt 13.4 kB
18 Joining Multiple Tables/007 LEFT joins Part 1.en.srt 13.4 kB
29 Using regular expressions for text patterns/007 REGEXP_REPLACE Function.en.srt 13.4 kB
16 Using DATE_TIME functions/019 Using Date, time, timestamp in tables.en.srt 13.3 kB
37 Using Cursors/004 Creating a cursor.en.srt 13.3 kB
06 Filtering Data/012 Using IN, NOT IN.en.srt 13.3 kB
05 Querying Data/003 Adding Aliases to columns in a table.en.srt 13.3 kB
18 Joining Multiple Tables/003 INNER joins with filter data Part 1.en.srt 13.3 kB
31 Table Partitions/011 ALTERing the partition bounds.en.srt 13.2 kB
46 PostgreSQL Internals/003 List all tables and views.en.srt 13.0 kB
36 PostgreSQL Triggers/009 Bind a function to a table with trigger.en.srt 12.9 kB
23 Indexes and Performance Optimization/024 Indexes for sorted output.en.srt 12.9 kB
40 PostgreSQL Transactions/003 ACID Database.en.srt 12.8 kB
14 String Functions/002 LEFT and RIGHT.en.srt 12.8 kB
21 Exploring array functions/005 Array metadata functions.en.srt 12.8 kB
28 Window Functions/003 Using aggregate functions.en.srt 12.7 kB
30 Powerful text searches in PostgreSQL/001 The Good Ol' Text Search.en.srt 12.7 kB
23 Indexes and Performance Optimization/010 The query optimizer.en.srt 12.5 kB
34 Functions with PL_pgSQL language/010 Assigning variables from query.en.srt 12.5 kB
33 Functions with SQL language/012 Function returning multiple rows.en.srt 12.5 kB
25 Fun with subqueries/004 Subquery with JOINs.en.srt 12.5 kB
18 Joining Multiple Tables/014 Joining multiple tables.en.srt 12.5 kB
12 Explore PostgreSQL Constraints/014 CHECK constraint - Add to new table.en.srt 12.5 kB
23 Indexes and Performance Optimization/032 Invalidating an index.en.srt 12.4 kB
10 Conversion Functions/001 to_char.en.srt 12.4 kB
18 Joining Multiple Tables/002 INNER joins with USING.en.srt 12.2 kB
28 Window Functions/013 Ordering inside window.en.srt 12.2 kB
46 PostgreSQL Internals/006 View privileges information across tables.en.srt 12.2 kB
23 Indexes and Performance Optimization/025 Using multiple indexes on a single query.en.srt 12.1 kB
24 All about Views/014 Updatable views using WITH CHECK OPTION.en.srt 12.1 kB
44 Managing PostgreSQL security/008 Column Level Security.en.srt 12.0 kB
18 Joining Multiple Tables/015 Self Joins Part 1.en.srt 12.0 kB
18 Joining Multiple Tables/009 LEFT joins Part 3.en.srt 12.0 kB
36 PostgreSQL Triggers/023 Prevent schema changes.en.srt 12.0 kB
31 Table Partitions/014 Determining a field for partition over.en.srt 12.0 kB
30 Powerful text searches in PostgreSQL/006 Analyzing presidents speeches text data.en.srt 11.9 kB
12 Explore PostgreSQL Constraints/015 CHECK constraint - Add, Rename, Drop on existing table.en.srt 11.9 kB
21 Exploring array functions/002 Using comparison operators.en.srt 11.9 kB
15 Aggregate functions/002 Sum with SUM function.en.srt 11.9 kB
28 Window Functions/002 Analyze Global Trades Data.en.srt 11.8 kB
09 Data type conversions/004 Table data conversion.en.srt 11.8 kB
08 Modifying Table Structures, Add constraints/003 Add constraints to columns.en.srt 11.7 kB
01 Welcome/002 countries_iso_codes.csv 11.7 kB
47 Managing Tables/611 countries_iso_codes.csv 11.7 kB
28 Window Functions/014 Sliding dynamic windows.en.srt 11.7 kB
40 PostgreSQL Transactions/001 What is a transaction_.en.srt 11.7 kB
20 PostgreSQL Schemas/009 Compare tables and columns in two schemas.en.srt 11.7 kB
35 Exploring Stored Procedures/002 Create a transactions.en.srt 11.7 kB
47 Managing Tables/010 Tracking table size.en.srt 11.6 kB
27 Grouping sets/003 Adding subtotal with ROLLUP.en.srt 11.4 kB
06 Filtering Data/016 Concatenation techniques.en.srt 11.4 kB
21 Exploring array functions/001 Constructing arrays and ranges.en.srt 11.3 kB
34 Functions with PL_pgSQL language/014 Control Structures - IF statement.en.srt 11.3 kB
22 JSON with PostgreSQL/005 Create our first table with JSONB data type.en.srt 11.3 kB
12 Explore PostgreSQL Constraints/009 Creating foreign key constraints.en.srt 11.3 kB
25 Fun with subqueries/012 Using ALL with subquery.en.srt 11.3 kB
12 Explore PostgreSQL Constraints/010 Foreign keys maintains referential data integrity.en.srt 11.2 kB
38 Creating Crosstab Reports/503 rainfalldata.sql 11.2 kB
07 PostgreSQL Data types/012 hstore.en.srt 11.2 kB
44 Managing PostgreSQL security/015 Encrypted data in columns.en.srt 11.2 kB
20 PostgreSQL Schemas/002 Schema Operations (Add_Alter_Delete schemas).en.srt 11.1 kB
26 Common Table Expressions (CTE)/005 Simultaneously DELETE INSERT via CTE.en.srt 11.1 kB
21 Exploring array functions/012 Query array data.en.srt 11.1 kB
41 Using Northwind Database/018 First order from each country.en.srt 11.1 kB
25 Fun with subqueries/011 Using ANY with subquery.en.srt 11.1 kB
47 Managing Tables/005 Deleting duplicate records.en.srt 11.0 kB
16 Using DATE_TIME functions/018 Date accuracy with EPOCH.en.srt 11.0 kB
31 Table Partitions/012 Partition Indexes.en.srt 11.0 kB
06 Filtering Data/002 AND operator.en.srt 11.0 kB
23 Indexes and Performance Optimization/013 Index Nodes.en.srt 10.9 kB
45 PostgreSQL Utilities - psql/005 List all sequences, roles, data types, domain data types.en.srt 10.9 kB
29 Using regular expressions for text patterns/003 SIMILAR TO operator.en.srt 10.9 kB
47 Managing Tables/003 Import data from CSV files.en.srt 10.9 kB
24 All about Views/007 Connecting multiple tables with a single view.en.srt 10.8 kB
23 Indexes and Performance Optimization/033 Rebuilding an index.en.srt 10.8 kB
13 PostgreSQL Sequences/007 Attach a sequence to a table column.en.srt 10.8 kB
24 All about Views/001 Introduction to views.en.srt 10.7 kB
14 String Functions/004 SPLIT_PART.en.srt 10.6 kB
41 Using Northwind Database/017 Customers with multiple orders.en.srt 10.6 kB
24 All about Views/005 Using filters with views.en.srt 10.6 kB
38 Creating Crosstab Reports/010 Dynamic pivot query via JSON.en.srt 10.6 kB
07 PostgreSQL Data types/011 Array.en.srt 10.5 kB
38 Creating Crosstab Reports/009 Static to dynamic pivots.en.srt 10.5 kB
21 Exploring array functions/006 Array search functions.en.srt 10.5 kB
22 JSON with PostgreSQL/004 Exploring JSON objects.en.srt 10.4 kB
18 Joining Multiple Tables/008 LEFT joins Part 2.en.srt 10.4 kB
14 String Functions/005 TRIM, BTRIM, LTRIM and RTRIM.en.srt 10.4 kB
28 Window Functions/036 Planning tips on using Window Functions.en.srt 10.3 kB
34 Functions with PL_pgSQL language/030 Exception with data exception errors.en.srt 10.3 kB
26 Common Table Expressions (CTE)/003 Combine CTE with a table.en.srt 10.2 kB
12 Explore PostgreSQL Constraints/008 Tables without foreign key constraints.en.srt 10.1 kB
13 PostgreSQL Sequences/010 Create an alphanumeric sequence.en.srt 10.1 kB
11 User-defined Data Types/013 Update an ENUM data in production server.en.srt 10.1 kB
16 Using DATE_TIME functions/008 Using MAKE_INTERVAL function.en.srt 10.1 kB
16 Using DATE_TIME functions/007 Date construction functions.en.srt 10.1 kB
28 Window Functions/041 Using WITH clause to set ORDER BY values.en.srt 10.1 kB
21 Exploring array functions/007 Array modification functions.en.srt 10.1 kB
25 Fun with subqueries/010 SELECT.. IN (Subquery).en.srt 10.0 kB
23 Indexes and Performance Optimization/026 Execution plans depends on input values.en.srt 10.0 kB
08 Modifying Table Structures, Add constraints/002 Modify Table Structures, Add_Modify Columns.en.srt 9.9 kB
37 Using Cursors/001 Understanding row by row operations.en.srt 9.9 kB
30 Powerful text searches in PostgreSQL/005 Setup presidents speeches data.en.srt 9.8 kB
20 PostgreSQL Schemas/003 Schema Hierarchy.en.srt 9.8 kB
20 PostgreSQL Schemas/010 Schemas and Privileges.en.srt 9.7 kB
31 Table Partitions/015 Sizing the partition.en.srt 9.7 kB
37 Using Cursors/006 Using a cursor.en.srt 9.6 kB
33 Functions with SQL language/018 Function based on views.en.srt 9.6 kB
31 Table Partitions/008 DEFAULT Partition.en.srt 9.6 kB
23 Indexes and Performance Optimization/014 Join Nodes.en.srt 9.6 kB
24 All about Views/021 Refreshing data in materialize views.en.srt 9.5 kB
03 Creating and Modifying Tables/011 Using pgAdmin - Rename, delete and change the data type of a column.en.srt 9.5 kB
16 Using DATE_TIME functions/010 Date Value Extractors functions.en.srt 9.4 kB
20 PostgreSQL Schemas/007 Duplicate a schema along with all data.en.srt 9.4 kB
12 Explore PostgreSQL Constraints/007 FOREIGN KEY Constraints.en.srt 9.4 kB
16 Using DATE_TIME functions/003 Time of day formats and inputs.en.srt 9.4 kB
13 PostgreSQL Sequences/001 Create a sequence, advance a sequence, get current value, set value.en.srt 9.4 kB
20 PostgreSQL Schemas/001 What is a Schema_.en.srt 9.3 kB
40 PostgreSQL Transactions/009 Using SAVEPOINT with transaction.en.srt 9.3 kB
05 Querying Data/005 Using ORDER BY to sort records.en.srt 9.3 kB
11 User-defined Data Types/001 CREATE DOMAIN - Create a DOMAIN data type, create an address.en.srt 9.3 kB
07 PostgreSQL Data types/007 DATE.en.srt 9.3 kB
24 All about Views/019 Changing materialized view data.en.srt 9.3 kB
22 JSON with PostgreSQL/013 Getting information from JSON documents.en.srt 9.2 kB
44 Managing PostgreSQL security/002 Instance Level Security.en.srt 9.2 kB
32 Server Programming/003 Keep the data on the server!.en.srt 9.2 kB
44 Managing PostgreSQL security/010 Using CURRENT_USER with RLS.en.srt 9.1 kB
09 Data type conversions/001 What is a data type conversion.en.srt 9.1 kB
23 Indexes and Performance Optimization/009 SQL statement execution stages.en.srt 9.1 kB
29 Using regular expressions for text patterns/001 Text to structured data.en.srt 9.1 kB
28 Window Functions/029 ROW_NUMBER() - Pagination technique.en.srt 9.1 kB
38 Creating Crosstab Reports/012 Interactive client-side pivot.en.srt 9.1 kB
21 Exploring array functions/011 Insert data into arrays.en.srt 9.1 kB
41 Using Northwind Database/016 Countries with customers or suppliers - Using CTE.en.srt 9.0 kB
05 Querying Data/001 Select all data from a table.en.srt 9.0 kB
05 Querying Data/009 Using ORDER BY with NULL values.en.srt 9.0 kB
23 Indexes and Performance Optimization/012 Sequential Nodes.en.srt 8.9 kB
10 Conversion Functions/002 to_number.en.srt 8.9 kB
34 Functions with PL_pgSQL language/019 FOR Loops.en.srt 8.8 kB
28 Window Functions/033 Using LEAD to compare with next values.en.srt 8.8 kB
28 Window Functions/030 Using OVER() to calculate percentage.en.srt 8.8 kB
35 Exploring Stored Procedures/001 Functions vs Stored Procedures.en.srt 8.8 kB
28 Window Functions/039 Using PARTITION BY for group averages.en.srt 8.8 kB
28 Window Functions/024 Finding Correlations.en.srt 8.8 kB
22 JSON with PostgreSQL/010 Creating a document from data.en.srt 8.8 kB
47 Managing Tables/009 Database operations and table size.en.srt 8.7 kB
28 Window Functions/031 Calculate difference compared to average.en.srt 8.7 kB
34 Functions with PL_pgSQL language/018 LOOP statement.en.srt 8.7 kB
07 PostgreSQL Data types/005 Selecting Numbers data types.en.srt 8.7 kB
02 Introduction to PostgreSQL/002 Installing PostgreSQL on Windows.en.srt 8.6 kB
34 Functions with PL_pgSQL language/005 Declaring variables.en.srt 8.6 kB
14 String Functions/006 LPAD and RPAD.en.srt 8.6 kB
10 Conversion Functions/003 to_date.en.srt 8.6 kB
16 Using DATE_TIME functions/013 Date _ Time Functions.en.srt 8.5 kB
36 PostgreSQL Triggers/016 Disallow data change on primary key.en.srt 8.4 kB
05 Querying Data/010 Using DISTINCT for selecting distinct values.en.srt 8.4 kB
15 Aggregate functions/001 Counting results via COUNT function.en.srt 8.4 kB
18 Joining Multiple Tables/010 LEFT joins Part 4.en.srt 8.4 kB
34 Functions with PL_pgSQL language/027 Error and exception handling.en.srt 8.3 kB
19 Combining queries together/005 EXCEPT with tables.en.srt 8.3 kB
32 Server Programming/002 Procedural languages.en.srt 8.3 kB
40 PostgreSQL Transactions/007 How to fix transactions on crash.en.srt 8.3 kB
18 Joining Multiple Tables/018 Natural Joins Part 1.en.srt 8.3 kB
31 Table Partitions/001 What is a partition.en.srt 8.2 kB
21 Exploring array functions/004 Array constructions.en.srt 8.2 kB
28 Window Functions/032 Calculating cumulative totals.en.srt 8.2 kB
26 Common Table Expressions (CTE)/001 Introduction to CTEs.en.srt 8.2 kB
02 Introduction to PostgreSQL/010 Install northwind database.en.srt 8.2 kB
24 All about Views/013 An updatable view with CRUD operations.en.srt 8.1 kB
46 PostgreSQL Internals/007 Using system Administration functions.en.srt 8.1 kB
41 Using Northwind Database/010 Customers with no orders.en.srt 8.1 kB
11 User-defined Data Types/008 CREATE TYPE - Create a composite address object.en.srt 8.1 kB
17 Grouping Data/006 HAVING vs WHERE.en.srt 8.0 kB
36 PostgreSQL Triggers/013 Disallow TRUNCATE on a table.en.srt 8.0 kB
28 Window Functions/042 DELETE and INSERT in one query using WITH.en.srt 8.0 kB
40 PostgreSQL Transactions/002 How SQL protect database during transaction.en.srt 8.0 kB
34 Functions with PL_pgSQL language/015 Using IF with table data.en.srt 8.0 kB
23 Indexes and Performance Optimization/011 Optimizer node types.en.srt 8.0 kB
03 Creating and Modifying Tables/007 Install sample data for 'movies' database.en.srt 7.9 kB
30 Powerful text searches in PostgreSQL/007 Ranking and Normalizing text results.en.srt 7.9 kB
28 Window Functions/004 GROUP BY ROLLUP.en.srt 7.9 kB
33 Functions with SQL language/005 Function returning a single value Part 2.en.srt 7.9 kB
03 Creating and Modifying Tables/002 Creating the movie database and a actors table.en.srt 7.9 kB
28 Window Functions/019 RANK and DENSE_RANK functions.en.srt 7.8 kB
28 Window Functions/009 Using FILTER clause.en.srt 7.8 kB
44 Managing PostgreSQL security/005 Database Level Security.en.srt 7.8 kB
35 Exploring Stored Procedures/003 Understanding the use of stored procedures.en.srt 7.8 kB
38 Creating Crosstab Reports/008 Aggregate over filter.en.srt 7.8 kB
33 Functions with SQL language/008 Function using parameters Part 2.en.srt 7.7 kB
34 Functions with PL_pgSQL language/028 Exception - Too many rows.en.srt 7.7 kB
36 PostgreSQL Triggers/011 View triggers variables.en.srt 7.7 kB
28 Window Functions/010 Using Window Functions.en.srt 7.7 kB
34 Functions with PL_pgSQL language/021 CONTINUE statement.en.srt 7.6 kB
03 Creating and Modifying Tables/010 Using pgAdmin - View table structure, and create column.en.srt 7.6 kB
28 Window Functions/008 Query performance check.en.srt 7.6 kB
34 Functions with PL_pgSQL language/003 Structure of a PL_pgSQL function.en.srt 7.6 kB
29 Using regular expressions for text patterns/004 POSIX regular expressions.en.srt 7.6 kB
22 JSON with PostgreSQL/007 Create JSON from tables.en.srt 7.6 kB
36 PostgreSQL Triggers/007 Steps to create a trigger.en.srt 7.6 kB
44 Managing PostgreSQL security/011 Row level policy for application users.en.srt 7.5 kB
22 JSON with PostgreSQL/008 Use json_agg to aggregate data.en.srt 7.5 kB
03 Creating and Modifying Tables/004 Creating the movies table with a foreign key.en.srt 7.5 kB
34 Functions with PL_pgSQL language/007 Declaring variables in function.en.srt 7.5 kB
14 String Functions/009 STRPOS.en.srt 7.4 kB
22 JSON with PostgreSQL/011 Null Values in JSON documents.en.srt 7.4 kB
11 User-defined Data Types/007 CREATE DOMAIN - How to drop a domain data type.en.srt 7.4 kB
28 Window Functions/028 ROW_NUMBER() - Find DISTINCT with subquery.en.srt 7.4 kB
23 Indexes and Performance Optimization/005 Size of the table index.en.srt 7.4 kB
15 Aggregate functions/004 GREATEST AND LEAST functions.en.srt 7.3 kB
42 Using Human Resource (hr) database/002 Quick overview of all tables.en.srt 7.3 kB
31 Table Partitions/010 Partition maintenance.en.srt 7.3 kB
33 Functions with SQL language/003 Function returning no values.en.srt 7.3 kB
28 Window Functions/006 GROUP BY CUBE.en.srt 7.3 kB
26 Common Table Expressions (CTE)/006 Recursive CTEs.en.srt 7.3 kB
37 Using Cursors/002 Cursors and procedural languages.en.srt 7.3 kB
31 Table Partitions/017 Common partitioning mistakes.en.srt 7.3 kB
10 Conversion Functions/004 to_timestamp.en.srt 7.3 kB
42 Using Human Resource (hr) database/013 Discard characters from employees email address.en.srt 7.2 kB
31 Table Partitions/016 Partitioning Advantages.en.srt 7.2 kB
25 Fun with subqueries/013 Subquery using EXISTS.en.srt 7.2 kB
18 Joining Multiple Tables/005 INNER joins with filter data Part 3.en.srt 7.2 kB
18 Joining Multiple Tables/013 FULL Joins.en.srt 7.2 kB
24 All about Views/006 A view with UNION of multiple tables.en.srt 7.1 kB
06 Filtering Data/004 Combining AND, OR operators.en.srt 7.1 kB
28 Window Functions/035 Window Function Summary.en.srt 7.0 kB
09 Data type conversions/003 Implicit to Explicit conversions.en.srt 7.0 kB
33 Functions with SQL language/019 Drop a function.en.srt 7.0 kB
34 Functions with PL_pgSQL language/020 FOR Loops iterate over result set.en.srt 7.0 kB
14 String Functions/001 UPPER, LOWER and INITCAP.en.srt 6.9 kB
28 Window Functions/011 Partitioning the data.en.srt 6.9 kB
21 Exploring array functions/003 Using inclusion operators.en.srt 6.9 kB
18 Joining Multiple Tables/006 INNER joins with different data type columns.en.srt 6.9 kB
22 JSON with PostgreSQL/009 Build a JSON array.en.srt 6.8 kB
34 Functions with PL_pgSQL language/011 Using IN, OUT without RETURNS.en.srt 6.8 kB
03 Creating and Modifying Tables/009 Using pgAdmin - Create and modify a table.en.srt 6.8 kB
24 All about Views/017 Creating a materialized view.en.srt 6.8 kB
34 Functions with PL_pgSQL language/012 Variables in block and subblock.en.srt 6.8 kB
16 Using DATE_TIME functions/014 PostgreSQL Date _ Time Functions.en.srt 6.8 kB
41 Using Northwind Database/011 Top customers with total orders amount.en.srt 6.8 kB
36 PostgreSQL Triggers/020 Creating event triggers.en.srt 6.8 kB
23 Indexes and Performance Optimization/006 List counts of all indexes.en.srt 6.7 kB
20 PostgreSQL Schemas/008 What is a system catalog schema_.en.srt 6.7 kB
34 Functions with PL_pgSQL language/013 How to return query results.en.srt 6.7 kB
28 Window Functions/038 Getting RANK to compute group and global ranks.en.srt 6.6 kB
24 All about Views/003 Rename a view.en.srt 6.6 kB
25 Fun with subqueries/003 Subquery with IN operator.en.srt 6.6 kB
36 PostgreSQL Triggers/021 Event trigger events and variables.en.srt 6.6 kB
46 PostgreSQL Internals/008 Show all running queries.en.srt 6.6 kB
12 Explore PostgreSQL Constraints/004 DEFAULT constraint.en.srt 6.6 kB
19 Combining queries together/004 INTERSECT with tables.en.srt 6.6 kB
46 PostgreSQL Internals/002 List all database and schemas.en.srt 6.6 kB
13 PostgreSQL Sequences/005 Creating a descending sequence, and CYCLE sequence.en.srt 6.5 kB
02 Introduction to PostgreSQL/004 Creating a Database User.en.srt 6.5 kB
34 Functions with PL_pgSQL language/029 Using SQLSTATE codes for exception handling.en.srt 6.5 kB
44 Managing PostgreSQL security/003 Instance Level Security - Add users to roles.en.srt 6.4 kB
21 Exploring array functions/010 Using arrays in tables.en.srt 6.4 kB
25 Fun with subqueries/006 Order entries in UNION without using ORDER BY.en.srt 6.4 kB
38 Creating Crosstab Reports/006 Pivoting rows and columns.en.srt 6.4 kB
21 Exploring array functions/014 Array Dimensions are ignored!.en.srt 6.4 kB
24 All about Views/022 Why not use a table instead of materialized view_.en.srt 6.4 kB
23 Indexes and Performance Optimization/015 Index Types - B-Tree Index.en.srt 6.3 kB
23 Indexes and Performance Optimization/016 Hash Index.en.srt 6.3 kB
06 Filtering Data/017 Concatenation with __, CONCAT and CONCAT_WS.en.srt 6.3 kB
16 Using DATE_TIME functions/012 OVERLAPS Operator.en.srt 6.3 kB
23 Indexes and Performance Optimization/008 SQL Statement execution process.en.srt 6.2 kB
44 Managing PostgreSQL security/004 Use pgAdmin to create roles.en.srt 6.2 kB
23 Indexes and Performance Optimization/028 Try to use index only scan.en.srt 6.2 kB
44 Managing PostgreSQL security/001 Security concepts and and levels.en.srt 6.2 kB
22 JSON with PostgreSQL/015 The Containment Operator.en.srt 6.2 kB
32 Server Programming/004 Functions vs stored procedures.en.srt 6.1 kB
46 PostgreSQL Internals/001 List database users, and database sizes with and without indexes.en.srt 6.1 kB
23 Indexes and Performance Optimization/004 List all indexes.en.srt 6.1 kB
22 JSON with PostgreSQL/016 JSON search with PostgreSQL functions.en.srt 6.1 kB
24 All about Views/026 List materialized views with no unique index.en.srt 6.1 kB
14 String Functions/010 SUBSTRING.en.srt 6.1 kB
34 Functions with PL_pgSQL language/025 Returning a table.en.srt 6.1 kB
04 Modifying Data in the tables/001 Insert a data into table.en.srt 6.0 kB
14 String Functions/007 LENGTH.en.srt 6.0 kB
45 PostgreSQL Utilities - psql/001 Connect to local or remote database.en.srt 5.9 kB
44 Managing PostgreSQL security/014 Row Level Security Performance.en.srt 5.9 kB
40 PostgreSQL Transactions/006 How to fix aborted transaction.en.srt 5.9 kB
21 Exploring array functions/015 Display all array elements.en.srt 5.8 kB
14 String Functions/012 REPLACE.en.srt 5.8 kB
31 Table Partitions/013 Partition pruning.en.srt 5.8 kB
28 Window Functions/005 ROLLUP - Grouping multiple columns.en.srt 5.8 kB
11 User-defined Data Types/005 CREATE DOMAIN - Create a Enum or Set of values domain data type.en.srt 5.8 kB
23 Indexes and Performance Optimization/001 What is an index_.en.srt 5.8 kB
41 Using Northwind Database/007 Total products in each categories.en.srt 5.8 kB
33 Functions with SQL language/002 Introducing dollar quoting.en.srt 5.7 kB
34 Functions with PL_pgSQL language/022 FOREACH loop with arrays.en.srt 5.7 kB
45 PostgreSQL Utilities - psql/010 Represent NULL values on psql terminal.en.srt 5.7 kB
45 PostgreSQL Utilities - psql/013 Represent NULL Visibly.en.srt 5.7 kB
28 Window Functions/040 Using WITH clause to create your own data.en.srt 5.7 kB
16 Using DATE_TIME functions/020 View and set timezones.en.srt 5.6 kB
07 PostgreSQL Data types/006 Date_Time data types.en.srt 5.6 kB
18 Joining Multiple Tables/004 INNER joins with filter data Part 2.en.srt 5.6 kB
40 PostgreSQL Transactions/008 Partial transaction rollback with savepoints.en.srt 5.6 kB
38 Creating Crosstab Reports/001 What is a crosstab report.en.srt 5.6 kB
23 Indexes and Performance Optimization/007 Drop a index.en.srt 5.5 kB
28 Window Functions/007 GROUP BY GROUPING SETS.en.srt 5.5 kB
35 Exploring Stored Procedures/004 Returning a value.en.srt 5.5 kB
28 Window Functions/027 ROW_NUMBER() - Find Nth record.en.srt 5.5 kB
13 PostgreSQL Sequences/002 Restart, rename a sequence, and use pgAdmin to alter a sequence.en.srt 5.4 kB
12 Explore PostgreSQL Constraints/001 Introduction to constraints.en.srt 5.4 kB
16 Using DATE_TIME functions/015 AGE function.en.srt 5.4 kB
08 Modifying Table Structures, Add constraints/001 Creating sample database 'mydata', adding columns.en.srt 5.4 kB
03 Creating and Modifying Tables/006 Creating a Junction table with movies and actors tables.en.srt 5.4 kB
24 All about Views/012 What is an updatable view_.en.srt 5.4 kB
43 Exploring Stock Markets Data/003 Get first or last record per each group.en.srt 5.3 kB
45 PostgreSQL Utilities - psql/004 List all table space, schemas, and indices.en.srt 5.3 kB
28 Window Functions/018 Using WINDOW with ROWS BETWEEN.en.srt 5.3 kB
05 Querying Data/002 Selecting specific columns from a table.en.srt 5.2 kB
22 JSON with PostgreSQL/003 JSON and JSONB data types.en.srt 5.2 kB
43 Exploring Stock Markets Data/002 Select first or last records in a table.en.srt 5.2 kB
03 Creating and Modifying Tables/001 Movie Database Structure.en.srt 5.2 kB
28 Window Functions/001 Introduction to Window Functions.en.srt 5.2 kB
13 PostgreSQL Sequences/009 Share one sequence between two tables.en.srt 5.2 kB
22 JSON with PostgreSQL/001 What is JSON_.en.srt 5.2 kB
16 Using DATE_TIME functions/017 CURRENT_TIME function.en.srt 5.2 kB
02 Introduction to PostgreSQL/011 Drop a database.en.srt 5.1 kB
42 Using Human Resource (hr) database/019 Select employees not in range.en.srt 5.1 kB
42 Using Human Resource (hr) database/004 Get highest, lowest, total, and average salaries of employees.en.srt 5.0 kB
45 PostgreSQL Utilities - psql/003 List all databases and tables.en.srt 5.0 kB
11 User-defined Data Types/009 CREATE TYPE - Create a composite inventory_item data type.en.srt 5.0 kB
14 String Functions/008 POSITION.en.srt 4.9 kB
41 Using Northwind Database/008 List products that needs re-ordering.en.srt 4.9 kB
27 Grouping sets/001 Introduction to summarization.en.srt 4.9 kB
33 Functions with SQL language/006 Function returning a single value Part 3.en.srt 4.9 kB
32 Server Programming/005 User-defined functions.en.srt 4.9 kB
24 All about Views/008 Re-arrange columns in a view.en.srt 4.8 kB
18 Joining Multiple Tables/016 Self Joins Part 2.en.srt 4.8 kB
38 Creating Crosstab Reports/004 Orders matters in crosstab reports.en.srt 4.8 kB
06 Filtering Data/003 OR operator.en.srt 4.8 kB
11 User-defined Data Types/010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.en.srt 4.8 kB
19 Combining queries together/003 UNION tables with different number of columns.en.srt 4.8 kB
45 PostgreSQL Utilities - psql/008 Display command history, run commands from a file.en.srt 4.7 kB
05 Querying Data/008 Using ORDER BY with column name or column number.en.srt 4.7 kB
36 PostgreSQL Triggers/017 Use triggers very cautiously.en.srt 4.7 kB
42 Using Human Resource (hr) database/001 Human Resources Database Structure.en.srt 4.6 kB
05 Querying Data/007 Using ORDER BY to sort rows by expressions.en.srt 4.6 kB
16 Using DATE_TIME functions/002 System Month Date settings.en.srt 4.6 kB
20 PostgreSQL Schemas/004 Move a table to a new schema.en.srt 4.6 kB
11 User-defined Data Types/011 ALTER TYPE - Alter a composite data type, change schema and more.en.srt 4.6 kB
18 Joining Multiple Tables/012 RIGHT joins Part 2.en.srt 4.6 kB
21 Exploring array functions/013 Modifying array data.en.srt 4.6 kB
24 All about Views/018 Drop a materialized view.en.srt 4.5 kB
23 Indexes and Performance Optimization/031 Adding data while indexing.en.srt 4.5 kB
23 Indexes and Performance Optimization/020 EXPLAIN output options.en.srt 4.5 kB
22 JSON with PostgreSQL/014 The Existence Operator.en.srt 4.4 kB
03 Creating and Modifying Tables/005 Creating the movies_revenues table.en.srt 4.4 kB
42 Using Human Resource (hr) database/014 List all employees with first_name starts with letters _A_, _C_ or _M_.en.srt 4.4 kB
13 PostgreSQL Sequences/003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.en.srt 4.4 kB
41 Using Northwind Database/012 Orders with many lines of ordered items.en.srt 4.4 kB
41 Using Northwind Database/015 Countries with customers or suppliers.en.srt 4.3 kB
33 Functions with SQL language/013 Function - order matters!.en.srt 4.3 kB
33 Functions with SQL language/016 Function parameter modes.en.srt 4.3 kB
42 Using Human Resource (hr) database/003 Quick overview of all tables Part 2.en.srt 4.3 kB
36 PostgreSQL Triggers/019 Event triggers usage scenarios.en.srt 4.3 kB
29 Using regular expressions for text patterns/009 REGEXP_SPLIT_TO_ARRAY function.en.srt 4.3 kB
04 Modifying Data in the tables/005 Update data in a table.en.srt 4.3 kB
24 All about Views/011 Regular views are dynamic.en.srt 4.2 kB
24 All about Views/023 The downsides of using materialized views.en.srt 4.2 kB
28 Window Functions/037 Difference between RANK and DENSE_RANK.en.srt 4.2 kB
04 Modifying Data in the tables/007 Updating all records in a table.en.srt 4.2 kB
46 PostgreSQL Internals/004 List all columns from a table.en.srt 4.2 kB
03 Creating and Modifying Tables/003 Creating the directors table.en.srt 4.2 kB
47 Managing Tables/002 Duplicate a table with or without data.en.srt 4.2 kB
41 Using Northwind Database/004 Orders shipped to latin america.en.srt 4.2 kB
11 User-defined Data Types/004 CREATE DOMAIN - Create a domain data type for an email validation.en.srt 4.1 kB
04 Modifying Data in the tables/008 Delete data from a table.en.srt 4.1 kB
11 User-defined Data Types/014 An ENUM with a DEFAULT value in a table.en.srt 4.1 kB
32 Server Programming/006 Structure of a function.en.srt 4.1 kB
31 Table Partitions/004 Partition types.en.srt 4.1 kB
34 Functions with PL_pgSQL language/009 Copying data types.en.srt 4.1 kB
36 PostgreSQL Triggers/006 Trigger key points.en.srt 4.1 kB
05 Querying Data/004 Using SELECT statement for expressions.en.srt 4.1 kB
37 Using Cursors/003 Steps to create a cursor.en.srt 4.0 kB
04 Modifying Data in the tables/004 Use RETURNING to get info on added rows.en.srt 4.0 kB
36 PostgreSQL Triggers/004 Trigger table.en.srt 4.0 kB
24 All about Views/010 Add a column in a view.en.srt 4.0 kB
02 Introduction to PostgreSQL/005 Creating a Database.en.srt 4.0 kB
33 Functions with SQL language/014 Function returning a table.en.srt 4.0 kB
44 Managing PostgreSQL security/013 Inspecting permissions.en.srt 4.0 kB
46 PostgreSQL Internals/009 Terminate running and IDLE process.en.srt 4.0 kB
06 Filtering Data/005 What goes before and after WHERE clause.en.srt 3.9 kB
46 PostgreSQL Internals/005 View system metadata via system information functions.en.srt 3.9 kB
42 Using Human Resource (hr) database/021 Update phone_number with your strings.en.srt 3.9 kB
12 Explore PostgreSQL Constraints/012 Add or update foreign key constraint on existing table.en.srt 3.9 kB
28 Window Functions/012 Set data into millions format.en.srt 3.9 kB
11 User-defined Data Types/012 ALTER TYPE - Alter an ENUM data type.en.srt 3.8 kB
05 Querying Data/006 Using ORDER BY with alias column name.en.srt 3.8 kB
40 PostgreSQL Transactions/004 Transaction setup.en.srt 3.8 kB
11 User-defined Data Types/003 CREATE DOMAIN - Create a postal code validation data type.en.srt 3.8 kB
47 Managing Tables/004 Export Data to CSV files.en.srt 3.7 kB
21 Exploring array functions/018 Single and Multi-dimensional arrays.html 3.7 kB
25 Fun with subqueries/008 A SELECT without a FROM.en.srt 3.7 kB
24 All about Views/020 How to check if a materialized view is populated or not_.en.srt 3.7 kB
14 String Functions/011 REPEAT.en.srt 3.7 kB
34 Functions with PL_pgSQL language/002 PL_pgSQL vs SQL.en.srt 3.7 kB
02 Introduction to PostgreSQL/007 Install sample data files on server.en.srt 3.7 kB
45 PostgreSQL Utilities - psql/014 Turn on query execution time.en.srt 3.6 kB
36 PostgreSQL Triggers/003 Types of triggers.en.srt 3.6 kB
03 Creating and Modifying Tables/012 Deleting tables from a database.en.srt 3.5 kB
28 Window Functions/026 ROW_NUMBER() - Reverse fields with order by.en.srt 3.5 kB
06 Filtering Data/007 Can we use column aliases with WHERE_.en.srt 3.5 kB
18 Joining Multiple Tables/019 Natural Joins Part 2.en.srt 3.5 kB
42 Using Human Resource (hr) database/011 Compute 15% of salary for all employees.en.srt 3.4 kB
42 Using Human Resource (hr) database/024 find employees whose names contains exactly six characters.en.srt 3.4 kB
34 Functions with PL_pgSQL language/008 Variable initializing timing.en.srt 3.4 kB
11 User-defined Data Types/006 CREATE DOMAIN - Get the list of all DOMAIN data types.en.srt 3.3 kB
04 Modifying Data in the tables/002 Insert multiple records into a table.en.srt 3.3 kB
14 String Functions/003 REVERSE.en.srt 3.3 kB
42 Using Human Resource (hr) database/020 Find Letter _C_ in last_name at 3rd or greater position.en.srt 3.2 kB
02 Introduction to PostgreSQL/008 Install Human Resources (hr) database.en.srt 3.2 kB
44 Managing PostgreSQL security/012 DROP a policy.en.srt 3.2 kB
42 Using Human Resource (hr) database/018 Select employees with particular department id only.en.srt 3.2 kB
34 Functions with PL_pgSQL language/004 PL_pgSQL block structure.en.srt 3.2 kB
02 Introduction to PostgreSQL/006 Running a query in pgAdmin tool.en.srt 3.2 kB
24 All about Views/009 Delete a column in a view.en.srt 3.2 kB
34 Functions with PL_pgSQL language/001 Introduction to PL_pgSQL language.en.srt 3.1 kB
02 Introduction to PostgreSQL/001 Installing PostgreSQL on Mac.en.srt 3.1 kB
12 Explore PostgreSQL Constraints/011 Drop a constraint.en.srt 3.1 kB
24 All about Views/004 Delete a view.en.srt 3.1 kB
02 Introduction to PostgreSQL/003 Configure pgAdmin 4 client.en.srt 3.1 kB
06 Filtering Data/001 Comparison, Logical and Arithmetic operators.en.srt 3.1 kB
42 Using Human Resource (hr) database/007 Average salary for each department with more than 10 employees.en.srt 3.1 kB
02 Introduction to PostgreSQL/009 Install sample stocks market data.en.srt 3.0 kB
20 PostgreSQL Schemas/006 Alter a schema ownership.en.srt 3.0 kB
23 Indexes and Performance Optimization/017 BRIN index.en.srt 3.0 kB
04 Modifying Data in the tables/006 Updating a row and returning the updated row.en.srt 3.0 kB
42 Using Human Resource (hr) database/022 Get the monthly salary of each employees.en.srt 3.0 kB
11 User-defined Data Types/015 Create a type if not exists using a PL_pgSQL function.en.srt 2.9 kB
13 PostgreSQL Sequences/004 Create a sequence using a specific data type.en.srt 2.9 kB
42 Using Human Resource (hr) database/006 Get lowest paid salaries by each manager.en.srt 2.9 kB
02 Introduction to PostgreSQL/009 sample_data.zip 2.9 kB
41 Using Northwind Database/006 First the oldest and latest order date.en.srt 2.9 kB
35 Exploring Stored Procedures/005 Drop a procedure.en.srt 2.8 kB
25 Fun with subqueries/001 Introduction to subqueries.html 2.8 kB
42 Using Human Resource (hr) database/009 Maximum salary for each post where salary is at or above $5000.en.srt 2.8 kB
45 PostgreSQL Utilities - psql/011 Make table layout funkey!.en.srt 2.8 kB
41 Using Northwind Database/002 Orders shipping to USA or France.en.srt 2.8 kB
11 User-defined Data Types/002 CREATE DOMAIN - Create a data type for a positive number.en.srt 2.7 kB
38 Creating Crosstab Reports/002 Installing the tablefunc extension.en.srt 2.7 kB
45 PostgreSQL Utilities - psql/002 Switch connection to a new database.en.srt 2.7 kB
04 Modifying Data in the tables/003 Insert a data that had quotes.en.srt 2.6 kB
42 Using Human Resource (hr) database/017 Get unique designations in employees table.en.srt 2.6 kB
42 Using Human Resource (hr) database/015 String manipulation with upper, lower and initcap functions.en.srt 2.5 kB
36 PostgreSQL Triggers/018 What is an event trigger.en.srt 2.5 kB
41 Using Northwind Database/003 Total numbers of orders shipped to USA or France.en.srt 2.5 kB
23 Indexes and Performance Optimization/018 GIN Index.en.srt 2.4 kB
37 Using Cursors/007 Updating data.en.srt 2.4 kB
45 PostgreSQL Utilities - psql/012 Repeatedly Execute a Query.en.srt 2.4 kB
34 Functions with PL_pgSQL language/006 Declaring variables via ALIAS FOR.en.srt 2.4 kB
06 Filtering Data/006 Execution order with AND, OR operators.en.srt 2.3 kB
46 PostgreSQL Internals/010 How to check live and dead rows in tables.en.srt 2.3 kB
42 Using Human Resource (hr) database/010 Using an alias name with columns.en.srt 2.3 kB
29 Using regular expressions for text patterns/008 REGEXP_SPLIT_TO_TABLE Function.en.srt 2.2 kB
03 Creating and Modifying Tables/008 Create a sample Database _mydata_.html 2.2 kB
24 All about Views/025 List all materialized views by a SELECT statement.en.srt 2.2 kB
42 Using Human Resource (hr) database/023 Calculate average salary with total number of employees.en.srt 2.1 kB
37 Using Cursors/008 Closing a cursor.en.srt 2.1 kB
12 Explore PostgreSQL Constraints/013 CHECK constraint - An Introduction.en.srt 2.1 kB
43 Exploring Stock Markets Data/004 How to calculate cube root in PostgreSQL_.en.srt 2.1 kB
17 Grouping Data/003 Order of execution in GROUP BY clause.en.srt 2.0 kB
36 PostgreSQL Triggers/001 Introduction to triggers.html 2.0 kB
42 Using Human Resource (hr) database/008 Average salary for each post excluding programmer.en.srt 2.0 kB
18 Joining Multiple Tables/021 ON versus WHERE.html 2.0 kB
25 Fun with subqueries/007 Subquery with an alias.en.srt 2.0 kB
16 Using DATE_TIME functions/016 CURRENT_DATE function.en.srt 1.9 kB
06 Filtering Data/008 Order of execution of WHERE, SELECT and ORDER BY clauses.en.srt 1.9 kB
13 PostgreSQL Sequences/006 Delete a sequence.en.srt 1.8 kB
25 Fun with subqueries/005 Get total revenues for all 'English' films.html 1.8 kB
13 PostgreSQL Sequences/008 List all sequences in a database.en.srt 1.8 kB
47 Managing Tables/006 Backup your databases regularly.html 1.8 kB
01 Welcome/001 Course Introduction.en.srt 1.8 kB
47 Managing Tables/007 Test queries on a test database.html 1.8 kB
24 All about Views/027 Quick queries for materialized views.html 1.6 kB
42 Using Human Resource (hr) database/005 Difference b_w highest and lowest salaries by job_id.en.srt 1.6 kB
26 Common Table Expressions (CTE)/004 Get the total revenues for each director.html 1.6 kB
47 Managing Tables/008 Not documenting your process_.html 1.6 kB
41 Using Northwind Database/001 Using Northwind database.en.srt 1.6 kB
22 JSON with PostgreSQL/012 JSON nulls and SQL nulls.html 1.6 kB
49 Thank You!/001 Your feedback is very valuable.html 1.5 kB
45 PostgreSQL Utilities - psql/006 Describe a table.en.srt 1.5 kB
43 Exploring Stock Markets Data/001 Introduction To stock market data.html 1.5 kB
42 Using Human Resource (hr) database/012 To list all employees IDs within each job_id group.en.srt 1.5 kB
17 Grouping Data/005 Order of execution in HAVING clause.en.srt 1.5 kB
45 PostgreSQL Utilities - psql/007 Edit SQL commands in editor.en.srt 1.4 kB
36 PostgreSQL Triggers/024 Dropping a trigger.en.srt 1.4 kB
01 Welcome/002 Sample Data Files.html 1.3 kB
49 Thank You!/002 Upcoming course - Advanced Time Series Analysis.html 1.3 kB
45 PostgreSQL Utilities - psql/009 Built-in syntax reference for commands.en.srt 1.3 kB
42 Using Human Resource (hr) database/016 Using SUBSTRING to get portion of string data.en.srt 1.1 kB
49 Thank You!/003 Thank You!.en.srt 1.0 kB
38 Creating Crosstab Reports/509 pivotcode.sql 948 Bytes
04 Modifying Data in the tables/026 q_insert data into table.sql 267 Bytes
03 Creating and Modifying Tables/017 q_creating the movies table with a foreign key.sql 258 Bytes
03 Creating and Modifying Tables/016 q_creating the directors table.sql 227 Bytes
04 Modifying Data in the tables/029 q_use RETURNING to get info on added rows.sql 224 Bytes
03 Creating and Modifying Tables/018 q_creating the movies_revenues table.sql 216 Bytes
34 Functions with PL_pgSQL language/437 q_variable_initialization_timing.sql 192 Bytes
03 Creating and Modifying Tables/015 q_creating movies database and actors table.sql 186 Bytes
03 Creating and Modifying Tables/019 q_creating a junction table with movies and actors table.sql 184 Bytes
04 Modifying Data in the tables/027 q_insert multiple records into a table.sql 137 Bytes
03 Creating and Modifying Tables/025 q_deleting tables from a database.sql 119 Bytes
04 Modifying Data in the tables/028 q_insert a data that had quotes.sql 93 Bytes