OCA oracle database 12c : SQL fundamentals I exam guide (exam 1Z0-061) 2nd ed.
Author
Ramklass, Roopesh
Additional Author(s)
-
Publisher
New York: McGraw-Hill Education, 2014
Language
English
ISBN
9780071820288
Series
Subject(s)
COMPUTERS
ORACLE (COMPUTER FILE)-EXAMINATIONS
ELECTRONIC DATA PROCESSING PERSONNEL-CERTIFICATION-STUDY GUIDES
Notes
CD ROM
. . Includes index (p. 532 - 550)
Abstract
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.