OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)
2nd Edition
Published on 18. September 2017
Book
832 pages
978-1-259-58549-4 (ISBN)
Description
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
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
More details
Edition
2nd Revised edition
Language
English
Place of publication
OH
United States
Target group
Professional and scholarly
Edition type
Revised edition
Illustrations
125 Illustrations
Dimensions
Height: 234 mm
Width: 201 mm
Thickness: 34 mm
Weight
962 gr
ISBN-13
978-1-259-58549-4 (9781259585494)
Schweitzer Classification
Person
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
Content
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
Glossary
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
Glossary