Skip to content

Complete PostGIS Course

This course uses PostgreSQL 16 and PostGIS 3.3. It is recommended to use the latest version of PostgreSQL and PostGIS.

  • Introduction


    • Who is this course for ?
    • What are databases ?
    • Course Overview and Tools Required
    • What all you can expect in this course ?
  • Introduction to Databases


    • Introduction to RDBMS
    • Relational vs. Non-Relational Databases
    • Overview of PostgreSQL
    • What is PostGIS and Why Use It?
  • PostgreSQL Fundamentals


    • Installation and Setup
    • SQL Basics
    • Creating Tables and Data Types
    • Data Import/Export
    • Basic Queries and Joins
  • PostGIS Basics


    • Spatial Data Types
    • Creating Spatial Tables
    • Importing Spatial Data
    • Geometry vs geography
    • Basic Spatial Queries
    • Running spatial functions
    • Reprojecting data in PostGIS
  • QGIS Integration


    • Spatial Data Types
    • Creating Spatial Tables
    • Importing Spatial Data
    • Connecting QGIS to PostGIS
    • Data Visualization in QGIS
    • Editing PostGIS Layers in QGIS
    • Forms and Attributes
  • PostGIS Extensions & Advanced Features


    • Topology Extension
    • Raster Support
    • 3D and Point Cloud Data
    • Routing with pgRouting
    • Address Geocoding
    • Serving data as tiles via postgis
    • PostGIS and MobilityDB
  • PostGIS Optimization for Production


    • Spatial Data Types
    • Optimizing PostGIS for High-Performance Environments
    • Scaling and Load Balancing
    • Securing and Hardening PostGIS for Production
  • Introduction to PostgREST


    • Installation and Setup
    • Creating functions in postgis