aspose file tools*
The moose likes Certification Results and the fly likes I cleared 'Oracle Database SQL Certified Expert' 1Z0-047 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Certification » Certification Results
Bookmark "I cleared Watch "I cleared New topic
Author

I cleared 'Oracle Database SQL Certified Expert' 1Z0-047

Stefan Feldmann
Ranch Hand

Joined: Nov 07, 2013
Posts: 38
I passed 'Oracle Database SQL Certified Expert' 1Z0-047 with 72% (min 66%). Oracle SQL was my first contact in development world and I used it several years. It was my 3. try - now succesful.

Next is 'Oracle Certified Associate, Java SE 7 Programmer' 1Z0-803. So far I have zero Java skills. What's the time effort in preparation to pass 1Z0-803 with my background?
Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 9382
    
    2

Congratulations!

What is your current knowledge level on general object oriented programming? When I started, it took me a month with 4 to 6 hours of practice everyday.


SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Stefan Feldmann
Ranch Hand

Joined: Nov 07, 2013
Posts: 38
Joe Harry wrote:Congratulations!

What is your current knowledge level on general object oriented programming? When I started, it took me a month with 4 to 6 hours of practice everyday.


thank you

30 x 6h only to learn OO concepts or exam 1Z0-803?

I have zero OO skills
Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 254

I think Joe is looking to make you master , I think in one month you will be flying high.


Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer
Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 254

I am also looking to give this SQL expert exam and have read the Steve `s book.

Can you explain your experience of the exam and I am having trouble in reading exhibit.
Stefan Feldmann
Ranch Hand

Joined: Nov 07, 2013
Posts: 38
Mahtab Alam wrote:
Can you explain your experience of the exam and I am having trouble in reading exhibit.


- It's really hard/complicated exam
- the questions and multiple-choice answer are confusing/tricky
- you can't pass without real world Oracle SQL experience

I recommend you this summary guide shortly before you attend the exam:

http://www.oraclecertificationprep.com/apex/f?p=OCPSG:Study_Guides:0::NO::::

here the exam objectives/exhibit


Retrieving Data Using the SQL SELECT Statement

List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Describe how schema objects work

Restricting and Sorting Data

Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query

Using Single-Row Functions to Customize Output

Describe various types of functions that are available in SQL
Use character, number, and date functions in SELECT statements
Describe the use of conversion functions

Reporting Aggregated Data Using the Group Functions

Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

Define subqueries
Describe the types of problems that subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries

Using the Set Operators

Describe set operators
Use a set operator to combine multiple a single query
Control the order of rows returned

Manipulating Data

Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

Using DDL Statements to Create and Manage Tables

Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation

Creating Other Schema Objects

Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

Managing Objects with Data Dictionary Views

Use the data dictionary views to research data on your objects
Query various data dictionary views

Controlling User Access

Differentiate system privileges from object privileges
Grant privileges on tables
View privileges in the data dictionary
Grant roles
Distinguish between privileges and roles

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 multitable 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
Tiberius Marius
Ranch Hand

Joined: Dec 27, 2013
Posts: 106
    
    2
I m in a similar situation with you Stefan except that i have 0 programming experience , OO or otherwise .I made some estimations (hopefully realistic) that i would need about 5 h a day for about 5 months for this certification ( 3 months general introduction into java/programming and 2 especially for the certification) . Maybe anyone here can tell me if i m close or way off .
Actually i spent some time looking into books for the introduction to programming/OO part and i don't think Head First is a good choice for anyone with no XP , i found the following 2 books to be most promising :

The Art and Science of Java
Introduction to Programming in Java: An Interdisciplinary Approach

Anyone has advice for starting books or general advice for someone green as green goes ?
 
Don't get me started about those stupid light bulbs.
 
subject: I cleared 'Oracle Database SQL Certified Expert' 1Z0-047