What is SQL?

What is SQL? SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases. SQL began life as an IBM creation but was standardized by the American National Standards Institute (ANSI) and the 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 over the 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 than the 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 where the employee has the last name "goodman", you would use the following SQL statement:

SELECT * FROM employees WHERE lastname = 'goodman';

There are many different categories of SQL statements but the basic ones which all programmers should be familiar with are the SQL statements that:

1. Create tables and manipulate their definitions

2. Query the table data

3. Manipulate the table data

SQL is predominantly used by 2 types of users - programs and humans (keying in the commands through a database client) - to pass instructions to databases. SQL commands can be keyed into a database client like the MySQL Query Browser or the SQL Server Enterprise Manager and executed to either return a result or modify records in the database. SQL can also be used in conjunction with programming language or scripting language like Microsoft Visual Basic or PHP to communicate with the database.

Although SQL is a world standard, it is unfortunate that most database vendors have come up with different dialects and variations. This is because every database vendor wants to differentiate their database products from the crowd. One good example is Microsoft SQL Server's TRANSACT-SQL. TRANSACT-SQL is a superset of SQL and is designed for use only with Microsoft SQL Server. Although it does make programming much easier for software developers, it is not compliant with other databases like Oracle or MySQL - making TRANSACT-SQL programs non database-portable. As such, although many of these features are powerful and robust, it is good practice to exercise caution and limit your SQL use to be compliant with the ANSI/ISO SQL standards and ODBC-Compliant.

Courtesty of SQLPrimer.com. For more information, please contact the Webmaster of SQLPrimer.com - http://www.sqlprimer.com.

New Listing of Knowledgeable Scripts for Web Development- Now at ... MediaSyndicate (press release) - 13 hours ago Soloscript.com lists valuable tutorials related to web development and designing. One can now refer, download, and add scripts essential for designing and ...

Stripes: ...and then Java Web Development Is Fun Again! Kansas City infoZine, MO - Nov 18, 2008 In Stripes: ...and Java web development is fun again! (Pragmatic Bookshelf, $36.95), author Frederic Daoud shows you how to use Stripes to its full ...

Ericsson to close Marshall plant; 250 jobs affected Pittsburgh Tribune-Review, PA - 17 hours ago By Kim Leonard Workers at Ericsson's plant in Marshall were told today that the plant will close at the end of 2009, according to a message on the company's ...

City hangs out 'for sale signs' to cut into anticipated deficit Poughkeepsie Journal, NY - 3 hours ago By Michael Valkys • Poughkeepsie Journal • November 21, 2008 City of Poughkeepsie leaders have sold all those items in recent months as they fight off a ...

Direct Hit Solutions Ranks as Best Web Development Company by SEO ... PRnine (press release), CA - Nov 14, 2008 Chicago, IL (PRnine - November 14, 2008) - The quality and breadth of Direct Hit Solutions, a web development firm specializing in meeting the needs of ...

AustConserv Promoting Eco Friendly Businesses and Organisations to ... PR Web (press release), WA - Nov 19, 2008 Using various methods of online marketing available, PB Web Development has created a buzzing online conservation community with user base that grows more ...

SEO Web Development and Design Outsourcing Services PRLog.Org (press release), Romania - Nov 18, 2008 PRLog (Press Release) – Nov 18, 2008 – SEO Web Development Outsourcing services is become most useful to the online web marketing and for any small business ...

Seattle Sounders FC Selects Digitaria to Kick Off New Digital Strategy PR Web (press release), WA - 21 hours ago San Diego, CA (PRWEB) November 20, 2008 -- Digitaria (www.digitaria.com), a leading full-service digital marketing and technology firm, today announced that ...

NGM Expands Web Development Capabilities InsideARM, MD - Nov 12, 2008 Net Gain Marketing, Inc. (www.netgain4results.com) has announced it has signed an exclusive agreement with EarthSky Studios (ESS) to work together to ...

Councillor to continue web development WalesOnline, United Kingdom - Nov 12, 2008 ATTEMPTS to bar a councillor from completing the development of his council’s controversial website have fallen on deaf ears. ...