E-Book Overview
The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor.Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include: * Basic relational database concepts* Reporting and querying using SQL*Plus and iSQL*Plus* Creating and maintaining a database* Managing user access and security* Understanding Oracle database functions* Using multiple tables in a query* Restricting, sorting, and grouping data* Optimizing database performance* Creating backups* Troubleshooting database errors
E-Book Content
Oracle Database Foundations Bob Bryla San Francisco ◆ London Associate Publisher: Neil Edde Acquisitions and Developmental Editor: Maureen Adams Production Editor: Susan Berge Copyeditor: Linda S. Recktenwald Compositor: Craig Woods, Happenstance Type-O-Rama Graphic Illustrator: Jeff Wilson, Happenstance Type-O-Rama Proofreaders: Amy J. Rasmussen, Nancy Riddiough Indexer: Ted Laux Book Designer: Judy Fung Cover Designer: Ingalls + Associates Cover Photo: Jerry Driendl, Taxi Copyright © 2004 SYBEX Inc., 1151 Marina Village Parkway, Alameda, CA 94501. World rights reserved. No part of this publication may be stored in a retrieval system, transmitted, or reproduced in any way, including but not limited to photocopy, photograph, magnetic, or other record, without the prior agreement and written permi