Introduction to MySQL

StayAhead Training Ltd

Course

In Birmingham, London, Leeds and another venue.

£ 995 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: Outline the structure of a MySQL database Use the MySQL Client Program and other interfaces Create a MySQL database Write SQL statements to select data from a MySQL database Use joins, subqueries, grouping and aggregate functions Use SQL expressions and basic functions Insert, update, delete and replace data Create and. Suitable for: New or existing users of MySQL, who have little or no previous experience with a relational database management system.  This course is suitable for delegates intending to sit the Certified MySQL Associate (CMA) 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
Leeds (West Midlands)
See map
Halsbury House, Chancellor Court, 21 The Calls, LS2 7EH

Start date

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

Start date

On request
Manchester (Greater Manchester)
See map
C/O Yses, St James Court, 30 Brown Street, M2 1DH

Start date

On request

About this course

A basic understanding of IT is required.

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

  • Using client programs to access a MySQL database

Course programme

Delegates:

New or existing users of MySQL, who have little or no previous experience with a relational database management system. This course is suitable for delegates intending to sit the Certified MySQL Associate (CMA) 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:
  • Outline the structure of a MySQL database
  • Use the MySQL Client Program and other interfaces
  • Create a MySQL database
  • Write SQL statements to select data from a MySQL database
  • Use joins, subqueries, grouping and aggregate functions
  • Use SQL expressions and basic functions
  • Insert, update, delete and replace data
  • Create and alter tables, indexes and views
  • Use various data types and constraints
  • Understand how privileges are controlled
  • Understand the principles of transactions
  • Export and Import data

Topics Covered:


  • Client/Server Concepts
  • Relational Database Principles
  • The MySQL Client Program
  • Other MySQL Interfaces
  • Data Types
  • Creating Databases
  • The Basic SELECT Statement
  • Selecting Data from Multiple Tables using JOIN
  • Grouping and Sorting Output
  • Sub-queries
  • String, Temporal and Numeric Functions
  • Creating, Altering and Dropping Tables
  • Creating, Altering and Dropping Views
  • Primary and Foreign Key Constraints
  • Creating and Dropping Indexes
  • Inserting, Updating and Deleting Data
  • Transactions
  • Controlling Access
  • Exporting and Importing Data

Requirements:

A basic understanding of IT is required.

See related categories

Introduction to MySQL

£ 995 VAT inc.

The best Other Database courses

See all

See all