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
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