- SQL is used to communicate with database
- its main aim to store, access and manipulate data in relational database.
- SQL statements are used to perform tasks such as update on a database, or retrieve data from a database
SQL consist of many types of statements..
- data query language(DQL)-retrieve the data from database
- data definition language(DDL)-schema creation and modification
- data control language(DCL)-grant,revoke
- data manipulation language(DML)-insert/update/delete
- transaction control language(TCL)-commit, rollback and begin transactions.
No comments:
Post a Comment