Oracle's Developer/2000 Version 2.1 is an outstanding tool for Web and client/server development - but Oracle ships it with practically no hard copy documentation! To make the most of this supercharged development environment, get Oracle Developer/2000 Handbook, Second Edition. This comprehensive tutorial and reference delivers step-by-step instructions for every Developer/2000 component - including forms, reports, graphics, data modeling and design tools. You'll learn the best ways to use each tool, and discover practical solutions for the key challenges of Web and client/server development.

Coverage includes:

Oracle's Web architecture, including back-end databases and middle-tier Web servers.
Tuning applications for optimal performance.
Building GUIs that maximize productivity.
Practical SQL and PL/SQL coding techniques.
Pitfalls and traps - and how to avoid them.

If you want great results with your next Oracle Developer/2000 application, one book brings together all the real-world techniques and insight you need: Oracle Developer/2000 Handbook, Second Edition.

CD-ROM INCLUDED!

The accompanying CD-ROM contains extensive Oracle Developer/2000 sample code, plus a CBT Systems Developer/2000 Training Module worth $225!



Sample Content

Downloadable Sample Chapter

Click here for a sample chapter for this book: 0139181113.pdf

I. OVERVIEW AND ARCHITECTURE.

1. Introduction.

Audience. Coverage. Platform. Typographical Conventions. Versions Covered and Version Numbering. Oracle Product Suites. Operational Definitions. How to Use This Book.

2. The Back-End: The Oracle Database and Its Role.

The Database Engine Concept. Communicating with the Database. SQL. Physical Organization: Files and Tablespaces. Logical Organization: Tables, Views and Synonyms. Indexes. Security. Users and Ownership. Transaction Processing. The SQL Optimizer(s). Execution Plans. PL/SQL. Constraints. Database Triggers. Stored Procedures.

3. The Middle Tier: The Web Server and Its Role.

The Web Server. The Oracle Web Application Server. Virtual Paths. Web Architectures and Network Traffic. Web Browsers and the Internet.

4. Forms.

The Form Builder. Objects and Object Types. Using Variables. Creating and Using Menus. Creating and Using Libraries. Running a Form. Query Mode. Running Forms on the Web.

5. Reports.

Data Model. Layout. The Parameter Form. PL/SQL in Oracle Reports. Running Reports on the Web.

6. Graphics.

Display. Embedding Graphics. Graphics on the Web.

7. Other Developer/2000 Tools.

Oracle Terminal. Procedure Builder. SQL*Plus. Project Builder. Translation Builder. Query Builder. Schema Builder.

II. DESIGN PRINCIPLES.

8. Data Modeling.

Principles of Normalization. Principles of Denormalization. Conclusion.

9. GUI Design Principles.

Know the End Users. Consistency. When to Use Widgets. The Mouse and the Keyboard. Fonts and Text. Color.

10. Coding with SQL and PL/SQL.

SQL. PL/SQL.

III. BUILDING APPLICATIONS.

11. Forms Walk Through.
12. Reports Walk Through.
13. Graphics Walk Through.

Drill Down.

14. Tips and Techniques.

Using Filenames. Validating Items in Conjunction with Other Items. Calling the Windows Help System. Web Integrations. Web Performance. Web Restrictions.

15. Projects in Oracle.

A System Development Life Cycle. People. Help and Information.

16. Developer/2000 Competitors.

ODBC. Microsoft Access. PowerBuilder (Sybase, Inc.). Visual Basic. Oracle Objects for OLE.

Appendix A: Oracle Forms Object Properties.
Appendix B: Oracle Forms Built-Ins.
Appendix C: Oracle Reports Built-Ins.
Appendix D: Oracle Graphics Built-Ins.
Appendix E: Common Developer/2000 Built-Ins.
Appendix F: Oracle Forms System Variables.
Appendix G: Microsoft Windows-Specific Issues.

Glossary.

Index.



Updates

Submit Errata



More Information



InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Email Address

Oracle Developer/2000 Handbook, 2nd Edition

Book

About

Features

Description