MySQL for Developers

StayAhead Training Ltd

Course

In London and Birmingham

£ 1,495 VAT inc.

The best Other Database courses

See all

See all

Description

  • Class hours

    35h

  • Duration

    5 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 databases, tables, indexes, views Write complex SQL query statements Use advanced SQL expressions and functions Modify, Import and export data Perform complex joins and. 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 and MySQL Developer II examinations.

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 and MySQL Developer II examinations.

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 databases, tables, indexes, views
  • Write complex SQL query statements
  • Use advanced SQL expressions and functions
  • Modify, Import and export data
  • Perform complex joins and subqueries
  • 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:


  • Client/Server Concepts and Architecture
  • The MySQL Client Program and Connectors
  • Data Types including Bit and Binary
  • Managing Databases, Tables, Indexes and Views
  • Retrieving and Aggregating Data
  • Advanced SQL Expressions and Functions
  • Modifying, Importing and Exporting Data
  • Complex Joins and Subqueries
  • User Variable Syntax and Properties
  • Prepared Statements
  • Stored Routine Definition
  • Procedures and Functions
  • Creating, Dropping and Altering Stored Routines
  • Invoking Stored Routines
  • Trigger Concepts, Creation and Use
  • Privileges for Stored Routines and Triggers
  • Obtaining Database Metadata
  • Debugging MySQL Applications
  • Optimization Principles
  • Storage Engines

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

£ 1,495 VAT inc.

The best Other Database courses

See all

See all