|
|
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.
The Problem with Automated Accessibility Testing Tools
An automated accessibility tool is a piece of software which can test a web page, or even an entire website, for accessibility. Automated accessibility tools are useful because they can save you a huge amount of time. Don't want to check images for alt text on each and every page on your website? Run the site through an automated tester and it'll do it all for you!
Learn What 98% of Targeted Visitors Do On Your Website
Getting a Targeted Visitor to a website is a waste of time and money if you've got no idea what 98% of them do when they get there.
Unlocking the Power of Your Website!
Why do some web sites reap huge benefits while others just get lost in the shuffle? Do some web masters have a secret that most of us have overlooked? Actually, there is a secret to unlocking the power of your web site and it has to do with words. When communicating via the web, words truly make all the difference. And the only way to get the most out of your website is carefully choosing what you have to say and how you say it.
How Improving Your Sites Usability Can Increase Your Buyers by 40% and Boost Each Order By 10%!
With all of the factors involved in designing and building a web site, one of the most influential questions is often overlooked:
Effective Webdesign
The Basics
Why You Really Need Your Own Web Page In-order To Make Online Business!
How many Web Sites did you stumble over telling you that you don't actually need your own? Now, this is true to a certain extend but not if you are heading for the real scoop.
Abandonment - Why Visitors Don?t Turn Into Customers
Every good Internet business understands the value of conversions versus hits received. Far too often, businesses become fixated on the hits they are receiving instead of monitoring their hit to sale conversion rate. This misguided focus is the road to ruin because it fails to take in the issue of abandonment.
Six Basic Reasons Why Visitors Stay On Your Web Site
1. The first page appears quickly.
12 Tips To Great Websites
Why do some sites succeed while the vast majority of others fail? More and more website owners are asking themselves these questions. The answers are often more obvious than you may think. Below are 12 tips for better, more successful web sites.
Web Accessibility Myths
With more and more countries around the world passing laws about blind and disabled access to the Internet (including the Disability Discrimination Act in the UK), web accessibility has been thrown into the spotlight of the online community. This article attempt to put a stop to the misinformation that has been thrown around and tell you the truth behind web accessibility.
Building eCommerce Websites that Work - Part 2
Succeeding with an eCommerce website is a dream for many these days. It may seem nearly impossible at times, but it can be done. This series covers some of the basic success factors - things you must consider in creating, implementing, managing and developing a quality eCommerce web site. There are many ways to do business on the internet - and, not surprisingly, a lot of ways to both make and lose money. Mainly, I'm focusing on eCommerce sites intended to sell products of various kinds. Not every factor is going to apply to every site, but since a major failing of many internet entrepreneurs is the lack of multiple income streams, you'd do well to carefully consider all factors and apply them as needed in developing alternate revenue streams.
Your Website Should Be Selling
It may come as some surprise to a traditionally off-line business that their website should be attracting new sales, or at least supporting the sales they have made. There is a common misconception that a website is more of a cost than an asset. When I ask companies why they would like a website the common answer is, "I don't know?" It seems to me that having a website is more of a reflex than something that is planned to help grow sales for the company. In other words, "Every business has one, I should too."
Websites for Writers ? Why You Need One and How to Get Started Today
It may seem like the publishing industry's equivalent of Beanie Baby madness- everyone is talking about writer's websites. Freelancers and authors everywhere are jumping on the bandwagon, publishing sites to promote themselves and their work. This craze leaves many writers wondering if it's just a fad or if it's really worth the expense and effort. While it may seem like an overwhelming or frivolous endeavor, there are some solid business reasons why you should consider setting up your own website.
Flash Deadly Sins (That Can Kill Your Web Business)
Looks like every client wants a Flash site these days but the reality is...as flashy as these sites may look, there are many negatives you may want to consider before delving into Flash.
4 Rock Solid Reasons For Building Your Own Website
What is the point of having a website, you may ask, when the affiliate programme you have joined has provided you with your own web page to promote? This is a fair question. The answer has to be that with your own site - and of course your own domain name - you will have a lot more control over your business. Here are four reasons why you should be grabbing your piece of internet real estate - right now.
7 Questions to Understand Your Customer Better
Customer service questionnaires can help your clients better understand their requirements. Your clients can benefit by:
Your Biggest Mistake When You Create a Website?
--------------------------------
Database Driven Web Site - Do You Need It?
Many of site owners still don't realize all advantages of database driven web sites and don't use all abilities they give. So when do you need a database driven web site and how it will make your web-life better?
Why Should Your Business Go O.N.L.I.N.E.
Optimize your time. How much time each day must you devote to paperwork, scheduling and accounting? You strive to meet the needs of your clients, but when chained to the obligations of business management, it's just as important to make sure the doors stay open as it is to satisfy customers. By integrating your daily tasks and taking advantage of the amazing Web-based software solutions out there, you can make more time for clients and spend less time behind your desk. Do you work from home? When your business is online, you can manage your business any place you have a connection to the Internet
Are Web Graphics Stealing Your Money?
They might not be wearing a mask and carrying a gun, but if you've got images on your web pages then they could be costing you a lot more money than you think every time a visitor looks at one. That's because image files are typically the biggest bandwidth user on any web page. Whenever a visitor's browser is displaying an image on your site, it's actually downloading that image to the local user's hard drive. When anything gets downloaded, it uses bandwidth and bandwidth costs money. The moral of that story is: The bigger the image the more bandwidth it consumes.