Home Products Articles Links Internet Marketing & SEO Contact Us
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.

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

Retrieving Data from Multiple Tables with SQL Joins
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.

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

Summarizing Data with CUBE and ROLLUP
SQL's CUBE and ROLLUP commands allow for the efficient summarization of data.

Structured Query Language (SQL)

Home » Articles » Databases » SQL_Basics »


Copyright © 2005 Genuine Infotech Private Limited - Software Development and Software Outsourcing Company in India
Feel free to Contact us  for your Outsourcing Software development Job Work from India