Genre:eLearning |Language:English
Files Included :
001 Course Introduction.mp4 (9.45 MB)
002 sample-data.zip (1.41 MB)
001 Installing PostgreSQL on Mac.mp4 (11.12 MB)
002 Installing PostgreSQL on Windows.mp4 (16.08 MB)
003 Configure pgAdmin 4 client.mp4 (4.63 MB)
004 Creating a Database User.mp4 (7.57 MB)
005 Creating a Database.mp4 (6.02 MB)
006 Running a query in pgAdmin tool.mp4 (3.89 MB)
007 Install sample data files on server.mp4 (6.57 MB)
007 sample-data.zip (1.41 MB)
008 Install Human Resources (hr) database.mp4 (5.36 MB)
008 sample-data.zip (1.41 MB)
009 Install sample stocks market data.mp4 (15.77 MB)
009 sample-data.zip (1.41 MB)
010 Install northwind database.mp4 (19.35 MB)
011 Drop a database.mp4 (8.57 MB)
001 Movie Database Structure.mp4 (8.41 MB)
002 Creating the movie database and a actors table.mp4 (13.24 MB)
003 Creating the directors table.mp4 (9.19 MB)
004 Creating the movies table with a foreign key.mp4 (13.19 MB)
005 Creating the movies revenues table.mp4 (8.4 MB)
006 Creating a Junction table with movies and actors tables.mp4 (9.96 MB)
007 Install sample data for 'movies' database.mp4 (49.48 MB)
007 sample-data.zip (1.41 MB)
009 Using pgAdmin - Create and modify a table.mp4 (13.46 MB)
010 Using pgAdmin - View table structure, and create column.mp4 (13.64 MB)
011 Using pgAdmin - Rename, delete and change the data type of a column.mp4 (30.98 MB)
012 Deleting tables from a database.mp4 (6.21 MB)
001 Insert a data into table.mp4 (11.64 MB)
002 Insert multiple records into a table.mp4 (6.15 MB)
003 Insert a data that had quotes.mp4 (4.8 MB)
004 Use RETURNING to get info on added rows.mp4 (7.01 MB)
005 Update data in a table.mp4 (12.02 MB)
006 Updating a row and returning the updated row.mp4 (6.9 MB)
007 Updating all records in a table.mp4 (8.19 MB)
008 Delete data from a table.mp4 (8.18 MB)
009 Using UPSERT.mp4 (24.2 MB)
001 Select all data from a table.mp4 (23.48 MB)
002 Selecting specific columns from a table.mp4 (9.84 MB)
003 Adding Aliases to columns in a table.mp4 (30.24 MB)
004 Using SELECT statement for expressions.mp4 (8.39 MB)
005 Using ORDER BY to sort records.mp4 (26.55 MB)
006 Using ORDER BY with alias column name.mp4 (8.43 MB)
007 Using ORDER BY to sort rows by expressions.mp4 (9.82 MB)
008 Using ORDER BY with column name or column number.mp4 (10.88 MB)
009 Using ORDER BY with NULL values.mp4 (14.53 MB)
010 Using DISTINCT for selecting distinct values.mp4 (16.51 MB)
001 Comparison, Logical and Arithmetic operators.mp4 (5.47 MB)
002 AND operator.mp4 (37.19 MB)
003 OR operator.mp4 (9.55 MB)
004 Combining AND, OR operators.mp4 (19.67 MB)
005 What goes before and after WHERE clause.mp4 (8.92 MB)
006 Execution order with AND, OR operators.mp4 (5.63 MB)
007 Can we use column aliases with WHERE.mp4 (5.79 MB)
008 Order of execution of WHERE, SELECT and ORDER BY clauses.mp4 (3.88 MB)
009 Using Logical operators.mp4 (55.76 MB)
010 Using LIMIT and OFFSET.mp4 (55.35 MB)
011 Using FETCH.mp4 (50.78 MB)
012 Using IN, NOT IN.mp4 (41.9 MB)
013 Using BETWEEN and NOT BETWEEN.mp4 (31.24 MB)
014 Using LIKE and ILIKE.mp4 (54.95 MB)
015 Using IS NULL and IS NOT NULL keywords.mp4 (38.62 MB)
016 Concatenation techniques.mp4 (21.17 MB)
017 Concatenation with , CONCAT and CONCAT WS.mp4 (11.42 MB)
001 Boolean.mp4 (34.14 MB)
002 CHAR, VARCHAR and TEXT.mp4 (47.75 MB)
003 NUMERIC.mp4 (26.66 MB)
004 DECIMALS.mp4 (26.14 MB)
005 Selecting Numbers data types.mp4 (15.75 MB)
006 DateTime data types.mp4 (9.81 MB)
007 DATE.mp4 (16.02 MB)
008 TIME.mp4 (37.96 MB)
009 TIMESTAMP and TIMESTAMPTZ.mp4 (33.62 MB)
010 UUID.mp4 (30.95 MB)
011 Array.mp4 (18.47 MB)
012 hstore.mp4 (20.01 MB)
013 JSON.mp4 (71.86 MB)
014 Network Addresses.mp4 (37.95 MB)
001 Creating sample database 'mydata', adding columns.mp4 (10.81 MB)
002 Modify Table Structures, AddModify Columns.mp4 (21.73 MB)
003 Add constraints to columns.mp4 (26.66 MB)
001 What is a data type conversion.mp4 (19.07 MB)
002 Using CAST for data conversions.mp4 (36.24 MB)
003 Implicit to Explicit conversions.mp4 (10.58 MB)
004 Table data conversion.mp4 (18.46 MB)
001 to char.mp4 (26.79 MB)
002 to number.mp4 (13.89 MB)
003 to date.mp4 (17.37 MB)
004 to timestamp.mp4 (18.73 MB)
001 CREATE DOMAIN - Create a DOMAIN data type, create an address.mp4 (17.39 MB)
002 CREATE DOMAIN - Create a data type for a positive number.mp4 (11.17 MB)
003 CREATE DOMAIN - Create a postal code validation data type.mp4 (7.1 MB)
004 CREATE DOMAIN - Create a domain data type for an email validation.mp4 (9.13 MB)
005 CREATE DOMAIN - Create a Enum or Set of values domain data type.mp4 (11.01 MB)
006 CREATE DOMAIN - Get the list of all DOMAIN data types.mp4 (5.85 MB)
007 CREATE DOMAIN - How to drop a domain data type.mp4 (13.25 MB)
008 CREATE TYPE - Create a composite address object.mp4 (16.87 MB)
009 CREATE TYPE - Create a composite inventory item data type.mp4 (10.76 MB)
010 CREATE TYPE - Create an ENUM data type and see how to drop a data type.mp4 (10.68 MB)
011 ALTER TYPE - Alter a composite data type, change schema and more.mp4 (10.82 MB)
012 ALTER TYPE - Alter an ENUM data type.mp4 (8.63 MB)
013 Update an ENUM data in production server.mp4 (20.4 MB)
014 An ENUM with a DEFAULT value in a table.mp4 (10.84 MB)
015 Create a type if not exists using a PLpgSQL function.mp4 (5.02 MB)
001 Introduction to constraints.mp4 (11.11 MB)
002 NOT NULL constraint.mp4 (28.39 MB)
003 UNIQUE constraint.mp4 (38.12 MB)
004 DEFAULT constraint.mp4 (13.99 MB)
005 PRIMARY KEY Constraints.mp4 (55.5 MB)
006 PRIMARY KEY Constraints on multiple columns.mp4 (34.81 MB)
007 FOREIGN KEY Constraints.mp4 (11.28 MB)
008 Tables without foreign key constraints.mp4 (31.42 MB)
009 Creating foreign key constraints.mp4 (20.2 MB)
010 Foreign keys maintains referential data integrity.mp4 (20.96 MB)
011 Drop a constraint.mp4 (4.97 MB)
012 Add or update foreign key constraint on existing table.mp4 (7.46 MB)
013 CHECK constraint - An Introduction.mp4 (3.13 MB)
014 CHECK constraint - Add to new table.mp4 (26.31 MB)
015 CHECK constraint - Add, Rename, Drop on existing table.mp4 (25.26 MB)
001 Create a sequence, advance a sequence, get current value, set value.mp4 (18.68 MB)
002 Restart, rename a sequence, and use pgAdmin to alter a sequence.mp4 (11.06 MB)
003 Create a sequence with START WITH, INCREMENT, MINVALUE and MAXVALUE.mp4 (8.42 MB)
004 Create a sequence using a specific data type.mp4 (7.14 MB)
005 Creating a descending sequence, and CYCLE sequence.mp4 (11.86 MB)
006 Delete a sequence.mp4 (3.53 MB)
007 Attach a sequence to a table column.mp4 (22.68 MB)
008 List all sequences in a database.mp4 (3.73 MB)
009 Share one sequence between two tables.mp4 (10.22 MB)
010 Create an alphanumeric sequence.mp4 (19.75 MB)
001 UPPER, LOWER and INITCAP.mp4 (12.35 MB)
002 LEFT and RIGHT.mp4 (25.45 MB)
003 REVERSE.mp4 (5.16 MB)
004 SPLIT PART.mp4 (20.52 MB)
005 TRIM, BTRIM, LTRIM and RTRIM.mp4 (16.91 MB)
006 LPAD and RPAD.mp4 (19.86 MB)
007 LENGTH.mp4 (10.29 MB)
008 POSITION.mp4 (8.92 MB)
009 STRPOS.mp4 (19.81 MB)
010 SUBSTRING.mp4 (10.38 MB)
011 REPEAT.mp4 (5.62 MB)
012 REPLACE.mp4 (10.69 MB)
001 Counting results via COUNT function.mp4 (23.74 MB)
003 Sum with SUM function.mp4 (37.72 MB)
004 MIN and MAX functions.mp4 (68.24 MB)
005 GREATEST AND LEAST functions.mp4 (20.97 MB)
007 Average with AVG function.mp4 (61.35 MB)
008 Combining Columns using Mathematical operators.mp4 (44.96 MB)
001 Datetimes data types.mp4 (26.52 MB)
002 System Month Date settings.mp4 (7.98 MB)
003 Time of day formats and inputs.mp4 (15.45 MB)
004 Strings to Dates conversions.mp4 (37.23 MB)
005 Using TO TIMESTAMP function.mp4 (26.6 MB)
006 Formatting Dates.mp4 (36.72 MB)
007 Date construction functions.mp4 (16.76 MB)
008 Using MAKE INTERVAL function.mp4 (22.5 MB)
009 Using MAKE TIMESTAMPTZ function.mp4 (34.91 MB)
010 Date Value Extractors functions.mp4 (21.42 MB)
011 Using math operators with dates.mp4 (29.09 MB)
012 OVERLAPS Operator.mp4 (10.13 MB)
013 Date Time Functions.mp4 (16.41 MB)
014 PostgreSQL Date Time Functions.mp4 (11.67 MB)
015 AGE function.mp4 (9.01 MB)
016 CURRENT DATE function.mp4 (3 MB)
017 CURRENT TIME function.mp4 (11.75 MB)
018 Date accuracy with EPOCH.mp4 (23.7 MB)
019 Using Date, time, timestamp in tables.mp4 (26.96 MB)
020 View and set timezones.mp4 (9.27 MB)
021 How to handle timezones.mp4 (36.69 MB)
022 date part function.mp4 (66.3 MB)
023 date trunc function.mp4 (29.44 MB)
001 Using GROUP BY.mp4 (35.26 MB)
002 Using GROUP BY with multiple columns, ORDER BY.mp4 (38.25 MB)
003 Order of execution in GROUP BY clause.mp4 (3.55 MB)
004 Using HAVING.mp4 (50.89 MB)
005 Order of execution in HAVING clause.mp4 (2.6 MB)
006 HAVING vs WHERE.mp4 (14.35 MB)
007 Handling NULL values with GROUP BY.mp4 (25.67 MB)
001 INNER joins.mp4 (52.04 MB)
002 INNER joins with USING.mp4 (30.87 MB)
003 INNER joins with filter data Part 1.mp4 (35.15 MB)
004 INNER joins with filter data Part 2.mp4 (13.71 MB)
005 INNER joins with filter data Part 3.mp4 (19.6 MB)
006 INNER joins with different data type columns.mp4 (12.79 MB)
007 LEFT joins Part 1.mp4 (48.64 MB)
008 LEFT joins Part 2.mp4 (26.43 MB)
009 LEFT joins Part 3.mp4 (31.51 MB)
010 LEFT joins Part 4.mp4 (23.2 MB)
011 RIGHT joins.mp4 (33.19 MB)
012 RIGHT joins Part 2.mp4 (9.16 MB)
013 FULL Joins.mp4 (13.62 MB)
014 Joining multiple tables.mp4 (37.02 MB)
015 Self Joins Part 1.mp4 (22.19 MB)
016 Self Joins Part 2.mp4 (8.08 MB)
017 CROSS Joins.mp4 (34.74 MB)
018 Natural Joins Part 1.mp4 (14.88 MB)
019 Natural Joins Part 2.mp4 (7.96 MB)
020 Append tables with different columns.mp4 (43.52 MB)
001 Combine results sets with UNION.mp4 (34.37 MB)
002 UNION with filters and conditions.mp4 (27.68 MB)
003 UNION tables with different number of columns.mp4 (8.65 MB)
004 INTERSECT with tables.mp4 (10.87 MB)
005 EXCEPT with tables.mp4 (30.04 MB)
001 What is a Schema.mp4 (16.17 MB)
002 Schema Operations (AddAlterDelete schemas).mp4 (17.69 MB)
003 Schema Hierarchy.mp4 (16.5 MB)
004 Move a table to a new schema.mp4 (6.87 MB)
005 Schema search path.mp4 (84.51 MB)
006 Alter a schema ownership.mp4 (5.36 MB)
007 Duplicate a schema along with all data.mp4 (24.46 MB)
008 What is a system catalog schema.mp4 (15.29 MB)
009 Compare tables and columns in two schemas.mp4 (28.12 MB)
010 Schemas and Privileges.mp4 (41.95 MB)
001 Constructing arrays and ranges.mp4 (19.49 MB)
002 Using comparison operators.mp4 (20.83 MB)
003 Using inclusion operators.mp4 (20.97 MB)
004 Array constructions.mp4 (13.32 MB)
005 Array metadata functions.mp4 (22.63 MB)
006 Array search functions.mp4 (17.68 MB)
007 Array modification functions.mp4 (18.32 MB)
008 Array comparison with IN, ALL, ANY and SOME.mp4 (33.85 MB)
009 Formatting and converting an array.mp4 (23.09 MB)
010 Using arrays in tables.mp4 (11.95 MB)
011 Insert data into arrays.mp4 (14.5 MB)
012 Query array data.mp4 (18.02 MB)
013 Modifying array data.mp4 (7.99 MB)
014 Array Dimensions are ignored!.mp4 (11.18 MB)
015 Display all array elements.mp4 (9.87 MB)
016 Using Multi-dimensional arrays.mp4 (28.73 MB)
017 Array vs JSONB.mp4 (38.04 MB)
001 What is JSON.mp4 (30.4 MB)
002 JSON Syntax.mp4 (21.74 MB)
003 JSON and JSONB data types.mp4 (11.93 MB)
004 Exploring JSON objects.mp4 (16.74 MB)
005 Create our first table with JSONB data type.mp4 (19.93 MB)
006 Update and Delete JSON Data.mp4 (33.28 MB)
007 Create JSON from tables.mp4 (17.46 MB)
008 Use json agg to aggregate data.mp4 (17.99 MB)
009 Build a JSON array.mp4 (11.2 MB)
010 Creating a document from data.mp4 (17.34 MB)
011 Null Values in JSON documents.mp4 (33.98 MB)
013 Getting information from JSON documents.mp4 (40.09 MB)
014 The Existence Operator.mp4 (7.79 MB)
015 The Containment Operator.mp4 (10.66 MB)
016 JSON search with PostgreSQL functions.mp4 (11.44 MB)
017 Indexing on JSONB.mp4 (49.02 MB)
001 What is an index.mp4 (10.78 MB)
002 Create an index.mp4 (48.46 MB)
003 Create unique indexes.mp4 (35.67 MB)
004 List all indexes.mp4 (11.12 MB)
005 Size of the table index.mp4 (12.91 MB)
006 List counts of all indexes.mp4 (12.37 MB)
007 Drop a index.mp4 (9.27 MB)
008 SQL Statement execution process.mp4 (11.41 MB)
009 SQL statement execution stages.mp4 (17.37 MB)
010 The query optimizer.mp4 (22.47 MB)
011 Optimizer node types.mp4 (14.4 MB)
012 Sequential Nodes.mp4 (22.18 MB)
013 Index Nodes.mp4 (25.95 MB)
014 Join Nodes.mp4 (22.7 MB)
015 Index Types - B-Tree Index.mp4 (12.24 MB)
016 Hash Index.mp4 (15.15 MB)
017 BRIN index.mp4 (5.82 MB)
018 GIN Index.mp4 (4.64 MB)
019 The EXPLAIN statement.mp4 (46.34 MB)
020 EXPLAIN output options.mp4 (7.41 MB)
021 Using EXPLAIN ANALYZE.mp4 (24.57 MB)
022 Understanding query cost model.mp4 (76.92 MB)
023 Index are not free.mp4 (37.17 MB)
024 Indexes for sorted output.mp4 (22.68 MB)
025 Using multiple indexes on a single query.mp4 (20.27 MB)
026 Execution plans depends on input values.mp4 (17.92 MB)
027 Using organized vs random data.mp4 (63.05 MB)
028 Try to use index only scan.mp4 (10.33 MB)
029 Partial indexes.mp4 (34.95 MB)
030 Expression Index.mp4 (72.62 MB)
031 Adding data while indexing.mp4 (7.47 MB)
032 Invalidating an index.mp4 (54.76 MB)
033 Rebuilding an index.mp4 (18.66 MB)
001 Introduction to views.mp4 (19.84 MB)
002 Creating a view.mp4 (34.04 MB)
003 Rename a view.mp4 (11.24 MB)
004 Delete a view.mp4 (4.35 MB)
005 Using filters with views.mp4 (24.69 MB)
006 A view with UNION of multiple tables.mp4 (14.3 MB)
007 Connecting multiple tables with a single view.mp4 (25.67 MB)
008 Re-arrange columns in a view.mp4 (7.64 MB)
009 Delete a column in a view.mp4 (4.6 MB)
010 Add a column in a view.mp4 (5.6 MB)
011 Regular views are dynamic.mp4 (8.51 MB)
012 What is an updatable view.mp4 (9.99 MB)
013 An updatable view with CRUD operations.mp4 (17.87 MB)
014 Updatable views using WITH CHECK OPTION.mp4 (26.19 MB)
015 Updatable views using WITH LOCAL and CASCADED CHECK OPTION.mp4 (25.02 MB)
016 What is a Materialized View.mp4 (26.02 MB)
017 Creating a materialized view.mp4 (11.75 MB)
018 Drop a materialized view.mp4 (9.15 MB)
019 Changing materialized view data.mp4 (33.2 MB)
020 How to check if a materialized view is populated or not.mp4 (15.43 MB)
021 Refreshing data in materialize views.mp4 (23.13 MB)
022 Why not use a table instead of materialized view.mp4 (11.13 MB)
023 The downsides of using materialized views.mp4 (9.41 MB)
024 Using materialized view for websites page analysis.mp4 (38.98 MB)
025 List all materialized views by a SELECT statement.mp4 (3.72 MB)
026 List materialized views with no unique index.mp4 (10.47 MB)
002 Subqueries with WHERE Clause.mp4 (41.27 MB)
003 Subquery with IN operator.mp4 (12.38 MB)
004 Subquery with JOINs.mp4 (29.3 MB)
006 Order entries in UNION without using ORDER BY.mp4 (10.86 MB)
007 Subquery with an alias.mp4 (4.36 MB)
008 A SELECT without a FROM.mp4 (6.55 MB)
009 Correlated Queries.mp4 (32.06 MB)
010 SELECT IN (Subquery).mp4 (24.08 MB)
011 Using ANY with subquery.mp4 (24.89 MB)
012 Using ALL with subquery.mp4 (28.71 MB)
013 Subquery using EXISTS.mp4 (12.81 MB)
001 Introduction to CTEs.mp4 (33.47 MB)
002 CTE query examples.mp4 (46.6 MB)
003 Combine CTE with a table.mp4 (22.39 MB)
005 Simultaneously DELETE INSERT via CTE.mp4 (20.3 MB)
006 Recursive CTEs.mp4 (11.98 MB)
007 Parent-child relationship via recursive CTE.mp4 (47.29 MB)
001 Introduction to summarization.mp4 (21.14 MB)
002 Subtotals on group sets.mp4 (64.49 MB)
003 Adding subtotal with ROLLUP.mp4 (20.27 MB)
004 Using GROUPING with ROLLUP.mp4 (68.28 MB)
001 Introduction to Window Functions.mp4 (4.59 MB)
002 Analyze Global Trades Data.mp4 (54.15 MB)
003 Using aggregate functions.mp4 (29.39 MB)
004 GROUP BY ROLLUP.mp4 (13.67 MB)
005 ROLLUP - Grouping multiple columns.mp4 (10.89 MB)
006 GROUP BY CUBE.mp4 (12.64 MB)
007 GROUP BY GROUPING SETS.mp4 (12.05 MB)
008 Query performance check.mp4 (13.42 MB)
009 Using FILTER clause.mp4 (13.9 MB)
010 Using Window Functions.mp4 (12.93 MB)
011 Partitioning the data.mp4 (16.7 MB)
012 Set data into millions format.mp4 (6.84 MB)
013 Ordering inside window.mp4 (45.42 MB)
014 Sliding dynamic windows.mp4 (20.07 MB)
015 Understanding window frames.mp4 (106.64 MB)
016 ROWS and RANGE indicators.mp4 (37.57 MB)
017 Using WINDOW.mp4 (22.31 MB)
018 Using WINDOW with ROWS BETWEEN.mp4 (11.24 MB)