Oracle 9i for Dummies (For Dummies (Computers)) (Paperback)

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 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!

From the Back Cover
In Oracle9i For Dummies, author Carol McCullough takes the complexity out of the features available in Oracle9i and Enterprise Manager version 2.2 and makes them easy to understand. She'll cover the most important features of Oracle9i, including how to: Change a table's structure more easily and convert LONG datatype columns to LOB datatype quickly with the ALTER TABLE command; Configure and schedule backup and recovery more easily through new features of the Recovery Manager tool; Fix mistakes with self-service error recovery (supported through a new feature of SQL itself); Use Flashback query, a tool to query past states of the database; Get the most out of the Virtual Private Database, a concept that was introduced in Oracle8i and is expanded upon with the introduction of Oracle Internet Directory - a web-based tool displaying files and directories. It includes a web-based Self-Service Administration Servlet with which users administer their own personalized data over the Web; Create XML documents quickly.

The audience for this book includes programmers, database administrators and systems analysts who are new to Oracle9i (no previous experience with databases is required), or are upgrading from a previous version.

See all Product Description

• Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
• Books > Computing & Internet > Databases > Oracle
• Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
• Books > Computing & Internet > Software & Graphics

• Would you like to update product info or give feedback on images?
• I am the Author, and I want to comment on my book.
• I am the Publisher, and I want to comment on this book.