Audience
Developers or Database Administrators who will be working with PostgreSQL.
Description
This Introduction to PostgreSQL for Developers and Administrators training class provides an introduction to the PostgreSQL database. The course targets both administrators and developers.
Objectives
Upon successful completion of this course, the student will be able to:
- Understand the history of PostgreSQL.
- Know where to find PostgreSQL documentation and resources.
- Understand PostgreSQL Server Architecture.
- Work with PostgreSQL functions.
- Create your own functions.
- Program with plpgsql.
- Install and setup PostgreSQL securely.
- Perform basic administration tasks such as user creation, cataloging and backing up.
- Understand SLONY and PGPOOL.
- Understand inheritance in PostgreSQL.
- Partition tables.
- Use tablespaces.
- Perform database monitoring.
- Understand the EXPLAIN Statement
- Understand PITR
- Tune the Postgresql Server
Prerequisites
A basic knowledge of relational databases and SQL.