The Ultimate PostGIS course
Comprehensive training on PostgreSQL database and PostGIS spatial extension
About This Course
This comprehensive training course covers PostgreSQL database management system and its spatial extension PostGIS. Learn how to store, query, and analyze spatial data efficiently using industry-standard open-source tools.
What You'll Learn
- PostgreSQL database fundamentals and administration
- Spatial data management with PostGIS
- Advanced spatial queries and analysis
- Performance optimization for spatial databases
- Integration with other GIS tools and services
Discover how to integrate PostgreSQL/PostGIS with other GIS tools like QGIS, GeoServer, and web mapping libraries
Course Stats
Course Content
PostgreSQL components
Introduction to SQL, Databases, and RDBMS
Introduction to SQL, Databases, and RDBMS What is a Database? A database is an organized …
Understanding Schemas in PostgreSQL
Understand what a schema is in PostgreSQL Learn why schemas are important for organizing …
Introduction to Tables in PostgreSQL
Understand what a table is in PostgreSQL Learn how to create tables using SQL …
Introduction to Views in PostgreSQL
Understand what views are and why they’re used Create and use regular and materialized …
Postgresql datatypes
Numeric datatype
Why Numeric Data Types Matter "Numeric data types define how your numbers are stored …
Text Data Types
Fixed-Length vs. Variable-Length PostgreSQL offers three core text types: Type Description Maximum …
Date and Time Types
Overview of Temporal Types PostgreSQL provides several types for working with temporal data: …
Boolean Data Type
Introduction to Boolean Type PostgreSQL has a native BOOLEAN data type. It accepts three values: …
Enumerated Types
Introduction to ENUM Types ENUM (enumerated) types allow you to define a column with a …
Working with JSON
Introduction to JSON in PostgreSQL PostgreSQL supports two JSON types: JSON: stores raw JSON …
UUID datatype
Understand what UUIDs are and why they are used Learn how to use the …
Monetary Types
Introduction to the MONEY Type The money type in PostgreSQL is designed to store currency …
PostgreSQL Functions
Functions Related to Strings and Text
String manipulation is a fundamental skill in database management. PostgreSQL provides a rich set of …
Mathematical Functions
PostgreSQL provides a comprehensive set of mathematical functions that make working with numerical data efficient …
Date and Time Functions
Working with dates and times is a fundamental aspect of database management. PostgreSQL provides comprehensive …
PostgreSQL Queries
Intro to SQL Queries in PostgreSQL
What is SQL and Why Does It Matter? SQL stands for Structured Query Language—the standard …
CRUD Operations in PostgreSQL
CRUD operations form the backbone of database interactions. Whether you're building web applications, managing data …
Using DISTINCT to Eliminate Duplicates
When working with databases, duplicate values in query results can clutter your output and make …
NULLs in PostgreSQL
NULL values are one of the most misunderstood concepts in database systems. In PostgreSQL, understanding …
Filtering Rows Using Logical Operators
Single conditions in WHERE clauses are often insufficient for complex data filtering needs. PostgreSQL provides …
Joins Explained: INNER, LEFT, RIGHT, FULL
Joins are one of the most powerful features of relational databases, allowing you to combine …
Pattern Matching with LIKE, ILIKE, and SIMILAR TO
Text pattern matching is a fundamental requirement in database applications, from implementing search functionality to …
Case expressions
SQL queries often need to incorporate conditional logic to transform data, categorize results, or implement …
Understanding PostGIS
Understanding Geometry Types
What is Geometry in PostGIS? In PostGIS, geometry is the backbone of spatial data. Every …
Understanding Geography Types
What is Geography in PostGIS? PostGIS provides two primary types to store spatial data: geometry …
Raster Data in PostGIS
What is Raster Data? Raster data represents spatial information as a regular grid of cells …
Geometry Input/Output Formats
Spatial data interoperability is crucial in modern GIS workflows. Whether you're importing data from external …
Understanding Projections
One of the most fundamental concepts in spatial databases is understanding how the three-dimensional Earth …
Working with data
Loading spatial data
Loading spatial data into PostGIS is a fundamental skill for anyone working with geographic information …
Geometrical Analysis
Geometrical analysis forms the backbone of spatial data processing in PostGIS. Whether you're calculating land …
Spatial Aggregate Functions
When working with large spatial datasets, the ability to summarize and merge geometries across groups …
Spatial Relationships
Understanding spatial relationships is fundamental to GIS analysis. PostGIS provides a comprehensive set of functions …
Advanced Spatial Analysis
Buffering and Thiessen Polygons
Spatial influence zones are fundamental concepts in GIS analysis, helping us understand how features affect …
Proximity and Distance Analysis
Proximity analysis is one of the most fundamental operations in GIS, answering the critical question …
Clustering and Nearest Neighbors
Spatial clustering and nearest neighbor analysis are powerful techniques for discovering patterns in geographic data. …
Overlay Analysis
Overlay analysis is one of the most fundamental operations in GIS, allowing you to combine …