會員

MySQL Management and Administration with Navicat

更新時間：2021-08-05 19:03:14

開會員，本書免費讀 >

StandardMini.ThisbookiswrittenforMySQLUsers,Developers,andadminswhowanttodiscoverjusthoweasyNavicatmakesevennormallyarduoustasks.

目錄(57章)

倒序

coverpage
MySQL Management and Administration with Navicat
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started
Enter Navicat
Setting up a connection to the database
Setting up Secure Sockets Layer (SSL)
Summary
Chapter 2. Working with Databases
Managing database objects with Navicat
Creating a database from scratch
Entering data in tables
Creating views
Working with functions and procedures
Using Navicat’s event designer for MySQL
Working with queries in Navicat
Summary
Chapter 3. Data Management with Navicat
Working with an existing database
Importing and exporting data
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
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
Performing maintenance tasks with Navicat
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 A. Additional Tips and Tricks
Transferring your settings from one computer to another
Monitoring the MySQL Server
Revealing a hidden search feature of Navicat
Summary
Index 更新時間：2021-08-05 19:03:14

官术网_书友最值得收藏!

MySQL Management and Administration with Navicat