MySQL for Beginners Training Course

Course Outline

MySQL for Beginners course overview

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.

Delegates will learn:

• Understand the features and benefits of MySQL
• Be able to 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
• 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 delete or modify a database, and 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)
• Describe MySQL connectors, their major features and differences
• Understand MySQL storage engines, transactions and features of the common engines

This short MySQL course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public MySQL wtraining course is given on training dragon website.

Who is MySQL for Beginners training for?

Students who can benefit from this course:

• New or existing users of MySQL, who have little or no previous experience with a relational database management system.

Prerequisites for MySQL for Beginners course

Required Prerequisites:

• Basic computer literacy is required

Suggested Prerequisites:

• Previous experience with any command-line program
• Knowledge of database concepts

What will I get?

• Training from professional MySQL certified trainers:

  Training Dragon consultants have been implementing professional MySQL Server Database solutions across a range of companies for many years. Those consultants write and teach our MySQL training courses, so their experience directly informs course content.

• Practical Projects:

  This MySQL training is designed to prepare you not only for MySQL certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical MySQL related exercises in this MySQL course. This will ensure that you can apply the knowledge gained from this course to your work environment.

• Course Material and Practice exams:

  MySQL electronic notes are included in this course. You will also take practice exams as part of the course.

• Course Completion Certificate:

  After completing this training you will receive MySQL course completion certificate.

• Support and Careers Advice:

  After the course if you have any problems or questions regarding MySQL, do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.

• Pass Guarantee and Train again for Free:

  We are sure that you will pass your MySQL certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.

• Official Course Curriculum:

  This MySQL certification course is based on the official Microsoft recommended course syllabus.