SQL: Structured Query Language Notes IBPS IT Officer 2020

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:

sql notes ibps it officer

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