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.
|
|
|
|
|
|
|
|
|
|
|


Although designing a great web site is an important part... Read More
In the time that I have been using the Internet,... Read More
Designing and creating your own website does not have to... Read More
Thousands of people are now making a living online and... Read More
Having an eye catching website is great, but are you... Read More
Right after the thought, "I need a website," people usually... Read More
The Disability Discrimination Act states that service providers must not... Read More
What you should do and know if you are an... Read More
Even with the steady growth of the World Wide Web,... Read More
Q1.Why would I need a web site? A1.- Improve my... Read More
Directory Generator, a product from Armand Morin and Marc Quarles,... Read More
In this day and age most businesses consider having their... Read More
Like any area of business your website needs some effort... Read More
If you don't have a web site yet, are thinking... Read More
Q. Hey, Cathy: I'm just setting up a website. What... Read More
Most interactive websites nowadays require data to be presented dynamically... Read More
Creatively marketing your corporate site takes time in the set... Read More
You want to give your site's visitors a way to... Read More
No matter the size of your business, having a web... Read More
When web content gets discussed on webmaster bulletin boards, the... Read More
A lot has changed in the way sites are optimized... Read More
Making maximum profit from your law firm website is important,... Read More
In about the Time it takes to Watch a Reality... Read More
Some left shoes are in isle 5, while the right... Read More
An automated accessibility tool is a piece of software which... Read More
Do you need a web site? Are you considering getting... Read More
Your site is getting traffic, but conversion rates are horrible.... Read More
So your traffic is going through the roof yeah? It's... Read More
Rosalind wants to share her inspirational poetry with a wider... Read More
Getting a Targeted Visitor to a website is a waste... Read More
Even though the Internet has been around for a long... Read More
In this example I have used the map of the... Read More
When you purchase a new item from a Yahoo! Store,... Read More


A website is lifeline of internet home business. In order... Read More
I'm one of those people that always wanted a website,... Read More
Running an effective website is a continuous process. I have... Read More
Like any area of business your website needs some effort... Read More
Dynamically Update Your Web Pages Via E-MailIf you can Send... Read More
Optimize your time. How much time each day must you... Read More
The needs of screen magnifier users are overlooked when implementing... Read More
So you want to take a look at a real... Read More
Making a web site is easy. Making a good web... Read More
You have permission to publish this article electronically, in print,... Read More
First, using a lot of web graphics, flash, banners and... Read More
Go to any internet marketing forum you want these days... Read More
Three way linking and concerns.For many years SEO experts were... Read More
The popular search engine Google indexes over 8 billion websites.... Read More
There are hundreds of millions of Web surfers today. Each... Read More
Just like all things in life, the ways to run... Read More
Q. Hey, Cathy: I'm just setting up a website. What... Read More
Analyzing traffic to a site is a key factor in... Read More
With the New Year upon us yet again, it's time... Read More
Webmasters deal with a myriad of complex design challenges every... Read More
Think up a name and check if yourname.com is available.... Read More
Absolutely everything stems from the purpose of your website -... Read More
The DDA (Disability Discrimination Act) states that service providers must... Read More
When you purchase a new item from a Yahoo! Store,... Read More
If you are developing your website on a host that... Read More
The first thing you will have to deal building your... Read More
A website provides invaluable advantages for businesses who have one.7... Read More
Do you make your website just to entertain yourself or... Read More
Many websites I come across don't have a single link... Read More
1. Address your targeted audience on your business site. Example:... Read More
Most people know they need a website in order to... Read More
A while ago one of my clients approached me and... Read More
1) A marketing necessityI still hear it said from time... Read More
Web Development |