A computer system comprises hardware and software components, aiming to offer a powerful computational tool. These systems play a crucial role across diverse domains, aiding us in numerous tasks. The prevalence of the internet has significantly bolstered the utilization of computers for information sharing and communication. Computer systems empower us to store, process, display, and transmit information. Even in a basic modern computer system, multiple programs are typically required to carry out various functions effectively.

Wednesday, April 1, 2015

SQL (Structured Query Language)

SQL, the abbreviation for Structured Query Language, is a a standard computer lingo that was initially elaborated by IBM for querying, changing and determining relational databank, utilizing Declarative programming.

There are many graphical tools that have made the task of developing applications that use SQL easier. Most of these tools, however, are available in the high-end databases.

IBM developed SQL in 1970, which means it’s been around for over 45 years. Its original name was SEQUEL.  SEQUEL stands for Structured English Query Language. It was developed by Donald D. Chamberlain and Raymond F. Boyce.

SQL is widely implemented by many companies in the industry and almost all major relational database management systems support SQL.

There are four sub-languages that make the SQL:
*Data Query Language (DQL) operations
*Data Definition Language (DDL)
*Data Control Language (DCL)
*Data Manipulation Language (DML)

SQL goes hand-in-hand with the relational model because the result of an SQL query is a table (also called, a result set). Thus, a new permanent table can be created in a relational database simply by storing the result set of a query.
SQL (Structured Query Language)

The Most Popular Posts

  • Pilsner, a pale and crisp lager beer, originated in the city of Pilsen (Plzeƈ), in what is now the Czech Republic, during the mid-19th century. Its creatio...
  • The Shinkansen, widely recognized as the "bullet train," revolutionized rail travel in Japan and set an enduring global benchmark for high-speed rail syste...
  • Acrylamide is a chemical compound that forms naturally in certain foods during high-temperature cooking methods such as frying, baking, and roasting. This ...