MySQL for Developers II

PPi Learning Services

Course

In London

£ 895 + VAT

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • 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

Facilities

Location

Start date

London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

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

Course programme

Course content
  • Importing and Exporting Data usingSQL
  • 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

See related categories

MySQL for Developers II

£ 895 + VAT

The best Other Database courses

See all

See all