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
Research reveals three important facts:1) The Internet is one of... Read More
There was a time not long ago when setting up... Read More
Huge Mistake #1: Creating a Website with Flash -- Did... Read More
What to do if you are an artist after you... Read More
I recently received an unsolicited e-mail from some company offering... Read More
In my previous life.....Actually, my previous JOB life, I was... Read More
The internet is a sea of knowledge. Getting your information... Read More
I can't think of any business alive today that couldn't... Read More
Thinking about starting up a business? The web is the... Read More
When a user signs up at your website, you may... Read More
While it may seem like a "quick and easy" task,... Read More
One of my most salient memories from when I sold... Read More
Although designing a great web site is an important part... Read More
Project Safekids provides webmasters a valuable tool which could save... Read More
More and more businesses are recognizing the importance of content... Read More
Conceptualize, Build and Publish a Web site - What's required... Read More
Simply ensuring your website is accessible to screen reader users... Read More
Anyone who knows anything about web accessibility knows that images... Read More
So you want to have a website. You have gone... Read More
Let's begin by setting some limits. If you're like me,... Read More
The Internet is a remarkable publishing medium. With just a... Read More
"I don't sell anything online, I don't advertise online, in... Read More
If your company own one or more stores, you might... Read More
What is the point of having a website, you may... Read More
Before you jump into spending coutnless hours on designing and... Read More
Are bloated images slowing down your web site and causing... Read More
Some left shoes are in isle 5, while the right... Read More
Setting up a website is the very first step of... Read More
When used to describe a web site, the term "sticky"... Read More
Developing a website with content that entices visitors to return... Read More
First, an eye opener. Making your fortune through affiliate programs... Read More
Never has competition been so difficult in the Internet world.... Read More
Many of site owners still don't realize all advantages of... Read More
Creatively marketing your corporate site takes time in the set... Read More
Wow, we`ve already taken a domain and chosen a web... Read More
No matter what browser you may want to use, you... Read More
Dynamically Update Your Web Pages Via E-MailIf you can Send... Read More
After deciding what kind of internet business you want to... Read More
A while ago one of my clients approached me and... Read More
How can we add Word Rich Content to our Websites... Read More
SiteSpinnerSiteSpinner is a user-friendly web site development tool that includes... Read More
The Internet is a remarkable publishing medium. With just a... Read More
You've put up a website to promote a product or... Read More
If you are like me you have wanted to build... Read More
"Don't Sell the Steak, Sell the Sizzle."Have you heard of... Read More
Building a new website can be a lengthy task. From... Read More
Does your website have a links/resources page?Do you exchange reciprocal... Read More
You've decided to create a website to market your products... Read More
As increasing numbers of people search for information on the... Read More
Huge Mistake #1: Creating a Website with Flash -- Did... Read More
Web Development |