Parvin Etibarli Java

 Primary functions: * Create and manage objects (Inversion of Control) * Inject object's dependencies (Dependency Injection)

1. Create database: create database test ; 2. Drop database: drop database test ; 3. Create table: create table actors ( actor_id serial primary key, first_name varchar ( 150 ) , last_name varchar ( 150 ) not null , gender char ( 1 ) , date_of_birth date, add_date date, update_date date ) ; create table movies_actors( movie_id int references movies( movie_id ) , actor_id int references actors( actor_id ) , primary key ( movie_id , actor_id ) ) ; 4. Rename column: alter table accounts rename add_date to adddate ; 5. Add column: alter table accounts add column add_by varchar ( 100 ) ; 6. Delete column: alter table accounts drop column add_by ; 7. Changing data type of a column: alter table accounts alter column is_enable type boolean; 8. Deleting tables from DB: drop table roles ; 9. Inserting into table: insert into customers ( first_name , last_name , email , age ) values ( 'Parvin' , 'Etibarli' , 'parvin@gmail.com' , 100