Home Specialist skills Technology and Software Introduction to MySQL

Introduction to MySQL

Creating, altering and dropping a MySQL database
Inserting, updating, deleting and replacing rows
Creating and altering tables, indexes and views
Granting and revoking access privileges on tables and views
Exporting and importing data

Overview

The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give learners practical experience in writing SQL statements using the MySQL client programme and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements, are introduced.