Oracle8i For Dummies

by McCullough-Dieter, Carol; Dana, Ned

• ISBN13: 9780764507984
• ISBN10: 0764507982
• Edition: 2nd
• Format: Paperback
• Copyright: 2000-12-15
• Publisher: For Dummies

Summary

In Oracle8i For Dummies, Second Edition, author Carol McCullough takes the complexity out of the features available in Oracle8i Release 2 and Enterprise Manager version 2.1.4 and makes them easy to understand. She'll uncover all you need to know about features like built-in support for XML and Enterprise Java Beans, new security options for Internet applications, and new performance and tuning tools included with Enterprise Manager. With her easy-to-follow examples, you'll quickly become familiar with the database and tools and be ready to put them to work.

Author Biography

<b>Carol McCullough-Dieter</b> develops Oracle training courses and large Oracle systems. Her many books include <I>Oracle8 Developer's Guide</I> and <I>Oracle8 Bible</I>.

Table of Contents

Foreword	xxi
Introduction	1	(6)
Part I: Road Map	7	(116)
A Quick Tour of Oracle8i	9	(36)
Data Whaaaat? A Database Primer	45	(18)
SQL Nuts and Bolts	63	(26)
Object SQL: The New Stuff	89	(16)
Using the Enterprise Manager DBA Tools	105	(18)
Part II: Getting Started	123	(46)
The Relational Model and You	125	(14)
Diagramming Your World	139	(10)
Getting Familiar with Oracle8i Data-Dictionary Views	149	(6)
Oracle's User	155	(14)
Part III: Putting Oracle8i to Work	169	(136)
Defining Tables, Tablespaces, and Columns	171	(18)
Creating Object Types, Objects, and References	189	(20)
Security Options: Roles and Grants	209	(16)
Views and Synonyms: Do You See What I See?	225	(22)
Oracle Portal: The Best New Tool for the Internet	247	(18)
Java and the Internet Database	265	(12)
XML and Enterprise Java Beans	277	(8)
The Five Ws of Safeguarding Your Data	285	(20)
Part IV: Turning Up and Turbocharging	305	(64)
What's Slowing Down Your Query?	307	(10)
Speeding Up Queries with Keys and Indexes	317	(28)
Correcting Flaws	345	(24)
Part V: The Part of Tens	369	(24)
Ten Tips for Good Design	371	(14)
Ten Handy Oracle8i Internet Features	385	(8)
Part VI: Appendix	393	(8)
Appendix: Glossary	395	(6)
Index	401