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
executive chauffeured services Bradford .. Madison to Airport carOne of the things that Internet excels is disseminating information... Read More
Most web sites are more like stage sets than real... Read More
1. Address your targeted audience on your business site. Example:... Read More
Succeeding with an eCommerce website is a dream for many... Read More
The first thing you will have to deal building your... Read More
If you are living in a country that its native... Read More
Before you start building your site, ask yourself "WHY?". Why... Read More
Why do some web sites reap huge benefits while others... Read More
What is SQL? SQL stands for Structured Query Language and... Read More
Appealing to others is really important when you have a... Read More
It's now easier than ever to take payments on the... Read More
Three way linking and concerns.For many years SEO experts were... Read More
Your ObjectiveYour small business needs an appealing and professional website... Read More
1. The first page appears quickly.It's a good way to... Read More
This simple question can take on several different forms, but... Read More
The definition of the phrase "Content Management" depends on what... Read More
Most interactive websites nowadays would require a user to log... Read More
We are clearly well past the innocent "golden age" of... Read More
The big thing these days is your ability to capture... Read More
The first step in setting up an online business...Starting an... Read More
When you publish a content site there are times when... Read More
What is the point of having a website, you may... Read More
Installment 1Developing State-enabled Applications With PHPWhen a user is browsing... Read More
The first thing my business consultant (read brother-in-law) asked me,... Read More
Designing an E-commerce Web site is not as simple as... Read More
O'Hare Chicago prom limo ..When building a relationship, listening is more important than talking.A... Read More
Anyone who knows anything about web accessibility knows that images... Read More
Your site is fast and getting traffic, but conversion rates... Read More
A PHP Redirect automatically transfers a web user from one... Read More
In this day and age most businesses consider having their... Read More
If one more business owner tells me their website sucks... Read More
Is Your Web Site an Expense or an Investment?Why don't... Read More
Often time I've browsed sites and seen the same thing... Read More
Directory Generator, a product from Armand Morin and Marc Quarles,... Read More
Everyday thousands of new businesses make the leap and take... Read More
The first step in setting up an online business...Starting an... Read More
Globalize Your WebsiteThe Internet has unlocked a wide array of... Read More
Here's something you may never have thought of before:If I... Read More
Running an effective website is a continuous process. I have... Read More
Writing for the web is totally different to writing for... Read More
Launching a new small business website is often a long... Read More
A while ago one of my clients approached me and... Read More
In about the Time it takes to Watch a Reality... Read More
If you are looking for creating your online presence you... Read More
We've all seen those messages on some websites warning not... Read More
1) Word of Mouth The single most powerful form of... Read More
1. The first page appears quickly.It's a good way to... Read More
What is SQL? SQL stands for Structured Query Language and... Read More
You've decided to create a website to market your products... Read More
Never has competition been so difficult in the Internet world.... Read More
Web Development |