PostgreSQL (PostGIS & QGIS)

Details

Length: 4 half day sessions Cost: $2,040 + GST (in-person), $1,870 + GST (online)
Time: 9:00 AM – 1:00 PM
Location: Accessible virtually and in-person at select locations

Are you interested in this course?

We are currently taking Expressions of Interest for online course delivery. Please fill out the contact form at the bottom of the page to register your interest, and we will establish upcoming dates based on demand.

This course will provide attendees with fundamental skills in designing, creating, administering and optimising spatial PostgreSQL databases. The training will include specifics to make the training relevant to attendees.
By the end of this course, you will be able to:

  • Understand the tools and techniques for high availability, disaster recovery, and replication.
  • 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.

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

  • Course Introduction
  • PostgreSQL Basics & Installation
  • Creating a Spatial Database in pgAdmin
  • Basic Data Loading
  • Simple SQL
  • Indexing
  • Communication with QGIS
  • Projecting & Dimensionality
  • History, Tracking & Tuning
  • Security, Users & Schema
  • Back-up & Restore
  • Database Replication & Availability
  • Course Conclusion

Contact Us

Submit this form to start the booking process.

Please provide any additional information such as which course content you are interested in, preferred course date, location and number of attendees.
Would you like to be kept up to date with the NGIS training program?
Have you read the NGIS training terms and conditions?(Required)