Structured Query Language (SQL) is a standard language to write queries. It was developed under R Project by IBM. SQL has a basic grammar and syntax. It was declared as a standard language to use by American Standard National Institute(ANSI) and International Standard Organization(ISO). The functionality of SQL language is virtually similar across the operating system platforms.
Using SQL doesn’t require programming experience, but programming experience helps one to conceptualize what a particular SQL command will help to execute and retrieve SQL queries.
Characteristics and Benefits of Structured Query Language:
The ANSI SQL provides with:
- Specific syntax and semantics of SQL data definition and data manipulation languages.
- It also provides with basic data structure and operations for designing, assessing, maintaining, controlling and protecting SQL databases.
- Portability of database definition and application is also provided. Applications can be moved from one machine to another.
- IS professionals share a common language and reduce training costs.
- Professionals can become proficient in its use and increase the productivity.
- It provides with longevity.
- It provides with reduced dependence on single vendor.
Rules to write commands:
- Table names cannot exceed 20 characters.
- Name of the table must be unique.
- Field names also must be unique.
- The field list and filed length must be enclosed in parentheses.
- The user must specify the field length and type.
- The field definitions must be separated with commas.
- SQL statements must end with a semicolon.
Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.
- Characteristics and Functions of Data warehouse
- Characteristics of Biological Data (Genome Data Management)
- Various rules of Object Oriented DBMS
- RENAME (ρ) Operation in Relational Algebra
- Difference between Amazon Aurora and Amazon SimpleDB
- Difference between Altibase and Amazon SimpleDB
- Difference between AllegroGraph and Amazon SimpleDB
- Difference between Alibaba Cloud AnalyticDB for PostgreSQL and Amazon Redshift
- Difference between Aerospike and Amazon SimpleDB
- Difference between 4D and Alibaba Cloud ApsaraDB for PolarDB
- SSTable in Apache Cassandra
- Difference between Alibaba Cloud AnalyticDB for PostgreSQL and Amazon SimpleDB
- Indexing in MongoDB
- Select top in MS SQL Server
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.