Overview
Oracle8i From Scratch teaches you the key concepts and techniques associated with designing and building a relational database using Oracle8i. You will build a web-enabled "Auto Sales Tracking" application using the Oracle8i relational database, Oracle Developer v6.0, Oracle Jdevoper v3.0, and Oracle Web Server v3.0. Oracle8i Database Development From Scratch also covers the basic administrative and tuning tasks necessary to insure a smooth running application.Editorials
From Barnes & Noble
Our ReviewThe best way to master Oracle 8i is to build an application from scratch. In Oracle 8i from Scratch, you'll not only build a complete sales tracking application, you'll also web-enable it.
Dan Hotka assumes no prior Oracle, Windows, or web development background. In fewer than 400 pages, he presents enough of the relevant basics to get you from start to finish and give you a solid grounding for your own real-world projects.
You'll start by building the application's database objects, loading data, creating basic forms, and generating character-mode reports with SQL*Plus. Next, Hotka walks you through the rudiments of administering, monitoring, tuning, and backing up your database. There's a full chapter on indexing and partitioning databases for enhanced performance.
Then you're ready for the Web. Hotka introduces the Oracle Web environment and compares three different strategies for database-enabling web sites. You'll first build your site with PL/SQL, then with Java, and finally, take a long look at Oracle's WebDB forms development tool. The book's appendices include an 85-page primer on SQL and PL/SQL. Whether you're a power user, web developer, or Oracle professional upgrading from an older version, this book will well reward the time you invest in it.