HRD Corp Claimable Course
Live Virtual Class
Public Class
In House Training
Private Class
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. The 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”.
You will learn how to Program with Connectors, Write console and web applications, Optimize query performance, Write stored routines and triggers, Use the InnoDB memcached plugin for NoSQL access to your data, Store, access, and analyze geospatial data and Gain an understanding of the MySQL Cloud Service.
This MySQL for Developer course is available on our public class training in Kuala Lumpur or also available if you want to conduct In-House training at your venue, throughout Malaysia. Since 2020, we conduct this class through live virtual class.
Who should attend?
Working knowledge of MySQL is required or attended the Introduction to MySQL course.
MySQL Database Developer Oracle Certified is among the most sought-after badges of credibility for expertise in the Information Technology marketplace. It demonstrates that you have a solid understanding of your job role and of MySQL Development.
Consultants, developers and DBAs use Oracle certifications on MySQL to show prospective employers and customers that they are current on the latest features, tools and tricks.
Students wishing to prepare for the MySQL 8.0 Developer Certification Exams.
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
Spatial Data
JSON Data
Document Store