Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Qty:1
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Study Guide for 1Z0-051: ... has been added to your Cart
+ $3.99 shipping
Used: Very Good | Details
Sold by TARTAN-FROG-USA
Condition: Used: Very Good
Comment: In VERY GOOD general condition, with some signs of previous use. Dispatched from the UK daily VERY GOOD overall condition, with only slight signs of previous usage. PRIORITY SHIPPING FROM THE UK DAILY. NORMALLY WITH YOU IN 5-7 DAYS.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep Paperback – April 16, 2012

2.3 out of 5 stars 3 customer reviews

See all 2 formats and editions Hide other formats and editions
Price
New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$11.99
$9.15 $10.21

Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
$11.99 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep
  • +
  • Study Guide for 1Z0-052: Oracle Database 11g: Administration I: Oracle Certification Prep
  • +
  • Study Guide for 1Z0-047: Oracle Database SQL Expert: Oracle Certification Prep
Total price: $38.40
Buy the selected items together


Editorial Reviews

From the Back Cover

This is the affordable solution with the information you need to complete your self-study for 1Z0-051.  The study guides in the Oracle Certification Prep series were developed to provide Oracle certification candidates a means to rapidly polish their skills for the exam.  The information presented is clear and to the point.
The 1Z0-051 guide covers all of the key exam topics:
  • Retrieving Data Using the SQL SELECT Statement
  • 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
  • Creating Other Schema Objects

About the Author

Matthew Morris has worked with the Oracle database since 1996 when he worked in the RDBMS support team for Oracle Support Services. Employed by Oracle for over eleven years in support and development positions, Matthew was an early adopter of the Oracle Certified Professional program. He was one of the first one hundred Oracle Certified Database Administrators (version 7.3) and was also in the first hundred to become an Oracle Certified Forms Developer. In the years since, he has upgraded his Database Administrator certification for releases 8i, 9i, 10G and 11G, and added the Application Express Expert and the Oracle SQL Expert certifications. Outside of Oracle, he has CompTIA certifications in Linux+ and Security+. Matthew is an experienced Database Administrator and PL/SQL developer and has been creating Web applications with Oracle Application Express since the early days of its release. He is currently employed as a Database Engineer with Computer Sciences Corporation developing enterprise applications.
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $1.99 (Save 78%). Print edition purchase must be sold by Amazon. Learn more.


Image
Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

Product Details

  • Paperback: 144 pages
  • Publisher: CreateSpace Independent Publishing Platform; Stg edition (April 16, 2012)
  • Language: English
  • ISBN-10: 1475204663
  • ISBN-13: 978-1475204667
  • Product Dimensions: 6 x 0.3 x 9 inches
  • Shipping Weight: 9.6 ounces (View shipping rates and policies)
  • Average Customer Review: 2.3 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Best Sellers Rank: #955,317 in Books (See Top 100 in Books)

More About the Author

Matthew Morris has worked with the Oracle database since 1996 when he worked in the RDBMS support team for Oracle Support Services. Employed by Oracle for over eleven years in support and development positions, Matthew was an early adopter of the Oracle Certified Professional program. He was one of the first one hundred Oracle Certified Database Administrators (version 7.3) and was also in the first hundred to become an Oracle Certified Forms Developer. In the years since, he has upgraded his Database Administrator certification for releases 8i, 9i, 10g, 11g, and 12c, become an Oracle Advanced PL/SQL Developer Certified Professional, and added the Expert certifications for Application Express, SQL, and SQL Tuning. Outside of Oracle, he has CompTIA certifications in Linux+ and Security+.

Matthew is an experienced Database Administrator and PL/SQL developer and has been creating Web applications with Oracle Application Express since the early days of its release. He is currently employed as a Database Engineer with Computer Sciences Corporation developing enterprise applications.

Customer Reviews

5 star
0%
4 star
0%
3 star
67%
2 star
0%
1 star
33%
See all 3 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
If you saw my earlier review - I WAS WRONG

I bought this and another book. The other book covered about 45 topics included a lot of analytic function stuff. Well, after taking the test I know - the book basically covered the areas and the hard-core analytic stuff was not there.

Some books have a CD of questions and a lot of other stuff. This does not. It goes through the topics on the Oracle website re subject areas and specifics.

So this should be *ONE OF* the references you need to prepare - not the only one
4 Comments 10 of 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
The book is good.
Comment 0 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I thought the book bigger, with more pages, but it doesn't matter for me.
Comment 0 of 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep
This item: Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep
Price: $11.99
Ships from and sold by Amazon.com