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 Methodology Followed by a Web Development Company Online PR News (press release) Proper planning and following a strategic process is cardinal to a web development company to develop bleeding-edge applications using web development ...

Big Star Media Group Partners With Graphic Design / Web Development Firm PR Newswire (press release) CLARKSDALE, Miss., July 29 /PRNewswire-FirstCall/ -- Big Star Media Group, Inc. (Pink Sheets: BMGI) (the "Company") a diversified entertainment and ... and more »

Think About Web Development For the iPhone Boosh News (press release) (blog) A free laptop for students is definitely something that will be put to good use. Would you like to get a yourself or a student a high quality new laptop, ...

Web Development Is a Broad Term That May Entail Web Designing, Content Writing ... SBWire (press release) Wildnet Technologies is a Web development company India to ensure that the needs of all those who require an effective website are met efficiently and ... and more »

Graphic Design and Web Development Coordinator Animation World Network Graphic Design and Web Development Coordinator. This position works with both the Graphic Design Manager and Web & E-Communications Manager in support of ...

OpenXcell to Offer Drupal Web Development Services to World Wide by '10 SBWire (press release) To meet the online marketing needs, OpenXcell Technolabs is now offering with the Drupal web development services. The firm is offering its services at a ... and more »

Metromode Media

Web Development Intern Metromode Media Web Development Internship Blue Sky Sessions, a small web development firm in Holland, Michigan, is seeking a paid web development intern to start work ... and more »

Sparsh Technologies Offers Complete Joomla Development Services for Web ... Online PR News (press release) Sparsh Technologies aids web development in Australia by providing array of Joomla development services to the local Australian businesses. ... Hire Good Joomla Developers India to get Proficient Joomla WebsitesPR-inside.com (press release) all 4 news articles »

ForeSite Technologies Executive Vice President Named 40 Under Forty PR Web (press release) Benjamin Sweet honored by Hartford Business Journal – ForeSite, a web development, web design and computer support firm based in East Hartford, ... and more »

SDLC Methodology and its Benefits to a Web Development Company Jazzou (blog) In this competitive world of software development to survive Darwin's theory of survival of the fittest it is important that a web development company ...