Home » Articles » Databases »
Structured Query Language (SQL)
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!
Using Self-Joins in SQL
Did you know that you can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table? Let's take a look at an example.
SQL Visual Quickstart
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.
Creating Databases and Tables In 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.
SQL Fundamentals
Would you like to learn SQL? This tutorial will introduce you to the basics.
Access Controls in SQL
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.
Aggregate Functions in SQL
SQL provides several aggregate functions to assist with data summarization. In this article we explore the usage of SUM, AVG, COUNT, MIN and MAX.
All About NULL Values
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.
|