SQL - Introduction
SQL stands for Structured Query Language. It is a query language and used for performing operations on the database such as insert new records, update records, delete records and view records etc. SQL queries are performed on database like Oracle database, MySQL database, MongoDB database and SQL Server database etc. All database management system uses SQL as standard database language. Some important features of SQL are given below:
Simple Language – SQL is a simple language and it is very easy to understand and learn.
High Performance Language – SQL is a high performance language and provides capability to work on a huge database system.
Management Ease Language – SQL is used in almost every relational database management system. It offers the following features:
- SQL is used to access data from relational database management systems(RDMS).
- SQL is used to describe the data.
- SQL is used to execute queries against the database.
- SQL is used to define data in a database and manipulate it when needed.
- SQL is used to create and drop databases and tables.
- SQL is used to create a view, stored procedure and functions in a database.
- SQL is used to provide permissions on tables, views and procedures.
Open-Source Language – SQL is an open source language for building relational database management system (RDMS), which makes it freely usable and distributable, even for commercial use.
Secure Language – When it comes to security, It is very easy to provide permissions on tables, views and procedures in SQL.
High Availability Language – Many relational database management systems (RDMS) like MS Access, SQL server, Oracle database, SAP Adaptive server, etc. supports SQL, which makes SQL a powerful language to learn.