Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.
Chapter 1 Getting started with Oracle database
Chapter 2 Retrieving data (SELECT)
Chapter 3 Filtering (WHERE) and sorting data (ORDER BY)
Chapter 4 Operators, conditions, pseudocolumns, and
expressions
Chapter 5 Single row functions
Chapter 6 Joining tables
Chapter 7 Groups and summaries (GROUP BY)
Chapter 8 Subqueries and other specialized queries
Chapter 9 SQL[superscript *]Plus formatting
Chapter 10 Changing data (DML)
Chapter 11 Tables, datatypes, and constraints (DDL)
Chapter 12 Views, indexes, sequences, and synonyms (DDL)
Chapter 13 Security (DDL)
Chapter 14 Practice test #1 (60 questions)
Chapter 15 Answer key to practice test #1
Chapter 16 Practice test #2
Chapter 17 Answer key to practice test #2
Shaun Pillay; Roger A. Grimes; Johnny Hughes [et.al]
Gavin Powell BSc. Comp. Sci., OCP DBA (Oracle Certified Professional) has 15 years of diverse experience in database administration and database development, both relational and object databases. His applications development experience is procedural and object-oriented. Consulting experience includes software vendors, Internet dotcoms, accounting, banking and financial services, the travel industry, construction, retail, mining, shipping, education and in a general advisory capacity. Gavin is the author of five other Oracle titles, including three Oracle certification titles.