Organization Name / Organize By
fineresultsresearch
Organizing/Related Departments
fineresultsresearch.org
Organization Type
Organization
WorkshopCategory
Both (Technical & Non Technical)
WorkshopLevel
All (State/Province/Region, National & International)
Related Industries
Education/Teaching/Training/Development
Research/Science
Business Development
Course title: PostGIS and PostgreSQL Training
Dates and registration links:
06/02/2023 to 17/02/2023: http://bit.ly/3TI9aAe
10/04/2023 to 21/04/2023: http://bit.ly/3gdD4hW
19/06/2023 to 30/06/2023: http://bit.ly/3UKAC1u
21/08/2023 to 01/09/2023:http://bit.ly/3OdQwPq
21/08/2023 to 25/08/2023: http://bit.ly/3Gjv9KF
04/12/2023 to 15/12/2023: http://bit.ly/3ULnKbd
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
Registration Fees
Available
Registration Fees Details
USD 1,600
Registration Ways
Email
Phone
Website