- SQL is used to work with RDBMS systems. It’s not for No-SQL or document based databases.
- We can create database, create table etc. These are data structure definition operations. SQL supports these operations and they come under “data definition language” or DDL operations. Some of the keywords for DDL queries are
- SQL queries are mostly used to retrieve and manipulate data in relational databases. They come under “data manipulation language” or DML statements. Some of the keywords used for DML operations are
- Data Control Language or DCL is used to control access to data stored in a database. It’s very important to make sure only authorized users can access the data. SQL supports DCL through use of
- We can store multiple queries in a file and execute them in SQL. SQL file name extension is
- Most popular database systems that support SQL queries are Oracle, MySQL and PostgreSQL.
- SQL implementations are incompatible with different databases, mostly because they have adapted to their own data structures. Some of the database implementations have their own data types and clauses, so if you have written queries for MySQL database, it may or may not work for Oracle database. For example MySQL has LIMIT clause that is not present in Oracle. MySQL has DATE, DATETIME and TIMESTAMP types whereas Oracle has only DATE type.