PostgreSQL 9 Database Administration
The 2 day class covers the tasks that a database administrator faces daily, starting from basic operations to advanced techniques. Course notes use PgAdmin as graphical administration tool.
Targets
- Software development
- Systems administration
Topics
- Connecting & Troubleshooting
- PgAdmin III Overview
- Server Configuration
- Database Administration
- User Administration
- Understanding Database Object Types
- Permissions & Security
- Running SQL
- Monitoring
- MVCC and VACUUM
- Maintenance
- Data Migration & Test Environments
- Server Logs
- Help & Support
Requirements
- SQL basics
- Basics of databases
Course acquired skills
- Basics of PostgreSQL database administration
- PostgreSQL basics
