MySQL for Developers

Location


Format What’s this?

Ways to train

Classroom
Live, instructor-led training in a standard, professional classroom environment

Virtual
Live, instructor-led training conducted over the internet, with hands-on labs

Online
An online, HTML5, self-paced learning experience available for all courses

On-site
Private training for your entire team, delivered at your location, a training center, or online

Video classroom
High-definition video of our most popular courses, streamed to your laptop or personal device
Learn more about our training formats

Starting From

RM 3705.00

40 Hours

HRDF SBL Claimable
Certificate of Attendance available
90 days of access from date of activation

Get started

Starting From

RM 5900.00

5 Day with 08 hours per day

Mon 06 Dec 09:00 - Fri 10 Dec 17:00

HRDF SBL Claimable
Certificate of Attendance available

Get started

5 Days

All of our private classes are customized to your organization's needs.
Click on the button below to send us your details and you will be contacted shortly.

Already purchased this offering? Log in

Request more information

Inquiry for: Myself My Company

By providing your contact details, you agree to our Privacy Policy

Thank You

Our learning consultant will get back to you in 1 business day

MySQL for Developers

Course Details
Modules
Trainers
Reviews

WHAT YOU WILL LEARN

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.

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

Developers who want to create applications using MySQL
Students wishing to prepare for the MySQL 5.0 Developer Certification Exams

PREREQUISITES

Have attended the MySQL for Beginners course or some experience with Relational Databases and SQL

SUGGESTED PREREQUISITES:

MySQL For Beginners (SQL-4401)

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and hands-on labs. This course can be conducted as instructor-led (ILT) or virtual instructor-led training (VILT).

COURSE OBJECTIVES

At the completion of this course, you should be able to:

Understand the steps necessary to invoke MySQL client programs
Utilize the general-purpose MySQL client program and the MySQL Query Browser graphical user interface (GUI) to run queries
Select the best data type for representing information in MySQL
Manage the structural characteristics of your databases and the tables within your databases
Utilize the SELECT statement to retrieve information from database tables
Utilize expressions in SQL statements to retrieve more detailed information
Utilize SQL statements to modify the contents of database tables
Write join expressions in your SQL statements to obtain information from multiple tables
Utilize subqueries in your SQL statements
Create views utilizing SELECT statements to produce virtual tables of specific data
Perform bulk data import and export operations
Create user defined variables, prepared statements and stored routines
Create and manage triggers
Use the INFORMATION_SCHEMA database to access metadata
Debug MySQL applications
Configure and Optimize MySQL

Expand All

Modules

Introduction

MySQL Overview, Products and Services
MySQL Enterprise Services
Supported Operating Services
MySQL Certification Program
Training Curriculum Paths
MySQL Website
Installing MySQL and the World Database

MySQL Client / Server Concepts

MySQL General Architecture
How MySQL uses Disk Space
How MySQL uses Memory

MySQL Clients

Invoking Client Programs
Using Option Files
The MySQL Client
MySQL Query Browser
MySQL Connectors
Third-Party APIs

Querying For Table Data

The SELECR Statement
Aggregating Query Results
Using UNION

Handling Errors And Warnings

SQL Modes
Handling Missing or invalid Data Values
Interpreting Error Messages

SQL Expressions

SQL Comparisons
Functions in SQL Expressions
Comments in SQL Statements

Data Types

Data Type Overview
Numeric Data Types
Character String Data Types
Binary String Data Types
Temporal Data Types
NULLs

Obtaining Metadata

Metadata Access Methods
The INFORMATION_SCHEMA Database / Schema
Using SHOW and DESCRIBE
The mysqlshow Command

Databases

Database Properties
Good Design Practices
Identifiers
Creating Databases
Altering Databases
Dropping Databases

Tables

Creating Tables
Table Properties
Column Options
Creating Tables based in Existing Tables
Altering Tables
Dropping Tables
Foreign Keys

Manipulating Table Data

The INSERT Statement
The DELETE Statement
The UPDATE Statement
The REPLACE Statement
INSERT with ON DUPLICATE KEY UPDATE
The TRUNCATE TABLE Statement

Transaction

What is a Transaction?
Transaction Commands
Isolation Levels
Locking

Joins

What is a Join?
Joining Tables in SQL
Basic Join Syntax
Inner Joins
Outer Joins
Other Types of Joins
Joins in UPDATE and DELETE Statements

Subqueries

Types of Subqueries
Table Subquery Operators
Correlated and Non-Correlated Subqueries
Converting Subqueries to Joins

Views

What are Views?
Creating Views
Updatable Views
Managing Views
Obtaining View Metadata

Prepared Statements

Why use Prepared Statements?
Using Prepared Statements from the mysql Client
Preparing a Statement
Executing a Prepared Statement
De-allocating a Prepared Statement

Exporting And Importing Data

Exporting and Importing Data
Exporting ad Importing Data using SQL
Exporting and Importing Data using MySQL Client Programs
Import Data with the SOURCE Command

Stored Routines

What is a Stored Routine?
Creating, Executing and Deleting Stored Routines
Compound Statements
Assign Variables
Parameter Variables
Parameter Declarations
Flow Control Statements
Declare and use Handlers
Cursors

Triggers

What are Triggers?
Delete Triggers
Restrictions on Triggers

Storage Engines

SQL Parser and Storage Engine Tiers
Storage Engines and MySQL
The MyISAM Storage Engine
The InnoDB Storage Engine
The MEMORY Staorage Engine
Other Storage Engines

Optimization

Overview of Optimization Principles
Using Indexes for Optimization
Using EXPLAIN to Analyze Queries
Query Rewriting Techniques
Optimizing Queries by Limiting Output
Using Summary Tables
Optimizing Updates
Choosing Appropriate Storage Engines

Oracle Certified Trainer

Genesis Douglas Row

Mr. Genesis Douglas Row has been working in the IT industry since 1996 and has contributed more than 17 years to the industry. Along the years, he has picked up skills in sales, marketing, business management, presales and product management that has made him an all-rounded skilled and experienced IT personnel in the industry.He has a strong technical background in Oracle Database Management, Solaris System Administration and Web Publishing. He has also proven to be a very talented and passionate trainer in delivering easy-to-understand, straight-to-the-point training sessions. He utilizes effective training techniques for maximum knowledge transfer, information retention and customer satisfaction. Read More

Course Reviews

No Remarks

0

0 Ratings