SQL Tutorial


SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL LIKE
SQL ORDER BY
SQL Functions
SQL COUNT
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL JOIN
SQL OUTER JOIN
SQL Subquery
SQL UNION
SQL UNION ALL
SQL INTERSECT
SQL MINUS

SQL CREATE TABLE
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM







Site Map
Resources

Data Warehousing & Business Intelligence
Area Codes Info
State Info
HTML Tutorial














Home
SQL Commands
Table Manipulation
SQL Syntax

SQL Tutorial

Whether you are a beginner seeking SQL help, or a data warehousing veteran looking for a SQL refresher, you have come to the right place. This SQL tutorial site lists commonly-used SQL commands, and is divided into the following sections:

  • SQL Commands: How SQL statements are used to store, retrieve, and manipulate data in the relational database.
  • Table Manipulation: How SQL statements are used to manage tables inside the database.
  • SQL Syntax: A single page that lists the syntax for all the SQL commands in this tutorial.

For each command, the SQL syntax will first be presented and explained, followed by an example. By the end of this brief tutorial, you should have a good general understanding of the SQL syntax. In addition, you should be able to write SQL statements using the correct syntax to perform basic queries. My experience is that understanding the basics of SQL is much easier than mastering all the intricacies of this computer language, and I hope you will reach the same conclusion as well.

Okay, enough introduction. Bookmark this site now by pressing Control-D and click here to start learning SQL!

Note: If you teach a SQL- or database-related class, you are welcome to link to this site as reference material for your students.


Copyright 1999-2004 Chuo-Han Lee All Rights Reserved.
Last updated on May 21, 2004

Chinese

1