Introduction to PostgreSQL
Introduction to PostgreSQL
The training programme “Introduction to PostgreSQL” of the Centre for Training and Lifelong Learning (KEDIVIM) of the University of the Aegean offers comprehensive theoretical and practical training in relational database management, focusing on the open-source PostgreSQL system and the SQL language.
Through a systematic approach, participants become familiar with installing and configuring PostgreSQL, creating and managing databases, retrieving and processing information, and running complex SQL queries.
The programme covers basic and advanced techniques, such as joining multiple tables, grouping data, using subqueries, safely modifying records and managing database structure. It also presents basic methods for monitoring and optimising performance.
Training is delivered entirely online, with asynchronous attendance, through a digital learning platform. The course material includes theory units, SQL examples, video presentations and lab exercises that reinforce the practical application of knowledge.
Particular emphasis is placed on using databases in scientific and professional settings, including geospatial data applications and integration with GIS environments such as PostGIS.
The programme is also suitable for beginners, as training starts from the basic concepts and gradually progresses to more complex data management operations.
Also in this category: IT Certification · SQL Database Courses
On completing the programme, participants will be able to:
- Understand the role of PostgreSQL in modern data management systems and use the basic terminology.
- Install and configure PostgreSQL on Windows, macOS and Linux.
- Connect to and manage databases using the psql and pgAdmin tools.
- Write and run SELECT queries to retrieve, sort and display data.
- Apply conditions to filter and limit results with the appropriate SQL commands.
- Combine data from multiple tables using different types of JOIN.
- Perform grouping, aggregate analyses and complex searches with GROUP BY, HAVING, CTEs and other SQL techniques.
- Use subqueries and advanced operators to search and process data effectively.
- Safely modify data with INSERT, UPDATE, DELETE, UPSERT, MERGE and transactions.
- Manage the structure of relational databases, applying DDL commands, suitable data types, integrity constraints and basic performance-tuning techniques.
Practical SQL skills
Become familiar with basic and advanced SQL commands to search, organise, process and manage data effectively.
Learn PostgreSQL from scratch
Step-by-step training, from installation and basic operations to handling complex queries and database structures.
Linking theory and practice
Consolidate your knowledge through lab examples, SQL exercises and data management applications.
Flexible distance learning
Asynchronous attendance through a digital platform, with access to the course material throughout the programme.
Use in scientific and professional settings
Develop knowledge you can apply to academic, research and professional work, including geospatial data management.
Understanding safe data management
Learn techniques for modifying data correctly, managing transactions and maintaining database integrity.
The aim of the programme is to provide practical, applicable skills in relational data management with PostgreSQL and the SQL language.
Learners are expected to become able to retrieve, filter, combine, group, modify and organise data safely and consistently.
The programme also aims to link theoretical knowledge with practical application through lab examples and SQL exercises, so that participants can use their knowledge in academic, research and professional settings.
The programme is aimed at:
- Students and graduates who want practical knowledge of relational database management and the SQL language.
- Professionals who need PostgreSQL skills to manage, organise and process data.
- Researchers and academics who want to use databases for scientific and research applications.
- PostgreSQL beginners who want to start from the basic concepts and gradually move on to more advanced techniques.
Entry requirements
A secondary school-leaving certificate is required.
Basic computer skills, file management and an understanding of English technical terminology are desirable. Previous database experience is not required.
To attend, you need a computer, an internet connection and knowledge of the Greek language.
The programme includes one teaching module, with 8 sessions and a total of 56 hours of training.
The course material is organised into 16 chapters (0–15), progressing gradually from the basic concepts to the more advanced features of PostgreSQL.
Teaching module: Introduction to PostgreSQL
The programme covers:
- Introduction to relational databases: Basic concepts, data structures, tables, relationships and integrity constraints.
- Installing and configuring PostgreSQL: Setting up the environment on Windows, macOS and Linux and using the psql and pgAdmin tools.
- Basic SQL commands: Retrieving, displaying and sorting data with SELECT.
- Filtering data: Using WHERE, AND/OR, IN, BETWEEN, LIKE, IS NULL and limiting results.
- Joining tables: Building complex queries with INNER, LEFT, RIGHT, FULL, CROSS, SELF and NATURAL JOIN.
- Grouping and analysing data: Using GROUP BY, HAVING, GROUPING SETS, CUBE, ROLLUP, CTEs and recursive queries.
- Complex queries: Subqueries, correlated subqueries and the use of ANY, ALL and EXISTS.
- Managing and modifying data: Using INSERT, UPDATE, DELETE, UPSERT, MERGE and transactions.
- Database structure and organisation: DDL commands, data types and constraints.
- Basic performance optimisation: Using analysis tools such as EXPLAIN.
The learning process is supported by theory material, detailed SQL examples and lab exercises for each chapter.
Participants receive:
- Access to a digital asynchronous learning platform to follow the programme.
- Electronic notes and presentations on databases, PostgreSQL and the SQL language.
- Study guides on installing, configuring and using PostgreSQL.
- Detailed SQL examples for creating, searching, modifying and managing data.
- Video presentations and multimedia material to help understand the key concepts.
- Lab exercises and practical examples to consolidate knowledge.
- Application examples in scientific and professional settings, including GIS and PostGIS applications.
- Supplementary digital and bibliographic material for further study.
- Certificate of Training, upon successful completion of the programme.
Requirements for successful completion
Successful completion requires submission of all compulsory activities and an overall score of at least 50/100.
Assessment is based on lab activities and SQL exercises, judged on the correctness of the commands, the appropriate choice of techniques, the documentation of solutions, safe data handling and sound database design.
Methodology
Expression of Interest Form
Completing and sending this form to the Employment Development Institute does not create any obligation or commitment to cooperation.