Learn everything about Postgres, the best open source DBMS in the world! Practical and updated course v2025!

What you'll learn

Know and learn more about the PostgreSQL database
Using pgAdmin
Database administration
Backup and Restore

Requirements

Solid knowledge of Linux Ubuntu or RHEL/Rocky Linux
Knowledge of Python and SQL and programming logic is desirable.

Description

Launched in 1996, PostgreSQL is an open-source DBMS maintained by the "PostgreSQL Global Development Group".As it is open-source and completely free, PostgreSQL is widely used in companies around the world.It is recommended that anyone who wants to invest in creating small to large systems use and apply the PostgreSQL database.Some of the main features are:Foreign keys;More complex searches;Robust and high-quality software with maintainable and well-commented codeMultiversion concurrency management;Transactional integrity;Performance, security and high availabilityHigh accessibility;Support for the hybrid object-relational model.Views;Triggers;Text indexing;Structured programming language in different languages ​​for stored procedures, such as pgSQL, Python, Java, Perl, C, etc.; PostGIS data storage system, for Geographic Information System.And it can be expanded by any user, gaining new tools such as: procedural languages, data types; functions; operators; aggregation functions; index methods, among others.Because of its less restrictive license, this DBMS can be used, modified and distributed by any company and for any purpose (commercial, academic, personal) without having to pay any type of license or any other remuneration.What surprises many people is that the PostgreSQL feature set is more comparable to that of Oracle Database or SQL Server than to MySQL or MariaDB itself.The only connection between MySQL/MariaDB and PostgreSQL is that these two projects are open source;In addition, the characteristics and philosophies of use are almost completely different.In the early days, when PostgreSQL was still a research database, the focus was exclusively on new features.But over the past few years, huge amounts of code have been rewritten and improved, and extensions have been provided to database administrators, more stable server software, and high availability for commercial use.Music by: Symbolism Electro-Light

Who this course is for

Students who wanted to know more about PostgreSQL database
DBAs who want to know more about Postgres and its functions
Homepage:

https://www.udemy.com/course/postgresql-course/