Training on PostGIS And PostgreSQL

Course: Training on PostGIS And PostgreSQL

 

Course Date

Onsite fees:

Registration

12/02/2024 To 16/02/2024

1,000 USD
90,000Ksh

https://bit.ly/3QRjrdM

13/05/2024 To 17/05/2024

1,000 USD
90,000Ksh

https://bit.ly/3Ga8izV

12/08/2024 To 16/08/2024

1,000 USD
90,000Ksh

https://bit.ly/46iTA4c

11/11/2024 To 15/11/2024

1,000 USD
90,000Ksh

https://bit.ly/46jyy5D

Contact : +254 732 776 700 / +254 759 285 295

Email : [email protected]

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: [email protected]

 

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: [email protected]

 

PAYMENT

Payment should be transferred to FineResults Research Limited bank before commencement of training. Send proof of payment through the email: [email protected]

 

CANCELLATION POLICY

• All requests for cancellations must be received in writing.

• Changes will become effective on the date of written confirmation being received.