[LALIT KUMAR]

CAN ANYONE FORWARD ME THE SQL BASICS TUTORIAL AND THE QUSETIONS AND TEH ANSWERS....


THANKS IN MILLIONS

[Pink]

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.academic tutorials. com/sql/sql- introduction. asp

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

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

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

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

SQL Delete Statement - Delete command removes Entire rows from a table.
http://www.academic tutorials. 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.academic tutorials. com/sql/sql- order-by. asp

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SQL Select Into - Make a backup copy
http://www.academic tutorials. com/sql/sql- select-into. asp

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

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

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


check out these

[LALIT KUMAR]

thanks for this nice information ..............