NOTICE: Many events listed here have been canceled or postponed due to the Covid-19 emergency. It is best to call ahead or check with organizer's websites to verify the status of any local event.

Change Location × Worldwide

    Recent Locations

      PostGIS and PostgreSQL course training


      • PostGIS and PostgreSQL course training Photo #1
      1 of 1
      November 30, 2020

      Monday   8:30 AM - 4:30 PM (every 5 days for 1 times)

      Nairobi Municipality

      Performers:
      • No Performers Listed
      EVENT DETAILS
      PostGIS and PostgreSQL course training

      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 30th November to 11th December, 2020.

      COURSE PROFILE
      Course Name: PostGIS And PostgreSQL Course
      Venue: FineResults Research Training Centre, Nairobi, Kenya
      Date: 30th November to 11th December, 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: training@fineresultsresearch.org

      PAYMENT
      Payment should be transferred to FineResults Research Services Limited bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org

      Visit our website for more details

      How to participate
      Individual Registration

      Contact information
      Email:training@fineresultsresearch.org
      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

      Categories: Education | Science | Technology

      This event repeats every 5 days for 1 times: Nov 30

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.

      Hotels and Airbnbs near PostGIS and PostgreSQL course training. Book your stay now!