• Online, Self-Paced
Course 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.

Learning 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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.