What Is SQL? in Database....
SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.
SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.
There are various applications of SQL −
- 1. Data Integration Scripts - The main application of SQL is to write data integration scripts by the database administrators and developers.
- 2. Analytical query- The data analysts use structured query language for setting and running analytical queries on a regular basis.
- 3. Retrieve Information -Another popular application of this language is to retrieve the subsets of information within a database for analytics applications and transaction processing. The most commonly used SQL elements are select, insert, update, add, delete, create, truncate and alter.
- 4. Other Important Applications -The SQL is used for modification of the index structures and database table. Additionally, the users can add, update and delete therows of the data by using this language.
Advantages of SQL
High speed:- Using the SQL queries, the user can quickly and efficiently retrieve a large amount of records from a database.
No coding needed:- In the standard SQL, it is very easy to manage thedatabase system. It doesn't require a substantial amount of code to manage the database system.
Well defined standards:- Long established are used by the SQL databases that are being used by ISO and ANSI.
Portability:- SQL can be used in laptop, PCs, server and even some mobile phones.
Interactive language:- SQL is a domain language used to communicate with the database. It is also used to receive answers to the complex questions in seconds.
Multiple data view:- Using the SQL language, the users can make different views of the database structure.
Disadvantages of SQL
- Interfacing an SQL database is more complex than adding a few lines of code.
- When the table is dropped view becomes inactive. It depends on the table objects.
- Although SQL databases conform to ANSI; ISO standards, some databases go for proprietary extensions to standard SQL to ensure vendor lock-in.
- It is an object so it occupies space.
SQL Commands
o SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data.
o SQL can perform various tasks like create a table, add data to tables, drop the table, modify the table, set permission for users.
