ORACLE DATABASE Salim Phone 0815 188 2384 Email

ORACLE DATABASE Salim Phone : 0815 -188 -2384 Email : salim. sucipto@gmail. com YM : talim_bansal 1

What is ORACLE? You can explore anything about ORACLE: www. oracle. com 2

What you will learn? • Basic ORACLE DBA • Advance SQL • ORACLE Objects 3

Who they are? • Administrator • Application Developers • Database Administrator • Form / Report Developer • PL/SQL Developer • Portal Developer • System Analyst • Technical Consultant 4

Prerequisites • Database Concept • Basic SQL • Basic Programming / Algorithm 5

References • Oracle University, Introduction to SQL • Oracle, Program Unit with PL/SQL • Any kind of book about SQL or PL/SQL for Oracle • Any kind of internet URL, contains SQL or PL/SQL for Oracle 6

Schedule 1. Overview & Pre-Practice 2. Oracle DBA at a glance 3. Oracle Objects (Part I) 4. Advance SQL (Part I) 5. Advance SQL (Part II) 6. Data Manipulation Language 7. Oracle Objects (Part II) 8. Mid Test 7

Schedule (Cont. ) 9. View 10. Database Trigger 11. SQL – Union 12. SQL – Exists, Not Exists 13. SQL - Sub query 14. SQL – Using Hint 15. Oracle Dictionary & Tables 16. Final Test 8

Start with ORACLE • ORACLE Database • ORACLE Client • Query Editor: TOAD, SQL Plus, PL/SQL Developer ( Choose 1) Ensure, all list above have been installed on your environment 9