This course is designed to provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.
It 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 Query Browser. The basic SQL statements,including the use of SQL functions and the basic table and view handling statements are introduced.
The delegates will practise:
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
Granting and revoking access privileges on tables and views
Exporting and importing data
There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.
There are currently no public dates for this course. This course can be run as a private course either at one of our training centers or at your offices. To get pricing for this use our quote wizard to generate a customised quote or call us on 0118 324 3000 to discuss your requirements.
Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.
This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!