Resources
Home / Resources / Glossary of Terms
SQL

SQL (pronounced “sequel”) is an English-like language used to ask questions of a database. For example, you might ask a database of people to: Select address from people where surname = ’bloggs’

However, the term SQL now refers to more than just the query language – it also tends to be used for the database server software that understands the SQL and manages the database. Popular SQL Servers include Microsoft SQL, Oracle, PostgreSQL and MySQL.

SQL was intended to simplify access to information by making it easier to write complex questions in a way that the computer can understand. However, although it’s true that many users can write simple SQL, many real-world questions are in fact quite complex and require complex SQL. For example: “show me the top three salespeople grouped by division” is a relatively complex question, and most non-programmers are unlikely to be able to write it.

SQL-based database systems have become the dominant approach to storing information, although it’s important to note that SQL is not a very strong standard. Each SQL Server implements its own version of the language and moving SQL queries between database systems can in some cases require significant changes.

Get A Quote
We're easy to talk to - tell us what you need.
0800 862 0555
enquiries@bbconsult.co.uk
Enquiry Form
Call us on Skype Call on Skype
 
 
Copyright © 2009-2012 Blueberry Consultants Ltd.
Custom Software Home  |  Company  |  Contact us  |  Site Map