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

OCA Oracle Database SQL Certified Expert Exam Guide is a comprehensive guide to certification exams. The candidates can prepare for their Oracle Certified Associate SQL Certified Expert exam with this book. The book contains challenging practice problems, exercises, and other drills to help students prepare well.

The book contains eighteen chapters and extensively covers all important topics related to SQL. There are chapters dedicated to manipulation of data and creating and managing tables. The chapters discuss various data manipulation techniques discussed and other methods to sort and arrange data. There is a discussion on reporting and displaying data from various tables. The author has also explained creating schema objects and managing them. There is also a section devoted to using set operators, manipulating large data sets, hierarchical retrieval, regular expression support, and controlling user access.

Written by Steve O’ Hearn, OCA Oracle Database SQL Certified Expert Exam Guide was published by McGraw-Hill Education in 2010 and is available in paperback.