Welcome

Welcome to StudynEnjoy

Come as guests, stay as family....

Tuesday, February 23, 2010

SQL Tutorial

SQL is a standard language for accessing and manipulating databases.

What is SQL?

* SQL stands for Structured Query Language
* SQL lets you access and manipulate databases
* SQL is an ANSI (American National Standards Institute) standard

What Can SQL do?

* SQL can execute queries against a database
* SQL can retrieve data from a database
* SQL can insert records in a database
* SQL can update records in a database
* SQL can delete records from a database
* SQL can create new databases
* SQL can create new tables in a database
* SQL can create stored procedures in a database
* SQL can create views in a database
* SQL can set permissions on tables, procedures, and views

* SQL is not case sensitive

No comments:

Post a Comment

 

Web Counter
StudynFun