Wednesday’s word
Posted by Jennifer on 3 September, 2008 in Technology, wednesday's word
SQL- Structured Query Language
A database is a collection of tables that contain similar facts about data. There are two types of databases: 1) Flat File – this is more of a spreadsheet of growing data. Cells with the same information can be filtered and isolated by the Data Sort function; 2) Relational databases – sets of tables of similar data that can be mined for specific pieces of information with Structured Query Language. Think of MIDAS as a massive relational database that relies solely on SQL.
SQL allows you to search a relational database and filter only the information you need and presented to you in an order that you choose. If you are searching a database and using drop-down boxes to help you find what you are looking for, you are using SQL- the drop down boxes are essentially writing the SQL statements for you.
Wednesday’s word is brought to you by SOLINET’s Charlie Sicignano. For additional information check out “Learning SQL” by Sikha Bagui & Richard Earp. Other resources for SQL are http://www.sql.org/, http://www.sql-tutorial.net/ and www.sqlzoo.com.
Subscribe
Follow comments by subscribing to the Wednesday’s word Comments RSS feed.