Preface

Navicat is a GUI tool used for managing every aspect of a MySQL Server, such as managing visual tools as well as an intelligent code editor for handcoding SQL and stored procedures. While some of its features are fairly intuitive, some of them require guidance to be discovered and learned.

The book starts with creating basic server connection setups, designing databases from scratch, or importing existing data. Then it continues with using advanced features, such as designing functions and stored procedures, creating event triggers, and creating and scheduling batch jobs.

The chapters are ordered in a logical progression, where the user starts from simple structures to complex design, and is gradually introduced to advanced features. By the end of the last chapter, the reader should be able to handle every aspect of database administration as well as how to master the intelligent code editor, in the case of a development need, such as functions and procedures.

For intermediate and advanced level MySQL users and administrators, the book could be used as a reference guide, and chapters need not be followed in any order.