This course covers the basics of SQL as used in 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 all covered.
Delegates will appreciate:
Delegates who need to access and work with a MySQL Database.
To provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.
There are no specific prerequisites, although an understanding of databases in general would be useful.
Using the MySQL Client
LIMIT, UNION and Aggregate Functions
Subqueries and Joins
Numeric and Character Functions
Date, Time and Other Functions
Databases and Tables
Indexes and Views
Import and Export Using SQL and Command Line
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.