SQL for Beginner The Tutorial brings a unique introduction on SQL for
want to learn and understand SQL in easy steps. The Tutorial provides you a
illustrative examples, which is easy to understand and learn using on-line SQL interpreter.
Quick Introduction to SQL: SQL is Structure Query Language. This Query language is used to connect with
the database. It is considered as standard language for relation database
management systems according to (American National Standards institute).
Create Table in Database The objects in a Relational database System is called Tables. The Tables
contain the information on data for the database. Each Table in a database is
uniquely identified by their names.
Select data from Table in Database The Select Statement is used to retrieve the selected data from table in database. The
select query in the database retrieve selected data , match with column name
specified by you.
Update Records in Database The Update Records in database is used to modify or change the value of
records which match with a specified criteria. The update query is accompanied
by where clause that specify the condition on column specified.
Where Clause in SQL The Where clause in SQL query is used with the
SELECT keyword.' Where' clause search the data with a particular condition. In
case the data matches with condition, return you the specific value of
particular data value.
Drop Table in Database The Drop Statement in SQL Command is used to delete or remove indexes, tables
August 21, 2011
sir, your website is very useful to know the subject contents about java,database.
Please send me the visual basic tutorial in my email or your website.
thanking you sir
June 3, 2013
thaq u very much....this very use full for beigneers