SQL fundamentals I exam guide (exam IZ0-061) Ramklass, Roopesh creator text New Delhi McGraw Hill Education 2014 monographic xxii, 550p. : 24cm(pbk) 1CD-ROM "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. by Roopesh Ramklass Includes index Electronic data processing personnel Certification Study guides COMPUTERS / Certification Guides 005.7585 9789339218102 9339218108 ENG-111200 DBAD/PUB 20141114152140.0