Complete Exam Preparation
SQL Certified Expert Exam Guide is the book for the exam 1Z0-047 from Oracle.
This book from Oracle Press includes a CD with over 200 practice questions via the MasterExam program and a digital version of the book as a PDF is included.
Each chapter of the book includes everything you need to prepare for the exam. This includes detailed overviews of what you need to know in each section together with setting out objectives, providing practical’s, a two minute drill and a self test.
The SQL Certified Expert Exam Guide book is broken into 18 sections. These are an introduction to SQL, using DDL to create tables, manipulating data, retrieving data, restricting and sorting data, using single row functions, grouping and aggregating data, data from multiple tables, getting data via sub queries, creating other schema objects, managing schema objects, using set operators, generating reports, managing objects via data dictionary views, manipulating large data sets, hierarchical retrieval, regular expressions and controlling user access.
The Oracle Exam Guide is well laid out and easy to work through and in my mind an absolute must if you are going to be sitting the SQL Certified Expert exam anytime soon.