{"id":6348,"date":"2026-10-13T13:49:02","date_gmt":"2026-10-13T10:49:02","guid":{"rendered":"https:\/\/ianap.gr\/?post_type=product&#038;p=6348"},"modified":"2026-11-15T14:25:11","modified_gmt":"2026-11-15T12:25:11","slug":"introduction-to-postgresql","status":"publish","type":"product","link":"https:\/\/ianap.gr\/en\/product\/introduction-to-postgresql\/","title":{"rendered":"Introduction to PostgreSQL"},"content":{"rendered":"<div class=\"product\"><div class=\"product\"><p>The training programme <strong>\u201cIntroduction to PostgreSQL\u201d<\/strong> of the <strong>Centre for Training and Lifelong Learning (KEDIVIM) of the University of the Aegean<\/strong> offers comprehensive theoretical and practical training in relational database management, focusing on the open-source PostgreSQL system and the SQL language.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>Training is delivered <strong>entirely online, with asynchronous attendance<\/strong>, 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.<\/p>\n<p>Particular emphasis is placed on using databases in scientific and professional settings, including geospatial data applications and integration with GIS environments such as PostGIS.<\/p>\n<p>The programme is also suitable for beginners, as training starts from the basic concepts and gradually progresses to more complex data management operations.<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Gain practical skills in relational database management with the online programme <strong>\u201cIntroduction to PostgreSQL\u201d of KEDIVIM, University of the Aegean<\/strong>.<\/p>\n<p>Learn to use SQL, create and manage databases, run complex queries and apply basic optimisation techniques.<\/p>\n<p><strong>56 hours of asynchronous training<\/strong>, with course material, practical exercises and the option to earn a Certificate of Training upon successful completion.<\/p>\n","protected":false},"featured_media":6052,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[133,132],"product_tag":[],"class_list":["post-6348","product","type-product","status-publish","has-post-thumbnail","product_cat-seminars-form","product_cat-technology-information-technology","first","instock","shipping-taxable","product-type-simple"],"acf":[],"_links":{"self":[{"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/product\/6348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/comments?post=6348"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/media\/6052"}],"wp:attachment":[{"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/media?parent=6348"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/product_brand?post=6348"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/product_cat?post=6348"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/ianap.gr\/en\/wp-json\/wp\/v2\/product_tag?post=6348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}