COURSE PROFILE
Course Name: PostGIS And PostgreSQL Course
Date: 17th-28th February, 2020
Duration:10 Days
Venue: FineResults Research Training Centre, Nairobi, Kenya
Cost: USD 1600
Online Registration : REGISTER HERE
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 a 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 trainers with skills that will enable them 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
DURATION
10 days
Requirements
SQL language and GIS knowledge
COURSE OUTLINE
MODULE 1
Introduction to data bases
History of databases
MODULE 2
Introduction to PostgreSQL/PostGIS
Installation and Configuration PostGIS
From stackbuilder
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 database to Excel
Backup and restore
TRAINING CUSTOMIZATION
This training can also be customized for your institution upon request. You can also have it delivered your preferred location.
For further inquiries, please contact us through Mobile: +254 732 776 700 or Email: training@fineresultsresearch.org
REQUIREMENTS
Participants should be reasonably proficient in English. During the trainings, participants should come with their own laptops.
TRAINING FEE
The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.
ACCOMMODATION
Accommodation is arranged upon request. For reservations contact us through Mobile: +254732776700 or Email: training@fineresultsresearch.org
PAYMENT
Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org
CANCELLATION POLICY
• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.