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)
- Graphical tool courtesy of DB Visualizer
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)
For your information
- IT performance management : review and tuning
- Testimonials : what customers are saying about dbi services
- Our expertise in database management