Site Sections => About Us | Consultancy | Training | Software | Publications | Open Source | Support | Open Standards | FAQ | Jobs
Site Style Info

MySQL for Developers I — A 2-Day Course

Course Synopsis

The content of this MySQL for Developers course covers the topics required for the 'Certified MySQL Developer I' examination.

Course Objectives

By the end of the course, delegates will be able to:

  • Understand MySQL Client/Server concepts
  • Use advanced features of the MySQL Client
  • Understand various types of Connector
  • Use advanced data types
  • Manage the structure of databases and tables
  • Manage and use indexes
  • Write complex SQL query statements
  • Use advanced SQL expressions and functions
  • Modify data

Suitable For

  • MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.

Course Prerequisities

A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.

Publicly scheduled dates, locations, and prices

Central London — £675 (+VAT)

  • 16–17 Jun 2008
  • 4–5 Aug 2008

Contents

Client/Server Concepts and Architecture

The MySQL Client Program in interactive and batch modes

Connector/J, Connector/ODBC, Connector/NET

Advanced Data Types including Bit and Binary

Managing the Database

Managing and Using Tables

Managing and Using Indexes

Retrieving and Aggregating Data

Advanced SQL Expressions and Functions

Further Insert, Update, Delete, Replace and Truncate Operations

MySQL training UK enquiries

UK Training enquiries and feedback form.

MySQL training UK prices

For publicly scheduled training (individual places), see our UK training schedule.

In-house training for company groups is charged at a daily rate per group — see our In-House UK Training Guidelines.

Publicly Scheduled Training Locations

We currently run public training courses in the following locations:

  • London, UK
  • Leeds, West Yorkshire, UK
  • Birmingham, West Midlands, UK
  • Carshalton, Surrey, UK
  • Chester, North West, UK
  • Coventry, West Midlands, UK
  • Edinburgh, Scotland, UK
  • Glasgow, Scotland, UK
  • Harwell, Oxfordshire, UK
  • Manchester, North West, UK
  • Milton Keynes, Buckinghamshire, UK
  • Newark, Nottinghamshire, UK
  • Reading, Berkshire, UK
  • Slough, Berkshire, UK
  • Stevenage, Hertfordshire, UK
  • Wakefield, West Yorkshire, UK
  • Wokingham, Berkshire, UK

Most UK public training courses are available on a monthly basis.

Please see the individual course outlines or our public training schedule for details.

In-house (on-site) training locations

We deliver in-house courses at client premises and/or training facilities in any part of the world which is practically and commercially accessible.

Our In-house training guidelines outline our basic requirements and our UK pricing structure. To estimate costs for training in other countries, simply convert to your local currency and then make a rough calculation of our tutor's costs for travelling to and staying at your location.


West Yorkshire Office

GBdirect Ltd
Training Division
Bradford Design Exchange
34 Peckover Street
BRADFORD
BD1 5BD
West Yorkshire
United Kingdom

training@gbdirect.co.uk

Training: 0800 651 0338
General: +44 (0)870 200 7273
Finance: +44 (0)1353 615 174

Please call between 0900 and 1700 (UK time) on Monday to Friday


South East Regional Office

GBdirect Ltd
Training Division
18 Lynn Rd
ELY
CB6 1DA
Cambridgeshire
United Kingdom

training@gbdirect.co.uk

Training: 0800 651 0338
General: +44 (0)870 200 7273
Finance: +44 (0)1353 615 174

Please call between 0900 and 1700 (UK time) on Monday to Friday


Please note:
Non-training enquiries should be directed, initially, to our UK national office in Bradford (West Yorkshire), even if the enquiry concerns services delivered in London or South/East England. Clients in London and the South East will typically be handled by staff working in the London or Cambridge areas.