India Forums



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


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 02-28-2007, 03:32 PM
priyanka1
 
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
http://www.academictutorials.com/sql...troduction.asp


SQL Select Statement - Select command is use to select data from the tables
http://www.academictutorials.com/sql/sql-select.asp


SQL WHERE Clause - To conditionally select the data from a table
http://www.academictutorials.com/sql/sql-where.asp


SQL Insert Statement - The insert clause has one function; to insert data into a table.
http://www.academictutorials.com/sql/sql-insert.asp


SQL Update Statement - This command updates the column values of a table.
http://www.academictutorials.com/sql/sql-update.asp


SQL Delete Statement - Delete command removes Entire rows from a table.
http://www.academictutorials.com/sql/sql-delete.asp


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.
http://www.academictutorials.com/sql/sql-order-by.asp


SQL AND OR Operator - WHERE keyword might be used to conditionally select data from a table.
http://www.academictutorials.com/sql/sql-and-or.asp


SQL in operator - A special kind of operator which uses with where clauses.
http://www.academictutorials.com/sql/sql-in.asp


SQL Between - The BETWEEN keyword allows for selecting a values in range.
http://www.academictutorials.com/sql/sql-between.asp


SQL Aliases - Aliases for table and column.
http://www.academictutorials.com/sql/sql-aliases.asp


SQL Join - Combines columns of one table to that of another.
http://www.academictutorials.com/sql/sql-join.asp


SQL Outer Join - A type of join.
http://www.academictutorials.com/sql/sql-outer-join.asp


SQL Union - Combine the results of two queries together.
http://www.academictutorials.com/sql/sql-union.asp


SQL Subqueries - Queries placed within an existing SQL statement.
http://www.academictutorials.com/sql/sql-subqueries.asp


SQL Date Function - All SQL platform has its own version of date functions.
http://www.academictutorials.com/sql/sql-date.asp


SQL Create Statement - Create statement in SQL
http://www.academictutorials.com/sql/sql-create.asp


SQL Drop Statement - Delete an existing index in a table with the DROP INDEX statement.
http://www.academictutorials.com/sql/sql-drop.asp


SQL Alter - Change the structure of the table.
http://www.academictutorials.com/sql/sql-alter.asp


SQL Function - A function is a special type of command that return a single value.
http://www.academictutorials.com/sql/sql-functions.asp


SQL Group By Statement - The aggregate of all column values.
http://www.academictutorials.com/sql/sql-group-by.asp


SQL Select Into - Make a backup copy
http://www.academictutorials.com/sql...elect-into.asp


SQL Create View - Virtual table based on the result-set of a SELECT statement.
http://www.academictutorials.com/sql...reate-view.asp


SQL Server - SQL server
http://www.academictutorials.com/sql/sql-server.asp


SQL Summary - Summary
http://www.academictutorials.com/sql/sql-summary.asp

Reply With Quote
Reply


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 10:04 PM.


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