PostgreSQL and PostGIS Training
Training course for PostgreSQL and PostGIS
Itinerary and links
| Time | Description |
|---|---|
| 09:00 | Arrivals and coffee |
| 09:30 | Start and Introductions. Discussion on goals and outcomes. Run through of itinerary. |
| 09:45 | 1. Introduction to PostgreSQL |
| 10:00 | 2. Installing PostgreSQL. |
| 10:15 | 3. PostgreSQL clients – pgAdmin III, pgAdmin 4 and alternatives. |
| Break/Informal Discussion | |
| 11:00 | 4. Creating PostgreSQL databases, schemas, tables and datatypes. |
| 11:30 | 5. PostgreSQL. Common queries: SELECT, GROUP BY, ORDER BY |
| Lunch | |
| 13:20 | 6. GIS data types |
| 13:30 | 7. Introduction to PostGIS |
| 13:45 | 8. Installing PostGIS |
| 14:00 | 9. Creating a PostGIS database |
| Break/Informal Discussion | |
| 15:15 | 10. PostGIS data loading |
| 15:45 | 11. PostGIS common queries |
| 16:10 | 12. PostGIS data exports |
| 16:30 | Discussion, further queries, resources, and close |