course overview
download outline
Overview
This MySQL for Developers training teaches developers how to develop console and web applications using MySQL with their choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities to teach you how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and use MySQL support for “NoSQL”. In this course, you will be introduced to the MySQL Cloud Service.
Learn To:
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.
Audience
MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.
Skills Gained
Prerequisites
Required Prerequisites:
Suggested Prerequisites:
Those delegates who are attending via either virtual or extended classroom will be required to provide either dual monitors or single monitor plus a tablet device.
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
Subqueries
Modifying Table Data
Transactions
Query Optimization
Stored Routines
Triggers and Scheduled Events
Reporting
NoSQL
Spatial Data
Conclusion
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.
Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.
All $ prices are in USD unless it’s a NZ or AU date
SPVC = Self Paced Virtual Class
LVC = Live Virtual Class
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.