MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL is a fast, stable, robust, easy to use, and true multi­user, multi­threaded SQL database server.

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. The MySQL Community Server is the world’s most popular opensource database, used by millions of websites.

In this course, you will learn more advanced features in MySQL, including views, transactions, triggers, and stored procedures. By the end of this copurse, you will know how to facilitate rapid lookups with indexes, search for data in a result set provided by another select statement with subselects, and put database­intensive operations into stored functions and procedures for faster, more modular, and more efficient programming. These techniques allow you to create more optimized and stable databases from web applications to data warehouses.