MySQL Administration and Development

Course Description

MySQL is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimisation and performance tuning, and explore various APIs. This course covers MySQL 5.5.

On completion of the course, students will have a better understanding of:

  • introduction to data-base concepts and MySQL
  • installation, configuration, and upgrading
  • the MySQL command-line tool
  • DDL – Data Definition Language
  • data-base design
  • DML – Data Manipulation Language
  • advanced SQL techniques
  • MySQL storage engines
  • queries – the SELECT statement
  • utilities
  • building a result set from several sources.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Perfect. It doesn't get any better (Rating based on 2 reviews)

of respondents recommend this course to a friend.

Click here to Read Reviews

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline