|
SQL - Structured Query Language |
SQL statements are instructions used to
communicate with a database. It is the standard language for relational database management systems. SQL statements
are used to perform tasks such as update data on a database, or retrieve data from
a database. Some common relational database management systems that use SQL are:
Oracle, Sybase,
Microsoft SQL Server,
DB2, MYSQL, Access, Ingres, etc.
Although most database systems use SQL, few of them also have their own additional
proprietary extensions that are usually only used on their system. This tutorial
will provide you with the instruction on the basics of each of these commands as
well as allow you to put them to practice using the SQL Interpreter.
SQL is used to:
-
access data in relational database management systems.
- describe the data.
- to define the data in database and manipulate that data.
- create and drop databases and tables.
- create view, stored procedure, functions in a database.
- set permissions on tables, procedures, and views.
|
|
|
|
|
|
|
|
|