Tuesday, June 25, 2013

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