- SQL is a standard database language which is used to create maintain and retrieve the relational database.
following are some interesting facts about SQL
- SQL is case sensitive but it is a recommended practice to use keyword (Like SELECT, UPDATE,CREATE) iincapital letters and user defined thing (like table name, column name etc) in small letters.
- We can write comments in SQL using "--" at the beginning of any line.
- SQL is the programming language for relational databases like non relational databases (also called as NoSQL) databases like MangoDB,Dynamo DB,etc do not use SQL.
- Although there is an ISO standard for SQL most of the implementations slightly vary in syntax.so we may encounter queries that work in SQL server but not work in MySQL.
