Advertisment

Introduction to SQL

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

Views: 1414 | | by Adam
SQL Basics - Miscellaneous

SQL Select

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

Views: 1357 | | by Stephen
SQL Basics - Miscellaneous

SQL WHERE

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

Views: 1419 | | by Donald
SQL Basics - Miscellaneous

SQL INSERT INTO

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

Views: 1339 | | by Stephen
SQL Basics - Miscellaneous

SQL UPDATE

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

Views: 1392 | | by Mark
SQL Basics - Miscellaneous

SQL DELETE

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

Views: 1364 | | by Stephen
SQL Basics - Miscellaneous

SQL ORDER BY

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

Views: 1300 | | 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: 1441 | | by Mark
SQL Basics - Miscellaneous

SQL IN

How to use the IN operator.

Views: 1324 | | by Simon
SQL Basics - Miscellaneous

SQL BETWEEN

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

Views: 1395 | | by Sean
SQL Basics - Miscellaneous

SQL Aliases

How to use aliases for column names and table names.

Views: 1451 | | by Mark
SQL Basics - Miscellaneous

SQL Join

How to select information from multiple tables.

Views: 1343 | | by Daniel
SQL Basics - Miscellaneous

SQL UNION

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

Views: 1332 | | by Colin
SQL Basics - Miscellaneous

SQL CREATE

How to create databases, tables, and indices.

Views: 1381 | | by Isac
SQL Basics - Miscellaneous

SQL DROP

How to delete databases, tables, and indices.

Views: 1349 | | 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: 1367 | | by Colin
SQL Basics - Miscellaneous

SQL Functions

How to use the built-in functions in SQL.

Views: 1333 | | by Mathew
SQL Basics - Miscellaneous

SQL GROUP BY

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

Views: 1394 | | by Sarah
SQL Basics - Miscellaneous

SQL SELECT INTO

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

Views: 1337 | | 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: 1378 | | by Mathew
SQL Basics - Miscellaneous