MySQL for Geospatial Applications

MySQL for Geospatial Applications, available at $64.99, has an average rating of 3.5, with 90 lectures, based on 23 reviews, and has 233 subscribers.

You will learn about 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 This course is ideal for individuals who are GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases. or GIS professionals who want a simple and inexpensive way to get started with multi-user enterprise level spatial databases. It is particularly useful for GIS professionals who are interested in expanding their GIS skillsets into multi-user enterprise level spatial databases. or GIS professionals who want a simple and inexpensive way to get started with multi-user enterprise level spatial databases.

Enroll now: MySQL for Geospatial Applications

Summary

Title: MySQL for Geospatial Applications

Price: $64.99

Average Rating: 3.5

Number of Lectures: 90

Number of Published Lectures: 88

Number of Curriculum Items: 90

Number of Published Curriculum Objects: 88

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

GIS professionals who want a simple and inexpensive way to get started with multi-user enterprise level spatial databases.

Target Audiences

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

GIS professionals who want a simple and inexpensive way to get started with multi-user enterprise level spatial databases.

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 point it does not have all the bells and whistles that PostGIS has but all of the important core functionality is there. This course uses the latest (as of 11/22) versions of MySQL (8.0, and QGIS (3.28). 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 MySQL locally for development purposes and how to access a production version via a network or the internet.

How to load your spatial data into MySQL 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 MySQL

Optimizing your queries for the best performance

The basics of programming custom functions with the MySQL stored procedure language

The basics of database administration to keep your database operating smoothly

Deploy your database on a web’hosting service so that it is available to anyone with an internet connection (assuming they have been granted access priveleges)

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Why use a spatial database?

Lecture 3: What exactly is a spatial database?

Lecture 4: Where does a spatial database live?

Lecture 5: What is SQL and why use it?

Chapter 2: Installation and loading data

Lecture 1: Installing MySQL and XAMPP on Windows

Lecture 2: Installing QGIS 3.28 on Windows

Lecture 3: Installing MySQL and XAMPP on MacOS

Lecture 4: Installing QGIS 3.28 on MacOS

Lecture 5: Loading non-spatial data into MySQL

Lecture 6: Loading spatial data into MySQL

Lecture 7: Accessing MySQL from the command line

Lecture 8: The organization of a database

Chapter 3: Data Query Language – SQL queries for non-spatial data

Lecture 1: The SQL SELECT statement

Lecture 2: The SQL Where clause

Lecture 3: Aggregate functions and the GROUP BY clause

Lecture 4: Multi-table joins

Lecture 5: Multi-table joins (Part 2)

Lecture 6: MySQL data types

Lecture 7: Expressions, functions, and operators

Lecture 8: User defined functions

Lecture 9: The CASE statement

Lecture 10: MySQL views

Chapter 4: Making SQL spatial – Introduction

Lecture 1: The MySQL geometry model

Lecture 2: SRIDs

Lecture 3: The MySQL geometry column

Lecture 4: Geometry vs. Geography

Lecture 5: Spatial Functions – Description

Lecture 6: Spatial Functions – Measurements

Lecture 7: Spatial Functions – Coordinate Access

Lecture 8: Spatial Functions – Testing Spatial Relationships

Chapter 5: Making SQL spatial – Advanced

Lecture 1: Multi-table joins with spatial predicates

Lecture 2: Query optimization

Lecture 3: Aggregate functions in multi-table spatial queries

Lecture 4: Buffers in MySQL – Part 1

Lecture 5: Buffers in MySQL – Part 2

Lecture 6: Other geometry processing functions

Lecture 7: Challenge Exercises

Lecture 8: Challenge Exercises – Part 2

Chapter 6: SQL Data Definition Language (DDL)

Lecture 1: Intro to the Data Definition Language

Lecture 2: Creating a new table

Lecture 3: Populating a MySQL spatial table using QGIS digitizing tools

Lecture 4: Primary and Foreign Keys – Intro

Lecture 5: Implementing a lookup table with primary and foreign keys

Lecture 6: Creating indexes

Lecture 7: Changing the structure of existing tables with ALTER

Lecture 8: GUI methods for changing table structure

Chapter 7: SQL Data Manipulation Language (DML)

Lecture 1: Adding new records with the INSERT statement

Lecture 2: Adding geometry to a feature with the INSERT statement

Lecture 3: Modifying existing data with the UPDATE statement

Lecture 4: Deleting records

Lecture 5: Challenge exercise: Putting it all together

Chapter 8: SQL Data Control Language (DCL)

Lecture 1: Creating users and roles

Lecture 2: Granting privileges to roles

Lecture 3: Example Roles for this project

Lecture 4: Working with roles in QGIS

Chapter 9: Deploying your database to a web server

Lecture 1: Registering for a web hosting plan

Lecture 2: Creating a database and a user and import data from localhost

Lecture 3: Setting up remote hosting and accessing from remote clients

Lecture 4: Problem solved and mea culpa

Lecture 5: Challenge scenario – ST_Union and ST_Collect for dissolving features.

Lecture 6: Backing up your data

Chapter 10: Accessing your MySQL data from Python

Lecture 1: Quick Overview of Jupyter Notebooks

Lecture 2: Accessing your MySQL data from Python

Lecture 3: Quick overview of GeoPandas

Lecture 4: Reading your MySQL data into GeoPandas

Lecture 5: Quick overview of web technology

Lecture 6: Very basic client side web map with Leaflet

Lecture 7: Reading MySQL data stored in WGS84 coordinate system onto a web map

Lecture 8: Reading data stored in UTM – Coordinate transformation using Proj4

Lecture 9: Loading web map to the server

Chapter 11: Automation

Lecture 1: Transactions

Lecture 2: User Defined Functions

Lecture 3: Extending the language – Multi function

Lecture 4: Simplifying your code – Wetland system lookup

Lecture 5: Simplifying your code – Getting lastdate and lastsurvey from durvey data

Lecture 6: Introduction to triggers

Lecture 7: After insert trigger

Lecture 8: After update trigger

Lecture 9: After delete trigger

Lecture 10: Triggers for audit logging

Lecture 11: Introduction to Stored Procedures

Lecture 12: Stored procedures program flow controllers – Conditionals and branching

Lecture 13: Stored Procedures program flow – Loops

Lecture 14: Stored procedures . looping through a resultset with cursors

Lecture 15: Stored procedures – Error handling

Lecture 16: Where to go from next

Chapter 12: Background Info

Lecture 1: All about GeoJSON

Instructors

Michael Miller
GIS Programming

Rating Distribution

1 stars: 2 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 4 votes

5 stars: 13 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!