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.

 

 



 

Postgres_Course_Image


 

 
 

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

 

 

UPCOMING COURSE dates*

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.

Submit this form to start the booking process: