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 × Nairobi, Kenya

    Recent Locations

      Spatial Databases with PostGIS and QGIS course in Nairobi


      • Spatial Databases with PostGIS and QGIS course Photo #1
      1 of 1
      July 27, 2020

      Monday   8:00 AM - 4:30 PM

      Nairobi, Nairobi Municipality

      Performers:
      • No Performers Listed
      EVENT DETAILS
      Spatial Databases with PostGIS and QGIS course

      Dear all,

      RE: Spatial Databases with PostGIS and QGIS course

      FineResults Research Services would like to invite you to high impact training on Spatial Databases with PostGIS and QGIS course to be held in Nairobi from 27/07/2020 to 31/07/2020

      COURSE PROFILE

      Course Name: Spatial Databases with PostGIS and QGIS course

      Date: 27/07/2020 to 31/07/2020

      Duration: 5 Days

      Venue: FineResults Research Training Centre, Nairobi, Kenya

      Cost: USD 800

      Online Registration: REGISTER HERE

      INTRODUCTION
      This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. This course uses the latest versions of PostgreSQL, PostGIS, and QGIS.

      COURSE OBJECTIVES
      Upon course completion, participants should be able to:
      • What a spatial database is and why you would want to use one.
      • What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.
      • How to install PostGIS locally for development purposes and how to access a production version via a network or the internet.
      • How to load your spatial data into PostGIS and access it from a variety of clients, especially QGIS
      • The basics of SQL for both spatial and non-spatial queries
      • How to validate data and control user access with the tools built-in to PostGIS
      • Optimizing your queries for the best performance
      • How to work with raster data in PostGIS
      • The basics of programming custom functions with PL/pgSQL
      • The basics of database administration to keep your database operating smoothly

      DURATION
      5 days

      COURSE OUTLINE
      Module 1: Introduction to QGIS
      • Gain a basic conceptual understanding of cartography, GIS, and mapping
      • Gain familiarity with geographic data and information, and how it's encoded within computer files
      • Gain a basic familiarity with the QGIS interface
      • Gain awareness of spatial reference and projection issues
      • Practice opening a variety of geographic data with QGIS and viewing their attributes within QGIS

      Module 2: mapping using QGIS
      • Creating a Basic Map
      • Classifying Vector Data
      • Creating Maps
      • Vector Analysis
      • Rasters
      • Completing the Analysis
      • Plugins
      • Online Resources
      • QGIS Server
      • Perform basic map styling
      • Create and export a basic map as a static image file

      Module 3: POSTGIS
      • Introduction to POSTGIS
      • Installation
      • Applications that support PostGIS
      • Creating a PostGIS database
      • Loading spatial data
      • Data review
      • Postgis connection and settings
      • Spatial reference systems settings
      • Import .csv file with point location
      • SQL and graphical querying
      • Spatial relationships
      • Spatial joins
      • Spatial indexing
      • Geometry constructing functions

      Module 4: Advanced QGIS Processing
      • Using Spatial Databases in QGIS
      • Creating POSTGIS connection
      • Adding POSTGIS layers
      • Plot data in QGIS
      • Change layer style
      • Geoprocessing tools
      • Geometry tools
      • Processing toolbox
      • Web
      • Database

      Module 5: Online Sources of Data
      • Openstreet maps
      • CartoDB
      • Google earth
      • Interactive and shareable maps
      • Google maps, Geoserver, fusion tables and CartoDB
      • Online data analysis

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

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

      TEL: +254 759 285 295

      Website: fineresultsresearch.org/training/

      Visit our face book page

      Visit our linkedin page

      Visit our twitter account

      Cost: 800.00

      Categories: Conferences & Tradeshows | Business & Networking

      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 Spatial Databases with PostGIS and QGIS course. Book your stay now!