Home About US Matrimonial Education Recipis Inquiry Contact US
USER ID PASSWORD
New Member Forget Password
 
Member
24 Gaam
Hospital Project
School Project
Vibrant Newsletter
Events / News
Essay
Entertament
Services
Business
Health
Religion
Arts / Calture
Other Samaj
Help
 
 
  EDUCATION
   
 
Education :- Computer :- SQL TUTORIAL
Introduction to Structured Query Language

This page is a tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. The SQL used in this document is "ANSI", or standard SQL, and no SQL features of specific database management systems will be discussed until the "Nonstandard SQL" section. It is recommended that you print this page, so that you can easily refer back to previous examples.


Go to --> Table of Contents
Basics of the SELECT Statement
Conditional Selection
Relational Operators
Compound Conditions
IN & BETWEEN
Using LIKE

Joins
Keys
Performing a Join
Eliminating Duplicates
Aliases & In/Subqueries
Aggregate Functions
Views
Creating New Tables
Altering Tables
Adding Data
Deleting Data
Updating Data
Indexes
GROUP BY & HAVING
More Subqueries
EXISTS &ALL
UNION & Outer Joins
Embedded SQL
Common SQL Questions
Nonstandard SQL
Syntax Summary
 

 

 
 
 
 
 
 
 
Site Design By :- www.ebeesinfo.com
Site Best View in 1024 X 768
Home | About US | Terms and conditions | Education | Matrimonial | Resipis | Inquiry | Contact US
Copy Right 2008, www.24gaam.com