Back
|
|
|
MySQL for Developers
Delegates: |
|
MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. The content of the course covers the topics required for the Certified MySQL Developer I and MySQL Developer II examinations.
|
Note: |
|
Before taking any exam, ensure you have the recommended experience.
|
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
|
Topics Covered: |
- 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
|
Requirements:
|
|
A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course. |
|
|
|
