Trainings

As Postgresql & PHP expert, PragmaFabrik is pleased to share her knowledge

Pomm

Guided by a practical example, we will go through Postgresql's rich type set, complex SQL queries and how to use them in an object oriented PHP model layer.

Advanced Postgresql use through Pomm (2 days)

First steps with Postgresql
Connect with the command line
PSQL : survival guide
Configure PSQL
Structures and bases
Schémas and search_path
Tables and sequences
uuid extension
First steps with Pomm
Database introspection
Entities structure
First queries
Model layer
Organize queries
Dynamic queries
Projection operators
Collections and entities
Results iterators
Use of entities in the view
Augmented entities
Complex structures
Arrays
Geometric types
Time types
JSON, HStore &s; converters
Modifications
Entity creation
Modification
Deletion
SQL queries
Query building
Virtual fields
Joins
Set alteration
Values and generators
Aggregates
Window functions
Common Table Expression (CTE)
Simple queries
Recursive queries
Writable CTE
Objects in SQL
Composite types
Converters