Introduction

Last revised On: 01/05/2016 Author Gaurav Shukla

SQL is a structured query language which is primarily used for accessing and manipulating data in databases.

What is SQL ?

  • SQL Stands for structured Query Language.
  • SQL is used for getting information from a persistent storage i.e. database and updating a database.
  • SQL follow both an ANSI and an ISO standard.

Power of SQL

  • SQL can perform CRUD (Insert Records,Read Records,Update Records,Delete Records) operations.
  • SQL can create Database to store and organize data permanantely.
  • SQL can create Schema in the database. Schemas provides logical grouping to database objects.
  • SQL can create Tables in the database. Tables are used to store data in a database.
  • SQL can create Function in the database.
  • SQL can create Stored procedure in database.
  • SQL can create View in the database.
  • SQL can create Trigger in the database.
  • SQL can create Cursor in the database.
  • SQL can set permission on database, schema, tables, procedures, and views etc.
  • SQL can perform Transactions

SQL standards

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987. Since then, the standard has been revised to include a larger set of features. Despite the existence of such standards, though, most SQL code is not completely portable among different database systems without adjustments.

Evolution of SQL

Dr. E. F. Codd published the paper, "A Relational Model of Data for Large Shared Data Banks", in June 1970 in the Association of Computer Machinery (ACM) journal, Communications of the ACM. Codd's model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation, Inc., to use Codd's model. SEQUEL later became SQL (still pronounced "sequel"). In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language.

What is RDMS

RDMS stands for Relational Database Management System. It is the basic of all the database systems like SQL, IBM DB2, Oracle, MySQL, Microsoft Access, Microsoft SQL Server and others.

In RDMS data is stored in the form of the object that is called table. A table has row and column relationship. So due to this relationship, it is known as relational database.

Author
Author: Gaurav Shukla
Published On: 20/07/2015
Last revised On: 01/05/2016

Share this chapter
Comments
comments powered by Disqus

Navigation

Social Media