think-where-logo.png
tel_email.jpg twitter.jpg youtube.jpg linkedin.jpg
banner_training1.jpg

postgis_logo_square.jpgPostGIS - Administrator

Learn how to manage PostgreSQL/PostGIS databases with this hands-on training course.  This course focuses on administrator topics including database configuration and optimisation and user and role management.


This course is most suitable for:

  • Those who want to manage PostgreSQL/PostGIS databases.

PostGIS - Administrator

This course focuses on administrator topics including database configuration and optimisation and user and role management.


This course is most suitable for:

  • Those who want to manage PostgreSQL/PostGIS databases.

Course Outline

Module 1: PostGIS Introduction

  • PostgreSQL
  • PostGIS

Module 2: Getting Started with PostgreSQL and PostGIS

  • Architecture of PostgreSQL and PostGIS
  • User interfaces including pgAdmin
  • Data types and query syntax

Module 3: PostgreSQL and PostGIS Installation

  • Installation and configuration of PostgreSQL and PostGIS on Windows

Module 4: Spatial Database Design

  • The structure of spatial databases
  • The use of schemas and tablespaces
  • The use of groups and roles for managing access to data

Module 5: Database Administration

  • Configuration, security and optimisation of PostgreSQL and PostGIS
  • Vacuum and analyse tools
  • Memory allocation and usage
  • Logging
  • Error reporting

Module 6: Data Management

  • Data input / output
  • Using the COPY command
  • Database backups and restores

Module 7: PostgreSQL Scalability

  • Disaster recovery
  • High availability options for a production database

Cost: £450 (exc VAT)

Duration: 1 day

Course Dates:

  • 18th August 2017
  • 22nd November 2017

Venue: thinkWhere, Stirling. 

CPD Points: 4

Book Your Place

 

What's On

 

What Our Clients Say...

"I think it was one of the most useful training sessions I've had to date."


Performance & Information Officer

Clackmannanshire Council

 

line.jpg

Contact Us

thinkWhere
Glendevon House
Castle Business Park
Stirling
FK9 4TZ

Telephone: +44 (0)1786 476060
Email: info@thinkwhere.com

> Enquiries

Find Us

Our office is located in the
City of Stirling with convenient
motorway and rail links.

> View location map

thinkWhere Ltd. is registered in
Scotland: SC315349