DevDays Europe 2020

date

May 5-7

venue

Vilnius

Biography

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.

Workshop

PostgreSQL for Developers – a Crash Course

Time & Date

9:00, 5 May

Venue

Crowne Plaza Vilnius –
M. K. Čiurlionio str. 84, Vilnius, Lithuania

Language

English

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.

Agenda

Part 1: PostgreSQL basics

  • Introduction to the PostgreSQL project
  • Installation
  • 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
  • Security
  • Advanced SQL features
  • Stored procedures and triggers

Part 4: Performance

  • Finding and understanding slow queries
  • Indexing

Part 5: Intro to advanced topics

  • Scaling / Partitioning
  • Advanced architectures

Objectives

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.

Target audience

No knowledge of PostgreSQL is assumed, only generally on databases and some SQL knowledge will do also good.

Technical requirements

None.

« Back