This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. You will learn
What a spatial database is and why you would want to use one.
What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.
How to install PostGIS locally for development purposes and how to access a production version via a network or the internet.
How to load your spatial data into PostGIS and access it from a variety of clients, especially QGIS
The basics of SQL for both spatial and non-spatial queries
How to validate data and control user access with the tools built-in to PostGIS
Optimizing your queries for the best performance
How to work with raster data in PostGIS
The basics of programming custom functions with PL/pgSQL
The basics of database administration to keep your database operating smoothly
Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
We have 30 Million registered users and counting who have advanced their careers with us.
Feedbacks (3)
Great and informative course. More in-depth than I anticipated.
I have learnt a lot from this course it . It was very informative and I would recommend it to anyone interested in GIS and SQL