FOSS4g Stack: Spatial SQL with PostgreSQL / PostGIS
This course uses real data from Tompkins County, New York, and seamlessly integrates with other GIS advisor courses that will teach you QGIS, GDAL, Geoserver, and Python. You'll be working alongside the instructor as you explore the capabilities of SQL, working with raster, vector, and attribute data. And most importantly, after you learn SQL and spatial SQL you will simulate some real-world examples of GIS projects and spatial analysis.
Instructor: Dr. Arthur Lembo, Professor in the Department of Geography and Geosciences at Salisbury University, Maryland.
The course is also included in GEO Premium.
What you'll learn
How to conduct spatial analysis with Postgres 11 and PostGIS
Basic and spatial SQL statements.
Creating spatial functions with SQL.
How to create geographic models with SQL.
PGAdmin IV to manage Postgres databases.
QGIS Database module to manage Postgres databases.
Join multiple tables together.
Key features
Part of an entire curriculum based on Free and Open Source GIS (FOSS4g)
Claim your Certificate of Completion with no extra cost.
Study at your best time - online and always accessible.
Even when you finish the course and you get your certificate, you will still have access to course contents.
Key applications
Train your company
Train newest members
Stay updated on GIS applications, Remote Sensing techniques and Space technologies
Research & Academia
Fill in knowledge gaps
Continuing education on GIS applications, Remote Sensing algorithms and techniques and Space technologies
Fill in knowledge gaps
Continuing education on GIS applications, Remote Sensing algorithms and techniques and Space technologies
FAQs
The online course is hosted in the platform of GEO University. After the purchase, you will be sent further information on how to access the course from the GEO University platform.
You get access to the course for ever! You pay once and you get access to the entire course content and their updates for ever.
No. Your certificates of completion remain active for ever.
You can share it in your social media accounts and you can add it to your CV, LinkedIn profile etc as proof of knowledge.
In case you want multiple people to access the course, please fill out the Quotation Form below and add your exact needs in the 'Your Question' field. We will contact you as soon as possible!
Terms & Conditions and Privacy Policy of GEO University apply.
