Teach Yourself Oracle 8 Database Development in 21 Days

This complete guide takes an easy-to-understand approach to developing complete databases in the Oracle environment. With step-by-step instructions, real-world examples, and professional advice, you'll discover how to create objects to support, modify, retrieve, and manage data within the Oracle system. You will gain experience by creating an Oracle Forms application. You also will gain a working knowledge of Oracle objects, build a solid understanding of SQL and PL/SQL, and learn how to design a relational database for Oracle.

Contents

Introduction

Week 1 At A Glance

• Day 1 Exploring the World of Relational Databases
• 2 Guidelines for Developing an Oracle Application
• 3 Logical Database Design
• 4 Implementing Your Logical Model. Physical Database Design
• 5 Introduction to Structured Query Language (SQL)
• 6 Using SQL to Modify Data
• 7 Taking Advantage of SQL Built-In Functions
• Week 1 In Review

• Day 8 More Sophisticated Queries with SQL
• 9 Programming an Oracle Database with PL/SQL
• 10 Program Development with PL/SQL
• 11 More Programming Techniques with PL/SQL
• 12 Developer/2000: Introduction to Oracle Forms
• 13 Developer/2000: Developing a User Interface with Oracle Forms
• 14 Developer/2000: Application Development with Oracle Forms
• Week 2 In Review

• Day 15 Developer/2000: Developing Reports with Oracle Reports
• 16 Developer/2000: Using Oracle Graphics and Procedure Builder
• 17 Introduction to Oracle Power Objects
• 18 Developing an Application with Oracle Power Objects
• 19 An Overview of Oracle Database Security and Tuning
• 20 Using Oracle Database Designer and Oracle Designer/2000 in Application Development
• 21 Oracle: The Next Generation
• Week 3 In Review

• Bonus Day 22 Using PowerBuilder with an Oracle Database
• Bonus Day 23 Oracle8: New Features
• Appendix
• Answers to Quizzes and Exercises
• Index