MySQL Developer Techniques

Duration

3 days

Description:

• Are you being asked to design very complex queries to meet the demanding needs of your end users?
• Are you struggling with how to properly design queries to be more efficient while at the same time ensuring the performance of the these queries is not degraded?
• Do you want to be able to utilize advanced SQL features in your complex queries while at the same time improving the design of the queries to support better query performance?
• Do you want to learn tips and tricks that will improve not only the database applications you support but also make the tasks you are assigned easier to complete?
• Are you interested in creating and utilizing tree and hierarchical data structures with MySQL?
• Do you want to be more efficient in the way that you develop database applications with MySQL?:

If you answered YES to any of these questions, the MySQL Developer Techniques course is for you!

This instructor-led course is designed for MySQL developers who wish to obtain the skills required to create complex queries and efficient structures while improving the performance of their database applications. In addition, the MySQL developers will also be provided with additional query writing techniques that support creating reports that support the end users along with the skills required to create and utilize trees and hierarchical data structures.

At the completion of this course, you should be able to:

• Utilize the multiple indexing options available to create better response times of query executions
• Improve the design of joins to minimize performance related issues and produce better results
• Design and optimize queries that are responsible for searching text and date fields
• Design and utilize queries that perform complex calculations and aggregations
• Create report queries that provide the end users with precise and organized data
• Explain the affect locking levels have on query performance
• Improve the process of importing data into MySQL
• Design and work with tables that utilize tree and hierarchical data structures
• Utilize multiple MySQL tips and tricks to complete database development tasks in a more efficient and timely manner

Who Should Attend

Certified MySQL Developers and others with similar experience who want to utilize advanced SQL features to create queries that will result in better results and improved performance of their database queries.

Prerequisites

Attendance to the MySQL for Developers course, or an equivalent mastery of database concepts, SQL and the MySQL server.

Format

• Instructor led, with hands-on lab exercises
• Each student will be provided with their own computer

Applies to MySQL Version:

5.0.x, 5.1.x

Upcoming Sessions