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.
We can arrange your own private MySQL course.
Have us build a custom private course tailored to your needs.
If you are looking to training a group of people private courses can be very cost effective.
Unlimited post course email support on the course topics.
Fantastic tutor. Great course! Thank you.
Very good course. I've been using the software constantly in the last three months and still learnt a lot.
The trainer 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.
Really enjoyed this course. It delivered exactly what I wanted out it.
Very informative and was at a good pace. Lots of extra useful tips too.
The trainer was very through and very helpful. The course was delivered superbly and I'm very pleased.
You will learn how to build a MySQL database-driven Web application using the PHP scripting language.