What is SQL?
SQL (pronounced "ess-que-el") stands for Structured Query
Language. SQL is used to communicate with a database. According to ANSI
(American National Standards Institute), 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, Access, Ingres, etc.
Although most database systems use SQL, most of them also have their own
additional proprietary extensions that are usually only used on their
system. However, the standard SQL commands such as "Select", "Insert",
"Update", "Delete", "Create", and "Drop" can be used to accomplish
almost everything that one needs to do with a database. 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 stands for Structured Query Language
What Can SQL do?
source
https://en.wikipedia.org/wiki/SQL
http://www.w3schools.com/sql/sql_intro.asp
http://www.sqlcourse.com/intro.html
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
source
https://en.wikipedia.org/wiki/SQL
http://www.w3schools.com/sql/sql_intro.asp
http://www.sqlcourse.com/intro.html
No comments:
Post a Comment