PostgreSQL – SQL Basics (PGSQL1)

Databases, PostgreSQL

This course introduces core PostgreSQL skills through hands-on practice of SQL queries, data types, table modification and JOIN strategies. You will learn to write, filter and combine data safely and efficiently for everyday database work.

It emphasizes hands-on labs for transactions, referential integrity, import/export and data scripting. Exercises cover rollback, constraints and test-data generation so you can apply these skills immediately on real projects.

Location, current course term



Praha + online (volitelně)
12/8/2025 - 12/9/2025 CZECH
Order 		3/2/2026 - 3/3/2026 CZECH
Order 		5/25/2026 - 5/26/2026 CZECH
Order
Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Relational database systems
    1. Characteristics of relational databases
    2. PostgreSQL and other RDBMS
    3. Connecting to a database and first commands
  • Data types and tables
    1. Numeric and text data types
    2. Tables, sequences and keys
    3. Modifying tables and columns
  • Querying in SQL
    1. SELECT, filtering, sorting and calculations
    2. Joining tables (JOIN, Cartesian product)
    3. Aggregation and grouping
  • Integrity and database design
    1. Primary and foreign keys
    2. Referential integrity
    3. Normalization and schema design
  • Transactions
    1. Starting and ending a transaction
    2. Rollback and cascading actions
  • Practical work with SQL
    1. Scripting and data export/import
    2. Generating test data
Assumed knowledge:
Basic computer skills; familiarity with database concepts is an advantage.
Recommended subsequent course:
PostgreSQL – Programming in PL/pgSQL and Advanced Development Techniques (PGSQL2)
Schedule:
2 days (9:00 AM - 5:00 PM )
Course price:
436.00 € ( 527.56 € incl. 21% VAT)
Language: