售 价：¥
6.2
温馨提示：数字商品不支持退换货，不提供源文件，不支持导出打印
为你推荐
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
买过这本书的人还买过
读了这本书的人还在读
同类图书排行榜
购物车
个人中心
