PostgreSQL Training Course
Customized On-site Training
Request a Quote
or call
1 (888) 357-1204
(2 days)
PostgreSQL Training Summary
PostgreSQL Administration class is designed for DBAs and developers who are looking to install, administer, and use this powerful database system.
PostgreSQL Training Objectives
This class covers the basics of installing, managing, administering PostgreSQL database system.
Audience for PostgreSQL Training
This course is for anyone who is tasked with administering a PostgreSQL database.
PostgreSQL Training Prerequisites
Students attending this course should be familiar with SQL and feel comfortable working in a Linux/UNIX -type environment.
PostgreSQL Training Outline
PostgreSQL presentation
- Concepts
- Installation
- Create a database
- Connection to PostgreSQL and SQL introduction
- Tables management
- Data types
- Postgres SQL language
- Configuration
Programming with PostgreSQL
- Server side
- Client side
PostgreSQL Administration
- Authentication systems, privileges and security
- Users management
- Backup and restore
- Administration tools
Log files
Optimization
Replication
Add-ons (XSLT, PostGIS, etc...)