10th Lecture
Data should be organised for processing.
Start>programs>sqlserver>managenment studio.
SQL - Structured Query Language. This the language that is used to instruct DBMS to perform some tasks.SQL commands are cateogarised into 4 cateogaries
DDL- data defination language. For defining structure like create.
DML- data manupulation language. (Insert, Update, Delete and Select.)
DCL- data control language. (Grant and Revoke)
TCL- transaction control language. Begin,Commit and Rollback.
Transact SQL - SQL feo Microsoft.
ORACLE- PL\SQL
No comments:
Post a Comment