SQL

Advertisement by Google

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:

IT_Officer_010_01

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.

Download as PDF

Read next:  SQL – Data Definition Language ››

« Back to Course page

Advertisement

Comments

Subscribe Us

Join us to get latest article in your inbox

Advertisement

Article of the Week

Follow Us On Facebook