MySQL for Developers — A 5-Day Course

 Open Public Course Closed In-House Course

Course Synopsis

The content of the course covers the topics required for the Certified MySQL Developer I and MySQL Developer II examinations.

Course Objectives

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

• Understand MySQL Client/Server concepts
• Use advanced features of the MySQL Client
• Understand various types of Connector
• Use advanced data types
• Manage databases, tables, indexes, views
• Write complex SQL query statements
• Use advanced SQL expressions and functions
• Modify, Import and export data
• Perform complex joins and subqueries
• 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 a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course

Course Prerequisities

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

Publicly scheduled dates, locations, and prices

Contents

Client/Server Concepts and Architecture

The MySQL Client Program and Connectors

Data Types including Bit and Binary

Managing Databases, Tables, Indexes and Views

Retrieving and Aggregating Data

Advanced SQL Expressions and Functions

Modifying, Importing and Exporting Data

Complex Joins and Subqueries

User Variable Syntax and Properties

Prepared Statements

Stored Routine Definition

Procedures and Functions

Creating, Dropping and Altering Stored Routines

Invoking Stored Routines

Trigger Concepts, Creation and Use

Privileges for Stored Routines and Triggers

Obtaining Database Metadata

Debugging MySQL Applications

Optimization Principles

Storage Engines