EnterpriseDB’s Postgres courses are designed to meet the needs of
database administrators and application developers of all levels.
Courses are suitable for both the community edition of PostgreSQL and EnterpriseDB’s Postgres Plus Advanced Server.
Certified PostgreSQL Admin
Foundations of Postgres Administration
- Duration: 3 days
- Price: 2000 EUR (VAT 0%)
During the course you will be trained to administer and maintain Postgres databases. At the end of the course you will be able to accomplish a PostgreSQL Associate certificate.
Goal of the course:
You will learn the essential details of Postgres databases including architecture, configuration, maintenance, monitoring, backup, recovery, and data movement. You will also be introduced to enterprise class tools for Postgres administration and will prepare you to handle real time, production environments.
Course Outline:
- Introduction
- System Architecture
- Installation
- Configuration
- Creating and Managing Databases
- User Tools: Command Line Interface
- GUI Tools
- Security
- SQL Primer
- Backup and Recovery
- Point in Time Recovery
- Routine Maintenance Tasks
- Postgres Data Dictionary
- Moving Data
Target audience:
- IT Professionals who want to administer and maintain databases
- Professionals who are in the process of evaluating Postgres for use in their upcoming projects
- Professionals to develop their skills in Postgres
Recommended Prerequisites:
- Intermediate knowledge of RDBMS concepts
- Basic understanding of SQL
- Basic experience with use of the Linux operating system (helpful)
The course material is in English.
In addition to training itself the course fee includes coffees and lunches for each training day. Cancellation policy: Course can be cancelled free of charge 30 days prior the training. If cancellation takes place 6-30 days before the training the cancellation fee is 50% from the course fee. If cancellation takes place 0-5 days before the training the cancellation fee is 100% from the course fee. Registration can be cancelled by sending an email to edb@nordicmind.com or by calling to +358 20 759 8111.
Certified PostgreSQL Professional
Advanced Postgres Administration
- Duration: 3 days
- Price: 2000 EUR (VAT 0%)
During the course you will be prepared to manage large, highly available databases and their related security requirements. At the end of the course you will be able to accomplish a PostgreSQL Professional Certification.
Goal of the course:
You will learn replication to safe guard data, clustering for high availability, partitioning for performance and maintainability, and security for privacy and protection among other things. The course is appropriate for both the community edition of PostgreSQL and Postgres Plus Advanced Server.
Course Outline:
- PostgreSQL System Architecture
- Transactions and Concurrency
- Performance Tuning
- High Availability and Replication
- Table Partitioning
- Connection Pooling
- Monitoring
- Procedural Languages
- Extensions
Target audience:
- Database Administrators/Developers already using Postgres in their current deployments
- IT Professionals who want to enhance their Postgres administration skills
Recommended Prerequisites:
- Proficient in regular Postgres DBA functions
The course material is in English.
In addition to training itself the course fee includes coffees and lunches for each training day. Cancellation policy: Course can be cancelled free of charge 30 days prior the training. If cancellation takes place 6-30 days before the training the cancellation fee is 50% from the course fee. If cancellation takes place 0-5 days before the training the cancellation fee is 100% from the course fee. Registration can be cancelled by sending an email to edb@nordicmind.com or by calling to +358 20 759 8111.
Course Schedule
6.-8.9.2016
Certified PostgreSQL Admin
Location:
Conoa AB, Hälsingegatan 49 (The Park)
9.-11.11.2016
Certified PostgreSQL Professional
Location:
Technopolis, Hiilikatu 3
Date: To be announced soon!
Certified PostgreSQL Admin
Location:
To be announced soon!