Introduction To MYSQL Course

Course Overview

The Introduction to MySQL 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.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered. The delegate will learn and acquire skills as follows:

• Using client programs to access a MySQL database

• Creating, altering and dropping a MySQL database

• Writing SQL statements to select data from a MySQL database

• Writing joins and subqueries

• Using SQL expressions

• Using SQL aggregate functions and scalar functions

• Inserting, updating, deleting and replacing rows

• Creating and altering tables, indexes and views

• Using transactions

• Granting and revoking access privileges on tables and views

• Exporting and importing data

Entry Requirements

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

Course Objectives

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