Home > Store

Oracle 9i: SQL Exam Cram 2 (Exam Cram 1Z0-007)

View Larger Image

Oracle 9i: SQL Exam Cram 2 (Exam Cram 1Z0-007)

Register your product to gain access to bonus material or receive a coupon.

Oracle 9i: SQL Exam Cram 2 (Exam Cram 1Z0-007)

eBook (Adobe DRM)

  • Sorry, this book is no longer in print.
  • About Adobe DRM eBooks

    • ℹ This eBook requires the free Adobe® Digital Editions software.

    Before downloading this DRM-encrypted PDF, be sure to:


    • Install the free Adobe Digital Editions software on your machine. Adobe Digital Editions only works on Macintosh and Windows, and requires the Adobe Flash Player. Please see the official system requirements.
    • Authorize your copy of Adobe Digital Editions using your Adobe ID (select AdobeID as the eBook vendor). If you don't already have an Adobe ID, you can create one here.
Not for Sale

Description

  • Copyright 2005
  • Pages: 448
  • Edition: 1st
  • eBook (Adobe DRM)
  • ISBN-10: 0-7686-6382-2
  • ISBN-13: 978-0-7686-6382-2

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.

Sample Content

Table of Contents

Introduction.

Self-Assessment.

1. Getting Started with Oracle Database.

    What Is an RDBMS?

      Basic Relational Data Modeling.

      The Object-Relational Data Model.

    Database Design and Modeling the Oracle Way.

    What Is Oracle SQL?

    Tools.

      SQL*Plus.

      SQL*Plus Worksheet.

      iSQL*Plus.

      Oracle Enterprise Manager.

    Oracle SQL New Features for Oracle9i.

      General.

      SQL Statements.

      Datatypes.

      Expressions.

      Conditions.

      Built-In Functions.

    The MOVIES Schema.

    Syntax Conventions Used in This Book.

    Exam Prep Questions.

2. Retrieving Data (SELECT).

    What Is a Query?

    SELECT Statement Syntax and Query Capabilities.

      Selecting Columns from Tables.

      Using Aliases.

      Selecting from Other Database Objects.

    Types of Queries.

    Some Things We Can Do with SELECT.

      The DUAL Table.

      NULL Values.

      The DISTINCT Clause.

    Exam Prep Questions.

Updates

Submit Errata

More Information

Pearson IT Certification Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from Pearson IT Certification and its family of brands. I can unsubscribe at any time.