
MySQL Management and Administration with Navicat
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
- 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 DescriptionAny 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 - 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 forThis book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.
All prices
More details
Other editions
Additional editions

Person
Gökhan 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 graduate in 1999 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. During his high school years at the age of 16, he was known within 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. He has had experience in various domains of IT, such as business intelligence, data warehousing, and quality assurance, besides software development mainly on Java EE and.NET platforms. He went on to build his career working with the Business Process Management/Electronic Document Workflow software. He also runs several blogs, which are accessible from his personal website at http://gokhan.ozar.net, and also welcomes new followers on Twitter (twitter.com/skyhan).
Content
- Intro
- MySQL Management and Administration with Navicat
- Table of Contents
- MySQL Management and Administration with Navicat
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers, and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Errata
- Piracy
- Questions
- 1. Getting Started
- Enter Navicat
- Setting up a connection to the database
- Connecting via Secure Shell (SSH)
- Connecting via an HTTP tunnel
- Setting up Secure Sockets Layer (SSL)
- Advanced settings
- Testing and saving your settings
- Summary
- 2. Working with Databases
- Managing database objects with Navicat
- Creating a database from scratch
- Creating tables
- Defining foreign keys
- Defining triggers
- Entering data in tables
- Creating views
- Working with functions and procedures
- Using Navicat's event designer for MySQL
- Working with queries in Navicat
- Designing the Query
- Building further queries
- Summary
- 3. Data Management with Navicat
- Working with an existing database
- Creating the database schema from a SQL dump file
- Importing and exporting data
- Exporting in detail
- Importing a file into a table
- Direct data transfer between two databases
- Data and structure synchronization
- Backup and restore
- Creating and scheduling batch jobs
- Summary
- 4. Data Modeling with Navicat
- Working with Navicat's model designer
- Creating our first model
- Defining the relationships
- Adding some pizzazz to the model with notes and images
- Working with layers
- Deleting unwanted objects
- Working with multiple diagrams
- Exporting the model diagram to SQL
- Reverse-engineering a database into a model
- Summary
- 5. Database Maintenance and Security Management
- User and privilege management with Navicat
- How MySQL deals with access privileges
- Diving deep into creating and editing a user in Navicat
- Performing maintenance tasks with Navicat
- Analyzing a MySQL table or view with Navicat
- Checking a table or view
- Optimization made easy
- Repairing a table
- Summary
- 6. Designing Reports with Navicat
- First contact with the tool(s)
- Preparing the data with Query Wizard
- Designing the report
- Switching to the Preview tab
- Summary
- A. Additional Tips and Tricks
- Transferring your settings from one computer to another
- Transferring settings on the Mac
- Transferring settings on Windows
- Monitoring the MySQL Server
- The process list
- Variables
- Status
- Revealing a hidden search feature of Navicat
- Summary
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.