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.
More and more businesses are recognizing the importance of content management when it comes to their websites. Website content is more important than ever before, and as the Internet matures and changes, it is likely be become even more important.
Web Site Promotion: How To Advertise Your Website For Profits
Making money with your web site is the dream and goal of millions of webmasters all over the internet including myself. In order to reach this goal you need a variety of web site promotions running all at the same time.
2 Key Ways to Make Your Site a Success
If one more business owner tells me their website sucks because they're just "too darn busy to deal with it", I'm gonna hurl. That's like saying, "I'm doing business in my dirty underwear because I'm too busy to get dressed.
Making The Business Case For Web Standards
Through the explosive growth of the Web, companies have realized the benefit of building a strong online presence. By publishing a website to the Internet, companies are able to build their brand, market their products, support existing customers, release publicity pieces, and even take orders.
Direct Sales and Your Corporate Website - A Creative Marketing Plan that Works!
Creatively marketing your corporate site takes time in the set up but you will learn that building your customers isn't about marketing your products but getting your name and reputation into the minds of internet customers.I have randomly chosen Watkins to design a marketing approach but you will see how to apply this concept to any direct sales company.
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.
How To Evaluate Your Web Sites Performance
Setting up a website is the very first step of an Internet marketing campaign, and the success or failure of your site depends greatly on how specifically you have defined your
web site goals.If you don't know what you want your site to accomplish, it will most likely fail to accomplish anything.
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.What we all aim for is to go from point A to B in the shortest time.
Why to Have a Website for Your Company
After having decided to start a business, the next thing that arrives in your mind is How to market the Product/Service? How to create a brand? How to recruit people? How & where to advertise? etc? Next is creating departments like Marketing, Operations, Advertising, Branding and Human Resource. You need some way to represent each department?For example Human Resource needs a way to represent the company to hire talents, marketing team needs someway to represent products/services, branding team needs a way to represent the company overall.
Server Side Includes (SSI) with ASP
Server Side Includes (SSI) with ASP
People often have identical sections of code spread throughout many ASP pages, typically code at the top of the page (usually referred to as the header) and the lower part of the page (the footer). Similarly, you may have code that performs a certain set of instructions that you are repeating across multiple pages.
Study Your Sites Performance Via Hit Tracking
Knowledge is power.And undoubtedly, it is the key to making a substantial fortune online.
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.
Adding Word Rich Content to Your Website
You have permission to publish this article electronically, in print, in your ebook or on your web site, free of charge, as long as the author bylines are included.Adding Word Rich Content to your Website.
Guide to Internet Business - Website Setup
After planning the design and content of your website, it's time to actually physically set up your website. This is the step where you put all your designs and plans into action, creating a website that will attract visitors and earn income.
Live Support from Your Website? Can You Do It for Free?
I'm a freelance programmer and somehow I managed to get clients, speak with them, and generate leads for years without a live help system. To be honest, I had put in bids for a "live" help system several times, and I wasn't aware there were free options out there.
7 Reasons YOU Need a Website
1) A marketing necessityI still hear it said from time to time that you really do not need a website if you are a private practice professional. I disagree.
7 Questions to Understand Your Customer Better
Customer service questionnaires can help your clients better understand their requirements. Your clients can benefit by:* Focusing on immediate project requirements
* Increased awareness of budgeted time and finances
* Better understanding of project goals
* Setting priorities of essential project features
* Planning for project post-implementation phaseOn the other hand, you as a service provider will have a clearer understanding of what your clients want.
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?What is a database driven web site? Database driven web site is one that uses database for collecting and storing information.
Getting One-way Inbound Links: the 5 Major Strategies
With search engines putting a damper on direct reciprocal links, the hunt for the elusive one-way inbound link is on.As someone who works with small business website owners, I've heard just about every inbound-linking scheme there is.
35% Revenue Increase? from Your Website!
2 Golden Rules for an Engaging Website35% of visitors fail to achieve their goal when they visit company websites! By following 2 simple rules, you can increase your web-derived revenue by 1/3 or more!Renowned website usability researcher, Jakob Nielsen, today (Nov 24) published results of his latest study. His test subjects used 139 websites.