Jirotech provides hands on professional training for a range of PostgreSQL database courses and courses which cover the open source geospatial stack. Jirotech also provides customised training courses, where we tailor our courses to specific business needs.

PostgreSQL Administration

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX, and Windows.

In the PostgreSQL Administration training course attendees learn the essential skills for PostgreSQL Administration including: PostgreSQL architecture, configuration, maintenance, monitoring, backup, recovery and data import/export.

Target audience: This module is suitable for DBAs, Data Architects, IT Managers, IT Directors, IT Strategists, System Administrators and GIS Professionals. It is designed to convey the knowledge necessary to perform duties comparable to those of a PostgreSQL Database Administrator.

Prerequisites: No prior knowledge of PostgreSQL is required. Basic experience with Linux and any database product is recommended.

Course outline:

  • Installation
  • Database Management
  • Architecture
  • Roles
  • Schemas, Tablespaces, Partitions, Views, Indexes
  • Log Files
  • Configuration
  • Security
  • Contrib Modules
  • Statistics
  • PGAdmin
  • The Data Dictionary
  • Languages
  • Triggers, Rules
  • Logical Backups, Physical Backups, Point In Time Recovery (PITR)
  • Moving Data
  • Routine Maintenance
  • Supported PostgreSQL

Duration: 3 days

Cost: $3,620 (exc GST)

PostgreSQL High Availability

The PostgreSQL High Availability course builds on the PostgreSQL Administration course, providing an insight into ways to tune, manage and extend your Postgres database to provide a highly available environment. Participants will learn the skills needed to ensure that their database achieves maximum throughput with minimum downtime. The PostgreSQL High Availability course is a valuable asset to administrators looking to enhance their environment to its full potential.

Audience: The module is suitable for IT Professionals, system administrators and GIS professionals.

Prerequisites: Completion of PostgreSQL Administration

Course outline:

  • What defines a Highly Available Environment?
  • High Availability Options
  • Streaming Replication
  • Clustering
  • Load Balancing / Connection Pooling
  • Deciding on the High Availability Solution for You
  • Implementation Workshop

Duration: 2 days

Cost: $3,750 (ex GST)

PostgreSQL Oracle Migration and Replication

This course focuses on PostgreSQL Oracle Migration. The PostgreSQL Oracle Migration course introduces the EnterpriseDB Oracle compatibility and database migration tools. At the conclusion of this course students will be able to identify suitable Oracle database migration candidates, and replicate and migrate Oracle databases to EnterpriseDB. This course is a great way to demonstrate the power of PostgreSQL and look at little closer at the benefits of PostgreSQL over Oracle, from both a technical and cost saving point of view.

Prerequisites: Completion of PostgreSQL Administration

Audience: The module is suitable for IT Professionals, and system administrators.

Course outline:

  • Overview of EnterpriseDB Oracle Features
  • The EnterpriseDB Compatibility Layer
  • Migration or Replication?
  • EnterpriseDB Oracle Replication with xDB
  • EnterpriseDB PostgreSQL Oracle Migration with the Migration Assistant
  • Planning Replication
  • Hands on Replication Workshop
  • Planning a Migration
  • Hands on Migration Workshop

Duration: 2 days

Cost: $3,910 (ex GST)

Spatially Enabled with PostGIS

PostGIS spatially enables geographic objects in the PostgreSQL object relational database. It adds support for geographic objects allowing location queries to be run in SQL.

PostGIS provides the following benefits:

  • Open Geospatial Consortium (OGC) standards compliance
  • Feature rich spatial implementation
  • Industry leading query performance
  • Efficient and high performance data storage
  • Support for major spatial vendors including ESRI, Mapinfo, Autodesk, FME – as well as being the core spatial database format used by the Geospatial Open Source stack of software

Delegates Learn: The Spatially Enabled with PostGIS course covers the breadth of the PostGIS API, including modelling the physical world as geographic objects, importing, creation and manipulation of these objects, and complex analysis and generation of derived data sets.

Target Audience: Database Scientists, Geoscientists, Spatial Data Coordinators, Spatial Operations Managers, Metadata Managers, Enterprise Architects.

Prerequisites: Completion of PostgreSQL Administration Course and familiarity with spatial data and concepts.

Course outline:

  • Introduction to PostGIS
  • PostGIS Case Studies
  • Basic Tools
  • Datatabase Basics
  • Overview of the Data
  • Representing Geometries
  • Formatting your Output
  • PostGIS Metadata
  • Geographic Objects and Geometry Accessors
  • Visualising Data
  • Importing Data
  • Projection Overview
  • Projecting Data
  • Measurement Functions
  • Spatial Joins
  • Indexing Tablespaces
  • Tuning the Database
  • Optimising Query Plans
  • Clustering
  • Equality and Validity
  • Aggregate Functions
  • Set Returning Functions
  • Pointset Operations

Duration: 2 Days

Cost: $3,750 (exc. GST)