SQL definition of the

SQL stands for Structured Query Language to be pronounced "sequel (Sequel)," but in general, "" S kyuel frills.

Stuff I write on what's wrong?
  A wide range of information to many people at the same time so that you can use "database (Data Base: DB)" organized by a regular structure of a data set, and to manage this system called "database management system (Data Base Management System: DBMS)" relational structure (Relational) database while the structure of the database to a relational database (RDB) frills. So guess what the RDBMS has do not you come?
Need the tools of conversation, this conversation to a conversation with the people RDBMS running on this computer is a SQL tool.

SQL 1970 early in your computer when you think of a company called IBM in San Jose, California, was created at the Institute of Nasir. It originally was developed for the IBM DB2 RDBMS, currently standardized by the ISO (International Standards Organization) standard to promote industrialization two standards bodies, ANSI (American National Standards Institute) and is available in almost all of the company's RDBMS can. But every company that makes a RDBMS in order to improve the features and performance of your own bipyojuneo is included, it is not fully compatible with the other company's RDBMS. Therefore, every company has a separate software that you can use his company's SQL RDBMS to create Oracle database used by our company. "S kyuel Plus (SQL * Plus)"

Typical third-generation programming language such as COBOL or C, the result of the SQL "as a non-procedural language to describe how that technology will get not a procedural language," "what" will get what data to retrieve, insert, describe how to update, and delete. Non-primary language is because the narrative is expressed only on "what" and "how do internally SQL statement" on the software that runs using several pieces of information to establish the procedure for running the software will run the plan quickly derive results in accordance with the procedure for running late and are to be drawn. Late results derived execution procedures in several ways software can be instructed to take such action if the SQL tuning (tuning).

SQL is greatly to define the structure of data and DDL (Data Definition Language) and a search of the data and insert, delete and update DML (Data Manipulation Language), DCL (Data Control Language) to define the rights of the database user in three can be classified as
Data search and insert, delete and update for the following types of DML.

SELECT: retrieve data from the database that meet the search criteria
INSERT: insert new data in the database
UPDATE: modify existing data in the database
DELETE: delete the existing data from the database

SQL statement to get the same results can be expressed in order to obtain the results they want more quickly will need a lot of practice and effort.



Of Database and SQL interrelationships

SQL simple query capabilities as well as the ability to define and complete data manipulation features. Interactively through the online terminal may be used, and should be inserted into the program in the host language such as COBOL or PL / I, C, may be used. SQL access path to a device-independent and for any reference, does not perform the operation as a unit rather than a set of records, tables, individual records. SQL has a syntax similar to English sentences, so even beginners can be relatively easy to use.