MySQL for Developers II — A 3 day course

contact usEnquire about this course
Retired Course; no longer available

Synopsis

This course has been retired. Please review the five day MySQL for Developers course instead.

This course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Events.

Objectives

By the end of the course, delegates will be able to:

Suitable For

MySQL Developers who have a good understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course and the MySQL for Developers I course.

Related Courses

MySQL Database Administration

MySQL Performance & Tuning

Prerequisites

A good working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course and the MySQL for Developers I course.

Examination

Together with the Introduction to MySQL course and the MySQL for Developers I course, the content of this course covers the major topics required for the MySQL 5.6 Developer Certified Professional Exam (1Z0-882).

Following attendance on the relevant courses, delegates will need to dedicate time for self study and researching the topics covered on the course. They will also need to gain hands-on experience so they can put into practice what they have learnt on the courses.

Attending courses alone will not guarantee exam success, previous experience, practice, self study and aptitude are also key requirements.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course nor in the course fee.

Book your exam with Pearson VUE Testing Services.

Schedule

This course has been retired and is no longer available.


Contents

Obtaining Database Metadata

Debugging

Joins

Subqueries

Views

Import and Export

User Variables and Prepared Statements

Introduction to Stored Routines

Stored Routines - Program Logic

Stored Routines - Exception Handlers & Cursors

Procedures with Parameters

Functions

Triggers

The Event Scheduler

Basic Optimisations

More About Indexes