Objectives

  • Why developers need to understand databases
  • Understand users, roles, schemas and relationships
  • Grant and revoke permissions
  • Understand referential integrity (constraints, foreign keys, primary keys)
  • Enter data into and out of PostgreSQL
  • Understand triggers
  • Work with JSON in databases.
  • Implement full text search with PostgreSQL
  • Secure your database
  • Learn how to use the right data types
  • Encrypt and decrypt data
  • Understand table partitioning

Method

  • Presentations, practical exercises, case studies and question-oriented demonstrations
  • Discussion and networking during breaks and lunch (included)

Target groups

  • This PostgreSQL Training for Developers course is designed for developers who want to start working with PostgreSQL, developers already working on PostgreSQL who want to strengthen their database skills, and database administrators (DBAs) who want to learn more about development.

Prerequisites

  • Be able to navigate on Linux shell
  • Have knowledge of databases
  • Have basic knowledge of SQL and procedural languages

5% discount for SOUG, SwissPUG and DOAG members.

Trainers

Thumbnail [150x150]

Joan Frey

Consultant

Thumbnail [150x150]

Daniel Burgert

Consultant