OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press 2nd Revised edition)

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) (Oracle Press 2nd Revised edition)

By: Steve O'Hearn (author)

In Stock

£30.54 RRP £46.99  You save £16.45 (35%) With FREE Saver Delivery


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

About Author

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


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

Product Details

  • ISBN13: 9781259585494
  • Number Of Pages: 832
  • ID: 9781259585494
  • weight: 996
  • ISBN10: 1259585492
  • edition: 2nd Revised edition

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly