Module 1: Introduction to Geospatial Databases

• Why use a database for geospatial data? Advantages over file-based systems
• Relational Database Management Systems (RDBMS) basics
• Understanding geospatial data models in a database context
• Key concepts: tables, columns, rows, primary/foreign keys
• Overview of common geospatial database systems (PostGIS, SQL Server, Oracle Spatial, Esri Geodatabase)
• Practical session: Exploring the structure of a simple spatial database schema

Module 2: Relational Database Concepts for GIS

• SQL fundamentals: SELECT, INSERT, UPDATE, DELETE statements
• Creating and altering tables, defining data types
• Joins: INNER, LEFT, RIGHT, FULL OUTER joins for combining data
• Constraints: primary key, foreign key, unique, check
• Database normalization and its importance for geospatial data
• Practical session: Writing basic SQL queries to manage non-spatial attributes in a database

Module 3: Introduction to PostgreSQL and PostGIS

• Overview of PostgreSQL: open-source RDBMS
• Introduction to PostGIS: spatial extension for PostgreSQL
• Installing and configuring PostgreSQL and PostGIS
• Creating spatial databases and enabling PostGIS extension
• Connecting to PostGIS from various GIS clients
• Practical session: Installing PostgreSQL/PostGIS and creating your first spatial database

Module 4: Spatial Data Types and Functions in PostGIS

• Understanding spatial data types in PostGIS (e.g., POINT, LINESTRING, POLYGON, MULTIPOINT)
• Well-Known Text (WKT) and Well-Known Binary (WKB) representations
• Geometry constructors and transformers
• Basic spatial functions (e.g., ST_AsText, ST_GeomFromText, ST_SRID)
• Coordinate Reference Systems (CRS) in PostGIS (SRID)
• Practical session: Creating simple spatial geometries and querying their properties using PostGIS functions

Module 5: Importing and Exporting Geospatial Data in PostGIS

• Using ogr2ogr for importing and exporting various vector formats (Shapefile, GeoJSON, KML)
• Importing raster data into PostGIS (raster2pgsql)
• Copying data between tables
• Importing data from CSV with spatial coordinates
• Best practices for bulk data loading
• Practical session: Importing a Shapefile and a GeoTIFF into a PostGIS database

Module 6: Advanced Spatial Queries in PostGIS

• Spatial relationships (e.g., ST_Intersects, ST_Contains, ST_Within, ST_Overlaps)
• Spatial analysis functions (e.g., ST_Buffer, ST_Union, ST_Intersection, ST_Distance)
• Geoprocessing with SQL: combining spatial functions
• Aggregating spatial data
• Subqueries and Common Table Expressions (CTEs) for complex spatial analysis
• Practical session: Performing advanced spatial queries (e.g., finding points within a polygon, buffering features)

Module 7: Introduction to SQL Server and Spatial Capabilities

• Overview of Microsoft SQL Server and its role in enterprise data management
• SQL Server's spatial data types (Geometry, Geography)
• Installing and configuring SQL Server for spatial capabilities
• Management tools: SQL Server Management Studio (SSMS)
• Understanding the Geometry and Geography types differences
• Practical session: Setting up a SQL Server instance and creating a new spatial database

Module 8: Spatial Data Types and Functions in SQL Server

• Working with Geometry and Geography data types
• Constructors, properties, and methods for spatial objects
• Basic spatial functions (e.g., STAsText(), STBuffer(), STIntersection())
• Coordinate Reference Systems (SRIDs) in SQL Server
• Importing simple spatial data through T-SQL
• Practical session: Creating simple spatial objects and performing basic spatial operations in SQL Server

Module 9: Importing and Exporting Geospatial Data in SQL Server

• Using SQL Server Management Studio (SSMS) import/export wizard
• Importing data from Shapefiles and other formats using tools like ogr2ogr
• Bulk insert operations for spatial data
• Exporting spatial tables to file formats
• Working with spatial data in C#/.NET or Python (pyodbc)
• Practical session: Importing a Shapefile into a SQL Server spatial table

