This revised edition introduces you to Oracle9i, which offers many improved features for managing and monitoring databases, and also covers the companion tool Oracle Enterprise Manager (OEM version 2.x). In Oracle9i For Dummies , author Carol McCullough-Dieter takes the complexity out of the feature
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. T his friendly guide leads you through a complete tour of Oracle9i, hitting the highlights the object relational world and these important product components: Enterprise Manager Console Major DBA tools SQL Plus XML Developer's Kit Dataspeak Java applets If 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 SQL Befriending Schema Manager elements Making the most of Oracle9i's built-in functions Traveling back in time with Flashback Queries Connecting relational tables with objects Creating a role and assigning object privileges Knowing why, what, when, and how to back up your data -- and where to store it The 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!
Carol McCullough-Dieter, a veteran database designer and trainer, is the author of many books on Oracle products, including Oracle8I For Dummies and Oracle8 Bible.
Table of Contents
Foreword. Introduction. Part I: Road Map. Chapter 1: A Quick Tour of Oracle9i. Chapter 2: Data Whaaat? A Database Primer. Chapter 3: SQL Nuts and Bolts. Chapter 4: Object SQL: The New Stuff. Chapter 5: Using Enterprise Manager's DBA Tools. Part II: Getting Started. Chapter 6: The Relational Model and You. Chapter 7: Getting Familiar with Data-Dictionary Views. Chapter 8: Oracle's User. Part III: Putting Oracle9i to Work. Chapter 9: Defining Tables, Tablespaces, and Columns. Chapter 10: Creating Object Types, Objects, and References. Chapter 11: Security Options: Roles and Grants. Chapter 12: Views and Synonyms: Do You See What I See? Chapter 13: Java and the Internet Database. Chapter 14: XML and Enterprise Java Beans. Chapter 15: The Five Ws of Safeguarding Your Data. Chapter 16: Special Tasks with Enterprise Manager. Part IV: Tuning Up and Turbocharging. Chapter 17: What's Slowing Down Your Query? Chapter 18: Improving Performance with Indexes and Memory Buffers. Chapter 19: Correcting Flaws. Part V: The Part of Tens. Chapter 20: Ten Tips for Good Design. Chapter 21: Ten Handy Oracle9i Internet Features. Glossary. Index. Book Registration Information.
Oracle 9i for Dummies by Carol McCullough-Dieter
Used - Very Good
John Wiley & Sons Inc
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us.