MySQL is the world’s most popular open source database. Whether you’re a beginner or an experienced user, a MySQL database administrator, MySQL developer, or a MySQL security administrator, Oracle MySQL courses helps you develop deeper knowledge of relational databases so you can manage your MySQL applications more efficiently.
To design and implement applications that make use of MySQL, companies look to Oracle MySQL Developers. With MySQL Developer training, learn the ins and outs of data design, querying, and programming from expert Oracle trainers.
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
Prerequisites
Developing simple web applications using PHP, Java/JSTL, or Python Basic HTML Knowledge of JavaScript Object Notation (JSON)
Target Audience
- Application Developers
- Database Developers
- Analyst/Programmer
- Software Engineers
Course Outline
- Introduction to MySQL
- Connectors and APIs
- Using Connectors
- Prepared Statements
- Handling Errors and Warnings
- Building Database-Driven Web Applications
- Tables and Views
- Working with Strings
- Working with Numeric and Temporal Data
- Transactions
- Optimizing Queries
- Stored Routines
- Triggers and Scheduled Events
- Reporting
- Spatial Data
- JSON Data
- Document Store
- NoSQL
- Conclusion
Dates & Locations
July 13, 2026 - July 17, 2026
July 13, 2026 - July 17, 2026
September 21, 2026 - September 25, 2026
September 21, 2026 - September 25, 2026
November 16, 2026 - November 20, 2026
November 16, 2026 - November 20, 2026
Exam & Certification
MySQL 8.0 Database Developer Oracle Certified Professional (1Z0-909)
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
