MySQL Management and Administration with Navicat


MySQL Management and Administration with Navicat
eBook: $17.99
Formats: PDF, PacktLib, ePub and Mobi formats
$15.30
save 15%!
Print + free eBook + free PacktLib access to the book: $47.98    Print cover: $29.99
$45.29
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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 : English
Paperback : 134 pages [ 235mm x 191mm ]
Release Date : September 2012
ISBN : 1849687463
ISBN 13 : 9781849687461
Author(s) : Gökhan Ozar
Topics and Technologies : All Books, Big Data and Business Intelligence, Enterprise, MySQL

Table of Contents

Preface
Chapter 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
              • 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

                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).
                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

                MySQL Management and Administration with Navicat +    IBM Websphere Portal 8: Web Experience Factory and the Cloud =
                50% Off
                the second eBook
                Price for both: $39.60

                Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                What you will learn from this book

                • 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

                In Detail

                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.

                Approach

                Standard Mini

                Who this book is for

                This book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.

                Code Download and Errata
                Packt Anytime, Anywhere
                Register Books
                Print Upgrades
                eBook Downloads
                Video Support
                Contact Us
                Awards Voting Nominations Previous Winners
                Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                Resources
                Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software