Books: 2


Exam 1Z0-061
*** A Complete Study System for OCA Exam 1Z0-061 *** Prepare for the Oracle Certified Associate Oracle Database 12c 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 more » 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: * Data retrieval using the SQL SELECT statement * Restricting and sorting data * Single-row functions * Using conversion functions and conditional expressions * Reporting aggregated data with the group functions * Displaying data from multiple tables with joins * Using subqueries to solve problems * Using the set operators * Manipulating data with DML statements * Using DDL statements to create and manage tables Electronic content includes: * 150+ practice exam questions with detailed answers and explanations * Score report performance assessment tool * PDF copy of the book « less
Exams 1Z0-061 and 1Z0-062
An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that more » demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. * Provides you with a solid understanding of restricting and sorting data * Walks you through using conversion functions and conditional expressions * Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery * Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance * Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams. « less