Tel: UK 0845 757 3888 | Ireland: 01 284 6796
MySQL for Developers
Course type Essentials (What does this mean?)
| Course title | MySQL for Developers |
|---|---|
| Delivery method |  Classroom |
| RRP | £1650 exc. VAT |
| Days/Duration | 5 |
| Code | SQL4501 |
Secure online payment
- view dates / book course
- course description
- skills paths
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
Tabernacle Street, EC2 |- |- |- |- 
Location Sep Oct Nov Dec view earlier dates Tabernacle Street, EC2 |17 |- |- |- Tabernacle Street, EC2 location information and directions
17 Sep 5 or more places available £1,815 exc VAT MySQL for Developers training in Tabernacle Street, EC2
Special Notices
Courses in London are subject to a 10% surcharge
Overview
The MySQL for Developers course is the foundation course for developers planning on designing and implementingapplications 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.
Students who can benefit from this course:Developers who want to create applications using MySQLStudents wishing to prepare for the MySQL 5.0 Developer Certification Exams.
Audience
- Developers who want to learn MySQL 5.0
Prerequisites
Having attended the MySQL for Beginners (SQL4401) course or some experience with Relational Databases and SQL.
Delegates will learn how to
- Understand the steps necessary to invoke MySQL client programs
- Utilize the general-purpose mysql client program and the MySQL Query Browser graphical user interface (GUI) to run queries and Select the best data type for representing information in MySQL
- Manage the structural characteristics of your databases and 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
Related certification and/or skills paths
This course forms part of the following certification track(s) or skills path(s):
Need help planning your training?
The easiest way to get help planning your training is to call one of our specialists on 0845 757 3888 or to email us info@qa.com. We'll be happy to help.
Related blogs
Did you have a satisfactory course?
Posted by Phil Stirpe on 25 May 2012
I have written and delivered training courses for many years and in all that time there has always been some form of evaluation at the end of the course. Although there are several questions on the current QA evaluation form, the most important is Overall Satisfaction.
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
