Certefications ORACLE Oracle 10g Certified Professional - Developer

 Oracle 10g Certified Professional - Developer


The Oracle PL/SQL Developer Certified Associate
understands how to use this powerful programming language. This credential demonstrates the Developer's expertise in building database centric Internet applications for both Oracle9i and Oracle Database 10g. It is also the first step toward becoming an Oracle Forms Developer Certified Professional.
Exam: 1Z0-001 Introduction to Oracle: SQL® and PL/SQL™

The Oracle Forms Developer Certified Professional
credential is an industry-recognized credential that will provide skilled application developers greater credibility and professional opportunity. Candidates must show proficiency and competency in Oracle development tools and the skills required to build Internet applications. This credential is for professionals with developer skills using Oracle9i Forms Developer or Oracle Forms Developer 10g.
Exam: 1Z0-141 Oracle Forms: Build Internet Applications

Note: The Oracle Forms and Reports Developer Track includes 2 required courses and one elective Course

Course Objectives:
  • Design PL/SQL anonymous blocks that execute efficiently
  • Write PL/SQL code to interface with the database
  • Describe the features and syntax of PL/SQL
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle runtime errors
  • Create simple procedures and functions
  • Design PL/SQL packages to group and contain related constructs
  • Categorize and Use the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output
  • Schedule PL/SQL jobs to run independently
  • Write dynamic SQL for more coding flexibility
  • Create triggers to solve business challenges
  • Manage dependencies between PL/SQL subprograms
  • Create form modules, including components for database interaction and GUI controls
  • Display form modules in multiple windows and use a variety of layout styles
  • Test form modules in a Web browser
  • Debug form modules in a 3-tier environment
  • Implement triggers
  • Reuse objects and code
  • Link one form module to another
  • Add dynamic data to an existing HTML page
  • Use report parameters and customize a runtime parameter form
  • Enhance reports using graphs and PL/SQL trigger code
  • Maximize report performance using OracleAS Reports Services and tune reports
  • Publish a report on the Web and build reports to run in various languages
  • Manage report templates, create mailing labels and letters
  • Identify the main components in a report document and how they are related
  • Identify the differences between Web and paper reports
  • Identify standard report design styles and run existing reports to various output destinations
  • Create and modify basic tabular reports and high quality Web reports
  • Create other report styles such as break reports and matrix reports
  • Create reports by accessing data from various data sources
     
Register this Course
  • PL/SQL Developer
  • Database Designers
  • Forms Developer
  • Reports Developer
  • Technical Consultant
  • Support Engineer
  • Familiarity with data processing concepts and techniques
الى الاعلى
من نحن