D61830 - MySQL for Developers

The 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

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training


 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


 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
 Optimizing Queries
 Stored Routines
 Triggers and Scheduled Events
 Spatial Data
 JSON Data
 Document Store


 Application Developers
 Database Developers
 Software Engineers


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



This course is not associated with any Certification.

Course Benefits

  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses


This training is the first step in mastering MySQL, the world’s most popular open source database.


P10380 - Oracle Database 18c: Administration Workshop


Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.


D83527 - Java SE 8 Fundamentals
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy