Ebook: OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061)

This Oracle Press guide helps the reader to prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This book also serves as an essential, on-the-job reference. It covers 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; and using DDL statements to create and manage tables.