MySQL for Developers :: MySQL5-DEV

ExitCertified Canada English

ExitCertified Canada French



	start > courses and registration > training feature sheet

MySQL for Developers

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

MySQL5-DEV

length.

5 days

type.

Instructor-Led

partner.

MySQL

price.

$2,499

	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.

course schedule

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

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.

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

certification:

Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams

format

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

related courses, exams and materials

	before related training and products

MySQL for Beginners

course content details

	Course Topics

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.

Rock solid authorized training. Search all courses now...

Give your team direction. Authorized IT education.

	go to top

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include: