MySQL for Developers — A 5 day course

contact usEnquire about this course

Synopsis

This MySQL Developers training 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 Event Scheduling.

Objectives

To provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.

The delegates will practise:

Contents

Client/Server Concepts

The MySQL Client Program

Data Types

Identifiers

Databases

Tables & Indexes

Querying for Data

SQL Expressions & Functions

Updating Data

Connectors

Obtaining Database Metadata

Debugging

Joins

Subqueries

Views

Import & Export

User Variables & Prepared Statements

Introduction to Stored Routines

Stored Routines - Program Logic

Stored Routines - Exception Handlers & Cursors

Procedures with Parameters

Functions

Triggers

Basic Optimizations

More About Indexes

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 13 April 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1495 (+VAT)

Suitable For

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

Follow-On Courses

Prerequisites

A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.

Examination

Together with the Introduction to MySQL course, the content of this MySQL for Developers course will teach the major topics required for the delegate to work towards achieving the MySQL 5.6 Developer Certified Professional Exam (1Z0-882).

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.