SQL
your venue or ours 
| home | | | contact | | |  | email us | | | enquire | | | times etc | | | comments | | | find us |
MySQL Foundation
Course Description ( MSQ-68: a 2 day course )
This MySQL training course is for those charged with maintaining and using MySQL. It focuses on developing the skills required to create and maintain MySQL relational databases. A highly practical course based on a mix of lectures and well designed projects, it can be delivered on either the Windows or Linux platforms. If delivered at your venue, we can supply all equipment already setup for the course. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are provided on a free USB pen drive to take away.
Suggested Prerequisites
While the course is for those with little or no experience of working with MySQL, it is a course for IT Professionals. No prior MySQL training or relational database experience is assumed.
Relational Databases and MySQL
- The Relational Model
- Keys Explained
- Normalization
- About the SQL Syntax
- Working with Data Types in MySQL
- Database Servers
- Using the MySQL Client
Core MySQL
- Setting Up a Database
- Securing the Database
- Populating Tables
- Retrieving Data from a Table
- Using SELECT and FROM
- Sorting Rows
- Filtering and Combining
- WHERE, AND, OR, NOT, LIKE
- Using Operators
- Working with MySQL Functions
- Using Derived Columns
Applied MySQL
- Summarizing and Grouping
- Using GROUP BY and HAVING
- Data from Multiple Tables
- Qualifying Column Names
- Using Different Types of Joins
- Inserting, Updating and Deleting
- Working with Indexes
Administration and Integration
- Optimization
- Backup and Restore
- MySQL and Perl (if relevant)
- MySQL and PHP (if relevant)
- MySQL and ODBC (if relevant)
On Site Requirements
Remember, we provide all equipment and software required to deliver a course at your premises. Aside from this, we need a suitably quiet and equipped room with enough work space for each attendee and a whiteboard or flipchart. Most courses involve the use of a PC projector and we bring our own. But either a projector screen, or usually just a clear wall, would be very helpful.
Other Courses to Consider
- MSQ-67: SQL Querying for MySQL
Constructing successful SQL queries to extract data from MySQL databases. - MSQ-69: Introduction to SQL for MySQL
Introduction to SQL for those who need to extract and update MySQL data and objects. - MSQ-70: A Foundation in SQL for MySQL
A 3-day foundation in SQL for those who need to both query and modify MySQL data and create MySQL databases and tables.