Advertisment

Introduction to SQL

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

Views: 1502 | | by Adam
SQL Basics - Miscellaneous

SQL Select

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

Views: 1445 | | by Stephen
SQL Basics - Miscellaneous

SQL WHERE

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

Views: 1524 | | by Donald
SQL Basics - Miscellaneous

SQL INSERT INTO

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

Views: 1414 | | by Stephen
SQL Basics - Miscellaneous

SQL UPDATE

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

Views: 1472 | | by Mark
SQL Basics - Miscellaneous

SQL DELETE

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

Views: 1443 | | by Stephen
SQL Basics - Miscellaneous

SQL ORDER BY

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

Views: 1391 | | 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: 1521 | | by Mark
SQL Basics - Miscellaneous

SQL IN

How to use the IN operator.

Views: 1404 | | by Simon
SQL Basics - Miscellaneous

SQL BETWEEN

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

Views: 1476 | | by Sean
SQL Basics - Miscellaneous

SQL Aliases

How to use aliases for column names and table names.

Views: 1530 | | by Mark
SQL Basics - Miscellaneous

SQL Join

How to select information from multiple tables.

Views: 1417 | | by Daniel
SQL Basics - Miscellaneous

SQL UNION

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

Views: 1413 | | by Colin
SQL Basics - Miscellaneous

SQL CREATE

How to create databases, tables, and indices.

Views: 1452 | | by Isac
SQL Basics - Miscellaneous

SQL DROP

How to delete databases, tables, and indices.

Views: 1422 | | 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: 1448 | | by Colin
SQL Basics - Miscellaneous

SQL Functions

How to use the built-in functions in SQL.

Views: 1406 | | by Mathew
SQL Basics - Miscellaneous

SQL GROUP BY

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

Views: 1474 | | by Sarah
SQL Basics - Miscellaneous

SQL SELECT INTO

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

Views: 1412 | | 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: 1469 | | by Mathew
SQL Basics - Miscellaneous