---

• SfC home page
• About the SfC
• Success Stories
• Weekly Feedback

Subjects

Academic

• Algebra
• Arithmetic
• Astronomy
• Biographies
• Chemistry
• Electricity
• Electro-Optics
• Grades in School
• History
• List Your College
• List Your High School
• List Your Mid. School
• Magnetism
• Physical Science
• Physics
• Mental Health
• Missile Defense
• Strategic Defense
• Speeches
• Static Electricity
• Sports
• Tests
• Writing Methods

Life issues

• Animal Health
• Behavior
• Champion in Life
• Character
• Communication
• Competition
• Cookware
• Excellence
• Handling Money
• Health
• Knowledge
• Life Success
• Mental Health
• Religion
• Senses
• Spiritual Health
• Value in Life
• Vitality
• Winning

Professional

• Business
• Career
• ColdFusion
• e-Commerce
• Education
• e-Learning
• Entrepreneurship
• Fiction Writing
• Flash Development
• FrameMaker
• Internet Business
• ISO 9000
• List Your Company
• Marketing
• Online Business
• Personal Finance
• Public Speaking
• Quality Improvement
• Sales
• Starting a Business
• Security
• Self-Publishing
• Speaking to Groups
• Spiritual Health
• SQL Development
• Technical Writing
• Total Quality
• Training
• Web-Based Training
• Web Design
• Writing

---

Succeed in Using SQL

SQL (Structured Query Language) is a computer language used to query or make commands to a database. It is structured to be relatively straightforward and simple to use. SQL is used with such databases as Microsoft Access, My SQL, and Microsoft SQL Server. It is often used with Web programming languages, such as ColdFusion, ASP, and PHP.

The purpose of these lessons is to provide you with the basics of using SQL to query a database. It is also useful for those studying Web programming and e-commerce. If you have any questions, send us an email.

Contents

• Basics
• Resources
• Survey question
• Miscellaneous

---

Basics

Database Basics

Retrieving Columns of Data from a Database Table

Sorting Column Data Retrieved from a Database Table

Filtering Data Retrieved from a Database Table

Advanced Data Filtering

Wildcard Filtering

Creating Calculated Fields

Data Manipulation Functions

Summarizing Data

Grouping Data

Subqueries

Joining Tables

Advanced Joins

Combining Queries

Inserting Data

Updating Data in SQL

Deleting Data

Creating Tables

Manipulating Tables

Views

Transaction Processing

Resources

General SQL Reader Feedback

SQL Resources

Survey question

Answer a survey question and see the results from other participants.

Yes | No  

See results of all questions

Miscellaneous

---

If you agree with the philosophies of the School for Champions and have any questions or would like to support, sponsor or contribute in some manner, please send an email.

Also, feel free to establish a link from your web site to pages in this site:

Or use our form to send this link to yourself or a friend.

School for Champions

Champion a worthy cause

There are many problems in this world that need people to help in solving them.

If you see an injustice or someone in need and feel strongly about the situation, you can champion it as a cause and work to solve the problem.

Help out

Some can simply give donations to a charity, while others can get involved and participate in the solution.

When you champion a cause, you are making a difference. That is an important purpose of the
School for Champions.

Some causes that need champions include:

Haiti earthquake: How to help - A list of agencies in the Washington Post

Chile Earthquake - How to help and other volunteer opportunities

Doctors without Borders, providing aid to people whose survival is threatened by disasters or violence

Action Against Hunger, providing solutions to world hunger

CARE, a humanitarian organization fighting global poverty

There are also many agencies in your city that are looking for help.

Suggestions

This is just the start of our list. If you know of some charities or causes that need help, let us know about it.

---

---