Monday, December 6, 2010

Meanings of SQL

What is SQL ?

- SQL is the abbreviation of structured query language
- SQL is used to access and control/manage databases
- SQL is a standard called ANSI (American National Standards Institute)

What actions SQL may perform in a database?

- SQL may create new tables
- SQL may create stored procedures
- SQL may create views
- SQL may execute query
- SQL may fetch data
- SQL may insert records
- SQL may update records
- SQL may delete records
- SQL may create new databases
- SQL may set permissions on tables, procedures, and views


The base of SQL is RDBMS, which is the abbreviation of "Relational Database Management System" and this is also a base for all modern database systems like MS SQL, MySQL, IBM DB2, Oracle and Microsoft Access.

In RDBMS the storage of data is in database objects that are called tables.

A table in this case is a collections that has related data entries and its structure is made of rows and columns.

No comments:

Post a Comment