• Contact

  • Newsletter

  • About us

  • Delivery options

  • Prospero Book Market Podcast

  • OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047): Exam 1Z0-047

    OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) by O'Hearn, Steve;

    Exam 1Z0-047

    Series: Oracle Press;

      • GET 10% OFF

      • The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
      • Publisher's listprice GBP 45.89
      • The price is estimated because at the time of ordering we do not know what conversion rates will apply to HUF / product currency when the book arrives. In case HUF is weaker, the price increases slightly, in case HUF is stronger, the price goes lower slightly.

        21 923 Ft (20 879 Ft + 5% VAT)
      • Discount 10% (cc. 2 192 Ft off)
      • Discounted price 19 731 Ft (18 791 Ft + 5% VAT)

    21 923 Ft

    Availability

    Uncertain availability. Please turn to our customer service.

    Why don't you give exact delivery time?

    Delivery time is estimated on our previous experiences. We give estimations only, because we order from outside Hungary, and the delivery time mainly depends on how quickly the publisher supplies the book. Faster or slower deliveries both happen, but we do our best to supply as quickly as possible.

    Product details:

    • Publisher McGraw-Hill Education
    • Date of Publication 16 October 2009

    • ISBN 9780071614214
    • Binding Book
    • No. of pages796 pages
    • Size 233x190x43 mm
    • Weight 1318 g
    • Language English
    • 0

    Categories

    Short description:

    A fully integrated study system for Oracle Certification exam 1Z0-047, exclusively from Oracle Press

    More

    Long description:

    Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


    A Fully Integrated Study System for OCA Exam 1Z0-047

    Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, including:

    • DDL and SQL SELECT statements
    • Manipulating, restricting, and sorting data
    • Single-row and group functions
    • Subqueries
    • Schema objects
    • Set operators
    • Data dictionary views
    • Large data sets
    • Hierarchical retrieval
    • Regular expression support
    • User access control
    • And more

    On the CD-ROM:

    • One full practice exam
    • Detailed answers and explanations
    • Score report performance assessment tool
    • Complete electronic book
    • Bonus exam available with free online registration

    For a complete list of Oracle Press titles, visit www.OraclePressBooks.com



    Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


    A Fully Integrated Study System for OCA Exam 1Z0-047

    Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, including:

    • DDL and SQL SELECT statements
    • Manipulating, restricting, and sorting data
    • Single-row and group functions
    • Subqueries
    • Schema objects
    • Set operators
    • Data dictionary views
    • Large data sets
    • Hierarchical retrieval
    • Regular expression support
    • User access control
    • And more

    On the CD-ROM:

    • One full practice exam
    • Detailed answers and explanations
    • Score report performance assessment tool
    • Complete electronic book
    • Bonus exam available with free online registration

    For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

    More

    Table of Contents:

    Chapter 1. Introduction to SQL
    Chapter 2. Using DDL Statements to Create and Manage Tables
    Chapter 3. Manipulating Data
    Chapter 4. Retrieving Data Using the SQL SELECT Statement
    Chapter 5. Restricting and Sorting Data
    Chapter 6. Using Single-Row Functions to Customize Output
    Chapter 7. Reporting Aggregated Data Using the Group Functions
    Chapter 8. Displaying Data from Multiple Tables
    Chapter 9. Retrieving Data Using Subqueries
    Chapter 10. Creating Other Schema Objects
    Chapter 11. Managing Schema Objects
    Chapter 12. Using the Set Operators
    Chapter 13. Generating Reports by Grouping Related Data
    Chapter 14. Managing Objects with Data Dictionary Views
    Chapter 15. Manipulating Large Data Sets
    Chapter 16. Hierarchical Retrieval
    Chapter 17. Regular Expression Support
    Chapter 18. Controlling User Access
    Appendix A. About the CD
    Glossary
    Index

    More
    0