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)

Professional GeoServer

GeoServer is web server that allows you to serve maps and data from a variety of formats to standard clients such as web browsers and desktop GIS programs. Data is published via standards based interfaces, such as WMS, WFS, WCS, WPS, Tile Caching and more. GeoServer comes with a browser-based management interface and connects to multiple data sources at the back end.

Jirotech’s Professional Geoserver training provides an in-depth look at GeoServer. The courses focus on the role of GeoServer in a stack of spatial software, the publishing of spatial data and use of GeoServer by various clients.

Professional Geoserver Module 1

Professional Geoserver Module 1 covers the publication and styling capabilities of GeoServer. It introduces the standards used, available data sources, performance considerations and covers:

  • Installing and configuring GeoServer and a Postgres/PostGIS spatial database and loading data.
  • Publishing vector and raster data through WMS, Tiled WMS, and WFS interfaces, as well as PDF printing.
  • Viewing in a webpage, using OpenLayers.
  • Introduction to styling and use of colour.
  • Introduction to benchmarking and tuning.

Target audience: Geospatial Managers, GIS Professionals, Database Administrators, Database Professionals, System Administrators and relevant ICT Professionals.

Duration: 2 Days

Cost: $2,450 (exc. GST)

Professional Geoserver Module 2

Professional Geoserver Module 2 covers advanced GeoServer topics, and is designed for people wishing to take GeoServer into a production environment. This module covers:

  • Advanced mapping concepts, styling, filters, labelling
  • Incorporating GeoServer extensions
  • Using GeoServer in a range of clients
  • Style optimisation, comparing CSS and SLD
  • Advanced performance benchmarking
  • Security

Target audience: Geospatial Managers, GIS Professionals, Database Administrators, Database Professionals, System Administrators and relevant ICT Professionals.

Prerequisites: Completion of Professional Geoserver Module 1.

Duration: 2 Days

Cost: $2,680 (exc. GST)

Creating Metadata with GeoNetwork

GeoNetwork is a catalog application to manage spatially referenced resources. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. It is currently used in numerous Spatial Data Infrastructure initiatives across the world.

The course covers modern data and metadata standards and demonstrates how the use of these standards can secure data against the type of obsolescence caused by changing proprietary data formats or capabilities.

Delegates learn: Standards and guidelines for metadata and data, OCG compliant map services, XML and GeoNetwork, metadata preparation and management, GeoNetwork’s ISO compliancy, editing metadata records, identifying datasets, spatial information representation mechanisms, data accessing and distribution.

Target Audience: Data Managers, GIS Developers and GIS Users

Course outline:

  • GeoNetwork Functionality
  • Open Geospatial Consortium (OGC) Map Services
  • Metadata standards and guidelines
  • GeoNetwork, XML and Web Services
  • Metadata preparation and management
  • GeoNetworks Internet Interface
  • Metadata Fields
  • Dataset Identification
  • Spatial Representation
  • Reference System Information
  • Constraints Information
  • Data Quality Information
  • Maintenance Information
  • Distribution Information

Duration: 2 Days

Cost: $2,550 (exc. GST)