Country dropdown
Don't have an account yet? Register Now!

Sign in to your account

PostGIS and PostgreSQL course

Introduction

PostGIS is an open-source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). Technically PostGIS was implemented as PostgreSQL's external extension. PostgreSQL, often simply Postgres, is an object-relational database management system(ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database and it is also available for Microsoft Windows and (supplied in most distributions).

The main purpose of the training is to equip the trainees with skills that will enable them to handle cross-platform operations between the inter-operable software.

Objectives:

The participant(s) should be able to perform the following upon successful completion of the training:

  • Configure PostgreSQL for spatial operations
  • Create and administer spatial databases
  • Distinguish between, spatial and classic databases
  • Import and export spatial data
  • Perform both basic and complex queries
  • Perform spatial functions
  • Connect databases to GIS software
  • Embrace the significance of open source databases

Target group

New and seasoned GIS who are interested in expanding their GIS skills into multi-user enterprise-level spatial databases.

Database administrators

IT experts

Duration

10 days

Requirements

SQL language and GIS knowledge

Training content

MODULE 1 

  • Introduction to databases
  • History of databases

 

MODULE 2

  • Introduction to PostgreSQL/PostGIS
  • Installation and Configuration PostGIS
  • From stack builder
  • PostGIS template presentation
  • Create a spatial database
  • Differences between spatial databases and classic databases

MODULE 3

  • Spatial Data Presentation
  • Vector (point, line, polygons)
  • Raster
  • WKT, WKB
  • Spatial SQL
  • Projections

MODULE4

  • Administration of Postgis Spatial Queries in PostgreSQL
  • Import a spatial dataset
  • Simple queries

MODULE 5

  • Buffers, areas, distances
  • More complex queries, spatial joins (intersections, etc.)
  • PostGIS functions (on geometries)

MODULE 6

  • Import GIS layers (WKT, KML, SHP)
  • Shp2pgsql (command line) and useful parameters
  • PostGIS Shapefile and DBF Loader
  • Load data with other software (QGIS, GeoServer)

MODULE 7

  • Connect a QGIS and GeoServer software to PostgreSQL
  • Open layers from PostGIS
  • Privileges management (read, write, update, insert, delete) on GIS
    data

MODULE 8

  • Relational Model
  • Relational model theory
  • Basics on tables, primary keys, attributes
  • The different models (Conceptual Data Model, Relational
    model)
  • Creation of a Database
  • The main steps to create a database

MODEL 9

  • Import or create a dataset
  • Create tables, views
  • Constraints management (primary and foreign keys)
  • Simple queries with graphic composer
  • SQL basics

MODULE 10

  • Introduction to Users and Privileges
  • Roles and group of users
  • Grant and revoke privileges to users
  • Import / Export Data and Backup / Restore
  • Import from attribute tables (Excel, CSV, text files, etc.)
  • Export from the database to Excel
  • Backup and restore

 

 METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Services (IRES) certificate certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Mob: +250789621067

TAILOR-MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +250 789 621 067 or mail This email address is being protected from spambots. You need JavaScript enabled to view it.

PAYMENT

Payment should be transferred to IRES account through bank on or before C.O.B. 25th November 2019.

Send proof of payment to This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Please Note: The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

 

Event Properties

Event Duration 10 Days
Event Date 02-12-2019
Event End Date 13-12-2019
Cut off date 25-11-2019
Individual Price(rwanda franc) R₣ 1,200,000
Individual Price (International) EUR 1,741
Individual Price(International in Dollars) USD 1,999
Location Kigali,Rwanda
We are no longer accepting registration for this event
Share this event:
©2019 Indepth Research Services. All Rights Reserved.

Search

Don't have an account yet? Register Now!

Sign in to your account