Dear all,
RE: PostGIS And PostgreSQL Course
FineResults Research Services would like to invite you to high impact training on PostGIS And PostgreSQL Course to be held in Nairobi from 4th-15th May, 2020 .
COURSE PROFILE
Course Name: PostGIS And PostgreSQL Course
Venue: FineResults Research Training Centre, Nairobi, Kenya
Date: 4th-15th May, 2020 .
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
NB: We are offering you a half day, fun and interactive team building event!
ACCOMMODATION
Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700 / +254 759 285 295 or Email: [email protected]
PAYMENT
Payment should be transferred to FineResults Research Services Limited bank before commencement of training. Send proof of payment through the email: [email protected]
Visit our website for more details
How to participate
Individual Registration
Contact information
Email: [email protected]
TEL: +254 732 776 700 / +254 759 285 295
Website: fineresultsresearch.org/training/
Visit our face book page
Visit our linkedin page
Visit our twitter account