Learn how MySQL, a powerful relational database management system can make your life easier and fun! This class covers all the basics and will get you on your way to database mastery, with a solid foundation in MySQL.

Manage and maintain large amounts of data using the MySQL database. This instructor led, hands-on class on MySQL covers the fundamentals of SQL and relational databases using MySQL. Click to get more info

Learning Outcomes:
Upon completion of the Introduction to MySQL course, you will be able to:

MySQL Versions Covered
MySQL 5.0, command-line and graphical clients/tools.

• Understand the features and benefits of MySQL
• Be able to install and start the MySQL server
• Understand the basics of Relational Database Management Systems
• Understand the SQL and MySQL languages
• Understand Data/Column types with regard to efficient database design
• Be able to view a database design structure/content
• Create a database design using an efficient structure
• Be able to extract basic database information using the SELECT command
• Be able to troubleshoot syntax and understand typical warnings and errors
• Be able to modify or delete a database
• Be able to modify or delete table row data
• Grouping query data with Aggregation
• Connect data from multiple table rows using JOIN
• Perform nested sub-queries
• Use of Simple Functions (String, Date, Numerical)
• Understand the primary methods for exporting and importing data
• Describe MySQL connectors, their major features and differences.
• Understand MySQL storage engines, transactions and features of the common engines

Register for MySQL 2 day course for only S$780 Discount is available for a minimum of 3 registrations

Register Now!

OTHER MAJOR COURSES

MICROSOFT OFFICE
Advanced Excel 2007/2010
Basic-Intermediate Excel 2007/2010
Excel 2007/2010 VBA Macro
MS Project 2007/2010
MS Access 2007

PROJECT MANAGEMENT
PMP Exam Preparation training course
*(CITREP EXANDED grant available)
Better Project Management