LENGTH:                       4 half day sessions                              
COST:                             $1,645 + GST
TIME:                              9:00 AM - 1:00 PM AEST
LOCATION:                   Online ( virtual machines will be used ) 

Or contact NGIS on the form at the bottom of the page to request a corporate course.







course information


This 2 day training course will provide attendees with fundamental skills in designing, creating, administering and optimising spatial PostgreSQL databases. The training will include specific to make the training relevant to attendees.

By the end of this course, you will be able to: 
• Learn the foundations of PostgreSQL, to discover, use, make, and share data from a relational database system. 
• Gain essential skills required to successfully install, configure, manage and maintain a PostgreSQL Server. 
• Recognize common SQL commands and spatial support through PostGIS. 
• Understand the tools and techniques for high availability, disaster recovery, and replication. 

No previous experience with PostgreSQL is required. Experience with using Microsoft Windows is essential.

  • Installing PostgreSQL
  • Configuring PostgreSQL
  • Designing and Managing Databases
  • Database Administration
  • Database Security Configuration
  • Database Monitoring and Optimisation
  • Database Backup
  • Database Replication

Day 1 
Lesson 0: Course Introduction 
Lesson 1: PostgreSQL Basics & Installation 
Lesson 2: Creating a Spatial Database in pgAdmin 

Day 2 
Lesson 3: Basic Data Loading 
Lesson 4: Simple SQL 
Lesson 5: Indexing 
Lesson 6: Communication with QGIS 

Day 3 
Lesson 7: Projecting & Dimensionality 
Lesson 8: History, Tracking & Tuning 
Lesson 9: Security, Users & Schema 

Day 4 
Lesson 10: Back-up & Restore 
Lesson 11: Database Replication & Availability 
Lesson 12: Course Conclusion




Date Time Status
TBC TBC Please email training@NGIS.com.au to register your interest for the next course


Please note other than the dates above NGIS are able to offer group training sessions for a team of four or more on an agreed date in our professional training room in our Perth office. Please send an email to training@ngis.com.au and we will do our best to accommodate you.

*NGIS reserves the right to cancel, postpone or re-schedule courses due to low enrolments or unforeseen circumstances. Where a fee refund is due, such a refund will be provided within 30 days. NGIS will have no further liability.

Please ensure the below details are of the individual attending the course.

Submit this form to start the booking process: