OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press)

by Roopesh Ramklass

0 ratings • 0 reviews • 0 shelved
Book cover for OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061)

Bookhype may earn a small commission from qualifying purchases. Full disclosure.

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 Complete Study System for OCA Exam 1Z0-061

Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:

  • Data retrieval using the SQL SELECT statement
  • Restricting and sorting data
  • Single-row functions
  • Using conversion functions and conditional expressions
  • Reporting aggregated data with the group functions
  • Displaying data from multiple tables with joins
  • Using subqueries to solve problems
  • Using the set operators
  • Manipulating data with DML statements
  • Using DDL statements to create and manage tables

Electronic content includes:

  • 150+ practice exam questions with detailed answers and explanations
  • Score report performance assessment tool
  • PDF copy of the book

  • ISBN13 9780071820288
  • Publish Date 16 July 2014 (first published 25 April 2014)
  • Publish Status Active
  • Publish Country US
  • Publisher McGraw-Hill Education - Europe
  • Imprint Osborne/McGraw-Hill
  • Edition 2nd edition
  • Format Hardcover
  • Pages 592
  • Language English