Postgis Using Spatial Database Analysis

1. Introduction to Spatial Database
2. Installation Guide
3. Initial Database Setup
4. Choosing Map Projection
5. Introduction to Functions, Domains, Schema
6. Data preprocessing
7. Using pgAdminIII
8. Spatial Analysis using Spatial DB
9. Accessing PostGIS from Desktop GIS

Advanced Topics:

1. Query Plans, Performance Tuning
2. Administration
3. Data Migration/ Database Upgrade

After completing the course you will be able to 

1. Manage PostGIS DB
2. Import and Export Data
3. Execute SQL queries using Geometry data
4. Perform various Spatial Analysis
5. Replace Desktop analysis using Spatial DB