MYSQL FOR DEVELOPER

MYSQL FOR DEVELOPER

Summary

Location

Location

Malaysia

Duration

Duration

5 Days
Format

Format

Public Class

Public Class

Course Details

Course duration: 5 days; Instructor-led

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

Audience

  • Application Developers
  • Database Developers
  • Analyst/Programmer

Prerequisites

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

Methodology

This course is highly interactive and uses diverse teaching methods (lectures, self-assessments, group discussions, activities, and videos) to accommodate different learning styles This training will also leverage on participant’s personal life and work experiences.

Course Objectives

Upon completion of this program, participants should be able to :

  • 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

Outlines

Trainers

Reviews

Interested In

MYSQL FOR DEVELOPER

Starting From
RM6500
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: MYSQL FOR DEVELOPER
Duration: 5 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *