SQL OVERVIEW

What is SQL ?.

• SQL is structured Query Language which is a computer language for storing,manipulating and retrieving data stored in relational database.

• SQL is the standard language for Relational database system.All relational database management system like MySQL,MS Access,Oracle,Sybase,Informix postgre,and SQL Server uses SQL As database language.

• SQL is not case sensitive language.

Why SQL ?.

• Allow users to access data in relational database management systems.
• Allow user to describe the data.
• Allow user to define the data in database and manipulate that data.
• Allow to embed within other languages using SQL modules,libraries and pre-compilers.
• Allow users to create and drop database and tables.
• Allow users to create view,stored procedure in a database.
• Allow users to set permissions on tables,procedures and views.