SQL Tutorial

SQL is a Structured Query Language. It is designed to manage data stored in a relational database management system (RDBMS). It means used for storing, manipulating and retrieving data in databases.

What is SQL used for?

It helps you to describe the data.
It helps users to access data in the RDBMS system.
With the help of SQL, you can create and drop databases and tables.
It allows you to define the data in a database and manipulate that specific data.
SQL can execute queries, retrieve data, insert records, update records and delete records from a database.
SQL can create new databases, create new tables, create stored procedures and create views in a database.
You can set permissions on tables, procedures, and views.

History of SQL?

Here are important landmarks from the history of SQL:

1970 – Dr. Edgar F. “Ted” Codd described a relational model for databases.
1974 – Structured Query Language appeared.
1978 – IBM released a product called System/R.
1986 – IBM developed the prototype of a relational database, which is standardized by ANSI.
1989 – First ever version launched of SQL
1999 – SQL 3 launched with features like triggers, object-orientation, etc.
SQL 2003 – window functions, XML-related features, etc.
SQL 2006 – Support for XML Query Language
SQL 2011 -improved support for temporal databases