Introduction to PostgreSQL 9 Database Administration
The class covers the tasks that a PostgreSQL database administrator faces daily, from basic operations to advanced techniques. Course notes use pgAdmin as a graphical administration tool.
Course Length: 1 day
Who Should Attend:
Database administrators, systems administrators, or developers who are familiar with databases, but not PostgreSQL.
Students must have a working knowledge of SQL and database basics.
Connecting & Troubleshooting
PgAdmin III Overview
Understanding Database Object Types
Permissions & Security
MVCC and VACUUM
Data Migration & Test Environments
- Help & Support
Benefits of Attendance:
Upon completion of this course, students will be able to:
Start and stop a PostgreSQL server
Change the configuration of the database
Create users and restrict what they are able to do
Execute SQL queries on the server
Monitor database activity and statistics
Understand what background maintenance the database does automatically
Setup a test environment with sample data
Look for problems in the server's log files
Find the free and commercial resources for PostgreSQL issues