Introduction to MySQL
Course Duration: 3 DAYS - Full Time Course on MySQL
Course Content: Introduction to MySQL
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
MySQL Training and Certification:
Certificate of attendance would be given to participants.
Materials:
Notes in folders will be provided.
Class Size:
8-12 participants
Call (65) 6296-2995 or (65) 9877-3485 to enquire about the MySQL course, or email to training@intellisoft.com.sg