Introduction to PostgreSQL
Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
This training can also be held at your location, or as online training specifically tailored for your company. In this case, the course agenda can also be adapted to best suit your needs.Learn more about our customized training >>
This course takes 3 days – 8 hours per day (on site) or 5 hours per day (online).
The only difference is that there will be less practical exercises in an online course. However, we can share them with you so you can do them on your own. You can ask our consultants for feedback or help, if needed.
This workshop has been designed for people who want to get familiar with SQL and PostgreSQL. You will learn how to use PostgreSQL and how to write proper SQL statements. We start with basic topics like normalization, foreign keys and work our way step by step to topics like joins, subselects, analytics and co. The aim is to teach the participants SQL needed for working with PostgreSQL using practical examples and thus give them the tools for their daily work.
This course can be held in English, German, Spanish, Polish, Estonian, Ukrainian and Russian.
- Connection to the database
- Usage of pgAdmin4 and similar tools
Relational data models
- Creating tables and using data types
- Primary Keys and Foreign Keys
- Check constraints
Basic SQL commands
- INSERT: Insert data
- SELECT: Simple queries
- UPDATE: Modify data
- DELETE and SELECT: Delete data
- Filter data
- NULL Handling
- Sort data with ORDER BY
- LIKE queries
- UNION ALL, UNION, EXCEPT
- DISTINCT and DISTINCT ON
- LIMIT and OFFSET
- Aggregate data (count, sum, etc.)
- Minimum and maximum values
- Group data (GROUP BY … HAVING …)
- Use ordered sets (WITHIN GROUP …)
Subqueries and CTEs
- Nested queries
- Common Table Expressions (CTEs)
- Use IN and NOT IN
- EXISTS and NOT EXISTS
- Understand inner joins
- Use outer joins
- Semi joins, anti joins
- Calculating with date and time
- Understanding intervals
- Include range types
Windowing and Analytics
- Define sliding windows
- Important analytical functions (rank, lag, etc.)
- Time series analysis
Views and materialized views
- Basic views
- Dependency handling
- Using materialized views
- BEGIN, ROLLBACK
- Row locking and table locking
- Transaction isolation levels (read committed, etc)
- SELECT … FOR UPDATE
- Declare cursor
- WITH HOLD cursor
- Creating and deleting indexes
- Identify missing indexes
- Avoiding unnecessary indexes
Other courses that might interest you
GIS ESSENTIALS – „GETTING SPATIALLY ENABLED“
PostgreSQL High Availability & Patroni Cluster Manager
PostgreSQL in Kubernetes
Machine Learning for decision makers
Introduction to Machine Learning
Introduction to PostGIS
PostgreSQL Administration and Performance Tuning
PostgreSQL for business intelligence and big data analysis
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.