India Forums

Go Back   India Forums > Education, Jobs & Immigration > Jobs in India
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Thread Tools Search this Thread Display Modes
Old 02-28-2007, 04:32 PM
Posts: n/a
Default Learn sql

Learn SQL in Just 24 Hours - Fire the Queries to the Database using your Applications

SQL : Structured Query Language .
It is a language that provides an interface to relational database systems.

SQL was developed by IBM in the 1970s for use in System R.

SQL is a de facto standard, as well as an ISO and ANSI standard..

It is a special-purpose, nonprocedural language that supports the definition, manipulation, and control of data in relational database management systems.

Start Learning

SQL Introduction - Introduction to SQL

SQL Select Statement - Select command is use to select data from the tables

SQL WHERE Clause - To conditionally select the data from a table

SQL Insert Statement - The insert clause has one function; to insert data into a table.

SQL Update Statement - This command updates the column values of a table.

SQL Delete Statement - Delete command removes Entire rows from a table.

SQL Order By Clause - Order By Command The order by statement allows for table column range. WHERE keyword might be used to conditionally select data from a table.

SQL AND OR Operator - WHERE keyword might be used to conditionally select data from a table.

SQL in operator - A special kind of operator which uses with where clauses.

SQL Between - The BETWEEN keyword allows for selecting a values in range.

SQL Aliases - Aliases for table and column.

SQL Join - Combines columns of one table to that of another.

SQL Outer Join - A type of join.

SQL Union - Combine the results of two queries together.

SQL Subqueries - Queries placed within an existing SQL statement.

SQL Date Function - All SQL platform has its own version of date functions.

SQL Create Statement - Create statement in SQL

SQL Drop Statement - Delete an existing index in a table with the DROP INDEX statement.

SQL Alter - Change the structure of the table.

SQL Function - A function is a special type of command that return a single value.

SQL Group By Statement - The aggregate of all column values.

SQL Select Into - Make a backup copy

SQL Create View - Virtual table based on the result-set of a SELECT statement.

SQL Server - SQL server

SQL Summary - Summary

Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +5.5. The time now is 02:57 AM.

Powered by vBulletin Version 3.5.5
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.