PostgreSQL for Developers Workshop

Training objectives

• Understand users, roles  schemas and relations
• Grant and revoke permissions
• Understand referential integrity (constraints, foreign keys, primary keys)
• Get data into and out of PostgreSQL
• Understand triggers
• Work with JSON in the database
• Implement full text search with PostgreSQL

Topics

• Why developers need to understand the database
• Defining the requirements for the sample application
• Using a graphical user interface
• Making your database secure “instead of Roles and access permissions”
• Selecting the correct data types
• Generating data for testing
• Using identity columns
• Encrypting and decrypting data
• Correctly implementing constraints and triggers
• Using the power of default permissions
• Implementing row level security
• Transactional DDL
• Table partitioning
• How to use the database for handling JSON data
• Doing full text search with PostgreSQL

Method

• Presentation with numerous exercises, case studies, and live demos
• Discussions and networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

• Developers who want to start working with PostgreSQL
• Developers already working on PostgreSQL who want to strengthen their database skills
• Database administrators (DBA) who want to learn more from a development perspective

Language & documentation

• The workshop will be held in English in Lausanne and Geneva and in German in Basel, Zurich and Bern.
• Documentation: content details, scripts, case study solutions as PDF file (in English)

Equipment

• On-site training: As this training is provided on a Cloud platform, participants must be equipped with a laptop in order to access the Cloud infrastructure through an ssh client.

For your information

• IT performance management : review and tuning
• Testimonials : what customers are saying about dbi services
• Our expertise in database management