What is SQL?

Written by John L


What is SQL? SQL stands for Structured Query Language and isrepparttar lingua franca inrepparttar 105563 database world. SQL is a standard that

is used by all database vendors and programmers to define, extract and accessrepparttar 105564 information that is stored in databases.

SQL began life as an IBM creation but was standardized byrepparttar 105565 American National Standards Institute (ANSI) andrepparttar 105566

International Organization for Standardization (ISO) as ANSI/ISO SQL in 1988. Since then ANSI/ISO SQL standard continued to

evolve. The ANSI-SQL group has since published three standards overrepparttar 105567 years: 1. SQL89 (SQL1) 2. SQL92 (SQL2) 3. SQL99 (SQL3)

SQL is a query language. It is English-like and easy to use. However, although there are more than 90 SQL reserved words,

most programmers seldom use more thanrepparttar 105568 following handful of commands - SELECT, INSERT, UPDATE, DELETE, FROM, WHERE,

HAVING, BETWEEN, LIKE, OR, AND, NOT, IN, ORDER, GROUP and BY.

For example, if you had a database table named "employees" and you wanted to retrieve all records whererepparttar 105569 employee hasrepparttar 105570

last name "goodman", you would userepparttar 105571 following SQL statement: SELECT * FROM employees WHERE lastname = 'goodman';

There are many different categories of SQL statements butrepparttar 105572 basic ones which all programmers should be familiar with are

the SQL statements that: 1. Create tables and manipulate their definitions 2. Queryrepparttar 105573 table data 3. Manipulaterepparttar 105574 table data

SQL is predominantly used by 2 types of users - programs and humans (keying inrepparttar 105575 commands through a database client) - to


EXCLUDED ARTICLE

Written by




Cont'd on page 2 ==>
 
ImproveHomeLife.com © 2005
Terms of Use