Advanced MySQL

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.