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.
Add to these social bookmarking sites:
Victoria, British Columbia, Web Development and Internet Marketing College ... - PR Web (press release)
Notice: Undefined index: TITLE in /var/www/vhosts/harmonyhollow.net/httpdocs/webmaster-resources/web-development/inc/rss.inc on line 103
Website Sales: 10 Reasons Why People Dont Buy From You
You've put up a website to promote a product or service.You've spent piles of cash to generate traffic.
Making Your Websites More Compelling
The Internet is a remarkable publishing medium. With just a little effort, you can make your web pages visually irresistible by playing with color, shapes and text.
Beautiful Web Sites Seldom Make More Sales
Designing an E-commerce Web site is not as simple as having a "pretty" site that is a pleasure to visit. While it is important to have an attractive site, as much thought must be given to functionality as to appearance.
WYSIWYG Versus Coding: HTML With A Purpose
After years of working with entrepreneurs who developed their first web site using an image-based editor, the new world of internet marketing has placed a stronger emphasis on web development that conforms to technical concerns such as search engine optimization and multi-browser compatibility.Wigging OutWYSIWYG (What You See Is What You Get, pronounced "whizzy wig") web site editing programs can allow anyone to develop rich, full-feature web sites without a working knowledge of HTML (Hypertext Markup Language).
Improve Conversion Rates - Effective Content
Your site is fast and getting traffic, but conversion rates are disappointing. You may have problems with the tone of your contentDo You Believe?You must have passion for the product or service you are providing.
Set Up Your Website in Minutes - For Free
There was a time not long ago when setting up a website meant endless technical jargons, hiring a web designer, writing the html or jawa codes, selecting the right hosting platform and deciding on the band width.Now setting up a website is like 1.
The Top Ten Benefits of Having a Web Site
Do you need a web site? Are you considering getting one but are unsure? Here we take a look at the main reasons why a web site could be beneficial to your organisation.1) It will give you the competitive edgeIf you do not have a web site people cannot visit it - an obvious point you might say.
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.
Do You And Your Website Have Credibility?
I recently received an unsolicited e-mail from some company offering me their search engine optimization services for $199. Even though I had absolutely no interest in the offer, just out of curiosity, I decided to check out this company with the various search engines.
Web Coach Tip: What You Should Know About DIY Web Sites
Recently, a friend asked "What's the deal with those DIY companies that advertise "How to get a website with everything your business needs for under $20 bucks a month?". "How can they do that?" she said.
Using Mini Websites - Powerful Way to Direct Marketing
Mini Websites are the most powerful and cost effective solution to promote and market your brand. Normally people go for a large site which have 100's of pages of selling nos.
Why Do I Need A Web Site?
Even though the Internet has been around for a long time and many people are "educated" about the Internet, most have little knowledge about what a web site is and what can it do for their business.A web site is anything and everything you want it to be.
Why Local Service Companies Should Have a Website
The Internet is being used by local service business to improve sales today. Sales are improved because a website gives a company more credibility and in some cases generates leads.
The Number One Reason Most Websites Fail
Failure, just like success, is measured differently by each and every one of us. What one man treats as success another may view as failure.
4 Marketing Tips for Resourceful Webmasters!
The internet is a sea of knowledge. Getting your information to 'float' by the right audience can be like finding that one special grain of sand on the seashore.
Things to Consider Before Starting a Website
In the time that I have been using the Internet, (since 1996) I have seen a lot of websites. I have seen a lot of good websites and I have seen a lot that were just plain awful.
What is Blogger.com?
In the late 1990's three San Francisco based web developers came up with the idea of being able to share information about anything on the web. The terminology they used was called blog.
Why Is No-one Buying From My Website?
Are you, like many other website owners, frustrated at the amount of time, effort and money you've put into your website, only to see few or no sales?Like most business owners, you probably know your products or services inside out; you know the benefits of them, and what they can give to other businesses or consumers. And you probably paid good money for a website to promote them.
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.
Using Psychology Easily on Your Website to Make More Sales!
Psychology is a long word which everyone thinks, "no, that's not for me, it'll be too difficult". Apart from being lazy, anyone who thinks this is wrong.
|Home | Site Map|