MySQL for Developers I

StayAhead Training Ltd

Course

In Birmingham and London

£ 675 VAT inc.

The best Other Database courses

See all

See all

Description

  • Class hours

    14h

  • Duration

    2 Days

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.  The content of the course covers the topics required for the Certified MySQL Developer I examination.

Facilities

Location

Start date

Birmingham (West Midlands)
See map
C/O Netcom Training Solutions, 6th Floor, Quay Side Tower, Broad Street, Birmingham B1 2hf, B5 4UA

Start date

On request
London
See map
6 Long Lane, Barbican, EC1A 9HF

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Performing advanced Insert
  • Update
  • Delete
  • Replace and Truncate Operations

Course programme

Delegates:

MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. The content of the course covers the topics required for the Certified MySQL Developer I examination .

Note:

Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

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

Topics Covered:


  • 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

Requirements:

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

See related categories

MySQL for Developers I

£ 675 VAT inc.

The best Other Database courses

See all

See all