Do you want to start developing an application on PostgreSQL, or do you already develop on PostgreSQL and want to avoid common errors? Be sure not to miss out on our PostgreSQL training for developers. At the end of the course, you will understand what PostgreSQL can do for you from a development perspective. Topics range from basic concepts such as data types and permissions to more advanced topics such as PL/pgSQL, partitioning and working with JSON.
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.
