Introduction to PostGIS
On-Demand Training - Learn and Study PostgreSQL anywhere & anytime you want!
The course will provide an Introduction to Spatial Concepts and Geographic DataTypes and how to use them in PostgreSQL via PostGIS. Topics included are how to install and configure PostGIS to enable PostgreSQL to work with Spatial data types, how to properly run queries and set up Indexes on Spatial data. In addition the course will cover best practices for viewing, exporting and Administering Spatial data in PostgreSQL and PostGIS.
Topics covered:
- Introduction to Spatial Concepts
- Geometric Datatypes
- Metadata Views
- General GeoSpatial Theory
- Installation
- Configuration
- Installing PostgreSQL
- Installing PostGIS
- Creating a Spatially Enabled Database
- Using PostGIS - Part 1
- Connecting to the Database
- Simple Spatial SQL
- Loading Data
- Insert Statements
- Feature Manipulation Engine (FME)
- OGR
- Using PostGIS - Part II
- Creating Spatial Indexes
- Using Spatial Indexes
- Indexes and Query Plans
- When Query Plans Go Bad
- Spatial Comparators, Relate
- Exporting Data
- Shapefile Writer (pgsql2shp)
- Feature Manipulation Engine (FME)
- OGR
- Database Dumps
- Query Exports
- Viewing Data
- Options
- Geoserver/QGIS/Jump/uDig and PostGIS
- Database Administration
- Tables
- Role Management
- Vacuum
- Analyze
- Cluster
- Accepted Host Configuration
- Partitioning
The length of the recording for this class is approximately 3 hours, which includes all the above mentioned topics.You will be able to access the recording for a time period of 2 weeks. You also get a copy of the main course slides, exercises and answer-key workbooks via document.
See how On-Demand training works:
www.enterprisedb.com/products-services-training/training/demand
Learning Credits
EnterpriseDB offers Learning Credits as a way to simplify your training procurement. You can plan and budget your organizational training needs and enjoy built-in volume discounts.
Training Login Problems?
If you have registered for a training class which is scheduled for today and need urgent help with the login information, please use the contacts below and we will provide assistance as soon as possible.
Call Support at +1-732-331-1320 or
Email: trainingcoordinator@enterprisedb.com
Note: These contacts are for critical assistance only related to last minute login issues for any training class.
