Structured
Query Language is a database computer language designed for managing data in relational database management
systems (RDBMS), and originally based upon relational algebra and calculus. Its scope includes data insert,
query, update and delete, schema creation and modification, and data access
control. SQL was one of the first commercial languages for Edgar
F. Codd's relational model, as described in his influential
1970 paper, "A Relational Model of Data for Large Shared Data Banks".
Despite not adhering to the relational model as described by Codd, it
became the most widely used database language.
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
No comments:
Post a Comment