P2Pprogrammer 2 programmer

  • Facebook Share
  • Ready Made Project

Home > IT and Project Management Certification > Oracle Certification

Oracle Certification - Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), Oracle DBA (OCA DBA)

Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), Oracle DBA OCA, Oracle DBA OCP, Oracle Database: Admin, Install and Upgrade Accelerated, Oracle Database: Program with PL/SQL, Certification Path, Syllabus, Download eBook, Examination Preparation, Sample Question and Answers, Online mock test, online practice test, practice test questions, download question and answers.

There are many certification available in Oracle database, some of them listed here

  1. Oracle Certified Associate - OCA
  2. Oracle Certified Professional - OCP
  3. Oracle Certified Database Administrator (Oracle DBA)
OCA : Oracle Certified Associate

  1. Retrieving Data Using the SQL SELECT Statement, Restricting and Sorting Data
  2. Using Single-Row Functions to Customize Output, Reporting Aggregated Data Using the Group Functions
  3. Displaying Data from Multiple Tables, Using Subqueries to Solve Queries
  4. Using the Set Operators, Manipulating Data
  5. Using DDL Statements to Create and Manage Tables
  6. Creating Other Schema Objects
  7. Managing Objects with Data Dictionary Views
  8. Controlling User Access
  9. Managing Schema Objects
  10. Manipulating Large Data Sets
  11. Generating Reports by Grouping Related Data
  12. Managing Data in Different Time Zones
  13. Retrieving Data Using Subqueries
  14. Hierarchical Retrieval
  15. Regular Expression Support
  1. Overview of PL/SQL Programs
  2. Creating Procedures, Creating Functions
  3. Managing Subprograms
  4. Creating Packages, More Package Concepts
  5. Oracle Supplied Packages
  6. Creating Database Triggers, More Trigger Concepts
  7. Managing Dependencies
Download OCA eBook    Download OCA Question and Answer    OCA Practice and Mock Test

OCP : Oracle Certified Professional

You need to pass Oracle Certified Associate (OCA) examination prior to apply for OCP
Oracle Forms : Build Internet Applications(1Z0-141)
  1. Introduction to Oracle Forms Developer and Oracle Forms Services
  2. Running a Forms Developer Application
  3. Creating LOVs and Editors
  4. Creating Additional Input Items
  5. Creating Noninput Items
  6. Creating Windows and Content Canvases
  7. Working with Other Canvas Types
  8. Introduction to Triggers
  9. Working in the Forms Developer Environment
  10. Creating a Basic Form Module
Download OCP eBook    Download OCP Question and Answer    OCP Practice and Mock Test

Home > IT and Project Management Certification > Oracle Certification