Delegates: |
|
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. The content of the course covers the topics required for the Certified MySQL Developer II examination.
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
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
|
Topics Covered: |
- 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
|
Requirements:
|
|
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. |
