SQL Basic

The Structured Query Language (SQL) forms the backbone of most modern database systems. These links provide the best resources on the Net for neophytes and expert database administrators alike!

SQL’s CUBE and ROLLUP commands allow for the efficient summarization of data.

sql cube commands, sql cube query, sql cube rollup

Learn to retrieve information from your database with the SQL SELECT statement. This tutorial provides an introduction to the basics of database queries.

select query in sql, sql retrieve command, sql select statement

SQL join statements allow you to combine data from two or more tables in your query results. Learn how to leverage this powerful technology to supercharge your database queries.

sql equi joins, sql join queries, sql outer join on multiple tables

The SQL DELETE command allows the removal of some or all of the data stored in a relational database table.

delete sql command, delete sql count, sql where command

Users new to the world of databases are often confused by a special value particular to our field – the NULL value. Read about the proper uses of NULL in this article.

sql is not null function, sql is not null statement, sql null functions

SQL provides several aggregate functions to assist with data summarization. In this article we explore the usage of SUM, AVG, COUNT, MIN and MAX.

select sum sql, sql average function, sql average statement

Our databases contain information that is vital to the continued operations of our organizations. In this article, your About.com Guide introduces the SQL commands used to control access to your database.

sql deny delete, sql option for, sql revoke command

Would you like to learn SQL? This tutorial will introduce you to the basics.

sql query function, sql where command, update sql

Learn to create databases and tables using the Structured Query Language (SQL) in this step-by-step tutorial from your About.com Guide to Databases.

alter delete table, sql alter command, sql varchar not null

This software-independent book takes a hands-on approach to learning SQL. After some brief introductory material, it dives right into developing SQL queries designed to meet specific goals. It’s a great reference for those who occasionally use SQL and forget the details.

sql lower command, sql string case, sql upper command