SQL PRIMER


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

Home
SQL Commands
Table Manipulation
SQL Syntax
SQL Logical Operators

SQL PRIMER

PLEASE NOTE: this SQL Primer is identical (except for the operators page) to http://www.1keydata.com/sql/. This content has been graciously provided by 1keydata.com and is not intended to replace that resource in any way, shape or form. This page will change SHORTLY to a Lasso SQL specific page.

Whether you are a beginner seeking SQL help, or a data 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.