MySQL for Developers II — A 3-Day Course

 Open Public Course Closed In-House Course

Course Synopsis

The content of this MySQL for Developers course covers the topics required for the 'Certified MySQL Developer II' examination.

Course Objectives

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

• Import and export data
• Perform complex joins to access multiple tables
• Perform complex subqueries
• Manage and use views
• Use variables and prepared statements
• Create and use stored routines
• Create and use triggers
• Obtain database metadata
• Debug MySQL applications
• Understand basic optimisations

Suitable For

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

Course Prerequisities

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.

Publicly scheduled dates, locations, and prices

Contents

Importing and Exporting Data using SQL

Import and Export from the Command Line

Complex Joins and Subqueries

Managing and Using Views

User Variable Syntax and Properties

Prepared Statements

Stored Routine Definition

Procedures and Functions

Creating, Dropping and Altering Stored Routines

Invoking Stored Routines

Trigger Concepts

Creating and Using Triggers

Privileges for Stored Routines and Triggers

Obtaining Database Metadata

Debugging MySQL Applications

Optimization Principles

Storage Engines