Enrolment options
Udemy - Complete PostgreSQL course! From Basic to Advanced v2025
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
28
•
Activities:
1
•
Resources:
187
- Announcements
- 1 -Introduction to PostgreSQL
- 1 -Installing VirtualBox
- 2 -Installing Rocky Linux 9
- 3 -Using SSH via PowerShell on Windows
- 1 -Installing PostgreSQL on Rocky Linux
- 2 -Installing PostgreSQL on Windows
- 3 -Using pgAdmin
- 4 -The psql command
- 5 -Main psql commands
- 6 -PostgreSQL Process Architecture
- 1 -Configuration Files
- 2 -Managing connections
- 3 -Understanding Roles
- 4 -Creating a database
- 5 -Using Schemas
- 6 -Privileges
- 7 -Managing disk storage with Tablespaces
- 8 -Using the ALTER SYSTEM command
- 9 -Updating PostgreSQL versions
- 10 -Multiple Postgres instances on the same host
- 1 -Tables
- 2 -Managing temporary tables and EXISTS
- 3 -Unlogged and TYPE OF Tables
- 4 -Inserting and selecting data
- 5 -NULL Values
- 6 -Updating and removing data
- 7 -Auto Increment with Serial
- 8 -Sequences
- 1 -Visions
- 2 -Drop View
- 3 -Updatable Views
- 4 -Materialized Views
- 5 -Recursive View
- 1 -Using the LIKE clause
- 2 -Using DISTINCT
- 3 -Using limit and offset
- 4 -IN-NOT IN and EXISTS-NOT EXISTS subqueries
- 5 -JOIN Commands
- 6 -LEFT e RIGHT JOIN
- 7 -FULL OUTER JOIN
- 8 -CASE
- 9 -COALESCE
- 10 -NULLIF
- 1 -Constraints
- 2 -Constraints Check
- 3 -UNIQUE Constraints
- 4 -PRIMARY KEY Constraints
- 5 -FOREIGN KEY Constraints
- 6 -GENERATED AS IDENTITY
- 1 -CREATE INDEX
- 2 -List and DROP Index
- 3 -UNIQUE Index
- 4 -Indexes on Expressions
- 5 -Partial Index
- 6 -Multicolumn Indexes
- 7 -Creating a fuzzy search with pg_trgm
- 8 -Understanding the EXPLAIN command
- 9 -EXPLAIN ANALYZE
- 10 -HypoPG Index
- 11 -Table Partitioning
- 12 -Interval Partitioning
- 13 -Partitioning by lists and hashes
- 1 -NUMERIC
- 2 -CHAR VARCHAR and TEXT
- 3 -Boolean
- 4 -Date
- 5 -Timestamp
- 6 -Interval
- 7 -TIME
- 8 -SERIAL
- 9 -UUID
- 10 -JSON
- 11 -hstore
- 12 -Working with Matrices
- 13 -Working with Range Types
- 14 -Jsonb
- 15 -Indexes for Jsonb
- 16 -CREATE DOMAIN and TYPE
- 17 -XML
- 1 -Introduction to function
- 2 -Functions with FOR LOOP
- 3 -Raise Notice
- 4 -Working with operator classes
- 1 -Introduction to aggregation functions
- 2 -AVG
- 3 -ARRAY_AGG
- 4 -COUNT
- 5 -SUM
- 1 -Introduction to Window Functions
- 2 -RANK Function
- 3 -DENSE_RANK Function
- 4 -ROW_NUMBER Function
- 5 -CUME_DIST Function
- 6 -FIRST and LAST VALUE
- 1 -Creating a trigger
- 2 -ALTER TRIGGER
- 3 -Enable-Disable Trigger
- 1 -Remote and secure authentication with SSL
- 2 -User Restrictions
- 3 -Implementing Row Level Security
- 4 -Inspecting permissions
- 1 -Understanding the Backup command
- 2 -Restoration methods
- 3 -Automated Backup on Linux
- 4 -LZ4 and ZSTD Compression
- 5 -Backup and Restore with pgBackRest
- 6 -Backup and Restore with pgBackRest part2
- 1 -PITR Backup Preparations
- 2 -Backing up PITR
- 3 -Restoring WAL files
- 4 -WAL Replication
- 5 -Streaming in asynchronous mode
- 6 -Streaming in synchronous mode
- 1 -Barman backup preparations
- 2 -Barman Installation
- 3 -Installing Barman - part 2
- 4 -Backup with Barman
- 5 -Performing the restoration
- 1 -High availability with repmgr
- 2 -First installations and configurations
- 3 -Master Server Configuration
- 4 -Standby Server Configuration
- 5 -Witness Server Configuration
- 6 -Changing the Primary Server
- 1 -Working with Transactions
- 2 -Working with SAVEPOINT and DDLs
- 3 -Understanding the basics of blocking
- 4 -Using FOR SHARE and FOR UPDATE
- 5 -Understanding transaction isolation levels
- 6 -Studying deadlocks and similar problems
- 7 -VACUUM Theory
- 8 -Running VACUUM in practice
- 1 -Working with PL-pgSQL
- 2 -Managing scopes
- 3 -Working with Cursor
- 4 -Working with composite types
- 5 -Working with triggers
- 6 -Working with PL-Perl
- 7 -Working with SPI
- 8 -Working with PL-Python
- 9 -Working with PROCEDURE
- 10 -Working with Drop Procedure
- 1 -Setup Presentation
- 2 -HAProxy Settings
- 3 -Installing PgBouncer
- 1 -Presentation of the HA scenario
- 2 -Initial database configurations
- 3 -Configuring the etcd server
- 4 -Installing haproxy
- 5 -Configuring the patroni server
- 6 -Performing failover and recovery tests
- 7 -Setting up HA Zabbix
- 1 -Dealing with GROUPING SETS
- 2 -Aggregate functions of ordered sets
- 3 -Working with Window Functions
- 4 -Studying Windows Functions clauses
- 5 -Studying the lead and lag functions
- 6 -Studying the _value and row_number functions
- 7 -Creating your own function with CREATE AGGREGATE
- 8 -Working with WITH ORDINALITY
- 1 -Introduction to Citus
- 2 -Initial database configurations
- 3 -Configuring the etcd server
- 4 -Configuring the patroni server
- 5 -Installing haproxy
- 6 -Performing basic performance tests
- 1 -Using the adminpack module
- 2 -Using the bloom module
- 3 -Using the btree_gist and btree_gin extensions
- 4 -Searching for files with file_fdw
- 5 -Inspecting storage using pageinspect
- 6 -Checking the Cache with pg_buffercache
- 7 -Inspecting storage with pgstattuple
- 8 -PostgreSQL Anonymizer
- 9 -Accessing another PostgreSQL server with postgres_fdw
- 10 -Accessing a MySQL server with mysql_fdw
- 11 -Accessing PostgreSQL through LibreOffice
- 12 -Using TimescaleDB
- 13 -Protecting data with pgcrypto
- 1 -Monitoring PostgreSQL with Zabbix
- 2 -Log analysis with pgbadger
- 3 -Monitoring with Prometheus and Grafana
- 4 -Monitoring with Prometheus and Grafana part 2
- 5 -Monitoring PostgreSQL security with Wazuh
- 1 -Configure Syslog and journald
- 2 -Installing PG-Audit
- 3 -Monitoring with Graylog