Cover art for OCA Oracle Database SQL Certified Associate Exam Guide (Exam1Z0-071)
Published
Mcgraw Hill Education, July 2017
ISBN
9781259585494
Format
Softcover, 832 pages
Dimensions
23.4cm × 20.1cm × 3.4cm

OCA Oracle Database SQL Certified Associate Exam Guide (Exam1Z0-071) 2nd edition by

Not in stock
Fast $7.95 flat-rate shipping!
Only pay $7.95 per order within Australia, including end-to-end parcel tracking.
100% encrypted and secure
We adhere to industry best practice and never store credit card details.
Talk to real people
Contact us seven days a week – our staff are here to help.

A fully updated, integrated self-study system for the SQL Certified Expert Exam

This thoroughly revised Oracle Press guide offers 100% coverage of all 18 objectives on the latest version of the Oracle Database SQL Expert exam. Ideal both as a study guide and on-the-job reference, Oracle Database 12c: SQL Certified Expert Exam Guide, Second Edition (Exam 1Z0-047) 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-047, 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

On the CD-ROM:

  • Two full practice exams

  • Detailed answers and explanations

  • Complete PDF copy of the book

Related books