//DML commands select insert delete update //how to use insert keyword //if you want to follow the table structure in order insert into itec212 values (15700541,'Mohammed',053365214523,'mohammed@gmail.com') //Assume that you don't want to follow the table structure insert into itec212 (email,name,std_id,phone_no) values ('mustafa@gmail.com','Mustafa',1975421,05336589652) //how to use the update command update itec212 set std_id = 18500634, phone_no = 053365485123 where std_id = 15700541 //how to use the delete command delete from itec212 where std_id = 1975421 //DCL commands Grant : used to grant previlages to users Revoke : used to take back those previlages grant select, insert, update to user10, user15, user17 revoke insert from user15 grant select to all revoke delete from all //TCL commands Rename : used to rename your table name Truncate : used to delete all the data from your table rename itec212 to database_class truncate table database_class commit : used to save your changes rollback : used to go back to the last step - if you comitted your changes, you can't rollback - you cant rollback after dropping the whole table