Do you want to learn how to develop database applications on MySQL?
Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
Do you want to transfer your data from one server to another?
Then MySQL 5.0 for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.0
This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.
Skills Gained
At the completion of this course, you should be able to:
Describe the MySQL client/server architecture
Understand the steps necessary to invoke MySQL client programs
Utilize the general-purpose mysql client program to run queries and retrieve results
Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
Explain the MySQL connectors that provide connectivity for client programs
Select the best data type for representing information in MySQL
Manage the structural characteristics of your databases
Manage the structural characteristics of the tables within your databases
Utilize the SELECT statement to retrieve information from database tables
Utilize expressions in SQL statements to retrieve more detailed information
Utilize SQL statements to modify the contents of database tables
Write join expressions in your SQL statements to obtain information from multiple tables
Utilize subqueries in your SQL statements
Create views utilizing SELECT statements to produce "virtual tables" of specific data
Perform bulk data import and export operations
Create user defined variables, prepared statements and stored routines
Create and manage triggers
Use the INFORMATION_SCHEMA database to access metadata
Debug MySQL applications
Configure and Optimize MySQL
Who Can Benefit
Developers who want to learn MySQL 5.0
Prerequisites
Having attended the MySQL 5.0 for Beginners course or some experience with Relational Databases and SQL.
Certification:
Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams
Format
Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams
Code:
MySQL5-DEV
Length:
5 days
Type:
Instructor-Led
Certified By:
MySQL
Tuition:
$2,499
This course is taught by Certified MySQL instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Then MySQL for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.0
This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
