14.28 GB | 36min 55s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
1 -Introduction to PostgreSQL.mp4 (46.69 MB)
1 -11 - Data types.zip (9.74 KB)
1 -NUMERIC.mp4 (53.01 MB)
10 -JSON.mp4 (148.43 MB)
11 -hstore.mp4 (95.51 MB)
12 -Working with Matrices.mp4 (43.88 MB)
13 -Working with Range Types.mp4 (72.86 MB)
14 -Jsonb.mp4 (26.93 MB)
15 -Indexes for Jsonb.mp4 (91.01 MB)
16 -CREATE DOMAIN and TYPE.mp4 (76.83 MB)
17 -XML.mp4 (77.47 MB)
2 -CHAR, VARCHAR and TEXT.mp4 (48.84 MB)
3 -Boolean.mp4 (39.88 MB)
4 -Date.mp4 (89.7 MB)
5 -Timestamp.mp4 (54.14 MB)
6 -Interval.mp4 (69.55 MB)
7 -TIME.mp4 (37.53 MB)
8 -SERIAL.mp4 (74.63 MB)
9 -UUID.mp4 (53.77 MB)
1 -12 - Functions.zip (3.28 KB)
1 -Introduction to function.mp4 (121.55 MB)
2 -Functions with FOR LOOP.mp4 (139.41 MB)
3 -Raise Notice.mp4 (69.19 MB)
4 -Working with operator classes.mp4 (69.13 MB)
1 -13 - Aggregation functions.zip (2.13 KB)
1 -Introduction to aggregation functions.mp4 (126.41 MB)
2 -AVG.mp4 (70.73 MB)
3 -ARRAY AGG.mp4 (45.98 MB)
4 -COUNT.mp4 (44.8 MB)
5 -SUM.mp4 (63.55 MB)
1 -Introduction to Window Functions.mp4 (79.83 MB)
1 -Window Function.zip (3.17 KB)
2 -RANK Function.mp4 (69.78 MB)
3 -DENSE RANK Function.mp4 (40.39 MB)
4 -ROW NUMBER Function.mp4 (56.17 MB)
5 -CUME DIST Function.mp4 (51.62 MB)
6 -FIRST and LAST VALUE.mp4 (61.84 MB)
1 -Creating a trigger.mp4 (85.99 MB)
2 -ALTER TRIGGER.mp4 (46.15 MB)
3 -Enable-Disable Trigger.mp4 (36.74 MB)
1 -16.zip (5.06 KB)
1 -Remote and secure authentication with SSL.mp4 (52.76 MB)
2 -User Restrictions.mp4 (43.52 MB)
3 -Implementing Row Level Security.mp4 (101.29 MB)
4 -Inspecting permissions.mp4 (61.02 MB)
1 -16.zip (5.5 KB)
1 -Understanding the Backup command.mp4 (59.73 MB)
2 -Restoration methods.mp4 (56.53 MB)
3 -Automated Backup on Linux.mp4 (146.38 MB)
4 -LZ4 and ZSTD Compression.mp4 (51.36 MB)
5 -Backup and Restore with pgBackRest.mp4 (275.07 MB)
6 -Backup and Restore with pgBackRest part2.mp4 (69.72 MB)
1 -16.zip (3.06 KB)
1 -PITR Backup Preparations.mp4 (39.07 MB)
2 -Backing up PITR.mp4 (95.93 MB)
3 -Restoring WAL files.mp4 (143.29 MB)
4 -WAL Replication.mp4 (36.53 MB)
5 -Streaming in asynchronous mode.mp4 (112.5 MB)
6 -Streaming in synchronous mode.mp4 (99.68 MB)
1 -16.zip (2.24 KB)
1 -Barman backup preparations.mp4 (45 MB)
2 -Barman Installation.mp4 (85.95 MB)
3 -Installing Barman - part 2.mp4 (86.25 MB)
4 -Backup with Barman.mp4 (107.26 MB)
5 -Performing the restoration.mp4 (216.73 MB)
1 -17 - Clustering in PostgreSQL with repmgr.zip (3.84 KB)
1 -High availability with repmgr.mp4 (23.39 MB)
2 -First installations and configurations.mp4 (99.2 MB)
3 -Master Server Configuration.mp4 (75.9 MB)
4 -Standby Server Configuration.mp4 (105.24 MB)
5 -Witness Server Configuration.mp4 (76.85 MB)
6 -Changing the Primary Server.mp4 (94.13 MB)
1 -Installing VirtualBox.mp4 (49.48 MB)
2 -Installing Rocky Linux 9.mp4 (108.89 MB)
3 -Using SSH via PowerShell on Windows.mp4 (59.09 MB)
1 -18 - Transactions and blocking.zip (2.95 KB)
1 -Working with Transactions.mp4 (62.29 MB)
2 -Working with SAVEPOINT and DDLs.mp4 (48.04 MB)
3 -Understanding the basics of blocking.mp4 (124.69 MB)
4 -Using FOR SHARE and FOR UPDATE.mp4 (114.42 MB)
5 -Understanding transaction isolation levels.mp4 (77.86 MB)
6 -Studying deadlocks and similar problems.mp4 (48.98 MB)
7 -VACUUM Theory.mp4 (104.45 MB)
8 -Running VACUUM in practice.mp4 (29.79 MB)
1 -19 - Stored procedures.zip (5.49 KB)
1 -Working with PL-pgSQL.mp4 (35.65 MB)
10 -Working with Drop Procedure.mp4 (26.88 MB)
2 -Managing scopes.mp4 (61.55 MB)
3 -Working with Cursor.mp4 (40.44 MB)
4 -Working with composite types.mp4 (10.99 MB)
5 -Working with triggers.mp4 (80.89 MB)
6 -Working with PL-Perl.mp4 (50.53 MB)
7 -Working with SPI.mp4 (47.83 MB)
8 -Working with PL-Python.mp4 (76.25 MB)
9 -Working with PROCEDURE.mp4 (47.88 MB)
1 -17 - Load Balance com HAProxy e PgBouncer.zip (127.22 KB)
1 -Setup Presentation.mp4 (35.44 MB)
2 -HAProxy Settings.mp4 (126.3 MB)
3 -Installing PgBouncer.mp4 (90.45 MB)
1 -23 - Load Balance with HAProxy and Patroni.zip (8.92 KB)
1 -Presentation of the HA scenario.mp4 (41.71 MB)
2 -Initial database configurations.mp4 (69.36 MB)
3 -Configuring the etcd server.mp4 (140.49 MB)
4 -Installing haproxy.mp4 (83.66 MB)
5 -Configuring the patroni server.mp4 (194.53 MB)
6 -Performing failover and recovery tests.mp4 (68.3 MB)
7 -Setting up HA Zabbix.mp4 (188.36 MB)
1 -24 - Advanced SQL Commands.zip (4.99 KB)
1 -Dealing with GROUPING SETS.mp4 (107.19 MB)
2 -Aggregate functions of ordered sets.mp4 (62.89 MB)
3 -Working with Window Functions.mp4 (78.54 MB)
4 -Studying Windows Functions clauses.mp4 (52.31 MB)
5 -Studying the lead() and lag() functions.mp4 (32.23 MB)
6 -Studying the value() and row number() functions.mp4 (35.37 MB)
7 -Creating your own function with CREATE AGGREGATE.mp4 (82.71 MB)
8 -Working with WITH ORDINALITY.mp4 (31.84 MB)
1 -24 - HA com Citus Patroni e HAProxy.zip (6.8 KB)
1 -Introduction to Citus.mp4 (83.14 MB)
2 -Initial database configurations.mp4 (69.79 MB)
3 -Configuring the etcd server.mp4 (156.57 MB)
4 -Configuring the patroni server.mp4 (216.82 MB)
5 -Installing haproxy.mp4 (26.17 MB)
6 -Performing basic performance tests.mp4 (84.78 MB)
1 -25 - Extensions.zip (10.04 KB)
1 -Using the adminpack module.mp4 (67.48 MB)
10 -Accessing a MySQL server with mysql fdw.mp4 (145.34 MB)
11 -Accessing PostgreSQL through LibreOffice.mp4 (108.22 MB)
12 -Using TimescaleDB.mp4 (168.15 MB)
13 -Protecting data with pgcrypto.mp4 (104.78 MB)
2 -Using the bloom module.mp4 (44.6 MB)
3 -Using the btree gist and btree gin extensions.mp4 (14.98 MB)
4 -Searching for files with file fdw.mp4 (28.95 MB)
5 -Inspecting storage using pageinspect.mp4 (33.27 MB)
6 -Checking the Cache with pg buffercache.mp4 (32.14 MB)
7 -Inspecting storage with pgstattuple.mp4 (31.08 MB)
8 -PostgreSQL Anonymizer.mp4 (155.27 MB)
9 -Accessing another PostgreSQL server with postgres fdw.mp4 (139.45 MB)
1 -27 - Monitoring.zip (5.17 KB)
1 -Monitoring PostgreSQL with Zabbix.mp4 (171.9 MB)
2 -Log analysis with pgbadger.mp4 (232.09 MB)
3 -Monitoring with Prometheus and Grafana.mp4 (192.8 MB)
4 -Monitoring with Prometheus and Grafana part 2.mp4 (94.69 MB)
5 -Monitoring PostgreSQL security with Wazuh.mp4 (184.09 MB)
1 -28 - Audit.zip (3.01 KB)
1 -Configure Syslog and journald.mp4 (156.48 MB)
2 -Installing PG-Audit.mp4 (146.31 MB)
3 -Monitoring with Graylog.mp4 (177.13 MB)
1 -Installing PostgreSQL on Rocky Linux.mp4 (103.59 MB)
2 -Installing PostgreSQL on Windows.mp4 (57.72 MB)
3 -Using pgAdmin.mp4 (87.62 MB)
4 -The psql command.mp4 (42.28 MB)
5 -Main psql commands.mp4 (65.73 MB)
6 -PostgreSQL Process Architecture.mp4 (83.84 MB)
1 -comands.zip (4.83 KB)
1 -Configuration Files.mp4 (107.56 MB)
10 -Multiple Postgres instances on the same host.mp4 (95.39 MB)
2 -Managing connections.mp4 (32 MB)
3 -Understanding Roles.mp4 (69.04 MB)
4 -Creating a database.mp4 (32.4 MB)
5 -Using Schemas.mp4 (68.91 MB)
6 -Privileges.mp4 (88.79 MB)
7 -Managing disk storage with Tablespaces.mp4 (44.75 MB)
8 -Using the ALTER SYSTEM command.mp4 (128.1 MB)
9 -Updating PostgreSQL versions.mp4 (122.78 MB)
1 -Tables.mp4 (100.94 MB)
1 -Tables.zip (4.69 KB)
2 -Managing temporary tables and EXISTS.mp4 (41.7 MB)
3 -Unlogged and TYPE OF Tables.mp4 (57.59 MB)
4 -Inserting and selecting data.mp4 (65.6 MB)
5 -NULL Values.mp4 (33.43 MB)
6 -Updating and removing data.mp4 (47.81 MB)
7 -Auto Increment with Serial.mp4 (82.44 MB)
8 -Sequences.mp4 (93.99 MB)
1 -Views.zip (3.59 KB)
1 -Visions.mp4 (90.99 MB)
2 -Drop View.mp4 (57.57 MB)
3 -Updatable Views.mp4 (92.77 MB)
4 -Materialized Views.mp4 (77.74 MB)
5 -Recursive View.mp4 (97.3 MB)
1 -8 - Complex queries.zip (5.89 KB)
1 -Using the LIKE clause.mp4 (35.94 MB)
10 -NULLIF.mp4 (62.13 MB)
2 -Using DISTINCT.mp4 (35.08 MB)
3 -Using limit and offset.mp4 (16.99 MB)
4 -IN-NOT IN and EXISTS-NOT EXISTS subqueries.mp4 (92.54 MB)
5 -JOIN Commands.mp4 (71.78 MB)
6 -LEFT e RIGHT JOIN.mp4 (48.41 MB)
7 -FULL OUTER JOIN.mp4 (55.69 MB)
8 -CASE.mp4 (88 MB)
9 -COALESCE.mp4 (57.49 MB)
1 -Constraints.mp4 (27.35 MB)
1 -Constraints.zip (2.86 KB)
2 -Constraints Check.mp4 (57.6 MB)
3 -UNIQUE Constraints.mp4 (48.99 MB)
4 -PRIMARY KEY Constraints.mp4 (43.91 MB)
5 -FOREIGN KEY Constraints.mp4 (76.2 MB)
6 -GENERATED AS IDENTITY.mp4 (86.47 MB)
1 -10 - Indexes.zip (55.57 KB)
1 -CREATE INDEX.mp4 (74.29 MB)
10 -HypoPG Index.mp4 (97.62 MB)
11 -Table Partitioning.mp4 (21.38 MB)
12 -Interval Partitioning.mp4 (56.86 MB)
13 -Partitioning by lists and hashes.mp4 (71.19 MB)
2 -List and DROP Index.mp4 (73.81 MB)
3 -UNIQUE Index.mp4 (49.62 MB)
4 -Indexes on Expressions.mp4 (55.14 MB)
5 -Partial Index.mp4 (45.26 MB)
6 -Multicolumn Indexes.mp4 (51.81 MB)
7 -Creating a fuzzy search with pg trgm.mp4 (41.8 MB)
8 -Understanding the EXPLAIN command.mp4 (32.88 MB)
9 -EXPLAIN ANALYZE.mp4 (34.4 MB)]
Screenshot