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.