MySQL for Developers Ed 5 Certification Training Course Overview

Enroll for the 5-days MySQL for Developers Ed 5course from Koenig Solutions accredited by Oracle. 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.

Target Audience:

  • Application Developers
  • Database Developers
  • Analyst/Programmer
  • Software Engineers

 

MySQL for Developers Ed 5 (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2850
04 - 08 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 05 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3100
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Introduction to MySQL
  • Topic details are not available.
Module 2: Connectors and APIs
  • Topic details are not available.
Module 3: Using Connectors
  • Topic details are not available.
Module 4: Prepared Statements
  • Topic details are not available.
Module 5: Handling Errors and Warnings
  • Topic details are not available.
Module 7: Tables and Views
  • Topic details are not available.
Module 8: Working with Strings
  • Topic details are not available.
Module 10: Transactions
  • Topic details are not available.
Module 11: Optimizing Queries
  • Topic details are not available.
Module 12: Stored Routines
  • Topic details are not available.
Module 13: Triggers and Scheduled Events
  • Topic details are not available.
Module 14: Reporting
  • Topic details are not available.
Module 15: Spatial Data
  • Topic details are not available.
Module 16: JSON Data
  • Topic details are not available.
Module 17: Document Store
  • Topic details are not available.
Module 18: NoSQL
  • Topic details are not available.
Module 19: Conclusion
  • Topic details are not available.
Download Course Contents

Request More Information

Course Prerequisites

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

Objectives:

  • 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