PostgreSQL Training Courses

PostgreSQL Training Courses

Local, instructor-led live PostgreSQL (AKA Postgres) training courses demonstrate through interactive discussion and hands-on practice the fundamentals of PostgreSQL and how to handle the administration and performance tuning of PostgreSQL databases. PostgreSQL training is available as "onsite live training" or "remote live training". Onsite live PostgreSQL training can be carried out locally on customer premises in Ireland or in NobleProg corporate training centers in Ireland. Remote live training is carried out by way of an interactive, remote desktop. NobleProg -- Your Local Training Provider

Testimonials

★★★★★
★★★★★

PostgreSQL Course Outlines

CodeNameDurationOverview
pgsqladmPostgreSQL Administration and Development28 hoursThis course handles the administration and performance tuning of PostgreSQL databases. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
postgresadminPostgreSQL for Administrators14 hoursThis course covers the administration and performance tuning of PostgreSQL databases.

Target audience includes system administrators and database architects. Attendees will learn the use of specialised PostgreSQL (AKA Postgres) modules such as replication, connection pooling and full text searching.
postgresdevPostgreSQL for Developers14 hoursThis course provides programmatic interaction with PostgreSQL databases. Learn techniques, syntaxes and structures needed to develop quality applications using PostgreSQL backend. This training also covers SQL Tuning covering best practices for writing efficient SQL.

Target audience includes developers who want to use or extend PostgreSQL, as well as database architects.
postgresadminoptimreplPostgreSQL Administration, Optimization and Replication35 hoursPostgreSQL (or Postgres) is one of the most popular open-source relational databases.

In this instructor-led, live training (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

By the end of this training, participants will be able to:

- Use advanced administration techniques to configure and manage a PostgreSQL server
- Optimize the database and queries for maximum performance
- Replicate and scale a PostgreSQL server

Audience

- Database administrators
- Systems administrators
- Developers with database experience

Format of the Course

- Part lecture, part discussion, exercises and heavy hands-on practice

Note

- This course is based PostreSQL 9 but can be adapted for a different version.
- To request a customized training for this course, please contact us to arrange.
postgresadmin1PostgreSQL Essentials14 hoursThis training is designed for Database Administrators and Architects who want to learn PostgreSQL from basics.

You will learn PostgreSQL architecture, installation, designing as well as how to perform backup and recovery databases in PostgreSQL.
postgresadmin2PostgreSQL Advanced DBA14 hoursThis training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing High Availability and Database Security in PostgreSQL.

You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
postgresadmin3Implementing High Availability in PostgreSQL7 hoursThis training is designed for Database Administrators and Architects who want to learn Streaming Replication in PostgreSQL and how pgpool-II can be used to achieve automatic failovers and setup a highly available PostgreSQL Database Cluster.
postgresadmin4PostgreSQL Performance Tuning7 hoursThis training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.

Upcoming PostgreSQL Courses

CourseCourse DateCourse Price [Remote / Classroom]
PostgreSQL for Administrators - CorkMon, 2019-01-07 09:302310EUR / 3050EUR
PostgreSQL for Administrators - Dublin BallsbridgeMon, 2019-01-07 09:302310EUR / 3110EUR
PostgreSQL for Administrators - Dublin St. Kevin'sThu, 2019-01-10 09:302310EUR / 3110EUR
PostgreSQL for Administrators - Dublin SandyfordTue, 2019-01-29 09:302310EUR / 3160EUR
PostgreSQL for Administrators - Dublin Jury's InnWed, 2019-02-06 09:302310EUR / 3510EUR
Weekend PostgreSQL courses, Evening PostgreSQL training, PostgreSQL boot camp, PostgreSQL instructor-led, Weekend PostgreSQL training, Evening PostgreSQL courses, PostgreSQL coaching, PostgreSQL instructor, PostgreSQL trainer, PostgreSQL training courses, PostgreSQL classes, PostgreSQL on-site, PostgreSQL private courses, PostgreSQL one on one training

Course Discounts

CourseVenueCourse DateCourse Price [Remote / Classroom]
jBPM for Process DesignersCorkMon, 2019-02-18 09:305400EUR / 6680EUR
DevOps Practical Implementation and ToolsDublin Jury's InnMon, 2019-03-25 09:304050EUR / 5750EUR
Basics of BioinformaticsLimerick Strand HotelTue, 2019-04-23 09:304050EUR / 5450EUR
R for Data Analysis and Research Dublin Jury's InnTue, 2019-05-28 09:301350EUR / 2050EUR
IoT security Dublin Jury's InnMon, 2019-07-08 09:304158EUR / 5858EUR

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Ireland!

As a Business Development Manager you will:

  • expand business in Ireland
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!