MySQL Management and Administration with Navicat

Master the tools you thought you knew and discover the features you never knew existed with this book and ebook.

Key Features

• Tips, tricks and fast-paced tutorials for getting the most out of Navicat
• Master the visual design tools and editors with thorough examples
• Discover how easy Navicat makes outsmarting the trickiest cases
• Both Mac and PC versions covered, with screenshots detailing differences in performing tasks

Book Description

What you will learn

• Easily set up servers, establish connections, configure proxies and SSL certificates
• Design databases, tables, complex views, queries, functions and stored procedures through hand coding, point-and-click, or a mix of both
• Establish and manage complex relationships with visual editors and get the automatically generated SQL
• Import data or an entire database from almost any data source and export to a different database platform or a plethora of file formats
• Create visual models and create a database from them or just reverse-engineer an existing database into a visual diagram
• Backup and restore MySQL databases easily
• Create batch jobs and define automated schedules
• Manage complex privileges, analyze and repair tables with a few clicks

Who this book is for

This book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.