What's it About?
Everything you need to know to use Navicat for database design, modeling and administration of MySQL. You can learn some advanced SQL, as well. You can also apply what you have learnt to manage other databases such as Oracle and Microsoft SQL Server.
Any database designer, developer or administrator who wants to accomplish both everyday tasks and more advanced actions with a few clicks or drag-and-drops can now do so using Navicat’s advanced tools and this book. Starting with the basics before progressing with advanced features, the book can be read from cover to cover, or simply used as a reference guide for any problems you encounter.
The First and Currently the Only Book on Navicat
The only book ever written and published for Navicat at the time of this writing, MySQL Management and Administration with Navicat features ‘work along’ tutorials, tips, tricks, and more...
What the Book teaches
MySQL Management and Administration with Navicat features ‘work along’ tutorials, tips and tricks about Navicat for MySQL. It even features some intermediate to advanced SQL tutorials. The book reveals some features of Navicat which you may have never known existed – features such as drawing E-R diagrams, generating database tables from them, or reverse-engineer a database for vice versa, editing foreign keys with only a few clicks, designing functions and stored procedures, event triggers, creating batch jobs, scheduling them, and more…
Setting Up Simple to Advanced Connections
Database Design the 21st Century Way
Turn visual thinking into code
Import/Export Structure and Data as easy as you use Google Translate
Go Freely Back and Forth Between Visualisation and Coding
Have Navicat do All the DBA Work
What People Say
Some of the comments from readers...
David M. Stokes
“ Navicat for MySQL has been around for over ten years and allows graphical database management and development do be performed on Windows, Mac OS X, and Linux. Pact Publishing now has book out for those wishing to master this tool. The book is divided into six chapters and starts with the basics of installation and access over SSL. Please note that there is also a Navicat premium tool that allows a database administrator to work with MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases within a single application. I highly recommend this book for those new to using Navicat. This is a great introduction to a powerful tool. Experienced users may want deeper details. But Navicat newbies should have a copy of this for a handy reference. ”
A Reader
“ Get it with Navicat. Newer MySQL than book, but still best way to learn Navicat which is MUCH better than Workbench. Powerful tool for MySQL 101 users. ”
Djoni Darmawikarta
“ Right from the first chapter, you will eagerly look forward to continuing to the next; and highly likely you will only stop when you finish the very last page of the appendix. Regardless you are a database administrator, designer or application developer; new or familiar to MySQL, if you have used or are deciding to use Navicat, you will find this book a priceless hands-on tutor. ”
Available in All Major Book Stores
From Amazon and Apple iBook Store to Barnes and Nobles and Safari Books Online, MySQL Management and Administration with Navicat Book is available worldwide.