Classroom Training in Bangalore - attend training on site at a convenient location
About the course: This open enrollment class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices.
Comprehensive PostgreSQL Administration teaches the essential skills required by PostgreSQL DBAs to be successful. This course will present the PostgreSQL database architecture and core administrative tasks including configuration, maintenance, monitoring, backups, recovery, and moving data.
Advanced topics are also covered including: replication to safeguard data, clustering for high availability, partitioning for performance and maintainability, and security for privacy and protection.
Upon course completion, you will be prepared to manage large, highly available databases and their security requirements with confidence.
- PostgreSQL System Architecture
- Creating and Managing Databases
- Introduction to PSQL
- pgAdmin III
- Security Basics
- SQL Primer
- Backup and Recovery
- Point-in Time Recovery
- Routine Maintenance
- Postgres Data Dictionary
- Moving Data
- Transactions and Concurrency
- Performance Tuning
- Table Partitioning
- High Availability & Replication
- Extension Modules
Pre-requisites: Basic experience in database administration. No prior knowledge of PostgreSQL is required.
Certification: Includes one complimentary attempt at the PostgreSQL Associate Certification exam
- Hands-on lab exercises
- Printed course materials
- Food and beverages will also be provided
We encourage you to bring your laptop with the most current version of PostgreSQL installed
Location: 55A, Hosur Main Rd, Electronics City Phase 1, Electronics City, Bangalore, Karnataka
Price: INR 38000 + tax (as applicable)
Special Group Discounts are Available for this class
Please contact us or call for discount information and to learn more!