For the Oracle EBS Professionals, knowledge about SQL is necessary for ad hoc queries, data extraction for reporting, alerts and even setups for table validated value sets, approval management engine, workflow and many more. Skill set requirements for today are more for a techno-functional expert. SQL and PL/SQL are still an useful weapon to have in one's arsenal. Notwithstanding the onslaught of XML and BI Publisher, a foundation in SQL would go a long way in situations such as troubleshooting.
The following Oracle University courses can be taken for the exam: Oracle Database 10g: Introduction to SQL OR Oracle Database 11g: Introduction to SQL OR Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II
The 1Z0-047 exam qualifies one for Oracle Database: SQL Certified Expert credentials or helps you in the quest for Oracle9i DBA OCA certification or Oracle PL/SQL Developer Certified Associate certification.
There are several exam study guides available for SQL exams. A exam preparation guide being released in May-June 2009 is the "Oracle Database SQL Expert Exam Guide" by the popular author April Wells.
In case you find it difficult to get access to a test database like Oracle EBS vision database or your organization's test database, may I recommended that you download Oracle Express Edition or Oracle XE from Oracle Technology Network (OTN). Oracle XE is one of the most popular downloads with its own mini database schema that you can practice on. Also one the other popular download on OTN is the SQL tool - Oracle SQL Developer.
Have you already taken the Oracle Database SQL Expert Exam? Please share your exam preparation and test taking experiences with our blog readers.