Learn Oracle & Unix, with scenarios

Learn Oracle

• About Oracle
  
• About SQL*Plus
  
• About Oracle PL/SQL
  
• About backup, recovery and RMAN
  
• Oracle Instance Recovery
  

About Oracle Certification

• Oracle Certification Info
  
• Tips for Oracle Certification preparation
  
• Which path to choose : DBA or PL/SQL?
  

Scenarios

• Call executable file from DBMS_SCHEDULER
  
• RMAN's MAXPIECESIZE, SECTION SIZE and MAXSETSIZE options
  
• Connect to MS Access from Oracle
  
• Using DBMS_APPLICATION_INFO built-in Package
  
• Oracle 11g Client installation on Windows
  
• "Recover Table" feature in Oracle 12c (pdb)
  
• File write using Oracle PL/SQL
  
• Refresh table data remotely
  
• Flashback techniques using UNDO
  
• Check Multiple DBs Automatically
  

General Errors

• Error(s) in doing connection via Listener