Module 10: Advanced Spatial Queries in SQL Server

• Spatial relationship methods (e.g., STIntersects(), STContains(), STWithin())
• Spatial analysis methods (e.g., STBuffer(), STUnion(), STDifferenct(), STDistance())
• Combining spatial and non-spatial queries
• Joins based on spatial relationships
• Optimizing complex spatial queries in SQL Server
• Practical session: Performing advanced spatial analysis queries in SQL Server using spatial methods

Module 11: Database Design for Geospatial Data

• Designing tables to store spatial and attribute data
• Normalization vs. denormalization for geospatial performance
• Choosing appropriate spatial data types and projections
• Integrating non-spatial attributes with spatial features
• Designing for multiple users and concurrent access
• Practical session: Designing a schema for a new geospatial project in a database

Module 12: Geospatial Indexing and Performance Optimization

• Importance of spatial indexes for query performance
• Types of spatial indexes (e.g., GiST in PostGIS, spatial indexes in SQL Server)
• Creating and managing spatial indexes
• Analyzing query plans and identifying bottlenecks
• Database tuning for geospatial operations
• Practical session: Creating spatial indexes and evaluating their impact on query performance

Module 13: Integrating Geospatial Databases with GIS Software

• Connecting PostGIS and SQL Server to desktop GIS (e.g., QGIS, ArcGIS Pro)
• Direct database connections vs. enterprise geodatabases
• Editing spatial data stored in databases from GIS clients
• Publishing database layers as web services
• Working with views for simplified data access
• Practical session: Connecting a GIS desktop application to both PostGIS and SQL Server databases

Module 14: Geospatial Database Administration and Security

• User management and roles in PostgreSQL and SQL Server
• Granting and revoking permissions for spatial data
• Backup and recovery strategies for geospatial databases
• Monitoring database performance and health
• Maintaining spatial integrity and data quality
• Practical session: Managing user roles and permissions for geospatial tables

Module 15: Big Data Considerations for Geospatial Databases

• When traditional geospatial databases reach their limits
• Sharding and partitioning spatial data for scalability
• Introduction to distributed geospatial databases
• Leveraging cloud-based spatial databases (e.g., Amazon RDS with PostGIS, Azure SQL Database Spatial)
• Considerations for managing massive geospatial datasets
• Practical session: Discussing strategies for handling very large geospatial datasets in a database environment

Module 16: Web Mapping and Geospatial Databases

• Using geospatial databases as backends for web mapping applications
• Introduction to web mapping servers (e.g., GeoServer, MapServer)
• Querying spatial data from web applications (e.g., using Leaflet/OpenLayers with PostGIS/SQL Server)
• Developing simple web services for spatial data
• Data streaming for large web maps
• Practical session: Setting up a basic web map that consumes data from a geospatial database

Module 17: Case Studies and Best Practices in Geospatial Database Management

• Examples of geospatial database implementations in various industries (e.g., utilities, land administration, logistics)
• Lessons learned from real-world projects
• Best practices for data modeling, performance, and security
• Strategies for migrating legacy spatial data to databases
• Future-proofing geospatial database solutions
• Practical session: Analyzing a case study of a complex geospatial database implementation

Module 18: Future Trends in Geospatial Database Technologies

• New features in PostGIS and SQL Server spatial
• Graph databases for spatial networks
• Vector tiles and their impact on database usage
• Cloud-native spatial databases and services
• Integration with AI/Machine Learning for spatial analysis
• Practical session: Exploring new features or emerging trends in geospatial database systems

Requirements:

·       Participants should be reasonably proficient in English.

·       Applicants must live up to Armstrong Global Institute admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@armstrongglobalinstitute.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254725012095 / +254724452588

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Armstrong Global Training & Development Center Limited should be paid in advance, 5 days to the training.

2. Invoice: We can send a bill directly to you or your company.

3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

2. Participants may cancel attendance 14 days or more prior to the training commencement date.

3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588