MySQL Management and Administration with Navicat
eBook:
$17.99
Formats:
Formats:
$15.29
save 15%!
save 15%!
Print + free eBook + free PacktLib access to the book:
$47.98
Print cover: $29.99
$29.99
save 37%!
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
| Also available on: |
|
- 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 Details
Language : EnglishPaperback : 134 pages [ 235mm x 191mm ]
Release Date : September 2012
ISBN : 1849687463
ISBN 13 : 9781849687461
Author(s) : Gökhan Ozar
Topics and Technologies : All Books, Enterprise, MySQL
Table of Contents
PrefaceChapter 1: Getting Started
Chapter 2: Working with Databases
Chapter 3: Data Management with Navicat
Chapter 4: Data Modeling with Navicat
Chapter 5: Database Maintenance and Security Management
Chapter 6: Designing Reports with Navicat
Appendix: Additional Tips and Tricks
Index
- Chapter 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
- Chapter 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
- Chapter 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
- Chapter 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
- Chapter 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
- Chapter 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
- Appendix: 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
Gökhan Ozar
Sorry, we don't have any reviews for this title yet.
Submit Errata
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Sample chapters
You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.
Frequently bought together
+
=
50% Off
the eBooks
the eBooks
Buy both these recommended eBooks together and get 50% off the total price
- 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
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.
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.
