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.

Community goal-setting Tracy Press, CA - 1 hour ago ... it was a goal setting session — before a dozen or so Mountain House residents and made it clear what they’d like to see happen over the next few years. ...

Commission strategic planning, goal setting follow-up workshop ... Navarre Press, FL - 12 minutes ago The Santa Rosa County Board of County Commissioners will continue strategic planning and goal setting during a workshop on Thursday, Jan. ...

A strategic plan for goal setting Santa Rosa Press Democrat, CA - 20 hours ago The council has done goal setting, but it seems that there are usually goals focusing on pet projects or pet issues of individuals, but there never has been ...

Team and a Dream Announces Goal Setting Teleseminar for Web Businesses PR.com (press release), NY - 9 hours ago Team and a Dream (www.TeamAndADream.com) is announcing a Teleseminar workshop on January 12, 2009 entitled “Is your Web Business Failing to Capture Clients? ...

Goal-setting programs make for more active co-workers DailyIndia.com, FL - Jan 7, 2009 "They had individual goal setting - a common technique - but they also had group and organizational goal setting, which provided the peer encouragement that ... Wellness programs benefit from management support Business Insurance all 4 news articles

Frugal Duchess: Goal-setting Bellingham Herald, WA - Jan 6, 2009 Goal setting is an annual exercise as we try to whip our home and other fiscal assets into better shape. And so we crunch numbers and try to tone up our ...

Employer-Sponsored Workouts Boost Workers' Health Washington Post, United States - Jan 6, 2009 Key to the program's success may have been the use of group and organizational goal-setting along with individual goals, because they provide vital peer ...

Missoula officials offer New Year's goal setting tips KPAX-TV, MT - Jan 2, 2009 Missoula City-County Health officials say the new year is a great time to re-commit to new health goals. Here are some goals they recommend striving for ...

Workplace program ups employees' exercise levels Reuters - 1 hour ago The findings suggest that similar workplace programs, focused on exercise goal-setting, could help more adults become physically active, according to lead ...

Woman Who Lost 100 Pounds Opens Goal-Setting Social Network PR.com (press release), NY - Jan 2, 2009 Woman who lost 100 pounds shares how to set and achieve your goals through a new goal-setting social network site whose launch date coincides to help make ...