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

Benefits to you

This course will teach you how to write applications that maximize your investment in MySQL. You will learn best practice techniques for writing programs that store and retrieve MySQL data and present it to users in a way that allows them to gain insight into that data.

Course Modules

• 1. Introduction to MySQL
• 2. Connectors and APIs
• 3. Using Connectors
• 4. Prepared Statements
• 5. Handling Errors and Warnings
• 6. Creating Database-Driven Web Applications
• 7. Working with Views
• 8. Working with Strings
• 9. Working with Numeric and Temporal Data
• 10. Transactions
• 11. Optimizing Queries
• 12. Stored Routines
• 13. Triggers and Scheduled Events
• 14. Reporting
• 15. Spatial Data
• 16. JSON Data
• 17. Document Store
• 18. Conclusion