Opleiding: PostgreSQL fundamentals course

This course presents a description of PostgreSQL: what it is, what it is intended for, and how it can be used.

The participant will learn

• the structure of recent versions of the PostgreSQL database software;
• the use of some popular "client" tools: command line interface, graphical interface, admin interface;
• the objects for data storage and data manipulation;
• creating databases, tables, and users;
• preparing a database for use, especially authorisations and indexes.

Attention is also paid to the use in the context of a web server, to the relation of PostgreSQL to other RDBMS, and to specific topics like models for data storage, integrity, authorisations, and performance.

Moreover, this training will explain how to install the system and use it in practice. After completion, the participants will not only have the necessary theoretical background of PostgreSQL as RDBMS, but also will have had sufficient practical training to start working with it in an independent way.

Together with SQL and relational databases fundamentals this course forms a well-balanced whole, in such a way that after successful conclusion, the participants will have a 'complete overview' of PostgreSQL as a relational database system.