• views: 123
• date: 22 March 2025
• posted by: voska89

Learn Spatial SQL and database management for GIS Professionals

What you'll learn

Understand the advantages of storing spatial information in spatially enabled databases
Install PostGIS locally for development purposes and/or access an instance of PostGIS that is running on their organizations intranet, a web host, or the cloud
Write SQL queries to retrieve and analyze spatial data.
Use the tools available in PostGIS to validate data and control user access
Perform basic database administration functions to keep your spatial database running smoothly

Requirements

You should be familiar with GIS concepts and be willing to learn QGIS. My course QGIS 3.0 for GIS professionals will provide all the background that is necessary but it is not a formal pre-requisite.

Description

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. This course uses the latest (as of 2/18) versions of PostgreSQL (10.1), PostGIS (2.4), and QGIS (3.0). I believe it is the most current and thorough course on spatial databases available today. 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 QGISThe basics of SQL for both spatial and non-spatial queriesHow to validate data and control user access with the tools built-in to PostGISOptimizing your queries for the best performanceHow to work with raster data in PostGISThe basics of programming custom functions with PL/pgSQLThe basics of database administration to keep your database operating smoothly

Who this course is for

GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases.
Homepage:

https://www.udemy.com/course/introduction-to-spatial-databases-with-postgis-and-qgis/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.