Oracle and plsql

Syllabus  of Oracle and plsql 

Oracle

Introduction  to  Oracleand its architecture 

Definition  of  data,database 

Definition  of  SQL, types of sql  like dml,ddl,,dcl, tcl etc. 

Define query 

Create statements 

Insert  statements 

Update  statements 

Alter  statements 

Truncate statements 

Drop statements 

Delete  statements 

Creating  date  function, number  function, text function  and mathematical function 

Definition of  sequence, types,queries  on sequence 

Definition  of joins,types ,queries on each join

Definition  of subquery,types,examples on different types of subquery 

Definition of synonym,examples on synonym 

Plsql

Definition  of plsql 

Differeces  between  SQL and plsql 

Basic programs on plsql 

Definition  of procedures, examples  on procedures 

Definition of function, types, examples on function 

Definition on cursors,types,examples on cursors 

Definition on triggers, types, examples on triggers