| Course | Duration | ||
| MySQL Administration and Development | 4 days |
Thank you for reading this post, don't forget to subscribe!
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 optimization and performance tuning, and explore various APIs. This course covers MySQL 5.0.
Audience
Application and web developers, or system administrators.
Prerequisites
Prior experience installing software and programming in any language, such as HTML, is recommended but not required.
Course Objectives
- 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 data and data schemas in MySQL.
- Use SELECT to retrieve data from a database.
- Combine data 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.
- Manage database resources and users.
- Write and call stored procedures.
- Optimize database storage for performance.
- Connect MySQL to external programming interfaces.