Overview

A fully updated, integrated self-study system for the SQL Certified Expert Exam This thoroughly revised Oracle Press guide offers 100% coverage of all 18 objectives on the latest version of the Oracle Database SQL Expert exam. Ideal both as a study guide and on-the-job reference, Oracle Database 12c: SQL Certified Expert Exam Guide, Second Edition (Exam 1Z0-047) 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-047, 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 On the CD-ROM: • Two full practice exams • Detailed answers and explanations • Complete PDF copy of the book

Full Product Details

Author:   Steve O'Hearn
Publisher:   McGraw-Hill Education
Imprint:   McGraw-Hill Education
Edition:   2nd Revised edition
Dimensions:   Width: 20.10cm , Height: 3.40cm , Length: 23.40cm
Weight:   0.962kg
ISBN:  

9781259585494

ISBN 10:   1259585492
Pages:   832
Publication Date:   18 September 2017
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Book
Publisher's Status:   Active
Availability:   Out of stock  
The supplier is temporarily out of stock of this item. It will be ordered for you on backorder and shipped when it becomes available.

Table of Contents

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

Reviews

Author Information

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

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions