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

  • Recycle bin functions in computer
    The trash can has been a familiar presence on computer desktops starting with the early Macintosh systems. Unwanted files can be moved t...
  • Characteristic of internet communication
    Consuming resources responding to change and generating offspring, the internet may not be alive in literally sense, but it displays charact...
  • 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...
  • The Importance of Data Conversion in Modern Computing
    Data conversion in computer science refers to the process of transforming data from one format, structure, or type into another to ensure co...
  • Computer profiling
    Due to development of technology, digital devices are changing from data containers to a sort of “digital diaries” where it is impossible no...
  • Food Science Avenue
    Carrageenan, extracted from red seaweeds, stands as a leading hydrocolloid in the realm of food technology. Its applications span a variety of culinary are...
  • Notes of Food Science
    Plants contain thousands of bioactive compounds, known as phytochemicals, that play a crucial role in promoting health and preventing disease. These compou...
  • Shortnotes of History
    The history of hybrid vehicles spans more than a century, showcasing humanity's ingenuity in combining multiple power sources for efficient transportation....