01648nam a22002297a 450000500170000001000150001702000260003202000230005803500130008103700130009408200130010710000220012024500990014226000430024127000500028430000380033449000180037250000190039052008990040965000730130865000370138120141114152140.0  aENG-111200  a9789339218102c750.00  a9339218108c750.00  aEN-94732  bDBAD/PUB  a005.7585  aRamklass, Roopesh  aOCA Oracle Database 12c :cby Roopesh RamklassbSQL fundamentals I exam guide (exam IZ0-061) /  aNew DelhibMcGraw Hill Educationc2014  aP-24, Green Park ExtensionbNew Delhie110016  axxii, 550p. :c24cm(pbk)e1CD-ROM  a Oracle press  aIncludes index  a "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.  aElectronic data processing personnel xCertification vStudy guides.  aCOMPUTERS / Certification Guides