MySQL Management and Administration with Navicat and over one million other books are available for Amazon Kindle. Learn more

List Price: $29.99
Save: $3.00 (10%)

FREE Shipping on orders over $35.

In Stock.

Ships from and sold by Amazon.com.

Sign in to turn on 1-click ordering

Want it Thursday, Oct. 9? Order within and choose Two-Day Shipping at checkout. Details

Sell yours for a Gift Card
We'll buy it for $1.71
Learn More
Trade in now

Have one to sell? Sell on Amazon

Flip to back Flip to front

Listen Playing... Paused You're listening to a sample of the Audible audio edition.
Learn more

See this image

MySQL Management and Administration with Navicat Paperback – September 13, 2012

by Gökhan Ozar (Author)

2 customer reviews

Get the Kindle Edition for just $2.99 when you buy the new print edition of this book. Learn more about

See all 2 formats and editions Hide other formats and editions

Amazon Price New from Used from

Kindle

"Please retry"

$10.69

—

Paperback

"Please retry"

$26.99

$22.99

$37.40

Kindle
$10.69 Read with our free app
Paperback
$26.99 5 Used from $37.40 22 New from $22.99

Master the tools you thought you knew and discover the features you never knew existed

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

In Detail

Any database designer 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, this book can be read from cover to cover, or simply used as a reference guide for any problems you encounter.

The book features 'work along' tutorials, some of which will surprise you by revealing features of Navicat which you may never have known existed – features such as designing functions and stored procedures, event triggers, creating batch jobs and scheduling.

"MySQL Management and Administration with Navicat" is an ideal resource to master Navicat and unlock its true potential.

What you will learn from this book

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

Approach

Standard Mini

Who this book is written for

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

Special Offers and Product Promotions

Customers viewing this page may be interested in these sponsored links

(What's this?)

MySQL® Administrator	-	Powerful Environment For Design And Administration Of MySQL® Database!	www.devart.com/dbForge/MySQL-Studio
My SQL Admin SQL Tools	-	Excellent My SQL GUI client: power and ease of visual management!	www.sqlmanager.net/products/MySQL
My SQL Database Admin Help	-	Have the My SQL experts administer your databases. Fixed monthly cost.	www.percona.com/remote-dba-for-mysql

See a problem with these advertisements? Let us know

If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 72%). Print edition purchase must be sold by Amazon. .

Start reading MySQL Management and Administration with Navicat on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Product Details

Paperback: 134 pages
Publisher: Packt Publishing (September 13, 2012)
Language: English
ISBN-10: 1849687463
ISBN-13: 978-1849687461
Product Dimensions: 9.2 x 7.5 x 0.3 inches
Shipping Weight: 8.5 ounces (View shipping rates and policies)
Average Customer Review: 5.0 out of 5 stars See all reviews (2 customer reviews)
Amazon Best Sellers Rank: #2,310,619 in Books (See Top 100 in Books)

Would you like to update product info or give feedback on images?.

More About the Author

› Visit Amazon's Gökhan Ozar Page

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

(2)

5.0 out of 5 stars

5 star		2
4 star		0
3 star		0
2 star		0
1 star		0

See both customer reviews

Share your thoughts with other customers

Write a customer review

Most Helpful Customer Reviews

2 of 2 people found the following review helpful

You need this book to effectively use Navicat on MySQL !

By Djoni Darmawikarta on November 8, 2012

Format: Paperback

Navicat is one of the best IDE database tools available in the market. "MySQL Management and Administration with Navicat" enables you to explore the tool's rich capabilities on MySQL.

The book, seemingly brief, having only 105 pages, shows you step-by-step, how to build data model, create and maintain data, administer your MySQL database, write queries against the database, and develop reports from the data.

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.

A truly recommended professional book !

Comment Was this review helpful to you? Yes No Sending feedback...

Thank you for your feedback. If this review is inappropriate, please let us know.

Sorry, we failed to record your vote. Please try again

1 of 1 people found the following review helpful

A greate intro to Navicat for MySQL

By David M. Stokes on November 13, 2012

Format: Paperback

MySQL Management and Administration with Navicat
Gokhan Ozar
Packt Publishing
134 pages (e book)

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.

The second chapter goes covers creating databases, tables, defining foreign keys, and triggers. Entering data into tables, using Navicat as a query tool, and view creation is also covered. The format is that of a cookbook and walks the read the steps needed to illustrate the functionality of Navicat. The test is clear, well written, easy to follow for even novices. However this does not explain much of the underlying MySQL features such as how functions like triggers work and that is probably best left to an intensive book on MySQL.

The third chapter plunges into data management such as importing data, exporting data, and backups. The forth chapter is devoted to data modeling. Navicat's data modeling has some features not found in MySQL Workbench such as object history tracking. Also the feature to annotate with images and notes is a useful feature.

Chapter five is user and privilege management and table maintenance. The use of a GUI for user management over messy SQL statements and long been advocated by myself and others.Read more ›

Comment Was this review helpful to you? Yes No Sending feedback...

Thank you for your feedback. If this review is inappropriate, please let us know.

Sorry, we failed to record your vote. Please try again

See both customer reviews (newest first)

Write a customer review