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.

Web Development Company CEO elected to NJRCC Board of Directors TransWorldNews (press release) Founder, president and CEO of Web Development Company Hudson Horizons, Daryl H. Bryant, was recently elected onto the Board of Directors for the North ...

Mashable's Weekly Guide to Social Media & Web Development Jobs Mashable (blog) But we'd like to help in a more direct way, too. Mashable's job boards are a place for socially-savvy companies to find people like you. ... and more »

topseos.in Recognizes the Best Indian Web Development Firms for November 2009 Online PR News (press release) Online PR News – 18-November-2009 – Plymouth, IN- The Best Indian Web Development Firms have been chosen by topsoes.in for this month. ... and more »

3D Web development critical to HPC growth EE Times India The 3D Web development is critical to the growth oh high performance computing. "Nothing is more important to the long term health of the HPC industry than ...

Twitlicious - Republican/Democrat conceit, joining the Trump Network and ... MarketWatch Quick note to start - I need some interns for web development, stock mkt research and other stuff. No pay to start, but foot in the door. ...

appendTo Releases Industry-Leading Support, Training Solution to the jQuery ... PR Web (press release) “Corporate IT teams and web development professionals are increasingly seeing the value of using jQuery's sustainable, open source JavaScript library for ... and more »

ASP Web Development Team Leader ashdowngroup.com This is an excellent opportunity for an experienced Classic ASP Developer to take a Team Leader / Project Manager position within this leading online ...

Advaiya, Inc., Announces Cutting-Edge Microsoft SharePoint and Silverlight Web ... PR Newswire (press release) KIRKLAND, Wash., Nov. 17 /PRNewswire/ -- Sandy Sharma, CEO of Advaiya, Inc., a leader in new technology and Web site development, today announced Advaiya's ... and more »

Web Development Innovation Set To Disrupt Matters Scoop.co.nz (press release) The days of spending thousands of dollars on web development fees for small to medium sized businesses are over, that's according to Andrew Hendrie, ...

Getting Twitter storms in perspective guardian.co.uk Joanna Geary, web development editor for The Times and one of the most thoughtful of journalistic bloggers, has an interesting take on Twitter storm ...