Overview

Keep your mission-critical applications and essential services up and running with comprehensive MySQL training.

To grow your skillset and be more productive in your job, access a rich library of digital courses at your own convenience, then test your new skills through interactive, hands-on labs. Deepen your understanding of MySQL administration, development, security, and high availability in a risk-free environment through role- and topic-based courses. Learn what you need to know to deliver high-performance and scalable applications, then create new opportunities by getting MySQL certified.

The OM-D: MySQL for Developers training course teaches developers you how to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities in which you will learn how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and how to use MySQL’s support for JSON and spatial data.

Learn to:

  • Program with Connectors
  • Write console and web applications
  • Optimize query performance
  • Write stored routines and triggers
  • Store, access, and analyze geospatial data
  • Use X DevAPI to access JSON data in document store

Skills Covered

  • Create MySQL client programs in PHP, Java, and Python using Connectors
  • Use prepared statements to execute similar queries with different parameters
  • Protect against SQL injection using prepared statements
  • Interpret and handle errors and warnings
  • Create database-driven web applications
  • Work with views
  • Manipulate string data with functions and operators
  • Use temporal and numeric functions in expressions
  • Use transactions to group multiple SQL statements into an atomic operation
  • Identify and optimize poorly performing queries
  • Write stored routines, triggers, and scheduled events
  • Aggregate and summarize data to create reports
  • Store spatial and JSON data using MySQL native data type
  • Query and manipulate spatial and JSON data using functions and operators
  • Store JSON documents using MySQL Document Store
  • Use X DevAPI to access document store and relational data

Who Should Attend

  • Application Developers
  • Database Developers
  • Analyst/Programmer
  • Software Engineers

Course Curriculum

Prerequisites

Developing simple web applications using PHP, Java/JSTL, or Python Basic HTML Knowledge of JavaScript Object Notation (JSON)

Download Syllabus

Course Modules

Request More Information