TY - BOOK AU - Ramklass, Roopesh TI - OCA Oracle Database 12c: SQL fundamentals I exam guide (exam IZ0-061) T2 - Oracle press SN - 9789339218102 U1 - 005.7585 PY - 2014/// CY - New Delhi PB - McGraw Hill Education KW - Electronic data processing personnel KW - Certification KW - Study guides KW - COMPUTERS / Certification Guides N1 - Includes index N2 - "Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this exclusive 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 test 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"-- |c Provided by publisher ER -