MySQL for Geospatial Applications

Focused View

Michael Miller

5:38:26

145 View

1. Introduction

1. Introduction.mp4

15:03

2. Why use a spatial database.mp4

15:02

3. What exactly is a spatial database.mp4

16:48

4. Where does a spatial database live.mp4

10:24

5. What is SQL and why use it.mp4

15:23

2. Installation and loading data

1. Installing QGIS 3.28 on Windows.mp4

09:03

2. Installing MySQL on Windows.mp4

15:04

3. Loading non-spatial data into MySQL.mp4

13:58

4.1 mysql_course_data.zip

4. Loading spatial data into MySQL.mp4

20:06

5. Accessing MySQL from the command line.mp4

06:56

6. The organization of a database.mp4

08:08

3. Data Query Language - SQL queries for non-spatial data

1. The SQL SELECT statement.mp4

17:15

2. The SQL Where clause.mp4

12:45

3. Aggregate functions and the GROUP BY clause.mp4

09:39

4. Multi-table joins.mp4

17:38

5. Multi-table joins (Part 2).mp4

05:45

6. MySQL data types.mp4

19:03

7. Expressions, functions, and operators.mp4

07:12

8. User defined functions.mp4

06:29

9. The CASE statement.mp4

04:31

10. MySQL views.mp4

10:45

4. Making SQL spatial - Introduction

1. The MySQL geometry model.mp4

08:49

2.1 setsrid.zip

2. SRIDs.mp4

18:59

3. The MySQL geometry column.mp4

07:45

4. Geometry vs. Geography.mp4

08:07

5. Spatial Functions - Description.mp4

12:30

6. Spatial Functions - Measurements.mp4

08:21

7. Spatial Functions - Coordinate Access.mp4

11:45

8. Spatial Functions - Testing Spatial Relationships.mp4

05:13

Description

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

Who is this for?

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.

More details

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 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)
Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

I have been programming and working with database applications for over 30 years, and specializing in geospatial applications for over 20 years. I am a believer in the 80/20 pareto principle which suggests that you only need to understand 20% of a subject in order to do 80% of your work. My goal in all my courses is to teach at the level of that 20% sweet spot and to provide my students with the background and the tools they need to learn the rest of what they need on their own.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.