MySQL for Developers II

StayAhead Training Ltd

Course

In Birmingham and London

£ 895 VAT inc.

The best Other Database courses

See all

See all

Description

  • Class hours

    21h

  • Duration

    3 Days

By the end of the course, delegates will be able to: Import and export data Perform complex joins to access multiple tables Perform complex subqueries Manage and use views Use variables and prepared statements Create and use stored routines Create and use triggers Obtain database metadata Debug MySQL applications Understand basic optimisations. Suitable for: MySQL Developers who have an understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course and the MySQL for Developers I course.  The content of the course covers the topics required for the Certified MySQL Developer II 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 good working knowledge of MySQL is required.  This can be gained by attendance on the Introduction to MySQL course, and the MySQL for Developers I 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 complex joins to access multiple tables

Course programme

Delegates:

MySQL Developers who have an understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course and the MySQL for Developers I course. The content of the course covers the topics required for the Certified MySQL Developer II 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:
  • Import and export data
  • Perform complex joins to access multiple tables
  • Perform complex subqueries
  • Manage and use views
  • Use variables and prepared statements
  • Create and use stored routines
  • Create and use triggers
  • Obtain database metadata
  • Debug MySQL applications
  • Understand basic optimisations

Topics Covered:


  • Importing and Exporting Data using SQL
  • Import and Export from the Command Line
  • Complex Joins and Subqueries
  • Managing and Using Views
  • User Variable Syntax and Properties
  • Prepared Statements
  • Stored Routine Definition
  • Procedures and Functions
  • Creating, Dropping and Altering Stored Routines
  • Invoking Stored Routines
  • Trigger Concepts
  • Creating and Using Triggers
  • Privileges for Stored Routines and Triggers
  • Obtaining Database Metadata
  • Debugging MySQL Applications
  • Optimization Principles
  • Storage Engines

Requirements:

A good working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course, and the MySQL for Developers I course.

See related categories

MySQL for Developers II

£ 895 VAT inc.

The best Other Database courses

See all

See all