Training

Whereabouts Consulting regularly run a range of training courses.  Our course outlines follow below; to find out more detail about any one course,  or to get the course dates or to book, please follow this link and we will get in touch.

  • Basics of QGIS
  • Advanced QGIS
  • Basics of Inkscape
  • PostgreSQL Introduction
  • PL/pgSQL

The cost for all courses is $800.00 per person per day.  We prefer learners to bring their own computers, but we can arrange for training computers to be made available at an extra cost of $80.00 per day.

Courses are run at a training centre in North Sydney, but on-site training can also be arranged.

Basics of QGIS

Overview

Whereabouts Consulting’s Basics of QGIS course is a one-day QGIS course and it provides and introduction to the user interface, the basic operations including a thorough background to Spatial Information management using this software platform.  After this course learners will be comfortable with the main interface elements of QGIS and will be able to load and interrogate data, edit save and export data, and produce professional map outputs.

Who Should Attend?

This course is specifically aimed at users who need to operate QGIS at a basic level in order to work with a range of spatial data.  The course will also be a good starting point for senior spatial practitioners who are familiar with other spatial platforms.

Course Outline

  1. Spatial concepts
  2. What is QGIS?
  3. The QGIS interface
  4. Adding various data sources to the QGIS Map
  5. Spatial data symbolisation (styling)
  6. Editing spatial data
  7. Perform basic spatial operations
  8. Create a map output

Advanced QGIS

Overview

Whereabouts Consulting’s Advanced QGIS course is a one-day QGIS course and it provides an advanced look at the QGIS software platform.  After this course learners will be comfortable with advanced stylisation, including the creation of custom symbols and styles; Attribute form customisation, data automation and data integrity.  Learners will also be able to produce advanced map outputs.

Who Should Attend?

This course is specifically aimed at users who are familiar with the QGIS user interface but would like to get more out of the software, with special attention to data integrity, analysis and reporting.

Course Outline

  1. The QGIS plugin architecture
  2. QGIS Compound Stylisation
  3. Custom Point Symbol creation (Image and SVG)
  4. Attribute form customisation
  5. Managing your data integrity
  6. Form automation
  7. Data Processing Toolbar
  8. Data Process Modelling
  9. Map Atlases

Introduction to Inkscape

Overview

Whereabouts Consulting’s Introduction to Inkscape course is a one-day course and it provides a basic overview of the Inkscape software user interface, the basic operations including a thorough background of SVG principles.  After this course learners will be comfortable with the main interface elements of Inkscape and will be able to create a range of SVG documents that are great for reports or website graphics, symbology or vector image manipulation.

Who Should Attend?

This course is specifically aimed at users who would like to create their own custom vector images for websites, report document and icons.

Course Outline

  1. SVG concepts (Scalable Vector Graphics)
  2. What is Inkscape?
  3. The Inkscape interface
  4. Inkscape Drawing Primitives
  5. Vector Styling
  6. Vector Object manipulation
  7. Working with vertexes and beziers
  8. Create a SVG output

PostgreSQL Introduction

Overview

Whereabouts Consulting’s Introduction to PostgreSQL is another one-day course and it provides a basic overview of the Open Source PostgreSQL database.  After this course learners will be comfortable with the PGAdmin user interface elements and will be able to create database schemas and tables, load data and create data reports.

Who Should Attend?

This course is specifically aimed at users who would like to know more about databases in general and PostgreSQL in particular.

Course Outline

  1. Getting Started with PostgreSQL
    1. Brief overview of PostgreSQL
    2. Install PostgreSQL and connect to PostgreSQL database server
    3. Loading data
    4. PostgreSQL client applications: psql / pgAdmin 3
  2. Querying Data
    1. SQL Select
    2. Order By
    3. Distinct Selections
  3. Filtering Data
    1. The ‘Where’ clause
    2. Subsets with ‘Limit’
    3. Fetch
    4. The ‘In’ Clause
    5. Between
    6. Like
    7. Is Null
    8. Aliasing
    9. Grouping