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
Chicago limo Skokie ..In the big, wide online world there are millions of... Read More
Is Your Web Site an Expense or an Investment?Why don't... Read More
Your website conversion rate should concern you. This simply refers... Read More
Affiliate programs are a great way to earn an income... Read More
1. Choose a big enough font size. A size 12... Read More
Did you know that hosting companies overcrowd their servers despite... Read More
When visitors add your web site to their Favorites or... Read More
Through the explosive growth of the Web, companies have realized... Read More
Many websites I come across don't have a single link... Read More
When building a relationship, listening is more important than talking.A... Read More
Today it seems everyone is jumping on the entrepreneur bandwagon,... Read More
If you are living in a country that its native... Read More
Thousands of people are now making a living online and... Read More
So you want to take a look at a real... Read More
Your ObjectiveYour small business needs an appealing and professional website... Read More
Your content is what gets you in search engines, speaks... Read More
An Introduction to Server Side IncludesBeginner? That's OK!While much has... Read More
Many of site owners still don't realize all advantages of... Read More
Selecting the Perfect Domain NameThe first issue I have with... Read More
One of the things that Internet excels is disseminating information... Read More
Building a website and getting it online is easy. Driving... Read More
There have been many significant changes to the face of... Read More
If you are developing your website on a host that... Read More
With the New Year upon us yet again, it's time... Read More
What happened on your website yesterday? What about last week... Read More
limo O'Hare Bonfield ..First, using a lot of web graphics, flash, banners and... Read More
Profiles are one of the best kept secrets around regarding... Read More
The Internet has opened a whole New World of opportunity... Read More
Website, website, website, everyone says you need one. But do... Read More
Before you start building your site, ask yourself "WHY?". Why... Read More
There are many different traffic analysis tools, ranging from simple... Read More
There is an ongoing debate about web copy. Some say... Read More
If you haven't made the sales and built your clients... Read More
You've decided to create a website to market your products... Read More
cPanel is a control panel for your website and allows... Read More
Developing a website with content that entices visitors to return... Read More
1. The first page appears quickly.It's a good way to... Read More
A website provides invaluable advantages for businesses who have one.7... Read More
It may come as some surprise to a traditionally off-line... Read More
For years now I've been looking to start my own... Read More
If you've been developing websites on Mars for the past... Read More
An accessible Web site is easily approached, easily understood, and... Read More
Better Web Site ROIHow to increase your business profitability by... Read More
Writing for the web is totally different to writing for... Read More
If you are living in a country that its native... Read More
If you have some experience in web site design and... Read More
The Disability Discrimination Act says that websites must be made... Read More
The Internet is being used by local service business to... Read More
My life's greatest passion is a safari hobby. And what... Read More
When marketing your website, it's important to know which of... Read More
Web Development |