Training


Introduction to PostgreSQL/PostGIS

Prerequisite: None

Duration: 16 hours

Course Contents

  • Installing PostgreSQL/PostGIS
  • Basic Database and SQL Concepts using PostgreSQL
  • Geometric Datatypes
  • Creating a Spatial Database
  • Import and Export of Spatial Data
  • Spatial SQL Queries
  • Visualization of Spatial data in QGIS
  • Spatial Index and Query Plans

After Completing the Course you will be able to

  • Download and Install PostgreSQL/PostGIS
  • Execute basic SQL Queries
  • Create a Spatial Database
  • Understand the Geometric datatypes
  • Create Spatial SQL queries and view the results in QGIS
  • Create Spatial Index and build query plan for Spatial Queries
 

Back