PostGIS and PostgreSQL Training course

Dear all,

RE: PostGIS and PostgreSQL Training course

FineResults Research Services would like to invite you to high impact training on PostGIS and PostgreSQL Training course to be held in Nairobi from 24/08/2020 to 04/09/2020

COURSE PROFILE

Course Name: PostGIS and PostgreSQL Training course

Date: 24/08/2020 to 04/09/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

 

 

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact us through Mobile: +254 759 285 295 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.

 

GENERAL NOTES

• All our courses can be Tailor-made to participants needs
• The participant must be conversant with English
• Presentations are well guided, practical exercise, web based tutorials and group work. Our facilitators are expert with more than 10years of experience.
• Upon completion of training the participant will be issued with FineResults Research Services certificate
• Training will be done at FineResults Research Services center in Nairobi Kenya. We also offer more than five participants training at requested location within Kenya, more than ten participants within east Africa and more than twenty participants all over the world.
• Course duration is flexible and the contents can be modified to fit any number of days.
• The course fee includes facilitation training materials, 2 coffee breaks, buffet lunch and a Certificate of successful completion of Training. Participants will be responsible for their own travel expenses and arrangements, airport transfers, visa application dinners, health/accident insurance and other personal expenses.
• One year free Consultation and Coaching provided after the course.
• Register as a group of more than two and enjoy discount of (10% to 30%) plus free four hour adventure drive to the National game park, in Nairobi.

 

Visit our website for more details

 

How to participate

Individual Registration

Contact information

Email: [email protected]

TEL: +254 759 285 295

Website: fineresultsresearch.org/training/

Visit our face book page

Visit our linkedin page

Visit our twitter account

 

 

 

 

 

 

 

Others Details

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

SI NO	Filename	Download
1	COURSE DETAILS	Download