Working with PostGIS

Working with PostGIS

This course will cover the basics of working with PostGIS databases

Course Overview

Working with PostGIS

This course will cover the basics of working with PostGIS databases. Using PgAdmin and QGIS, we will create a new spatial database in an existing PostgreSQL instance, import some data, and load it in QGIS. We will also query the data using SQL commands directly from QGIS. Additionally, we will learn how to import a PostGIS database using pgAdmin as well as learn how to restore and backup a PostGIS database.

Experience Level:

Advanced

Skills Covered:

  • Connect to a server in pgAdmin
  • Create a new database
  • Import a shapefile using the Database Manager
  • Restore and backup a PostGIS database

Lessons1 hr 15 min

  • Working with PostGIS Spatial Databases
  • Importing a PostGIS Database using pgAdmin
  • Course Survey

Course Overview

Working with PostGIS

This course will cover the basics of working with PostGIS databases. Using PgAdmin and QGIS, we will create a new spatial database in an existing PostgreSQL instance, import some data, and load it in QGIS. We will also query the data using SQL commands directly from QGIS. Additionally, we will learn how to import a PostGIS database using pgAdmin as well as learn how to restore and backup a PostGIS database.

Experience Level:

Advanced

Skills Covered:

  • Connect to a server in pgAdmin
  • Create a new database
  • Import a shapefile using the Database Manager
  • Restore and backup a PostGIS database

Lessons1 hr 15 min

  • Working with PostGIS Spatial Databases
  • Importing a PostGIS Database using pgAdmin
  • Course Survey