MySQL Database Development: GIS, Cloud, and Connectors for MySQL


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

GIS data types, cloud integration, and low level access for database performance give MySQL the power necessary to handle many data storage tasks. Explore these features in MySQL.



Expected Duration (hours)
0.9

Lesson Objectives

MySQL Database Development: GIS, Cloud, and Connectors for MySQL

  • create and use geospatial tables, fields, and indexes to manage GIS based data in MySQL
  • work with the basic Point, Polygon, and Geometry spatial data types in MySQL
  • use the MySQL collection data types like Multipoint and Multilinestring to manage collections of values
  • describe a MySQL deployment using the Microsoft Azure cloud service
  • describe MySQL setup and migration using the Amazon Relational Database Service (RDS) and the Amazon Database Migration Service (DMS)
  • describe provisioning and integrating MySQL on the Oracle Cloud using Oracle's Cloud Services
  • use the Java Database Connectivity (JDBC) connector to access MySQL from within a Java app
  • work with the ADO.NET MySQL connector within Visual Studio
  • use the Python connector to access MySQL from within a Python App
  • describe and use geospatial database types in MySQL
  • Course Number:
    it_dfmydd_09_enus

    Expertise Level
    Intermediate