OracleA (R) 9i SQL Exam Cram2 "I have decided that the Que Certification books will be my first choice for any other cert exams I take. I just think they are a cut above." -John Calcagni In This Book You'll Learn How To: *Retrieve data using the SELECT statement *Filter rows with the WHERE clause*Sort data with the ORDER BY clause *Use operators, conditions, pseudocolumns expressions, and single row functions*Group and summarize rows with the GROUP BY clause *Construct subqueries and other specialized queries*Format with SQL*Plus *Change data using DML INSERT, UPDATE, and DELETE commands*Use DDL commands for creating and maintaining tables, their datatypes, and constraints*Use DDL commands for creating and maintaining views, indexes, sequences, and synonyms*Implement Oracle database security The Exam Cram MethodaA A of study focuses on exactly what you need to get certified now. *Organized according to the exam objectives so you can quickly and easily assess your understanding of the key material covered on the Oracle 9i SQL exam.* Edited by Ed Tittel, two-time finalist for Favorite Study Guide Author in a poll of CertCities readers and original creator of the Exam Cram series.*Features dozens of test-taking strategies and time-saving tips!*Use our popular Cram Sheet tearcard-which includes exam tips, acronyms, and memory joggers-for a last-minute review before you take your exam.*Register for The Crammers Club (www.examcram2.com) for access to additional practice questions, industry news, our Question of the Day program, and an online community where you can ask questions and participate in open forums with others who are studying for their Oracle 9i SQL exam.