1 / 9

ORACLE DATABASE

ORACLE DATABASE. Salim Phone : 0815-188-2384 Email : salim.sucipto@gmail.com YM : talim_bansal. What is ORACLE?. You can explore anything about ORACLE: www.oracle.com. What you will learn?. Basic ORACLE DBA Advance SQL ORACLE Objects. Who they are?. Administrator

Download Presentation

ORACLE DATABASE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


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

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

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

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

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

  6. 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

  7. Schedule • Overview & Pre-Practice • Oracle DBA at a glance • Oracle Objects (Part I) • Advance SQL (Part I) • Advance SQL (Part II) • Data Manipulation Language • Oracle Objects (Part II) • Mid Test

  8. Schedule (Cont.) • View • Database Trigger • SQL – Union • SQL – Exists, Not Exists • SQL - Sub query • SQL – Using Hint • Oracle Dictionary & Tables • Final Test

  9. 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

More Related