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
- Basics of programming
- Basics of systems administration
- Basics of PostgreSQL database administration
Topics
- 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
Acquired Skills
- 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.)
As a subscription-based service, Developer Support is designed specifically to help application developers with their PostgreSQL database. This service offers direct support from experts for questions related to installation, usage, configuration, and management of PostgreSQL for projects that are not in production.
Upcoming Training Courses
Trainings in Prato / Milano / Roma, Italy
On hold until further notice due to COVID-19
Additional information
- The course will be confirmed when three students are enrolled for the Prato office, while for the Milan and Rome offices the course will be confirmed when 4 students are enrolled.
- The registration fee includes: didactic material, 2 coffee breaks per day and lunch.
- Each participant must have a personal laptop.
Tags: Database Administration, Database Development, Software development, Systems Architecture, PostgreSQL
Length: 3.00 days