Published 11/2022
Created by Michael Miller
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 29 Lectures (5h 38m ) | Size: 2.1 GB
Build your own multi-user enterprise GIS for free
What you'll learn
Understand the advantages of storing spatial information in spatially enabled databases
Install MySQL locally for development purposes and/or access an instance of MySQL 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 MySQL to validate data and control user access
Perform basic database administration functions to keep your spatial database running smoothly
Customize your database with your business logic using stored procedures, user defined functions, and triggers
Access your data from a variety of clients including, QGIS, ArcGIS, PhPMyAdmin, MySQL Workbench, the MySQL command line, Python, and web maps
Requirements
You should be familiar with GIS concepts and be willing to learn QGIS. My course QGIS 3.10 for GIS professionals will provide all the background that is necessary but it is not a formal pre-requisite.
Some prior exposure to SQL for non-spatial data will be useful as we will go through that section fairly quickly so we can focus on spatial data.
Description
This course is intended to provide an introduction to spatial databases in general and MySQL in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. MySQL is available on almost all web-hosting platforms and geospatial capabilities have been part of the core MySQL distribution since version 5.6. This means that is far easier and less expensive to setup and deploy a spatial database with MySQL than other options such as PostGIS. At this...
Read more
Continue reading...