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

Name		Name	Last commit message	Last commit date
Latest commit History 19 Commits
data		data
pdfs		pdfs
01 Introduction to PostgreSQL.md		01 Introduction to PostgreSQL.md
02 Installing PostgreSQL.md		02 Installing PostgreSQL.md
03 PostgreSQL Clients.md		03 PostgreSQL Clients.md
04 Creating PostgreSQL databases.md		04 Creating PostgreSQL databases.md
05 PostgreSQL Common Queries.md		05 PostgreSQL Common Queries.md
06 GIS data types.md		06 GIS data types.md
07 Introduction to PostGIS.md		07 Introduction to PostGIS.md
08 Installing PostGIS.md		08 Installing PostGIS.md
09 Creating a PostGIS database.md		09 Creating a PostGIS database.md
10 PostGIS Data loading.md		10 PostGIS Data loading.md
11 PostGIS Common Queries.md		11 PostGIS Common Queries.md
12 PostGIS Exporting Data.md		12 PostGIS Exporting Data.md
PostgreSQL Training Itinerary.docx		PostgreSQL Training Itinerary.docx
PostgreSQL Training Itinerary.pdf		PostgreSQL Training Itinerary.pdf
Readme.md		Readme.md
highlight.css		highlight.css
pdf.css		pdf.css