Structured Query Language-definition of SQL

Structured Query Language (SQL):-

     Structured Query Language (SQL) is the standard command set used to communicate with the relational database management systems. All tasks related to relational data management creating tables, querying the database for information, modifying the data in the database, deleting them, granting access to users and so on can be done using SQL.

Characteristics of SQL:-

    SQL usage by its very nature is extremely flexible. It uses a free form syntax that gives the user the ability to structure SQL statements in a way best suited to him. Each SQL statements in a particular column or be finished in a single line. The same SQL request can be written in a variety of ways.

Advantages of SQL:-

     !) SQL is a high level language that provides a greater degree of abstraction than procedural languages.

    !!) SQL enables the end-users and systems personnel to deal with a number of database management systems where it is available. Increased acceptance and availability of SQL are also in its favor.

    !!!)Applications written in SQL can be easily ported across systems. Such porting could be required when the underlying DBMS needs to be upgraded or changed.

    !V) SQL specifies what is required and not how it should be done.