SQL  (Structured Query Language) pronounced seaqwell

 A query language is a programming language which is designed to search a database. There are different query languages each with their own syntax.There have been variations to SQL which have been designed for specific DBMSs. For instance Access has its own form of SQL called MSSQL which stands for Microsoft SQL, but most of these variations are based on standard SQL.

 

Stored data is manipulated using a programming language called Structured Query Language, or SQL. Many varieties of SQL exist. SQL is based on set theory; relational operators such as and, or, not, in are used to perform operations on the data. The operations that can be used in a relational database include insert, select, update, and delete privileges.

 

Search query language which is designed to help a DBMS manage and search databases.

KEYWORD (which is always in capitals)	VALUE	DESCRIPTION	EXAMPLE
SELECT	fields to search	need to include the names of the fields to search, There can be more than one field but each must be seperated by a comma	SELECT CompanyName,Email
FROM	Table(s) names where fields are found	There will often be many tables, they can all be included	FROM Customers,Orders
WHERE	Search criteria i.e. what you are looking for	this is the main focus of your query, the rest of the query is where to find it	WHERE Customers="John"
ORDER BY	Field name and whether ascending or descending order	This is to do with the presentation and the order in which results will be displayed	ORDER BY Customers ASC NB Ascending is ascending order, it can also be DESC for descending order

 

 

More On Distributed Databases: Distributed Databases,

 

 

Related Topics (Information Systems) : DBMS, The 5 Types of Information Systems, Expert Systems, TPS, DSS, ES, MIS, OAS, Characteristics, computerised methods, non-computerised methods, flat file databases, relational databases, data modelling, URLs, storyboards, searching, HTML, backups, security methods, encryption, firewalls, virus' and virus scanners, passwords and security levels, social and ethical issues, data accuracy, data integrity, data validation, data bias, data reliability, privacy, ownership and control of data, access to data, data warehousing, data mining, freedom of information, acknowledgement of data sources, issues related to new trends, sequential access, direct access, distributed databases, storage media, querying, operators, wildcards, sorting, SQL, biometrics and ethical issues, face recognition

 

See Also: Knowledge Management, data mining,Information systems