What is a Structured Query Language (SQL)? 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.
Structured Query Language (SQL) created in the 1970s by IBM San Jose Research Laboratories. SQL standardization began 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). SQL becomes something that is important because:is a portable that can be directly used in the PC even though made in the minicomputer.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:
Structured Query Language (SQL) created in the 1970s by IBM San Jose Research Laboratories. SQL standardization began 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). SQL becomes something that is important because:is a portable that can be directly used in the PC even though made in the minicomputer.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, type in sql plus then 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 svrmgrl then enter. After that, type connect internal and fill password.
- Open Database Connectivity (ODBC), is the standardization of the various databases in order to run 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.
Structured Query Language (SQL) has advantages and disadvantages. Here are the advantages and disadvantages of these SQL commands:
Here are the Advantages and Disadvantages of SQL (Structured Query Language) is:
1. Advantages of SQL
- Since it is interactive and is embedded in the program are not much different, then in addition to easy for the user, the programmer easily perform error tracking program (debugging)
- Facilitate communication between users, programmers and DBAs. In addition, embedded SQL for different host language (COBOL, FORTRAN, PL / I) nearly equal
- Because SQL is compiled, the runtime is much faster than the interactive
2. The drawback SQL
- Form of the language is much different from the host language that is so difficult for a programmer in writing kodingnya.
SQL is divided into Data Definition Language and Data Manipulation Language. That was a brief description of Structured Query Language (SQL). If there are errors or omissions please justified or added. May be useful.
0 komentar
Posting Komentar