This section covers the advanced MySQL concepts including triggers, views, indexes, stored procedures, full-text searches, and administration.
MySQL Triggers
MySQL triggers are stored programs executed automatically to respond to specific events associated with a table such as an insert, update or delete. This section shows you how to work with MySQL triggers effectively.
MySQL Views
This tutorial introduces you to MySQL Views, which are named query stored in the database, and shows you step by step on how to manage views effectively.
MySQL Index
This section introduces you to the MySQL index concept and shows you how to manage indexes in MySQL to optimize your queries.
MySQL Tips
We provide you with the advanced MySQL techniques and tips to help you solve the most difficult challenges in MySQL effectively.
MySQL Administration
In this tutorial series, you will learn about MySQL administration including security, maintenance, backups, and restores.