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

Name: OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)
Rating: 4.5714287757873535 (7 reviews)

Steve O'Hearn

Aug 2017 · McGraw Hill Professional

4.6

7 reviews

eBook

832

Pages

About this eBook

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

Ratings and reviews

4.6

7 reviews

ANALIZA ORIO A.

2 December 2022

Oracle home Court

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.

Rate this eBook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Centre instructions to transfer the files to supported eReaders.