How to better manage your database--navicat

We used to use SQL Server, the graphical interface makes us a duck, but to the Oracle and MySQL, the black box of DOS command suddenly dumbfounded, not only no visual interface, And remember a bunch of Oracle or MySQL commands.

faced with difficulties in the face of difficulty, it is necessary to produce new things. so Navicat and Plsql are born, so let's talk about these two tools briefly.

　1. NavicatConcept　　

Navicat is a fast, reliable and affordable database management tool designed to simplify database management and reduce system administration costs. It is designed to meet the needs of database administrators, developers, and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access, and share information in a secure and simple way.

Advantages　　

1. Navicat offers up to 7 languages to choose from and is recognized as the world's most popular database front-end user interface tool. It can be used to manage and develop native or remote MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases.

2, for the Novice database server is quite easy to learn. With an extremely complete graphical user interface (GUI), Navicat lets you create, organize, access, and share information in a secure and simple way.

3. Navicat is suitable for three platforms-MicrosoftWindows, Mac OS X and Linux. It allows users to connect to any native or remote server, and provides useful database tools such as data model, transfer, data synchronization, fabric synchronization, import, export, backup, restore, report creation tools, and plans to assist in managing data.

Use　　

Download the appropriate installation package, for example, if you chose Navicat for MySQL, click Install after downloading.

In addition, Navicatpremium is a database management tool that is a multi-connection repository management tool that allows you to connect to MySQL, SQLite, Oracle and PostgreSQL repositories in a single program, making it easier to manage different types of repositories. That is to say, download a navicat premium, you can switch the connection flexibly, Oracle or MySQL, and so on.

Remote (local) connection (Navicat for MySQL example)　　

Click the "file" or "Connect" icon in the upper-left corner to create your own database connection. Navicat for MySQL can connect to a local MySQL database and can also connect to a remote MySQL database. The two connections are basically the same way.

　　　To open the connection interface:

　　　Fill in the connection information, including password and user name, and IP address:

Note　　

Before I was using navicatfor MySQL, just installed Navicat Formysql, did not install MySQL, because I was a remote connection to the other database, so even if I do not install MySQL locally, is not an error, now I want to test the local program, Need to use the connection to the local, so that the error, the next article will introduce the relevant knowledge of MySQL.

　　In short: Navicatfor MySQL only applies to the MySQL database; using navicat for MySQL must first install MySQL.

　2. Plsql Developer

PL/SQL Developer is an integrated development environment that specializes in developing applications for Oracle databases. PL/SQL is also a programming language called the procedural SQL language (procedurallanguage/sql). PL/SQL is an extension of the Oracle database to the statement. In the use of ordinary SQL statements to add the characteristics of the programming language, so PL-SQL to the data Operations and query statements organized in the PL/SQL code of the process unit, through logical judgment, loop and other operations to achieve complex functions or calculations. PL/SQL is available only for Oracle databases. MySQL currently does not support PL/SQL.

Use　　

After the installation of Oracle, and then download the installation of Plsql Developer, after the corresponding configuration can be, here is no longer detailed.

　3. Summary

The main introduction is Navicat Formysql, since navicat operation is MySQL, the following article will have to mention MySQL.

The visual interface will make developers more comfortable with the development, especially for beginners, of course, the necessary commands to know.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

How to better manage your database--navicat