Advantages And Uses Of SQL

1139 Words5 Pages
SQL stands for Structured Query Language. SQL is a standard interactive and programming language designed for the retrieval and management of data in relational database. According to the ANSI, it is the standard language for relational database management systems. SQL statements are used to perform tasks such as - update data on a database, or retreive data from a database.
Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access Ingres, etc. The strengths of SQL provides benefits for all types of users, including application programmers, database administrators, managers, and
…show more content…
• It provides automatic navigation to the data.
• It uses statements that are complex and powerful individually, and that therefore stand alone.
• It processes sets of data as groups rather than as individual units.

Recent Enhancements
• The Oracle Database SQL engine is the underpinning of all the Oracle Database applications.
• Oracle SQL continually evolves to meet the growing demands of database applications and to support the emerging computing architectures, APIs, and network protocols.
In addition to the traditional structured data, SQL is also capable of storing, retrieving, and processing more complex data.
Built – in SQL aggregate and analytic functions facilitate access to and manipulation of data in the data warehouses and data marts.

Ongoing enhancement in Oracle SQL will continue to provide comprehensive support for the development of versatile, scalable and high - performance database applications.
…show more content…
It is used to modify and build the structure of the tables and the objects in database.

The three types of DDL commands are :-
1. CREATE : This is used to create a table.
The syntax is : CREATE TABLE [ table name] ([columns definitions] [table parameters])
For example :-
CREATE TABLE employess (first_name VARCHAR(30) not null, Last_name VARCHAR(30) not null, Dateofbirth DATE not null );

2. DROP : This deletes an existing an existing database, table, index or view.
The syntax is :- DROP objecttype objectname
For Example :- DROP TABLE
Get Access