OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press)
<h4>A Complete Study System for OCA Exam 1Z0-061</h4> <p>Prepare for the Oracle Certified Associate Oracle Database 12<i>c</i> SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:</p> <ul> <li>Data retrieval using the SQL SELECT statement</li> <li>Restricting and sorting data</li> <li>Single-row functions</li> <li>Using conversion functions and conditional expressions</li> <li>Reporting aggregated data with the group functions</li> <li>Displaying data from multiple tables with joins</li> <li>Using subqueries to solve problems</li> <li>Using the set operators</li> <li>Manipulating data with DML statements</li> <li>Using DDL statements to create and manage tables</li> </ul> <p>Electronic content includes:</p> <ul> <li>150+ practice exam questions with detailed answers and explanations</li> <li>Score report performance assessment tool</li> </ul>