Search Contents

Sunday, 13 November 2016

What is SQL?

This is considered as an icon or symbol for SQL
SQL- some call it S-Q-L and others call it "sequel", stands for Structured Query Language, is used to play with databases. The American National Standards Institute commonly known as ANSI has declared SQL as the standard language for relational database management systems. It allows us to run different queries against a particular database, update, insert, delete records, create views, join tables and many more things.
Although, there are many different versions of SQL available but they all have the same basic commands like SELECT, UPDATE, ALTER, DELETE, DROP, WHERE, etc.
It is based upon relational algebra and relational calculus and SQL consists of data manipulation language, data control language and data definition language. It is generally considered as a fourth-generation programming language (4GL). However, it also includes procedural elements.
In 1970 an English computer scientist Edgar F. Codd, invented the relational model for database management, while working for IBM. It consists of 12 rules commonly known as Codd's 12 rules. Although, SQL does not strictly follow all those rules, it is most popularly used database language.

What is the difference between SQL and MySQL?

This is a very common confusion among some people that they think both MySQL and SQL are same but they are different in fact.
As we have already discussed above, SQL is a standard language for working with databases. Whereas, MySQL can be defined as a database management system, similar to Oracle SQL, Informix, Postgres, Microsoft SQL, Mongo DB etc. MySQL is a RDBMS or Relational Database Management System.

No comments :

Post a Comment