What this book covers

Chapter 1, Getting Started, gives an introduction to the Navicat Database Administration tool with a GUI and describes how to set up different kinds of connections, from basic settings to advanced configurations.

Chapter 2, Working with Databases, discusses the fundamentals of working with database objects, such as tables, views, functions, and events, along with designing queries using Navicat's visual tools.

Chapter 3, Data Management with Navicat, takes you through the process of data management. The topics covered are import and export of data in a variety of formats, direct data transfer between different databases, data and structure synchronization, backup/restore operations, and creating and scheduling of batch jobs.

Chapter 4, Data Modeling with Navicat, guides you through the steps involved in visual data modeling, so as to help us learn how to design data models using GUI tools; create, edit, and manipulate table structures from within the visual editor; forward-engineer a data model into a .sql file; and reverse-engineer an existing database into visual representations.

Chapter 5 , Database Maintenance and Security Management, discusses the essentials of basic DBA functions regarding the security and maintenance of MySQL using Navicat. It walks you through the necessary steps to create and edit MySQL users, manage the access privileges, and perform maintenance tasks, such as database analysis, optimization, and repairs.

Chapter 6, Designing Reports with Navicat, discusses report design and provides instructions on the various steps involved in conceiving, creating, and customizing reports based on your MySQL database objects.

Appendix, Additional Tips and Tricks, provides some additional tips and tricks to make the most of Navicat, with guided instructions on how to copy your settings to another Navicat user or computer, monitor the MySQL server, intervene the running processes, power search databases, and discover a new way of designing queries.