SQL is abbreviation of Structured Query Language. It is not a complete language in itself rather it is a set of commands that help users interact with database in easy and convenient way. We hope by now you have basic understanding of DBMS, if not have a look at Introduction to Database Management Systems.
SQL allows you to perform three types of operations on DBMS i.e. data definition, data manipulation and data control. To achieve this, the commands are divided into three categories:
Some the points to remember:
- SQL is an ANSI (American National Standards Institute) standard.
- There are different flavors of SQL like T-SQL, PL/SQL, JET SQL etc.
- It was the first implementation of Edgar F. Codd’s relational model.
- It was first developed at IBM and released a product named System R.
- There are many DBMS which use SQL as database language. Some of them are MySQL, MS Access, Oracle, Sybase, Informix, postgresql, SQL Server etc.