Advertisment

Introduction to SQL

SQL is a standard computer language for accessing and manipulating databases.

Views: 1940 | | by Adam
SQL Basics - Miscellaneous

SQL Select

How to use the SELECT statement to select data from a table in SQL.

Views: 1861 | | by Stephen
SQL Basics - Miscellaneous

SQL WHERE

How to use the WHERE clause to specify a criterion for the selection.

Views: 1947 | | by Donald
SQL Basics - Miscellaneous

SQL INSERT INTO

How to use the INSERT INTO statement to insert new rows into a table.

Views: 1823 | | by Stephen
SQL Basics - Miscellaneous

SQL UPDATE

How to use the UPDATE statement to update or change rows in a table.

Views: 1874 | | by Mark
SQL Basics - Miscellaneous

SQL DELETE

How to use the DELETE statement to delete rows in a table.

Views: 1854 | | by Stephen
SQL Basics - Miscellaneous

SQL ORDER BY

How to use the ORDER BY keywords to return rows in a defined order.

Views: 1554 | | by Jason
SQL Basics - Miscellaneous

SQL AND & OR

How to use AND and OR to join two or more conditions in a WHERE clause.

Views: 1922 | | by Mark
SQL Basics - Miscellaneous

SQL IN

How to use the IN operator.

Views: 1815 | | by Simon
SQL Basics - Miscellaneous

SQL BETWEEN

How to use BETWEEN....AND to find data in a range.

Views: 1878 | | by Sean
SQL Basics - Miscellaneous

SQL Aliases

How to use aliases for column names and table names.

Views: 1939 | | by Mark
SQL Basics - Miscellaneous

SQL Join

How to select information from multiple tables.

Views: 1837 | | by Daniel
SQL Basics - Miscellaneous

SQL UNION

How to select information from two tables with the UNION and UNION ALL commands.

Views: 1831 | | by Colin
SQL Basics - Miscellaneous

SQL CREATE

How to create databases, tables, and indices.

Views: 1870 | | by Isac
SQL Basics - Miscellaneous

SQL DROP

How to delete databases, tables, and indices.

Views: 1840 | | by Colin
SQL Basics - Miscellaneous

SQL ALTER TABLE

How to use the ALTER TABLE statement to add or drop columns in an existing table.

Views: 1857 | | by Colin
SQL Basics - Miscellaneous

SQL Functions

How to use the built-in functions in SQL.

Views: 1857 | | by Mathew
SQL Basics - Miscellaneous

SQL GROUP BY

How to use the built-in GROUP BY function in SQL.

Views: 1871 | | by Sarah
SQL Basics - Miscellaneous

SQL SELECT INTO

How to use the SELECT INTO statement to create backup copies of tables.

Views: 1825 | | by Jason
SQL Basics - Miscellaneous

Sql-Tutorial with an offline-interface

The Sql-Tutorial uses a small sample, which allows Group By and subqueries (german). A .NET1.1 - based interface (freeware) allows the execution of...

Views: 1859 | | by Mathew
SQL Basics - Miscellaneous