did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780764508806

Oracle9iTM For Dummies®

by ;
  • ISBN13:

    9780764508806

  • ISBN10:

    0764508806

  • Format: Paperback
  • Copyright: 2002-01-01
  • Publisher: For Dummies
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $34.99 Save up to $1.05
  • Buy New
    $33.94

    PRINT ON DEMAND: 2-4 WEEKS. THIS ITEM CANNOT BE CANCELLED OR RETURNED.

Supplemental Materials

What is included with this book?

Summary

If you have Oracle9i, you have the database to beat all databases. Besides being among the cream of the crop when it comes to relational database packages, Oracle9i is one of the more complex. Oracle9i does some amazingly fancy things, but the easy things are sometimes tricky.Oracle9i For Dummies covers the tough stuff in a straightforward and conversational manner, touching on key points and new features. This friendly guide leads you through a complete tour of Oracle9i, hitting the highlights the object relational world and these important product components:- Enterprise Manager ConsoleMajor DBA toolsSQL *PlusXML Developer's KitDataspeakJava appletsIf you're new to relationship databases, you're bound to appreciate the many examples of simple database designs in Oracle9i For Dummies. As you consider each example, you begin to get a feel for how relational databases are used to model real-world situations. The down-to-earth coverage includes- Getting to know the meat and potatoes of SQLBefriending Schema Manager elementsMaking the most of Oracle9i's built-in functionsTraveling back in time with Flashback QueriesConnecting relational tables with objectsCreating a role and assigning object privilegesKnowing why, what, when, and how to back up your data - and where to store itThe majority of the subject matter in this friendly - and believe it or not, fun - book applies to PCs, Macs, and mainframes and to all platforms from Windows to MacOS to UNIX. (Oracle9i's primary tools, Enterprise Manager and Console, have caught the Java wave and use the same mouse-driven screens no matter what operating system you're using.) With Oracle9i For Dummies, you won't be able to use the "no experience" excuse when you face the task of building, using, or administering an Oracle database. This is the guide that packs in all you need to put Oracle9i to work - starting today!

Author Biography

<b>Carol McCullough-Dieter</b>, a veteran database designer and trainer, is the author of many books on Oracle products, including <I>Oracle8I For Dummies</I> and <I>Oracle8 Bible</I>.

Table of Contents

Foreword xxiii
Introduction 1(6)
Part I: Road Map 7(104)
A Quick Tour of Oracle9i
9(20)
Data Whaaat? A Database Primer
29(20)
SQL Nuts and Bolts
49(30)
Object SQL: The New Stuff
79(16)
Using Enterprise Manager's DBA Tools
95(16)
Part II: Getting Started 111(32)
The Relational Model and You
113(14)
Getting Familiar with Data-Dictionary Views
127(6)
Oracle's User
133(10)
Part III: Putting Oracle9i to Work 143(138)
Defining Tables, Tablespace, and Columns
145(26)
Creating Object Types, Objects, and References
171(22)
Security Options: Roles and Grants
193(14)
Views and Synonyms: Do You See What I See?
207(20)
Java and the Internet Database
227(6)
XML and Enterprise Java Beans
233(8)
The Five Ws of Safeguarding Your Data
241(20)
Special Tasks with Enterprise Manager
261(20)
Part IV: Tuning Up and Turbocharging 281(64)
What's Slowing Down Your Query?
283(18)
Improving Performance with Indexes and Memory Buffers
301(16)
Correcting Flaws
317(28)
Part V: The Part of Tens 345(24)
Ten Tips for Good Design
347(14)
Ten Handy Oracle9i Internet Features
361(8)
Glossary 369(8)
Index 377

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program