Logo
Home Dot More Free Tutorials Dot Educational Resources

Ad: Find an Online or Campus School Near You

SQL Tutorial

SQL -- pronounced sequel -- stands for Structured Query Language. It is the language used to access data stored in a SQL database. With SQL, you can query your database in a variety of ways, using English-like statements.

With SQL, data is stored in tables. A table is a set of columns and rows.  Each column is referred to as a field. Each value in a field represents a single type of data. For example, a table might have three fields: name, city, and state. The table will consist of three columns: one for name, one for city, and one for state.  For every row in the table, the name field contains the name, the city field contains the city, and the state field contains the state. A database is a collection of related data. It can also be viewed as a collection of related tables. This tutorial is on storing data in and retieving data from a SQL database. 



Table of Contents

Introduction
  SQL
  Tables
  Scalable SQL for Windows
  Definition of Database
  Tables used by Solomon IV
  Reading the Reports
  SQLScope
  The Menu Bar
  The View Option
  Database in Use
  Conventions Used in this Guide
  Errors
Creating Tables
Importing Data
Retrieving All Data
Retrieving a Single Column
Retrieving Multiple Columns
Formatting Numbers
Ordering Rows
Displaying Rows in Descending Order
Ordering Multiple Columns
Retrieving Specific Rows
Multiple Conditions
Joining Tables
Updating Tables
Deleting Rows
Inserting Rows

Our Free Tutorials Word Basics 2007 Word Basics 2003/2002 Word Basics 97 Excel Basics 2007 Excel Basics 2003/2002 Excel Basics 97 PowerPoint Basics 2007 PowerPoint Basics 2002 Access Basics 2007 Windows Vista Tutorial Windows XP Tutorial Windows 98 Tutorial Scalable SQL -- A Tutorial RealSlideshow for RealPlayer Guide to Paint Shop Pro Flash CS4 Flash 8 Photoshop
Google
Web
www.baycongroup.com

Online Learning University of Phoenix - Obtain a Degree in Information Technology Online or on Campus. Click Here! The Art Institute of Pittsburgh -- Online Division - Learn Graphic Design Online. Click Here! DeVry University - Earn a Bachelor's Degree Online or on Campus. Click Here!
 
Legal Dot Privacy
Copyright©1999-2009 Baycon Group, Inc. All Rights Reserved