MySQL for Developers I — A 2 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 MySQL Developer training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience using SQL commands. The course provides practical experience in more advanced MySQL commands and SQL statements.

Objectives

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

The delegate will practise:

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

MySQL for Developers II

Related Courses

MySQL Database Administration

MySQL Performance & Tuning

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 I course and the MySQL for Developers II course will teach the major topics required for the delegate to work towards achieving 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

Client/Server Concepts

The MySQL Client Program

Data Types

Identifiers

Databases

Tables and Indexes

Querying for Data

SQL Expressions and Functions

Updating Data

Connectors