Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool.
Install the MySQL server
Describe the features and benefits of MySQL
Describe the basics of relational databases
Understand the features and benefits of MySQL
Install and start the MySQL server
Understand the basics of relational databases
Understand the SQL and MySQL languages
Understand Data/Column types with regard to efficient database design
View a database design structure and content
Create a database design using an efficient structure
Extract basic database information using the SELECT command
Troubleshoot syntax and understand typical warnings and errors
Delete or modify a database, and table row data
Group query data with aggregation
Connect data from multiple table rows using JOIN
Perform nested sub-queries
Use simple functions (String, Date, Numerical)
Describe MySQL connectors, their major features and differences
Understand MySQL storage engines, transactions and features of the common engines
Basic computer literacy is required
Previous experience with any command-line program
Knowledge of database concepts
Please note: In order to provision you with your courseware and lab access for this course CourseMonster must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our CourseMonster Partner data sharing page. If you have any questions or concerns please contact your CourseMonster account manager.
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.