MySQL Database Development: GIS, Cloud, & Connectors

MySQL    |    Intermediate
  • 10 videos | 56m 29s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 33 users Rating 4.5 of 33 users (33)
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 8m 14s
    In this video, learn how to create and use geospatial tables, fields, and indexes to manage GIS-based data in MySQL. FREE ACCESS
  • 7m 11s
    In this video, you will learn how to work with the basic Point, Polygon, and Geometry spatial data types in MySQL. FREE ACCESS
  • Locked
    3.  Using the Geospatial Collection Data Types
    3m 46s
    Learn how to use the MySQL collection data types like Multipoint and Multilinestring to manage collections of values. FREE ACCESS
  • Locked
    4.  Using the Azure MySQL Service
    2m 57s
    After completing this video, you will be able to describe a MySQL deployment using the Microsoft Azure cloud service. FREE ACCESS
  • Locked
    5.  Migrating to Amazon RDS
    2m 56s
    After completing this video, you will be able to describe MySQL setup and migration using Amazon Relational Database Service (RDS) and Amazon Database Migration Service (DMS). FREE ACCESS
  • Locked
    6.  Integrating with Oracle Cloud
    2m 36s
    After completing this video, you will be able to describe how to provision and integrate MySQL on the Oracle Cloud using Oracle's Cloud Services. FREE ACCESS
  • Locked
    7.  Using the MySQL JDBC Connector
    8m 36s
    In this video, find out how to use the Java Database Connectivity (JDBC) connector to access MySQL from within a Java app. FREE ACCESS
  • Locked
    8.  Working with the ADO.NET Connector
    7m 48s
    During this video, you will learn how to work with the ADO.NET MySQL connector within Microsoft Visual Studio. FREE ACCESS
  • Locked
    9.  Using MySQL via the Python Connector
    7m 49s
    Find out how to use the Python connector to access MySQL from within a Python App. FREE ACCESS
  • Locked
    10.  Exercise: Using Geospatial Data Types
    4m 37s
    Upon completion of this video, you will be able to describe and use different types of geospatial databases in MySQL. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Visualization: Visualizing Data Using Advanced Charts in Plotly
Rating 4.3 of 24 users Rating 4.3 of 24 users (24)
Course Java Certified Foundations Associate: Math & Random Classes
Rating 4.7 of 40 users Rating 4.7 of 40 users (40)
Course Certified Information Systems Auditor (CISA) 2019: Data Privacy & Risk
Rating 4.5 of 124 users Rating 4.5 of 124 users (124)