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 - sqlprimer.com
apartment cleaning near Wilmette ...In about the Time it takes to Watch a Reality... Read More
Optimize your time. How much time each day must you... Read More
An accessible Web site is easily approached, easily understood, and... Read More
Keywords in Search Engine Optimizing and Search Engine Marketing are... Read More
A simple website stats counter is not enough if you... Read More
Does your website have a links/resources page?Do you exchange reciprocal... Read More
In this day and age most businesses consider having their... Read More
Web sites are not just places to sell things; they... Read More
One of the most useful features offered by some web... Read More
Is Your Web Site an Expense or an Investment?Why don't... Read More
A lot has changed in the way sites are optimized... Read More
When visitors add your web site to their Favorites or... Read More
As a business you can't afford to ignore the Internet... Read More
1. Address your targeted audience on your business site. Example:... Read More
Analyzing traffic to a site is a key factor in... Read More
It never ceases to amaze me how many people set-up... Read More
So you have decided that you want to do freelance... Read More
1. SiteSpinner V2 - On Sale www.deprice.com/sitespinner.htmSiteSpinner is a user-friendly... Read More
The Internet is a remarkable publishing medium. With just a... Read More
The definition of the phrase "Content Management" depends on what... Read More
A professional online reputation is essential to the flourishing of... Read More
We've all seen those messages on some websites warning not... Read More
Is your website Really useful?I had a 'rep' in yesterday... Read More
The first thing my business consultant (read brother-in-law) asked me,... Read More
With search engines putting a damper on direct reciprocal links,... Read More
bedroom cleaning professionals Morton Grove ...I am just a learner who likes to delve in... Read More
A while ago one of my clients approached me and... Read More
After years of working with entrepreneurs who developed their first... Read More
If you haven't made the sales and built your clients... Read More
Every business needs to know how it is doing. That's... Read More
In the time that I have been using the Internet,... Read More
Revenues are often lost because many business owners don't see... Read More
First, an eye opener. Making your fortune through affiliate programs... Read More
You've put up a website to promote a product or... Read More
Have you ever thought the secret behind the success of... Read More
Understanding and using web analytics.In recent years, website marketers were... Read More
The first thing you will have to deal building your... Read More
Many web developers today are starting to KISS their website,... Read More
An Introduction to Server Side IncludesBeginner? That's OK!While much has... Read More
Profiles are one of the best kept secrets around regarding... Read More
As a business you can't afford to ignore the Internet... Read More
While creating a Web site may seem like... Read More
How many Web Sites did you stumble over telling you... Read More
Looks like every client wants a Flash site these days... Read More
The process of Web application development is critical to the... Read More
The first step in setting up an online business...Starting an... Read More
In the late 1990's three San Francisco based web developers... Read More
Do you make your website just to entertain yourself or... Read More
1. Upload robots.txt file in to your root directory and... Read More
You don't believe in astrology but you check your horoscope... Read More
Web Development |