Oracle8I for Dummies

by McCullough-Dieter, Carol

• ISBN13: 9780764505706
• ISBN10: 076450570X
• Edition: CD
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: John Wiley & Sons Inc

Summary

An essential tool for e-commerce, Oracle8i is the first relational database to integrate Java programs, Web sites, and Internet content. In Oracle8i For Dummies, author Carol McCullough-Dieter takes the complexity out of the program's new features and saves you time with expert tips, sample SQL code, and real-world advice. Whether you're upgrading or just starting out, this guide provides a clear and practical road map that will put Oracle8i to work for you. Book jacket.

Author Biography

A self-made Oracle expert with more than 15 years of experience, Carol McCullough-Dieter has developed and taught courses on database design. The author of several books on Oracle, she has built database systems -- both large and small -- for state government and private corporations.

Table of Contents

Foreword	xxiii
Introduction	1	(6)
Part I: Road Map	7	(114)
A Quick Tour of Oracle8i	9	(34)
Data Whaaaaat? A Database Primer	43	(22)
SQL Nuts and Bolts	65	(26)
Object SQL: The New Stuff	91	(16)
Using the Enterprise Manager DBA Tools	107	(14)
Part II: Getting Started	121	(46)
The Relational Model and You	123	(14)
Diagramming Your World	137	(10)
Getting Familiar with Oracle8i Data-Dictionary Views	147	(6)
Oracle's User	153	(14)
Part III: Putting Oracle8i to Work	167	(122)
Defining Tables, Tablespaces, and Columns	169	(16)
Creating Object Types, Objects, and References	185	(16)
Security Options: Roles, Profiles, and Grants	201	(20)
Views and Synonyms: Do You See What I See?	221	(20)
WebDB: The Best New Tool for the Internet	241	(18)
Java and the Internet Database	259	(10)
The Five Ws of Safeguarding Your Data	269	(20)
Part IV: Tuning Up and Turbocharging	289	(54)
What's Slowing Your Query Down?	291	(10)
Speeding Up Queries with Keys and Indexes	301	(24)
Correcting Flaws	325	(18)
Part V: The Part of Tens	343	(22)
Ten Tips for Good Design	345	(14)
Ten Handy Oracle8i Features	359	(6)
Part VI: Appendixes	365	(18)
Appendix A: Glossary	367	(8)
Appendix B: About the CD	375	(8)
Index	383	(19)
IDG Books Worldwide End-User License Agreement	402	(2)
Installation Instructions	404
Book Registration Information
Back of Book