Web Development - What Is Sql?

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.

Created & Maintained by Empower! CMS Web Sites

Host2Sell Web Hosting | Emarketing Workshops | Site SEO Review | FREE Newsletter

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |

The Number 1 Reason Most Websites Fail
Failure, just like success, is measured differently by each and every one of us. What one man treats as success another may view as failure. For the purposes of this article a website that fails is one that fails to attract and convert enough targeted visitors into paying customers.Yeah - positive feedback from your website visitors is great but let's face it - we're all in this ul...(related: Web Development)

Art, Artists, And The Web:part: 2--first Steps In Building An Artist?s Website
What you should do and know if you are an artist and you have decided to have a website.1) Look at "Web Sites T...(related: Web Development)

Your Biggest Mistake When You Create A Website?
--------------------------------Why Should You Create a website?--------------------------------A. What do you want when you create a website?B. What to do to get what you want.--------------------A. What do you want?--------------------1. You may be in a non-profit organisation and want to post forthcoming events on the web. You don't want to have thousands of visitors to the site. But wait - do you want to create a website for new members from the web? I found a new barbershop singer thr...(related: Web Development)

Five Essential Questions To Answer Before Creating Your First (or Second...or Third) Website
Right after the thought, "I need a website," people usually say, "I need a web designer!" Actually, before even whispering "web design," you need to answer these five questions in as much detail as possible. Once you're clear on your strategy, you can provide better information to your web designer. And most likely you'll be pleased with your new home on the web.1. What is the purpose of your website?When you're well-known through face-to-face contacts, your website will s...(related: Web Development)

Art, Artists And The Web: Part 4--what To Do After A Website Is Designed
What to do if you are an artist after you finish your website.Unfortunately, just because you've created a website, does not mean that anyone will visit it. The first thing to do is visit a website called "Words In A Row", www. wordsinarow.com. This is one of the best websites that explains how to have you...(related: Web Development)

2 Key Ways To Make Your Site A Success
If one more business owner tells me their website sucks because they're just "too darn busy to deal with it", I'm gonna hurl. That's like saying, "I'm doing business in my dirty underwear because I'm too busy to get dressed." Realize it or not, your website (or lack thereof) is very often the first impression your prospect or peer will have of you. Now, it's no longer...(related: Web Development)

Enhance Your Website With A Yahoo-style Directory
Does your website have a links/resources page?Do you exchange reciprocal with other websites to help boost your targeted traffic and search engine rankings?Do you believe that a relevant, yet comprehensive resources page provides tangible benefits to your site's visitors?If you answered "yes" to one or more of these questions, then you should consider adding an inexpensive (or free!) Yahoo-style Directory to your website. A quality Directory script will add an air of professionalism to your website and provide valuable content ...(related: Web Development)

New Years Resolutions: Is Improving Your Website One Of Them?
With the New Year upon us yet again, it's time to prepare for the successes of 2005. Did you watch with envy last year as your competitors dominated your industry? Do you think your site is doing just fine because no one has ever called to complain? Well here's some food for thought: 96% of all prospects will click over to your competitor if they encounter a problem on your website.While you're resolving to get fit, quit smoking and pay off some debts, we're offering up some New Year's resolutions for your business. Learn how to ethically kick your online competit...(related: Web Development)

Making Your Website Shine! Attract And Keep Visitors At Your Site!
When you consider the billions of individuals and companies on the net who are attempting to influence visitors with their wares, it is vitally important that your site offers something out of the ordinary. An important fact to remember is that what the site says is far more important than how it looks. Why? Because good copy sells!Pretty is as Pretty Does!I don't mean to imply that a beautiful site isn't going to attract visitors, but pretty is as pretty does! What happens once visitors get to your site? Your potential prospects will surely appreciate an entertaining and good-looking web site but they didn't necessarily come by to be dazzled by the design. They came because they were looking for your product or service. So be sure your site is conveying an enthusiastic message about your business.Content must be ...(related: Web Development)