MySQL Management and Administration with Navicat - Softcover

Ozar, Gökhan

Softcover

ISBN 10: 1849687463 ISBN 13: 9781849687461

Verlag: Packt Publishing, 2012

Inhaltsangabe

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.

Über diesen Titel

Reseña del editor

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

Biografía del autor

Gokhan Ozar is an IT professional with both hands-on and outsourcing expertise in the areas of application development, database design, data analysis, project management, systems integration, training, support, and delegation of support. A 1999 graduate of Bilkent University in Ankara, Turkey, he started his career as a web designer and developer making database-driven web applications on a variety of platforms. In his high-school years at the age of 16, he was known in the Mac user communities in Turkey as the maker of an adventure game called 'The Journey' made exclusively for older Macs running on Mac OS versions prior to OS X. Gokhan Ozar has had experience in various domains of IT like business intelligence, data-warehousing and quality assurance, besides software development mainly on Java EE and .NET platforms, he went on his career working on Business Process Management / Electronic Document Workflow software. Gokhan Ozar also runs several blogs accessible from his personal web site at http://gokhan.ozar.net also welcoming new followers on Twitter (twitter.com/skyhan).

Details zur Ausgabe

• Verlag: Packt Publishing
• Erscheinungsdatum: 2012
• Sprache: Englisch
• ISBN 10: 1849687463
• ISBN 13: 9781849687461
• Einband: Tapa blanda
• Anzahl der Seiten: 134
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar