Course Summary
PostgreSQL Administration class is designed for DBAs and developers who are looking to install, administer, and use this powerful database system.Duration
2 days.
Objectives
This class covers the basics of installing, managing, administering PostgreSQL database system.
Audience
This course is for anyone who is tasked with administering a PostgreSQL database.
Students attending this course should be familiar with SQL and feel comfortable working in a Linux/UNIX -type environment.
Instructors
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
