PostgreSQL (PostGIS)

Details

Length: 4 half day sessions Cost: $1,645 + GST
Time: 9:00 AM – 1:00 PM AEST
Location: Online ( virtual machines will be used )

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.

Date: 25/03/2025 – 28/03/2025 Time: 9:00 AM – 1:00PM Status: Open Location: Online (AEST)
Date: 13/05/2025 – 16/05/2025 Time: 9:00 AM – 1:00PM Status: Open Location: Online (AEST)  

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

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)