PostgreSQL

PostgreSQL is an open source relational database management system. It supports the storage, organisation and querying of information through SQL, together with mechanisms for control and data consistency. It is the name of a software project rather than a single commercial publisher, and it is used in a wide range of application environments.

Developers and database administrators can explore schema design, queries, transactions and operations according to their responsibilities. A useful progression connects data models with application requirements and then with performance, access rights and backup considerations. The aim is reliable data management, which requires testing changes and understanding the consequences of queries and configuration decisions. Course selection should identify the expected level and distinguish development objectives from administration tasks, while practical exercises should make data integrity and recoverability part of the discussion.

Training related to PostgreSQL