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.

More Web Development Articles

Get to Know People through Websites
Web sites are not just places to sell things; they are a medium where people can get insight into other people?s lives. Take the musician Xavier Rudd for example.

Find the Purpose of Your New / Proposed Website
Absolutely everything stems from the purpose of your website - selection of hosting, programming, graphic design, copywriting, internet marketing, autoresponder service, and e-commerce. So it's very important to establish the purpose of your business website first.

Internet Marketing Website Promotion -The 7 Biggest Mistakes I See People Make With Websites!
1. Many people are not getting good or complete advice.

Writing Effective ALT Text For Images
Anyone who knows anything about web accessibility knows that images need alternative, or ALT, text assigned to them. This is because screen readers can't understand images, but rather read aloud the alternative text assigned to them.

Free Isnt Always Good - 5 Reasons Why You Need Your Own Website
Often time I've browsed sites and seen the same thing - general rep websites or free hosted sites. Pop ups irritate me from the free sites as does the blatant ads getting in the way of the text, and if you have seen one rep site you literally have seen them all.

How to Get a Knock Out Website!
The first step in setting up an online business..

How Did You Get Here?
When marketing your website, it's important to know which of your efforts are producing results and which of them are a waste of time.You can learn a lot about this by analyzing your website's statistics (assuming your webhost offers this service).

Planning Your Website for Success
Most people know they need a website in order to publicise and promote their business but very few people know what they want in their website. Fewer still are those who can actually sit down and plan their websites well.

Web Development Processes and Technical Environments
The process of Web application development is critical to the success of web-based projects. The proper processes can not be enforced unless technical environments are properly setup.

What Does An Ex-Basketball Coach Know About Pulling Web Metrics?
In my previous life..