Introduction to MySQL — A 3 day course

contact usEnquire about this course

Synopsis

This course covers the basics of the SQL language as implemented by MySQL.

The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench.

The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.

Objectives

To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.

The delegates will practise:

Suitable For

Anyone who needs to access and work with a MySQL Database.

Follow-On Courses

MySQL for Developers I

MySQL for Developers II

MySQL Database Administration

MySQL Performance & Tuning

Prerequisites

There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.

Examination

This course together with the MySQL for Developers I and MySQL for Developers II courses covers the major topics required for the MySQL 5.6 Developer Certified Professional Exam (1Z0-882).

Together with the MySQL Database Administration course, this Introduction to MySQL course will teach the major topics required for the delegate to work towards achieving the MySQL 5.6 Database Administrator Certified Professional Exam (1Z0-883).

Following attendance on the relevant courses, delegates will need to dedicate time for self study and researching the topics covered on the course. They will also need to gain hands-on experience so they can put into practice what they have learnt on the courses.

Attending courses alone will not guarantee exam success, previous experience, practice, self study and aptitude are also key requirements.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course nor in the course fee.

Book your exam with Pearson VUE Testing Services.

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 2 February 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £995 (+VAT)

Manchester — £995 (+VAT)


Contents

Database Concepts

Using The MySQL client

Basic SELECT

LIMIT, UNION and Aggregate functions

Subqueries and Joins

Numeric and Character functions

Date, Time and Other Functions

Databases and Tables

Indexes and Views

Managing Data

Access Control

Import and Export