PostgreSQL (PostGIS & QGIS)

Details

Length: 4 half day sessions Cost: $1,870 + GST
Time: 9:00 AM – 1:00 PM AEST
Location: Accessible virtually nationwide in Australia

Are you interested in this course?

To book this public course, view all available dates on our training calendar. If you can’t find a suitable date or would like to arrange a private session for your organisation, contact us at training@ngis.com.au

View Training Calendar

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 ensure the details are of the individual attending the course.

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)