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.
GeeksforGeeks has prepared a complete interview preparation course with premium videos, theory, practice problems, TA support and many more features. Please refer Placement 100 for details
- Characteristics and Functions of Data warehouse
- Characteristics of Biological Data (Genome Data Management)
- Difference between ALTER and UPDATE Command in SQL
- Cartesian Product Operation in Relational Algebra
- Multivalued Dependency (MVD) in DBMS
- SELECT Operation in Relational Algebra
- The CAP Theorem in DBMS
- Job Control Language (JCL) Utilities
- Flashback Queries
- Difference between SQL and HiveQL
- Difference between Cassandra and MySQL
- Difference Between MySQL and MariaDB
- Difference between DELETE, DROP and TRUNCATE
- PROJECT Operation in Relational Algebra
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.