Contact Sales
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 653 0071
Germany: +49 89 420 95 98 95
France: +33 1 70 38 72 00
Sweden: +46 730 234 111
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 653 0071
Asia Pacific: +81 3 5918 7507
Learn about new MySQL releases, technical articles, events and more.
MySQL for Developers (5 days)
- 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?
- 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
- Certification:
-
- Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams
- Who should Attend
-
- 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.
- Format
-
- Instructor led, with hands-on lab exercises
- Each student will be provided with their own computer
- Applies to MySQL Version:
- 5.0, 5.1
- Duration
- 5 Days.
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.
Upcoming Sessions
© 1995-2008 MySQL AB. All rights reserved.