Kaarel is an IT professional with 15 years of industry experience in various roles, working with complex high-scale solutions, recently focusing on the open source PostgreSQL DBMS.
PostgreSQL for Developers — a Crash Course
This workshop will cover full range of topics to bootstrap, run and do development with the PostgreSQL database engine. Main focus point will be on the supported developer features but also touched will be the general architecture of the database engine and performance aspects. The workshop will not involve practical exercises from the attendees but it will be held in a discussional format.
Part 1: PostgreSQL basics
- Introduction to the PostgreSQL project
- Basic management operations
- Connecting and executing queries
Part 2: Engine internals overview
- Architecture overview
- Transaction models
- The extensibility model
- Most important configuration settings
Part 3: Developer features
- Data types and limitations
- Advanced SQL features
- Stored procedures and triggers
Part 4: Performance
- Finding and understanding slow queries
Part 5: Intro to advanced topics
- Scaling / Partitioning
- Advanced architectures
Main objective is to get even absolute beginners up-to-date with how to do applications development with PostgreSQL and to give an overview of supported features and expected behaviour.
No knowledge of PostgreSQL is assumed, only generally on databases and some SQL knowledge will do also good.