Or contact NGIS on the form at the bottom of the page to request a corporate course.
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.
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 |
07/03/2022 - 10/03/2022 | 9:00 AM - 1:00PM | Open |
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.