Top Characteristics of SQL
A Quick Overview
Introduction to SQL
SQL or Structured Query Language is a standard database language used to store, manipulate, and retrieve data from relational database. Also, database optimization and maintenance.
1. Query and maintain data in relational databases.
2. Changes or modifies previous data.
3. Contains various commands for managing databases.
4. Maintains database transactions.
Why SQL is used?
Characteristics of SQL
1. Easy to learn
SQL is practical and user-friendly language, and even if you aren't familiar with it, you can easily learn it. Its syntax is remarkably similar to English, making it easy to learn.
2. Wide Variety of Commands
SQL supports various commands such as DDL commands like CREATE, DROP, ALTER; DML commands like INSERT, UPDATE, DELETE; DCL commands like GRANT, REVOKE; and many more.
3. Stored Procedures
SQL stored procedures are pieces of code that can be saved and reused many times. A stored procedure executes one or more DML operations on a database.
4. Portable Language
A key feature of SQL is the portability of data definitions and applications, which means that applications can be moved between machines.
SQL supports joins, which combine two sets of data (i.e. two or more tables). Among the joins supported by SQL are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
SQL Server connect to a non-SQL Server database using connected server. With linked servers, SQL Server can connect to 3rd-party backends like Oracle, MySQL, etc., using ODBC drivers.
For more information on SQL characteristics, click below.