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.

---

Why Should Your Business Go O.N.L.I.N.E.

Optimize your time. How much time each day must you... Read More

Flash Deadly Sins (That Can Kill Your Web Business)

Looks like every client wants a Flash site these days... Read More

Why Every Small Business Owner Needs Two Websites

Every small business owner knows that they need a website,... Read More

7 Killer Ways To Increase Your Online Sales

Every online entrepreneur I talk to is asking the same... Read More

Guidelines for Web Page Optimization

Below, I have listed 8 simple steps that you can... Read More

Establishing Your Web Presence

Part of the success of most home-based businesses is their... Read More

Tips to Protect Your Downloads or Products

1. Upload robots.txt file in to your root directory and... Read More

From Concept to Website

You've decided to create a website to market your products... Read More

17 Tips to Plan a Website

Everyone wants one.Everyone wishes they knew how to make one.SOME... Read More

How to Get a Better Web Site ROI

Better Web Site ROIHow to increase your business profitability by... Read More

Websites: You Get What You Pay For!

So you finally decided to invest in a web presence... Read More

Web Design for the Professional Magician Part I - Selecting the Perfect Domain Name

Selecting the Perfect Domain NameThe first issue I have with... Read More

Website Survival Guide

In the big, wide online world there are millions of... Read More

WYSIWYG Versus Coding: HTML With A Purpose

After years of working with entrepreneurs who developed their first... Read More

Learn What 98% of Targeted Visitors Do On Your Website

Getting a Targeted Visitor to a website is a waste... Read More

Website For The Company Store

If your company own one or more stores, you might... Read More

Should You Design Your Own Website?

If you're anything like most small business owners, you probably... Read More

Up The Sandbox!

Go to any internet marketing forum you want these days... Read More

Web Site Promotion: How To Advertise Your Website For Profits

Making money with your web site is the dream and... Read More

Ten Quick Tests To Check Your Website For Accessibility

The Disability Discrimination Act says that websites must be made... Read More

Newsletter Management Using PHP w/o mySQL for Beginners

Let's begin by setting some limits. If you're like me,... Read More

Is Your Web Site Talking to Your Customer?

A while ago one of my clients approached me and... Read More

How To Convert More Sales On Your Website

One of the biggest mistakes that most online retailers make... Read More

Entangled in the World Wide Web

I am just a learner who likes to delve in... Read More

Ten Major Tips to Develop a Multilingual Web Site to Work

If you are living in a country that its native... Read More

Effectively Using Robots Meta Tags

The "robots" meta tag, when used properly, will tell the... Read More

Why Your Business Needs a Website

Even with the steady growth of the World Wide Web,... Read More

Using Psychology Easily on Your Website to Make More Sales!

Psychology is a long word which everyone thinks, "no, that's... Read More

Why to Have a Website for Your Company

After having decided to start a business, the next thing... Read More

Learn to Build a Better Online Business Website Using Keywords and Content

Are you aware that 90% of the websites on the... Read More

Website Imperatives and Solutions

When you take a look at the most visited sites... Read More

How To Start Your Own Website

I'm one of those people that always wanted a website,... Read More

I Did It: Six Months to a Successful Website

For years now I've been looking to start my own... Read More