Author Ramklass, Roopesh Additional authorUnknown Publisher McGraw-Hill Education (New York, 2014) Language(eng) English ISBN9780071820288 SeriesUnknown Edition2nd ed. SubjectELECTRONIC DATA PROCESSING PERSONNEL-CERTIFICATION-STUDY GUIDES; NoteCD ROM; AbstractThis 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.

Number of pagesxxi, 550 p. Dimension24 cm. Other descriptionill.