Jump to content


Oracle Database SQL Expert

sql certification

  • Please log in to reply
1 reply to this topic

#1 CentralDogma


    Neowinian Senior

  • Joined: 29-February 08

Posted 04 February 2013 - 19:49

I’m going to be trying for a Oracle Database SQL Expert Certification. If anyone here has any advice, I would welcome it.

I feel comfortable with about half the content of the exam (mostly the stuff that’s common to any SQL database), so I just need a review on those topics. I’m going to have to get more comfortable with the following:

Managing Schema Objects
  • Add constraints
  • Create indexes
  • Create indexes using the CREATE TABLE statement
  • Creating function-based indexes
  • Drop columns and set column UNUSED
  • Perform FLASHBACK operations
  • Create and use external tables
Manipulating Large Data Sets
  • Manipulate data using subqueries
  • Describe the features of multitable INSERTs
  • Use the following types of multita ble INSERTs (Unconditional, Conditional and Pivot)
  • Merge rows in a table
  • Track the changes to data over a period of time
Generating Reports by Grouping Related Data
  • Use the ROLLUP operation to produce subtotal values
  • Use the CUBE operation to produce crosstabulation values
  • Use the GROUPING function to identify the row values created by ROLLUP or CUBE
  • Use GROUPING SETS to produce a single result set
Managing Data in Different Time Zones
  • Use Various datetime functions
Retrieving Data Using Subqueries
  • Write a multiple-column subquery
  • Use scalar subqueries in SQL
  • Solve problems with correlated subqueries
  • Update and delete rows using correlated subqueries
  • Use the EXISTS and NOT EXISTS operators
  • Use the WITH clause
Hierarchical Retrieval
  • Interpret the concept of a hierarchical query
  • Create a tree-structured report
  • Format hierarchical data
  • Exclude branches from the tree structure
Regular Expression Support
  • Using Meta Characters
  • Regular Expression Functions
  • Replacing Patterns
  • Regular Expressions and Check Constraints

Any idea how long this would take?

Thanks in advance.

#2 Kalint


    Neowinian Senior

  • Tech Issues Solved: 2
  • Joined: 16-January 07

Posted 05 February 2013 - 17:40