What Is SQL (Structured Query Language)?

What Is SQL (Structured Query Language)? Many people who already know what it is Structured Query Language (SQL). Understanding Structured Query Language (SQL) is a high language-oriented, group data (tables) and non-procedure for a relational database. Why are said to be a high level language? because SQL uses the English language, why say oriented group table? because unlike other languages ​​that only have the capability to record only. And why are non-procedural? because it give us what we are looking for.

SQL (Structured Query Language) created in the 1970s by IBM in San Jose Research Laboratories. SQL standardization started in 1986 from the American National Standards Institute (ANSI) and in 1987 by the International Standards Organization (ISO).

SQL language created to define and manipulate objects and data in the database (database). It becomes something that is important because:

• is a portable that can be directly used on the PC though made on minicomputers.
• procedure language database created on a PC, can be used to retrieve data in the same minicomputer because of its language.

Tools to run the command Structured Query Language (SQL), among others:

• SQL Plus (Windows), is part of Oracle Database products. This tool can be run on Microsoft XP/98/2000. For how to run this product: Start -> Programs -> Oracle for windows NT -> SQL Plus
• SQL Plus (DOS), how to execute SQL commands by using cmd or DOS. How to run it: Start -> Run, type cmd. Once open cmd, then type in sql plus enter. Enter your user ID and password.
• SVRMGRL (DOS), the same as the SQL Plus DOS, distinguished only way to run it. How to run it: Start -> Run. Type cmd. When cmd is already open, type and enter svrmgrl. After that, type connect internal and fill passwords.
• Open Database Connectivity (ODBC), is the standardization of various kinds of databases that can be run by other applications. How to run it: Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources. Press the Add button, then select the driver database searchable.
• Another tool that can be used, such as: Toad, Quest Software.

That was a brief description of What Is SQL (Structured Query Language). If there are errors or omissions please justified or added. May be useful.