Table of Contents

oracle9i dba jumpstart
Oracle9i DBA JumpStart
byBob Bryla ISBN:0782141897
Sybex 2003 (347 pages)

Get up to speed for Oracle9i Administration Training Courses--Fast!

Table of Contents
Oracle9i DBA JumpStart
Chapter 1- Relational Database Concepts
Chapter 2- SQL*Plus and iSQL*Plus Basics
Chapter 3- Oracle Database Functions
Chapter 4- Restricting, Sorting, and Grouping Data
Chapter 5- Using Multiple Tables
Chapter 6- Advanced SQL Queries
Chapter 7- Logical Consistency
Chapter 8- Installing Oracle and Creating a Database
Chapter 9- Reporting Techniques
Chapter 10- Creating and Maintaining Database Objects
Chapter 11- Users and Security
Chapter 12- Making Things Run Fast (Enough)
Chapter 13- Saving Your Stuff (Backups)
Chapter 14- Troubleshooting
Appendix A- Answers to Review Questions
Appendix B- Glossary
Appendix C- Common Database Platforms
Where Can I Find?
List of Tables
List of Sidebars

Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence:

  • Introduction to relational database concepts
  • Using basic SQL *Plus and iSQL *Plus commands
  • Understanding Oracle database functions
  • Using multiple tables
  • Restricting, sorting, and grouping data
  • Creating and maintaining a database
  • Using SQL *Plus reporting techniques
  • Setting up users and managing security
  • Configuring optimization
  • Creating backups
  • Troubleshooting

About the Author

Bob Bryla, is an Oracle9i Certified Professional with more than ten years of experience in database design, database application development, training, and database administration. He is currently an internet database analyst and DBA at Land’s End, Inc. in Dodgeville, Wisconsin.

Oracle9i DBA JumpStart

Bob Bryla

Associate Publisher: Neil Edde

Acquisitions Editor: Elizabeth Hurley Peterson

Developmental Editor: Heather O’Connor

Production Editor: Leslie E.H. Light

Technical Editor: Betty MacEwen

Copyeditor: Marilyn Smith

Compositor: Kate Reber, Happenstance Type-O-Rama

Graphic Illustrator: Jeffery Wilson, Happenstance Type-O-Rama

Proofreaders: Nancy Riddiough, Monique Van Den Berg, and Emily Hsuan

Indexer: Ann Rogers

Book Designer: Maureen Forys, Happenstance Type-O-Rama

Cover Designer: Archer Design

Cover Illustrator/Photographer: Archer Design

Copyright 2003 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 permission of the publisher.

Library of Congress Card Number: 2002115476

ISBN: 0-7821-4189-7

JumpStart is a trademark of SYBEX Inc.

SYBEX and the SYBEX logo are either registered trademarks or trademarks of SYBEX Inc. in the United States and/or other countries.

Screen reproductions produced with FullShot 99. FullShot 99 1991-1999 Inbit Incorporated. All rights reserved. FullShot is a trademark of Inbit Incorporated.

Internet screen shot(s) using Microsoft Internet Explorer 6 reprinted by permission from Microsoft Corporation.

SYBEX is an independent entity from Oracle Corporation and is not affiliated with Oracle Corporation in any manner. This publication may be used in assisting students to prepare for an Oracle Certified Professional exam. Neither Oracle Corporation nor SYBEX warrants that use of this publication will ensure passing the relevant exam. Oracle is either a registered trademark or a trademark of Oracle Corporation in the United States and/or other countries.

TRADEMARKS: SYBEX has attempted throughout this book to distinguish proprietary trademarks from descriptive terms by following the capitalization style used by the manufacturer.

The author and publisher have made their best efforts to prepare this book, and the content is based upon final release software whenever possible. Portions of the manuscript may be based upon pre-release versions supplied by software manufacturer(s). The author and the publisher make no representation or warranties of any kind with regard to the completeness or accuracy of the contents herein and accept no liability of any kind including but not limited to performance, merchantability, fitness for any particular purpose, or any losses or damages of any kind caused or alleged to be caused directly or indirectly from this book.

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

For MCL and the kids.


I couldn’t have written this book without the help of many talented and creative people.

I would like to thank Neil Edde, associate publisher, and Elizabeth Hurley, acquisitions editor, for recognizing the need for an introductory Oracle DBA text. Many thanks to developmental editor Heather O’Connor for telling me in the nicest possible way when I was way out in left field, and production editor Leslie Light and copyeditor Marilyn Smith for their valuable advice. Thanks also to technical editor Betty MacEwen for her attention to detail and helpful suggestions throughout the book.

The nature of this book required a great deal of artwork. Jeffery Wilson and the rest of Happenstance Type-O-Rama did an excellent job of creating artwork that was appropriate for the book. They say a picture is worth a thousand words, and their art is an essential part of this book. Somehow they were able to decipher my Microsoft Word cave drawings and turn them into real graphics.

Many of my professional colleagues at both Lands’ End and Greenbrier & Russel were a source of both inspiration and guidance. Also, regards to my long lost friend from fourth grade, Janice, who I’m sure is a DBA out there somewhere.

Finally, I want to thank my family for all of their support and patience. I was still able to give the kids a bath and read books at bedtime, even with the tough deadlines. The journey wouldn’t have been half the fun without them.