PostgreSQL for Developers

This class covers important basic and intermediate level details for developers interacting with PostgreSQL. Suitable for developers using Java, PHP, Python, perl, .Net and other client languages.

Prerequisites Topics Acquired skills

- Basics of programming

- Basics of systems administration

- Basics of PostgreSQL database administration

- Basic Development

- psql

- Statement Behavior

- Transaction Management

- Data Loading

- Interface Basics

- Functions and Languages

- PostgreSQL Features

- Triggers

- XML

- JSON

- Window Functions

- More Functions

- Recursive Queries

- Grouping Sets

- Further Aggregates

- PL/pgSQL

- Testing with pgTAP

- Extensions

- Basics of PostgreSQL development logical constructs and operators

- Basics of applications design with PostgreSQL

- Basics of PL/pgSQL

- Techniques of software development with PostgreSQL (debugging, error management, etc.)

Tags: Database Administration, Database Development, Software development, Systems Architecture, PostgreSQL

Code: PGDEVEN
Length: 3.00 days

    

2ndQuadrant Updates


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.

Cookie Settings

2ndQuadrant Updates