Oracle Database 12c SQL Certified Expert Exam Guide (Exam 1Z0-047)

Oracle Database 12c SQL Certified Expert Exam Guide (Exam 1Z0-047)
By:O'Hearn, Steve; O'Hearn , Steve
Pub Date:August 26th 2016
Format:Mixed media product 832 pages
ISBN:1259585492 / 9781259585494
Your Price:$60.00 ADD TO CART
More Information




Main description

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


Table of contents

Chapter 1. Introduction to SQL
Chapter 2. Using DDL Statements to Create and Manage Tables
Chapter 3. Manipulating Data
Chapter 4. Retrieving and Sorting Data
Chapter 5. Using Single-Row Functions to Customize Output
Chapter 6. Reporting Aggregated Data Using the Group Functions
Chapter 7. Displaying Data from Multiple Tables
Chapter 8. Retrieving Data Using Subqueries
Chapter 9. Creating Other Schema Objects
Chapter 10. Managing Schema Objects
Chapter 11. Using the Set Operators
Chapter 12. Generating Reports by Grouping Related Data
Chapter 13. Managing Objects with Data Dictionary Views
Chapter 14. Manipulating Large Data Sets
Chapter 15. Hierarchical Retrieval
Chapter 16. Regular Expression Support
Chapter 17. Controlling User Access
Appendix A. About the CD
Glossary
Index


Backcover

Author Information


Steve O'Hearn, OCP (Bowie, MD) 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.


Steve O’Hearn, OCP (Bowie, MD) has been an Oracle Certified Application Developer since 1999 and has designed databases for the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He is the author of OCP Developer PL/SQL Program Units Exam Guide and OCA Oracle Database SQL Certified Expert Exam Guide, both from Oracle Press.

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Mar 22nd, 2017
Your Price: $40.00
Owl Image

Date: Nov 22nd, 2016
Your Price: $50.00
Owl Image

Date: Oct 22nd, 2016
Your Price: $110.00
Owl Image

Date: Aug 26th, 2016
Your Price: $35.00
Owl Image

Date: Aug 5th, 2016
Your Price: $40.00
Owl Image

Date: May 22nd, 2016
Your Price: $80.00
Owl Image

Date: Apr 25th, 2016
Your Price: $85.00
Owl Image

Date: Apr 19th, 2016
Your Price: $80.00
Owl Image

Date: Apr 8th, 2016
Your Price: $60.00
Owl Image

Date: Dec 29th, 2015
Your Price: $99.00
Owl Image

Date: Dec 3rd, 2015
Your Price: $70.00
Owl Image

Date: Nov 13th, 2015
Your Price: $35.00
Owl Image

Date: Oct 12th, 2015
Your Price: $60.00
Owl Image

Date: Sep 11th, 2015
Your Price: $50.00
Owl Image

Date: Sep 2nd, 2015
Your Price: $50.00