Introduction To SQL

                               

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