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
Click to Join
