ORACLE Certification (Database Application Development) | Universal

ORACLE Certification (Database Application Development)

Oracle Database SQL (1Z0-071)

Oracle and Structured Query Language (SQL)
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Managing Objects with Data Dictionary Views
Controlling User Access
Managing Schema Objects
Manipulating Large Data Sets

Oracle Database 11g: Program with PL/SQL (1Z0-144)

Overview of PL/SQL Programs
PL/SQL Basics
Language Fundamentals
Block Structure
Control Structures, Conditional & Iterative Statement
Cursor Structure & Bulk Statement
Error Management, Exception Type & Scope
User Defined Exception
Functions and Procedures
Pass By Value & Reference
Collections, Large Objects
Packages & Triggers
Dynamic SQL

Oracle 11g Advanced PL/SQL (1Z0-146)

PL/SQL Programming Concepts: Review
Designing PL/SQL Code
Identify guidelines for cursor design
Use cursor variables
Create subtypes based on existing types
Working with Collections
Using Advanced Interface Methods
Execute external C programs from PL/SQL
Execute Java programs from PL/SQL
Implementing Fine-Grained Access Control for VPD
Explain & Implement the process of fine-grained access control
Manipulating Large Objects
Use the DBMS_LOB PL/SQL package
Administering Secure File LOBs
Performance and Tuning
Use native and interpreted compilation methods
Tune PL/SQL code
Improving Performance with Caching
Analyzing PL/SQL Code