Course Duration: 4 Weeks - Part Time Course on MySQL
Course Contents: Introduction to MySQL
Febuary 12 - March 6, 2009
Thursday & Fridays 6:30-9:30pm, 3 hours each session. Total 24 Hours
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.
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
Who Should Attend:
New or existing users of MySQL, who have little or no previous experience with a relational database management system. Both new MySQL Developers and Database Administrators will benefit from this class.
Prerequisites:
Basic computer literacy is required. Knowledge of database concepts would be helpful but is not necessary.
Format:
Instructor led, highly interactive classroom setting with many exercises. Each student will be provided with a PC. You can bring in your laptop notebook for your use in the class.
Applies to MySQL Version:
4.1, 5.0, 5.1
Certification:
Certificate of attendance would be given to participants.
Materials:
Notes in folders will be provided.
Class Size:
8-12 participants
Course Dates: Thursday & Fridays evenings for 4 weeks.
Febuary 12 to March 6, 2009. 6:30pm to 9:30pm, Singapore
Call (65) 6296-2995 or (65) 9877-3485 to enquire about the MySQL course, or email to training@intellisoft.com.sg
