Study Guide for 1Z0-047 : Oracle Database SQL Expert

Paperback - April 5, 2012

By Matthew Morris

ISBN: 1475152434
Publisher: Createspace Independent Pub
Year: 2012
Pages: 149

About This Book

This Study Guide is targeted at IT professionals who are looking to become an Oracle Database Certified SQL Expert. The book provides information covering all of the exam topics for the Oracle Expert exam: "1Z0-047: Oracle Database SQL Expert".The books in the Oracle Certification Prep series are built in lockstep with the test topics provided by Oracle Education's certification program. Each book is intended to provide the information that will be tested in a clean and concise format. The guides introduce the subject you'll be tested on, follow that with the information you'll need to know for it, and then move on to the next topic. They contain no drills or unrealistic self-tests to bump the page count without adding value. The series is intended to provide a concentrated source of exam information that is compact enough to be read through multiple times.This series is ideal for experienced Oracle professionals that are familiar with the topic being tested, but want a means to rapidly reinforce their existing skills and bridge any gaps in their knowledge. It is also an excellent option as a second source of information for candidates pursuing certification.

Product Details

Publisher Createspace Independent Pub
Publication date April 5, 2012
Language English
Print length 149 pages
ISBN-10 1475152434
ISBN-13 978-1475152432
Item Weight 0.56 pounds

Editorial Reviews

Editorial Review

Review"There's no fluff of any kind in this book. It's clearly written by someone who has taken a lot of Oracle certification exams and knows what's critically important and what's less so: Here's what you need to know about what's on this test, and then bang-bang-bang through the Oracle 1Z0-047 exam objectives. Each topic includes a condensed explanation complete with relevant syntax, vocabulary, and examples. Their slim size makes them easy to carry with you and realistic to read more than once." -- Anne Martinez -- GoCertify.comFrom the Back CoverThis is the affordable solution with the information you need to complete your self-study for 1Z0-047. 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-047 guide covers all of the key exam topics:Retrieving Data Using the SQL SELECT StatementRetrieving Data Using the SQL SELECT StatementRestricting and Sorting DataRestricting and Sorting DataUsing Single-Row Functions to Customize OutputUsing Single-Row Functions to Customize OutputReporting Aggregated Data Using the Group FunctionsReporting Aggregated Data Using the Group FunctionsDisplaying Data from Multiple TablesDisplaying Data from Multiple TablesUsing Subqueries to Solve QueriesUsing Subqueries to Solve QueriesUsing the Set OperatorsUsing the Set OperatorsManipulating DataManipulating DataUsing DDL Statements to Create and Manage TablesUsing DDL Statements to Create and Manage TablesCreating Other Schema ObjectsCreating Other Schema ObjectsManaging Objects with Data Dictionary ViewsManaging Objects with Data Dictionary ViewsControlling User AccessControlling User AccessManaging Schema ObjectsManaging Schema ObjectsManipulating Large Data SetsManipulating Large Data SetsGenerating Reports by Grouping Related DataGenerating Reports by Grouping Related DataManaging Data in Different Time ZonesManaging Data in Different Time ZonesRetrieving Data Using SubqueriesRetrieving Data Using SubqueriesHierarchical RetrievalHierarchical RetrievalRegular Expression SupportRegular Expression Support 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/S
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers