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