MySQL Management and Administration with Navicat

Master the tools you thought you knew and discover the features you never knew existed with this book and ebook.

MySQL Management and Administration with Navicat

Gökhan Ozar

1 customer reviews
Master the tools you thought you knew and discover the features you never knew existed with this book and ebook.
Mapt Subscription
FREE
$29.99/m after trial
eBook
$12.60
RRP $17.99
Save 29%
Print + eBook
$29.99
RRP $29.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$12.60
$29.99
$29.99p/m after trial
RRP $17.99
RRP $29.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Code Files
Preview in Mapt

Book Details

ISBN 139781849687461
Paperback134 pages

Book Description

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.

Table of Contents

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

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

Authors

Table of Contents

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

Book Details

ISBN 139781849687461
Paperback134 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
MySQL Admin Cookbook Book Cover
MySQL Admin Cookbook
$ 29.99
$ 21.00
CodeIgniter 1.7 Book Cover
CodeIgniter 1.7
$ 23.99
$ 16.80
Git: Version Control for Everyone Book Cover
Git: Version Control for Everyone
$ 23.99
$ 16.80
AJAX and PHP: Building Modern Web Applications 2nd Edition Book Cover
AJAX and PHP: Building Modern Web Applications 2nd Edition
$ 23.99
$ 16.80
Advanced Penetration Testing for Highly-Secured Environments: The Ultimate Security Guide Book Cover
Advanced Penetration Testing for Highly-Secured Environments: The Ultimate Security Guide
$ 35.99
$ 7.20