PostgreSQL Course - Basic

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

Better data modeling - You will learn how to design tables, 1:1, 1:n and m:n relationships, and choose data types that keep your database consistent, readable, and easier to expand and report on.

Confident SQL querying - You will practice writing SQL queries with filters, logical operators, and conditions, so you can find the right data faster and reduce mistakes in day-to-day analysis work.

Efficient data joins - You will master joins, subqueries, and CTEs, which will help you build more advanced queries without losing clarity. This makes working with many related tables much easier.

Clearer reporting output - You will learn to use aggregate functions, STRING_AGG, RANK, and DENSE_RANK to prepare summaries, rankings, and reports that support practical business and operational tasks.

Smarter data handling - You will understand NULLIF, CASE, date and time functions, plus ROLLUP and CUBE grouping, so you can calculate results correctly and avoid misleading conclusions from your data.

Safe CRUD operations - You will learn how to run INSERT, UPDATE, and DELETE statements in a controlled way, helping you make changes in the database more efficiently and with less risk of accidental damage.

Clean data import/export - You will explore practical ways to import data from flat files and other databases, then export results for further work, including Excel, making data exchange much smoother.

Faster query performance - You will gain a solid introduction to indexes in PostgreSQL, so you can better spot why queries slow down and prepare your database to handle everyday workloads more efficiently.

Training programme

1. Introduction to the PostgreSQL database management system

database basics,
1:1, 1:n, m:n models and joins,
schemas, database objects,
data types and their impact on modeling and query execution,
logical operators AND, OR, BETWEEN, EXISTS, IN, LIKE, NOT, SOME, ALL,
creating SQL queries.

2. Detailed discussion of creating SQL queries in PostgreSQL

data filtering,
basic functions such as Count and Distinct,
subqueries,
joins,
Common Table Expression (CTE), that is the WITH construct,
built-in functions and procedures,
date and time functions,
aggregate functions MAX, MIN, AVG, COUNT, SUM,
multidimensional grouping:
- Rollup,
- Cube,
grouping with the STRING_AGG() function,
ranking functions RANK() and DENSE_RANK(),
NULLIF and CASE,
IIF, CHOOSE.

3. Discussion of CRUD operations (Create, Read, Update, Delete) in PostgreSQL

INSERT, UPDATE, DELETE.

4. Practical approach to data import and export operations in PostgreSQL

data structure and modeling,
analysis of data from Postgres in Excel,
import of data from flat files or existing relational databases,
built-in data import and export tools.

5. Detailed discussion of indexes in PostgreSQL

overview of indexes.

What are the prerequisites for participating in the training?

Basic computer skills - You should be comfortable using a computer, working with the keyboard, saving files, and launching applications, because the course involves independent work in an SQL environment.

Basic data concepts - You should understand what rows, columns, and tables are, and be able to read simple data sets, because this will make PostgreSQL relational structures much easier to follow.

Logical thinking - You should be able to analyze conditions and relationships, because the course covers filtering, logical operators, table relationships, and different grouping techniques.

Readiness to practice - You should be ready to complete hands-on exercises and test queries on your own, because the training focuses on practical work with creating, changing, and analyzing data.