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)

at 3:13 AM
Labels: , , , ,

The Most Popular Posts

  • Characteristics of computer: Accuracy
    Accuracy of a computer is consistently high and the degree of accuracy of a particular computer depends on the instructions and the type of ...
  • The Characteristics of Computers
    Much of the world runs on computers and computers profoundly changed human life mostly for better. What is the characteristics for computer:...
  • Utility Programs
    The utility programs is a type of system software that allows a user to perform maintenance-type tasks, usually related to managing computer...
  • Microcomputers
    When all the circuitry for a digital computer is contained on one integrated circuit, the unit is called a microcomputer. Even though ther...
  • Characteristics of computer: Versatility
    Computer is versatile in nature. Multi-processing features of computer makes it quiet versatile in nature. It can control a variety of job...
  • Food Science Avenue
    Niacin deficiency, often referred to as pellagra in its severe form, can lead to a spectrum of health problems due to niacin's essential role in the body. ...
  • Shortnotes of History
    The history of toothpaste is a fascinating journey through time, reflecting humanity's evolving understanding of dental hygiene. The earliest known toothpa...
  • Notes of Food Science
    Organic food refers to agricultural products grown and processed without the use of synthetic chemicals such as pesticides, herbicides, and fertilizers, as...