Oracle 9i: SQL Exam Cram 2 (Exam Cram 1Z0-007)
by Powell, GavinEdition: 1st
Format: Paperback w/CD
Pub. Date: 2005-01-01
Publisher(s): Que Pub
Other versions by this Author
List Price: $36.74
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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 2can 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 2is your smartest way to get certified.
Author Biography
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.
Table of Contents
| Getting started with Oracle database | p. 1 |
| Retrieving data (SELECT) | p. 27 |
| Filtering (WHERE) and sorting data (ORDER BY) | p. 43 |
| Operators, conditions, pseudocolumns, and expressions | p. 63 |
| Single row functions | p. 77 |
| Joining tables | p. 103 |
| Groups and summaries (GROUP BY) | p. 125 |
| Subqueries and other specialized queries | p. 145 |
| SQL[superscript *]Plus formatting | p. 167 |
| Changing data (DML) | p. 195 |
| Tables, datatypes, and constraints (DDL) | p. 215 |
| Views, indexes, sequences, and synonyms (DDL) | p. 239 |
| Security (DDL) | p. 261 |
| Practice test #1 (60 questions) | p. 279 |
| Answer key to practice test #1 | p. 299 |
| Practice test #2 | p. 317 |
| Answer key to practice test #2 | p. 337 |
| Table of Contents provided by Blackwell. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.