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 |