12-13-2024, 05:28 PM
![[Image: 537368816_que-es-udemy-analisis-opiniones.jpg]](https://img100.pixhost.to/images/404/537368816_que-es-udemy-analisis-opiniones.jpg)
12.41 GB | 17min 53s | mp4 | 1280X720 | 16:9
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)
019 RANK and DENSE RANK functions.mp4 (12.89 MB)
020 NTILE function.mp4 (23.63 MB)
021 LEAD and LAG functions.mp4 (45.61 MB)
022 FIRST VALUE, LAST VALUE and NTH value functions.mp4 (48.2 MB)
023 ROW NUMBER function.mp4 (33.36 MB)
024 Finding Correlations.mp4 (14.41 MB)
025 ROW NUMBER() - Window with Partition datasets.mp4 (70.75 MB)
026 ROW NUMBER() - Reverse fields with order by.mp4 (8.68 MB)
027 ROW NUMBER() - Find Nth record.mp4 (9.3 MB)
028 ROW NUMBER() - Find DISTINCT with subquery.mp4 (16.32 MB)
029 ROW NUMBER() - Pagination technique.mp4 (21.57 MB)
030 Using OVER() to calculate percentage.mp4 (15.66 MB)
031 Calculate difference compared to average.mp4 (15.91 MB)
032 Calculating cumulative totals.mp4 (13.42 MB)
033 Using LEAD to compare with next values.mp4 (27 MB)
034 Comparing with least number.mp4 (29.65 MB)
035 Window Function Summary.mp4 (10.29 MB)
036 Planning tips on using Window Functions.mp4 (11.42 MB)
037 Difference between RANK and DENSE RANK.mp4 (7.6 MB)
038 Getting RANK to compute group and global ranks.mp4 (12.91 MB)
039 Using PARTITION BY for group averages.mp4 (16.78 MB)
040 Using WITH clause to create your own data.mp4 (9.26 MB)
041 Using WITH clause to set ORDER BY values.mp4 (16.17 MB)
042 DELETE and INSERT in one query using WITH.mp4 (14.95 MB)
001 Text to structured data.mp4 (15.14 MB)
002 Regular expressions notations table.mp4 (23.35 MB)
003 SIMILAR TO operator.mp4 (17.67 MB)
004 POSIX regular expressions.mp4 (13.25 MB)
005 SUBSTRING with regular expressions.mp4 (109.18 MB)
006 REGEXP MATCHES Function.mp4 (24.79 MB)
007 REGEXP REPLACE Function.mp4 (19.44 MB)
008 REGEXP SPLIT TO TABLE Function.mp4 (3.6 MB)
009 REGEXP SPLIT TO ARRAY function.mp4 (8.2 MB)
001 The Good Ol' Text Search.mp4 (26.37 MB)
002 Introducing tsvector.mp4 (31.89 MB)
003 Using tsquery with operators.mp4 (83.44 MB)
004 Full text search within a table.mp4 (39.17 MB)
005 Setup presidents speeches data.mp4 (27.92 MB)
006 Analyzing presidents speeches text data.mp4 (26.34 MB)
007 Ranking and Normalizing text results.mp4 (14.79 MB)
001 What is a partition.mp4 (35.61 MB)
002 When a partition can be used.mp4 (50.4 MB)
003 Table inheritance.mp4 (41.33 MB)
004 Partition types.mp4 (7.23 MB)
005 Partition by Range.mp4 (63.51 MB)
006 Partition by List.mp4 (80.26 MB)
007 Partition by Hash.mp4 (38.28 MB)
008 DEFAULT Partition.mp4 (21.02 MB)
009 Multi-level partitioning.mp4 (37.7 MB)
010 Partition maintenance.mp4 (16.52 MB)
011 ALTERing the partition bounds.mp4 (23.91 MB)
012 Partition Indexes.mp4 (19.44 MB)
013 Partition pruning.mp4 (11.06 MB)
014 Determining a field for partition over.mp4 (19.88 MB)
015 Sizing the partition.mp4 (14.46 MB)
016 Partitioning Advantages.mp4 (13.1 MB)
017 Common partitioning mistakes.mp4 (30.82 MB)
001 PostgreSQL as a development platform.mp4 (25.59 MB)
002 Procedural languages.mp4 (13.6 MB)
003 Keep the data on the server!.mp4 (15.77 MB)
004 Functions vs stored procedures.mp4 (10.52 MB)
005 User-defined functions.mp4 (9.77 MB)
006 Structure of a function.mp4 (7.06 MB)
001 Creating our first SQL function.mp4 (31.24 MB)
002 Introducing dollar quoting.mp4 (10.03 MB)
003 Function returning no values.mp4 (13.88 MB)
004 Function returning a single value.mp4 (31.52 MB)
005 Function returning a single value Part 2.mp4 (17.9 MB)
006 Function returning a single value Part 3.mp4 (15.78 MB)
007 Function using parameters.mp4 (46.7 MB)
008 Function using parameters Part 2.mp4 (17.5 MB)
009 Function using parameters Part 3.mp4 (79.74 MB)
010 Function using parameters Part 4.mp4 (49.99 MB)
011 Function returning a composite.mp4 (42.13 MB)
012 Function returning multiple rows.mp4 (34.16 MB)
013 Function returning a table.mp4 (9.25 MB)
014 Function - order matters!.mp4 (10.32 MB)
015 Function as a table source.mp4 (34.38 MB)
016 Function parameter modes.mp4 (10.32 MB)
017 Function parameters with default values.mp4 (28.71 MB)
018 Function based on views.mp4 (20.75 MB)
019 Drop a function.mp4 (11.36 MB)
001 Introduction to PLpgSQL language.mp4 (5.21 MB)
002 PLpgSQL vs SQL.mp4 (6.78 MB)
003 Structure of a PLpgSQL function.mp4 (12.34 MB)
004 PLpgSQL block structure.mp4 (6.44 MB)
005 Declaring variables.mp4 (14.79 MB)
006 Declaring variables via ALIAS FOR.mp4 (4.12 MB)
007 Declaring variables in function.mp4 (13.46 MB)
008 Variable initializing timing.mp4 (5.75 MB)
009 Copying data types.mp4 (7.37 MB)
010 Assigning variables from query.mp4 (25.25 MB)
011 Using IN, OUT without RETURNS.mp4 (11.5 MB)
012 Variables in block and subblock.mp4 (12.03 MB)
013 How to return query results.mp4 (19.69 MB)
014 Control Structures - IF statement.mp4 (21.08 MB)
015 Using IF with table data.mp4 (20.99 MB)
016 CASE Statement.mp4 (38.03 MB)
017 Searched CASE statement.mp4 (29.39 MB)
018 LOOP statement.mp4 (14.9 MB)
019 FOR Loops.mp4 (14.3 MB)
020 FOR Loops iterate over result set.mp4 (14.73 MB)
021 CONTINUE statement.mp4 (12.48 MB)
022 FOREACH loop with arrays.mp4 (9.62 MB)
023 WHILE loop.mp4 (33.43 MB)
024 Using RETURN QUERY.mp4 (35.49 MB)
025 Returning a table.mp4 (10.91 MB)
026 Using RETURN NEXT.mp4 (43.88 MB)
027 Error and exception handling.mp4 (15.01 MB)
028 Exception - Too many rows.mp4 (14.32 MB)
029 Using SQLSTATE codes for exception handling.mp4 (14.78 MB)
030 Exception with data exception errors.mp4 (37.74 MB)
001 Functions vs Stored Procedures.mp4 (15.11 MB)
002 Create a transactions.mp4 (21.27 MB)
003 Understanding the use of stored procedures.mp4 (14.36 MB)
004 Returning a value.mp4 (16.23 MB)
005 Drop a procedure.mp4 (4.34 MB)
002 What is a trigger.mp4 (28.09 MB)
003 Types of triggers.mp4 (7.1 MB)
004 Trigger table.mp4 (7.16 MB)
005 Pros and Cons of triggers.mp4 (30.32 MB)
006 Trigger key points.mp4 (6.87 MB)
007 Steps to create a trigger.mp4 (14.38 MB)
008 Data auditing with a trigger.mp4 (28.67 MB)
009 Bind a function to a table with trigger.mp4 (22.11 MB)
010 Modify data at INSERT event.mp4 (30.52 MB)
011 View triggers variables.mp4 (13.69 MB)
012 Disallow DELETE on a table.mp4 (26.58 MB)
013 Disallow TRUNCATE on a table.mp4 (17.99 MB)
014 Creating an audit trigger.mp4 (52.42 MB)
015 Creating conditional triggers.mp4 (47.92 MB)
016 Disallow data change on primary key.mp4 (14.52 MB)
017 Use triggers very cautiously.mp4 (8.9 MB)
018 What is an event trigger.mp4 (4.67 MB)
019 Event triggers usage scenarios.mp4 (8.85 MB)
020 Creating event triggers.mp4 (12.44 MB)
021 Event trigger events and variables.mp4 (11.96 MB)
022 Creating an audit event trigger.mp4 (46.32 MB)
023 Prevent schema changes.mp4 (22.95 MB)
024 Dropping a trigger.mp4 (2.45 MB)
001 Understanding row by row operations.mp4 (25.58 MB)
002 Cursors and procedural languages.mp4 (13.7 MB)
003 Steps to create a cursor.mp4 (8.18 MB)
004 Creating a cursor.mp4 (21.83 MB)
005 Opening a cursor.mp4 (26.31 MB)
006 Using a cursor.mp4 (22.87 MB)
007 Updating data.mp4 (4.72 MB)
008 Closing a cursor.mp4 (3.65 MB)
009 Creating a PLPGSQL Cursor.mp4 (28.63 MB)
010 Using a parametric cursor via function.mp4 (56.65 MB)
001 What is a crosstab report.mp4 (30.09 MB)
002 Installing the tablefunc extension.mp4 (4.81 MB)
003 Creating a crosstab report - Student Rankings.mp4 (38.38 MB)
004 Orders matters in crosstab reports.mp4 (7.82 MB)
005 Pivoting with Rainfalls data.mp4 (28.67 MB)
006 Pivoting rows and columns.mp4 (13.33 MB)
007 Matrix report via a query.mp4 (26.11 MB)
008 Aggregate over filter.mp4 (31.89 MB)
009 Static to dynamic pivots.mp4 (17.68 MB)
010 Dynamic pivot query via JSON.mp4 (24.55 MB)
011 Dynamic pivot table columns.mp4 (55.62 MB)
012 Interactive client-side pivot.mp4 (41.91 MB)
013 Handling missing values.mp4 (37.79 MB)
001 Global Character Set Support.mp4 (35.16 MB)
002 Client and Server Encoding.mp4 (36.19 MB)
001 What is a transaction.mp4 (23.33 MB)
002 How SQL protect database during transaction.mp4 (13.91 MB)
003 ACID Database.mp4 (23.27 MB)
004 Transaction setup.mp4 (6.08 MB)
005 Transaction analysis.mp4 (34.89 MB)
006 How to fix aborted transaction.mp4 (9.42 MB)
007 How to fix transactions on crash.mp4 (19.63 MB)
008 Partial transaction rollback with savepoints.mp4 (9.41 MB)
009 Using SAVEPOINT with transaction.mp4 (14.5 MB)
001 Using Northwind database.mp4 (2.63 MB)
002 Orders shipping to USA or France.mp4 (5.66 MB)
003 Total numbers of orders shipped to USA or France.mp4 (5.74 MB)
004 Orders shipped to latin america.mp4 (10.61 MB)
005 Show total order amount for each order.mp4 (11.85 MB)
006 First the oldest and latest order date.mp4 (5.42 MB)
007 Total products in each categories.mp4 (9.47 MB)
008 List products that needs re-ordering.mp4 (8.67 MB)
009 Freight analysis.mp4 (30.25 MB)
010 Customers with no orders.mp4 (14.26 MB)
011 Top customers with total orders amount.mp4 (14.18 MB)
012 Orders with many lines of ordered items.mp4 (6.77 MB)
013 Orders with double entry line items.mp4 (24.58 MB)
014 Late shipped orders by employees.mp4 (27.05 MB)
015 Countries with customers or suppliers.mp4 (6.62 MB)
016 Countries with customers or suppliers - Using CTE.mp4 (15.01 MB)
017 Customers with multiple orders.mp4 (21.59 MB)
018 First order from each country.mp4 (23.86 MB)
001 Human Resources Database Structure.mp4 (17.03 MB)
002 Quick overview of all tables.mp4 (13.24 MB)
003 Quick overview of all tables Part 2.mp4 (8.84 MB)
004 Get highest, lowest, total, and average salaries of employees.mp4 (9.54 MB)
005 Difference bw highest and lowest salaries by job id.mp4 (3.4 MB)
006 Get lowest paid salaries by each manager.mp4 (5.39 MB)
007 Average salary for each department with more than 10 employees.mp4 (6.3 MB)
008 Average salary for each post excluding programmer.mp4 (4.86 MB)
009 Maximum salary for each post where salary is at or above $5000.mp4 (5.92 MB)
010 Using an alias name with columns.mp4 (4.37 MB)
011 Compute 15% of salary for all employees.mp4 (7.77 MB)
012 To list all employees IDs within each job id group.mp4 (3.29 MB)
013 Discard characters from employees email address.mp4 (19.43 MB)
014 List all employees with first name starts with letters A, C or M.mp4 (7.95 MB)
015 String manipulation with upper, lower and initcap functions.mp4 (4.74 MB)
016 Using SUBSTRING to get portion of string data.mp4 (1.87 MB)
017 Get unique designations in employees table.mp4 (5.52 MB)
018 Select employees with particular department id only.mp4 (5.71 MB)
019 Select employees not in range.mp4 (8.78 MB)
020 Find Letter C in last name at 3rd or greater position.mp4 (6.41 MB)
021 Update phone number with your strings.mp4 (7.23 MB)
022 Get the monthly salary of each employees.mp4 (5.66 MB)
023 Calculate average salary with total number of employees.mp4 (4.4 MB)
024 find employees whose names contains exactly six characters.mp4 (5.7 MB)
002 Select first or last records in a table.mp4 (14.99 MB)
003 Get first or last record per each group.mp4 (12.91 MB)
004 How to calculate cube root in PostgreSQL.mp4 (4.53 MB)
001 Security concepts and and levels.mp4 (7.78 MB)
002 Instance Level Security.mp4 (14.19 MB)
003 Instance Level Security - Add users to roles.mp4 (11.19 MB)
004 Use pgAdmin to create roles.mp4 (9.09 MB)
005 Database Level Security.mp4 (14.22 MB)
006 Schema Level Security.mp4 (29.49 MB)
007 Table Level Security.mp4 (42.39 MB)
008 Column Level Security.mp4 (21.64 MB)
009 Row Level Security.mp4 (93.46 MB)
010 Using CURRENT USER with RLS.mp4 (15.8 MB)
011 Row level policy for application users.mp4 (13.85 MB)
012 DROP a policy.mp4 (6.19 MB)
013 Inspecting permissions.mp4 (13.36 MB)
014 Row Level Security Performance.mp4 (12.07 MB)
015 Encrypted data in columns.mp4 (40.13 MB)
001 Connect to local or remote database.mp4 (9.6 MB)
002 Switch connection to a new database.mp4 (4.04 MB)
003 List all databases and tables.mp4 (8.63 MB)
004 List all table space, schemas, and indices.mp4 (8.56 MB)
005 List all sequences, roles, data types, domain data types.mp4 (46.53 MB)
006 Describe a table.mp4 (2.4 MB)
007 Edit SQL commands in editor.mp4 (3.02 MB)
008 Display command history, run commands from a file.mp4 (7.4 MB)
009 Built-in syntax reference for commands.mp4 (2.66 MB)
010 Represent NULL values on psql terminal.mp4 (9.71 MB)
011 Make table layout funkey!.mp4 (7.16 MB)
012 Repeatedly Execute a Query.mp4 (5.66 MB)
013 Represent NULL Visibly.mp4 (9.7 MB)
014 Turn on query execution time.mp4 (9.87 MB)
001 List database users, and database sizes with and without indexes.mp4 (11.06 MB)
002 List all database and schemas.mp4 (24.44 MB)
003 List all tables and views.mp4 (24.31 MB)
004 List all columns from a table.mp4 (7.33 MB)
005 View system metadata via system information functions.mp4 (6.72 MB)
006 View privileges information across tables.mp4 (29.24 MB)
007 internal-view-system-administration-functions.mp4 (89.29 MB)
007 Using system Administration functions.mp4 (17.06 MB)
008 Show all running queries.mp4 (13.42 MB)
009 Terminate running and IDLE process.mp4 (7.47 MB)
010 How to check live and dead rows in tables.mp4 (4.4 MB)
011 File layout of PostgreSQL Tables.mp4 (43.31 MB)
001 Using SELECT INTO to create a new table with joins.mp4 (46.74 MB)
002 Duplicate a table with or without data.mp4 (8.31 MB)
003 Import data from CSV files.mp4 (25.39 MB)
004 Export Data to CSV files.mp4 (16.96 MB)
005 Deleting duplicate records.mp4 (19.2 MB)
009 Database operations and table size.mp4 (16.58 MB)
010 Tracking table size.mp4 (19.64 MB)
011 PostgreSQL autovacuum proces.mp4 (35.77 MB)
012 Recovering unused space with VACUUM.mp4 (35.56 MB)
013 Generated Columns.mp4 (34.11 MB)
001 Create a custom index method.mp4 (73.97 MB)
002 Create a user-defined aggregate function.mp4 (28.93 MB)
004 Thank You!.mp4 (1.64 MB)]
Screenshot
![[Image: cV0vp8IA_o.jpg]](https://images2.imgbox.com/fc/df/cV0vp8IA_o.jpg)
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)
019 RANK and DENSE RANK functions.mp4 (12.89 MB)
020 NTILE function.mp4 (23.63 MB)
021 LEAD and LAG functions.mp4 (45.61 MB)
022 FIRST VALUE, LAST VALUE and NTH value functions.mp4 (48.2 MB)
023 ROW NUMBER function.mp4 (33.36 MB)
024 Finding Correlations.mp4 (14.41 MB)
025 ROW NUMBER() - Window with Partition datasets.mp4 (70.75 MB)
026 ROW NUMBER() - Reverse fields with order by.mp4 (8.68 MB)
027 ROW NUMBER() - Find Nth record.mp4 (9.3 MB)
028 ROW NUMBER() - Find DISTINCT with subquery.mp4 (16.32 MB)
029 ROW NUMBER() - Pagination technique.mp4 (21.57 MB)
030 Using OVER() to calculate percentage.mp4 (15.66 MB)
031 Calculate difference compared to average.mp4 (15.91 MB)
032 Calculating cumulative totals.mp4 (13.42 MB)
033 Using LEAD to compare with next values.mp4 (27 MB)
034 Comparing with least number.mp4 (29.65 MB)
035 Window Function Summary.mp4 (10.29 MB)
036 Planning tips on using Window Functions.mp4 (11.42 MB)
037 Difference between RANK and DENSE RANK.mp4 (7.6 MB)
038 Getting RANK to compute group and global ranks.mp4 (12.91 MB)
039 Using PARTITION BY for group averages.mp4 (16.78 MB)
040 Using WITH clause to create your own data.mp4 (9.26 MB)
041 Using WITH clause to set ORDER BY values.mp4 (16.17 MB)
042 DELETE and INSERT in one query using WITH.mp4 (14.95 MB)
001 Text to structured data.mp4 (15.14 MB)
002 Regular expressions notations table.mp4 (23.35 MB)
003 SIMILAR TO operator.mp4 (17.67 MB)
004 POSIX regular expressions.mp4 (13.25 MB)
005 SUBSTRING with regular expressions.mp4 (109.18 MB)
006 REGEXP MATCHES Function.mp4 (24.79 MB)
007 REGEXP REPLACE Function.mp4 (19.44 MB)
008 REGEXP SPLIT TO TABLE Function.mp4 (3.6 MB)
009 REGEXP SPLIT TO ARRAY function.mp4 (8.2 MB)
001 The Good Ol' Text Search.mp4 (26.37 MB)
002 Introducing tsvector.mp4 (31.89 MB)
003 Using tsquery with operators.mp4 (83.44 MB)
004 Full text search within a table.mp4 (39.17 MB)
005 Setup presidents speeches data.mp4 (27.92 MB)
006 Analyzing presidents speeches text data.mp4 (26.34 MB)
007 Ranking and Normalizing text results.mp4 (14.79 MB)
001 What is a partition.mp4 (35.61 MB)
002 When a partition can be used.mp4 (50.4 MB)
003 Table inheritance.mp4 (41.33 MB)
004 Partition types.mp4 (7.23 MB)
005 Partition by Range.mp4 (63.51 MB)
006 Partition by List.mp4 (80.26 MB)
007 Partition by Hash.mp4 (38.28 MB)
008 DEFAULT Partition.mp4 (21.02 MB)
009 Multi-level partitioning.mp4 (37.7 MB)
010 Partition maintenance.mp4 (16.52 MB)
011 ALTERing the partition bounds.mp4 (23.91 MB)
012 Partition Indexes.mp4 (19.44 MB)
013 Partition pruning.mp4 (11.06 MB)
014 Determining a field for partition over.mp4 (19.88 MB)
015 Sizing the partition.mp4 (14.46 MB)
016 Partitioning Advantages.mp4 (13.1 MB)
017 Common partitioning mistakes.mp4 (30.82 MB)
001 PostgreSQL as a development platform.mp4 (25.59 MB)
002 Procedural languages.mp4 (13.6 MB)
003 Keep the data on the server!.mp4 (15.77 MB)
004 Functions vs stored procedures.mp4 (10.52 MB)
005 User-defined functions.mp4 (9.77 MB)
006 Structure of a function.mp4 (7.06 MB)
001 Creating our first SQL function.mp4 (31.24 MB)
002 Introducing dollar quoting.mp4 (10.03 MB)
003 Function returning no values.mp4 (13.88 MB)
004 Function returning a single value.mp4 (31.52 MB)
005 Function returning a single value Part 2.mp4 (17.9 MB)
006 Function returning a single value Part 3.mp4 (15.78 MB)
007 Function using parameters.mp4 (46.7 MB)
008 Function using parameters Part 2.mp4 (17.5 MB)
009 Function using parameters Part 3.mp4 (79.74 MB)
010 Function using parameters Part 4.mp4 (49.99 MB)
011 Function returning a composite.mp4 (42.13 MB)
012 Function returning multiple rows.mp4 (34.16 MB)
013 Function returning a table.mp4 (9.25 MB)
014 Function - order matters!.mp4 (10.32 MB)
015 Function as a table source.mp4 (34.38 MB)
016 Function parameter modes.mp4 (10.32 MB)
017 Function parameters with default values.mp4 (28.71 MB)
018 Function based on views.mp4 (20.75 MB)
019 Drop a function.mp4 (11.36 MB)
001 Introduction to PLpgSQL language.mp4 (5.21 MB)
002 PLpgSQL vs SQL.mp4 (6.78 MB)
003 Structure of a PLpgSQL function.mp4 (12.34 MB)
004 PLpgSQL block structure.mp4 (6.44 MB)
005 Declaring variables.mp4 (14.79 MB)
006 Declaring variables via ALIAS FOR.mp4 (4.12 MB)
007 Declaring variables in function.mp4 (13.46 MB)
008 Variable initializing timing.mp4 (5.75 MB)
009 Copying data types.mp4 (7.37 MB)
010 Assigning variables from query.mp4 (25.25 MB)
011 Using IN, OUT without RETURNS.mp4 (11.5 MB)
012 Variables in block and subblock.mp4 (12.03 MB)
013 How to return query results.mp4 (19.69 MB)
014 Control Structures - IF statement.mp4 (21.08 MB)
015 Using IF with table data.mp4 (20.99 MB)
016 CASE Statement.mp4 (38.03 MB)
017 Searched CASE statement.mp4 (29.39 MB)
018 LOOP statement.mp4 (14.9 MB)
019 FOR Loops.mp4 (14.3 MB)
020 FOR Loops iterate over result set.mp4 (14.73 MB)
021 CONTINUE statement.mp4 (12.48 MB)
022 FOREACH loop with arrays.mp4 (9.62 MB)
023 WHILE loop.mp4 (33.43 MB)
024 Using RETURN QUERY.mp4 (35.49 MB)
025 Returning a table.mp4 (10.91 MB)
026 Using RETURN NEXT.mp4 (43.88 MB)
027 Error and exception handling.mp4 (15.01 MB)
028 Exception - Too many rows.mp4 (14.32 MB)
029 Using SQLSTATE codes for exception handling.mp4 (14.78 MB)
030 Exception with data exception errors.mp4 (37.74 MB)
001 Functions vs Stored Procedures.mp4 (15.11 MB)
002 Create a transactions.mp4 (21.27 MB)
003 Understanding the use of stored procedures.mp4 (14.36 MB)
004 Returning a value.mp4 (16.23 MB)
005 Drop a procedure.mp4 (4.34 MB)
002 What is a trigger.mp4 (28.09 MB)
003 Types of triggers.mp4 (7.1 MB)
004 Trigger table.mp4 (7.16 MB)
005 Pros and Cons of triggers.mp4 (30.32 MB)
006 Trigger key points.mp4 (6.87 MB)
007 Steps to create a trigger.mp4 (14.38 MB)
008 Data auditing with a trigger.mp4 (28.67 MB)
009 Bind a function to a table with trigger.mp4 (22.11 MB)
010 Modify data at INSERT event.mp4 (30.52 MB)
011 View triggers variables.mp4 (13.69 MB)
012 Disallow DELETE on a table.mp4 (26.58 MB)
013 Disallow TRUNCATE on a table.mp4 (17.99 MB)
014 Creating an audit trigger.mp4 (52.42 MB)
015 Creating conditional triggers.mp4 (47.92 MB)
016 Disallow data change on primary key.mp4 (14.52 MB)
017 Use triggers very cautiously.mp4 (8.9 MB)
018 What is an event trigger.mp4 (4.67 MB)
019 Event triggers usage scenarios.mp4 (8.85 MB)
020 Creating event triggers.mp4 (12.44 MB)
021 Event trigger events and variables.mp4 (11.96 MB)
022 Creating an audit event trigger.mp4 (46.32 MB)
023 Prevent schema changes.mp4 (22.95 MB)
024 Dropping a trigger.mp4 (2.45 MB)
001 Understanding row by row operations.mp4 (25.58 MB)
002 Cursors and procedural languages.mp4 (13.7 MB)
003 Steps to create a cursor.mp4 (8.18 MB)
004 Creating a cursor.mp4 (21.83 MB)
005 Opening a cursor.mp4 (26.31 MB)
006 Using a cursor.mp4 (22.87 MB)
007 Updating data.mp4 (4.72 MB)
008 Closing a cursor.mp4 (3.65 MB)
009 Creating a PLPGSQL Cursor.mp4 (28.63 MB)
010 Using a parametric cursor via function.mp4 (56.65 MB)
001 What is a crosstab report.mp4 (30.09 MB)
002 Installing the tablefunc extension.mp4 (4.81 MB)
003 Creating a crosstab report - Student Rankings.mp4 (38.38 MB)
004 Orders matters in crosstab reports.mp4 (7.82 MB)
005 Pivoting with Rainfalls data.mp4 (28.67 MB)
006 Pivoting rows and columns.mp4 (13.33 MB)
007 Matrix report via a query.mp4 (26.11 MB)
008 Aggregate over filter.mp4 (31.89 MB)
009 Static to dynamic pivots.mp4 (17.68 MB)
010 Dynamic pivot query via JSON.mp4 (24.55 MB)
011 Dynamic pivot table columns.mp4 (55.62 MB)
012 Interactive client-side pivot.mp4 (41.91 MB)
013 Handling missing values.mp4 (37.79 MB)
001 Global Character Set Support.mp4 (35.16 MB)
002 Client and Server Encoding.mp4 (36.19 MB)
001 What is a transaction.mp4 (23.33 MB)
002 How SQL protect database during transaction.mp4 (13.91 MB)
003 ACID Database.mp4 (23.27 MB)
004 Transaction setup.mp4 (6.08 MB)
005 Transaction analysis.mp4 (34.89 MB)
006 How to fix aborted transaction.mp4 (9.42 MB)
007 How to fix transactions on crash.mp4 (19.63 MB)
008 Partial transaction rollback with savepoints.mp4 (9.41 MB)
009 Using SAVEPOINT with transaction.mp4 (14.5 MB)
001 Using Northwind database.mp4 (2.63 MB)
002 Orders shipping to USA or France.mp4 (5.66 MB)
003 Total numbers of orders shipped to USA or France.mp4 (5.74 MB)
004 Orders shipped to latin america.mp4 (10.61 MB)
005 Show total order amount for each order.mp4 (11.85 MB)
006 First the oldest and latest order date.mp4 (5.42 MB)
007 Total products in each categories.mp4 (9.47 MB)
008 List products that needs re-ordering.mp4 (8.67 MB)
009 Freight analysis.mp4 (30.25 MB)
010 Customers with no orders.mp4 (14.26 MB)
011 Top customers with total orders amount.mp4 (14.18 MB)
012 Orders with many lines of ordered items.mp4 (6.77 MB)
013 Orders with double entry line items.mp4 (24.58 MB)
014 Late shipped orders by employees.mp4 (27.05 MB)
015 Countries with customers or suppliers.mp4 (6.62 MB)
016 Countries with customers or suppliers - Using CTE.mp4 (15.01 MB)
017 Customers with multiple orders.mp4 (21.59 MB)
018 First order from each country.mp4 (23.86 MB)
001 Human Resources Database Structure.mp4 (17.03 MB)
002 Quick overview of all tables.mp4 (13.24 MB)
003 Quick overview of all tables Part 2.mp4 (8.84 MB)
004 Get highest, lowest, total, and average salaries of employees.mp4 (9.54 MB)
005 Difference bw highest and lowest salaries by job id.mp4 (3.4 MB)
006 Get lowest paid salaries by each manager.mp4 (5.39 MB)
007 Average salary for each department with more than 10 employees.mp4 (6.3 MB)
008 Average salary for each post excluding programmer.mp4 (4.86 MB)
009 Maximum salary for each post where salary is at or above $5000.mp4 (5.92 MB)
010 Using an alias name with columns.mp4 (4.37 MB)
011 Compute 15% of salary for all employees.mp4 (7.77 MB)
012 To list all employees IDs within each job id group.mp4 (3.29 MB)
013 Discard characters from employees email address.mp4 (19.43 MB)
014 List all employees with first name starts with letters A, C or M.mp4 (7.95 MB)
015 String manipulation with upper, lower and initcap functions.mp4 (4.74 MB)
016 Using SUBSTRING to get portion of string data.mp4 (1.87 MB)
017 Get unique designations in employees table.mp4 (5.52 MB)
018 Select employees with particular department id only.mp4 (5.71 MB)
019 Select employees not in range.mp4 (8.78 MB)
020 Find Letter C in last name at 3rd or greater position.mp4 (6.41 MB)
021 Update phone number with your strings.mp4 (7.23 MB)
022 Get the monthly salary of each employees.mp4 (5.66 MB)
023 Calculate average salary with total number of employees.mp4 (4.4 MB)
024 find employees whose names contains exactly six characters.mp4 (5.7 MB)
002 Select first or last records in a table.mp4 (14.99 MB)
003 Get first or last record per each group.mp4 (12.91 MB)
004 How to calculate cube root in PostgreSQL.mp4 (4.53 MB)
001 Security concepts and and levels.mp4 (7.78 MB)
002 Instance Level Security.mp4 (14.19 MB)
003 Instance Level Security - Add users to roles.mp4 (11.19 MB)
004 Use pgAdmin to create roles.mp4 (9.09 MB)
005 Database Level Security.mp4 (14.22 MB)
006 Schema Level Security.mp4 (29.49 MB)
007 Table Level Security.mp4 (42.39 MB)
008 Column Level Security.mp4 (21.64 MB)
009 Row Level Security.mp4 (93.46 MB)
010 Using CURRENT USER with RLS.mp4 (15.8 MB)
011 Row level policy for application users.mp4 (13.85 MB)
012 DROP a policy.mp4 (6.19 MB)
013 Inspecting permissions.mp4 (13.36 MB)
014 Row Level Security Performance.mp4 (12.07 MB)
015 Encrypted data in columns.mp4 (40.13 MB)
001 Connect to local or remote database.mp4 (9.6 MB)
002 Switch connection to a new database.mp4 (4.04 MB)
003 List all databases and tables.mp4 (8.63 MB)
004 List all table space, schemas, and indices.mp4 (8.56 MB)
005 List all sequences, roles, data types, domain data types.mp4 (46.53 MB)
006 Describe a table.mp4 (2.4 MB)
007 Edit SQL commands in editor.mp4 (3.02 MB)
008 Display command history, run commands from a file.mp4 (7.4 MB)
009 Built-in syntax reference for commands.mp4 (2.66 MB)
010 Represent NULL values on psql terminal.mp4 (9.71 MB)
011 Make table layout funkey!.mp4 (7.16 MB)
012 Repeatedly Execute a Query.mp4 (5.66 MB)
013 Represent NULL Visibly.mp4 (9.7 MB)
014 Turn on query execution time.mp4 (9.87 MB)
001 List database users, and database sizes with and without indexes.mp4 (11.06 MB)
002 List all database and schemas.mp4 (24.44 MB)
003 List all tables and views.mp4 (24.31 MB)
004 List all columns from a table.mp4 (7.33 MB)
005 View system metadata via system information functions.mp4 (6.72 MB)
006 View privileges information across tables.mp4 (29.24 MB)
007 internal-view-system-administration-functions.mp4 (89.29 MB)
007 Using system Administration functions.mp4 (17.06 MB)
008 Show all running queries.mp4 (13.42 MB)
009 Terminate running and IDLE process.mp4 (7.47 MB)
010 How to check live and dead rows in tables.mp4 (4.4 MB)
011 File layout of PostgreSQL Tables.mp4 (43.31 MB)
001 Using SELECT INTO to create a new table with joins.mp4 (46.74 MB)
002 Duplicate a table with or without data.mp4 (8.31 MB)
003 Import data from CSV files.mp4 (25.39 MB)
004 Export Data to CSV files.mp4 (16.96 MB)
005 Deleting duplicate records.mp4 (19.2 MB)
009 Database operations and table size.mp4 (16.58 MB)
010 Tracking table size.mp4 (19.64 MB)
011 PostgreSQL autovacuum proces.mp4 (35.77 MB)
012 Recovering unused space with VACUUM.mp4 (35.56 MB)
013 Generated Columns.mp4 (34.11 MB)
001 Create a custom index method.mp4 (73.97 MB)
002 Create a user-defined aggregate function.mp4 (28.93 MB)
004 Thank You!.mp4 (1.64 MB)]
Screenshot
![[Image: signature.png]](https://softwarez.info/images/avsg/signature.png)
