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 examination.
|
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 the structure of databases and tables
- Manage and use indexes
- Write complex SQL query statements
- Use advanced SQL expressions and functions
- Modify data
|
Topics Covered: |
- Client/Server Concepts and Architecture
- The MySQL Client Program in interactive and batch modes
- Connector/J, Connector/ODBC, Connector/NET
- Advanced Data Types including Bit and Binary
- Managing the Database
- Managing and Using Tables
- Managing and Using Indexes
- Retrieving and Aggregating Data
- Advanced SQL Expressions and Functions
- Further Insert, Update, Delete, Replace and Truncate Operations
|
Requirements:
|
|
A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course. |
