sql Oracle Database SQL Expert

[CentralDogma]

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.

[Kalint]

http://www.examcollection.com/oracle_exams.html