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

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

4.33 (3 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?


This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12cThis comprehensive study guide from Oracle Press enables readers to prepare for the SQL Database Expert Exam with total confidence. Ideal both as a study guide and on-the-job reference, Oracle Database 12c SQL Certified Expert Exam Guide features examples, practice questions, and chapter summaries. Between the book and accompanying CD-ROM, you will have access to more than 150 questions that match the topics, format, and complexity of the real test.

This study system covers all of the objectives for the Oracle Database 12c SQL Expert Exam in full detail and features up-to-date coverage of advanced SQL features related to Oracle Database 12c. An "exam readiness checklist" at the front of the book and "inside the exam" and "two minute drills" sections at the end of each chapter reinforce key skills. You will acquire in-depth knowledge of SQL programming and relational database concepts and will be prepared to sit for the Oracle Certified Expert exam.

Each chapter includes examples, practice questions, and summariesCD-ROM contains two interactive practice tests and a searchable PDF version of the bookSample questions throughout match the format and difficulty of the live exam
show more

Product details

  • Book | 832 pages
  • 201 x 234 x 34mm | 996g
  • OH, United States
  • English
  • Revised ed.
  • 125 Illustrations, unspecified
  • 1259585492
  • 9781259585494
  • 368,297

Table of contents

Chapter 1: Oracle and Structured Query Language (SQL)
Chapter 2: Using DDL Statements to Create and Manage Tables
Chapter 3: Manipulating Data
Chapter 4: Restricting and Sorting Data
Chapter 5: Using Single-Row Functions to Customize Output
Chapter 6: Using Conversion Functions and Conditional Expressions
Chapter 7: Reporting Aggregated Data Using the Group Functions
Chapter 8: Displaying Data from Multiple Tables
Chapter 9: Using Subqueries to Solve Queries
Chapter 10: Managing Schema Objects
Chapter 11: Using the Set Operators
Chapter 12: Managing Objects with Data Dictionary Views
Chapter 13: Manipulating Large Data Sets
Chapter 14: Controlling User Access
Appendix A: About the CD
show more

About Steve O'Hearn

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
show more

Rating details

3 ratings
4.33 out of 5 stars
5 33% (1)
4 67% (2)
3 0% (0)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X