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

4 avg rating
( 1 ratings by Goodreads )
 
9781259585494: OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press)

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

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

O'hearn, Steve
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 5
Seller:
GreatBookPrices
(Columbia, MD, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # 23886344-n

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.80
Convert Currency

Add to Basket

Shipping: US$ 2.64
Within U.S.A.
Destination, Rates & Speeds

2.

O'Hearn, Steve
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 8
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2017. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # KB-9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 32.46
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

O'HEARN
Published by Mcgraw Hill Publishers
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

Book Description Mcgraw Hill Publishers. Book Condition: New. Brand New. Bookseller Inventory # 1259585492

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.07
Convert Currency

Add to Basket

Shipping: US$ 3.50
Within U.S.A.
Destination, Rates & Speeds

4.

O'Hearn, Steve
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 2
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2017. PAP. Book Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 36.13
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

5.

O'Hearn, Steve
Published by McGraw-Hill Education (2017)
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Paperback Quantity Available: 1
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2017. Paperback. Book Condition: New. Never used!. Bookseller Inventory # 1259585492

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 41.30
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

6.

Steve O Hearn
Published by McGraw-Hill Education - Europe, United States (2018)
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2018. Book. Book Condition: New. 2nd Revised edition. Language: English . Brand New Book. This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12c This 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 summaries CD-ROM contains two interactive practice tests and a searchable PDF version of the book Sample questions throughout match the format and difficulty of the live exam. Bookseller Inventory # AAS9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 43.87
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Steve O Hearn
Published by McGraw-Hill Education - Europe, United States (2018)
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 10
Seller:
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2018. Book. Book Condition: New. 2nd Revised edition. Language: English . Brand New Book. This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12c This 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 summaries CD-ROM contains two interactive practice tests and a searchable PDF version of the book Sample questions throughout match the format and difficulty of the live exam. Bookseller Inventory # AAS9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 44.80
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Steve O'Hearn
Published by McGraw-Hill Education 2018-08-16, New York (2018)
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 5
Seller:
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education 2018-08-16, New York, 2018. book. Book Condition: New. Bookseller Inventory # 9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 46.25
Convert Currency

Add to Basket

Shipping: US$ 4.05
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Steve O'Hearn
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Paperback Quantity Available: 1
Seller:
Grand Eagle Retail
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. 2nd. Paperback. This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12c This comprehensive study guide from .Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 832 pages. 0.381. Bookseller Inventory # 9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 50.82
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Oandapos;Hearn, Steve
Published by McGraw-Hill Education (2018)
ISBN 10: 1259585492 ISBN 13: 9781259585494
New Quantity Available: 2
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education, 2018. UNK. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9781259585494

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 39.98
Convert Currency

Add to Basket

Shipping: US$ 12.16
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book