MySQL Development

Catalog Home Front-End Web & Mobile Development PHP & MySQL
Your Training Location:  

MySQL Development

Instructor Led
Loading Course Dates...
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
ViewHide Additional Dates

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, and learn about optimization. Also included is an exploration of various APIs. This course covers MySQL 5.5.

Prior experience programming in any language, such as HTML, is recommended but not required.

3 Days/Lecture & Lab

This course is designed for application and web developers.

  • Describe MySQL’s benefits and features.
  • Configure the MySQL server.
  • Perform database design and normalization.
  • Work with the command-line MySQL tool
  • Set up and manage date and data schemas in MySQL.
  • Use SELECT to retrieve data from a database.
  • Combine date from multiple sources.
  • Utilize more complex SQL functionality.
  • Understand the MySQL storage engine types and their applicability.
  • Use some of the more common MySQL standalone tools.
  • Write and call stored procedures.

< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media