OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

Steve O?Hearn

ISBN 10: 1259585492 / ISBN 13: 9781259585494

Published by McGraw-Hill Education, 2017

This fully integrated study system covers every aspect of the Oracle Database SQL Certified Expert exam, and has been thoroughly updated for Oracle Database 12c Num Pages: 832 pages. BIC Classification: UNSB; UQ. Category: (G) General (US: Trade). . . 2017. 1st Edition. Paperback. . . . . Seller Inventory # V9781259585494

Synopsis:

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 updated, integrated self-study system for the Oracle Database SQL Exam

This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Job” sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test.

Get complete coverage every topic on Exam 1Z0-071, including:

• DDL and SQL SELECT statements
• Manipulating, restricting, and sorting data
• Single-row and group functions
• Displaying data from multiple tables
• Subqueries
• Schema objects
• Set operators
• Grouping related data
• Report creation
• Data dictionary views
• Large data sets
• Hierarchical retrieval
• Regular expression support
• User access control

The electronic includes:
• Two full practice exams
• Detailed answers and explanations
• Complete PDF copy of the book

About the Author:

Steve O'Hearn, OCP is an Oracle Certified Application Developer who has designed databases for clients such as the U.S. Army, U.S. Navy, the FAA, the World Bank, and NASA. He is the author of several computer books, including Oracle OCP Developer PL/SQL Program Units Exam Guide.

Bibliographic Details

Title: OCA Oracle Database SQL Exam Guide (Exam 1Z0...
Publisher: McGraw-Hill Education
Publication Date: 2017
Binding: Soft cover
Condition: New
Edition: 1st Edition