Oracle Training
By
MGTechnosoft

Agenda for Database(SQL & PLSQL)

• Basic of  DATABASE.
• DATABASE Structure
• Basic of  DBMS.
• Basic of  RDBMS.
• Normalization
• De-Normalization
• DATABASE DESIGN TECHNIQUES
• SQL Statement
• DATA TYPES
• DDL COMMAND
  • Create
  • Drop
  • Truncate
  • Alter
  • Desc
• DML COMMAND
  • Insert
  • Delete
  • Update
  • Select
• DCL COMMAND
  • Commit
  • Rollback
• TCL COMMAND
  • Grant
  • Revoke
• JOIN
  • Inner join
  • Outer join
    • Left outer join
    • Right outer join
    • Full outer join
  • Cross join
  • Equi join
  • Natural join
  • Self  join
• VIEWS
• Sub Queries
• DUAL  FUNCTION
• AGGREGATE  FUNCTION
• Basic of  PLSQL.
• PLSQL Structure
• PLSQL Blocks
• Procedure
• Function
• Cursor
• Trigger
• Records
• Package