SQL commands

To create new account:
create user Maruf identified by p1789;//user created;
grant all privileges to Maruf;//privileges granted;
..........
to Log in:
connect Maruf;
pass;
.........
To create table:
create table Students(name varchar(10),roll number(7));
...........
To see table heading rows:
describe students;
...........
To add col:
alter table student add department varchar(20);
alter table student add(term varchar(3),semester varchar(3));
..........
To modify col:
alter table student modify roll number(10);
..........
To rename col:
alter table student rename column department to dept;
...............
To delete column :
alter table student drop column name;
.............
To rename table:
rename student to students;
..............
To see all tables:
select * from tab;
.............
to see a whole table:
select * from students;
..........
to delete a table:
drop table students;
...............

to update a particular row:
update student set gpa=3.77 where roll=1707004;
...........
 to delete a particular row:
delete from student where gpa<=3.95;//=,<,> all can be used;
................