back to Course Categories | back | print
Oracle9iR2 Object-Relational Design Concepts          

Duration: 3 days

Description 
This class will introduce object-relational design concepts using Oracle9iR2. Students will be introduced to relational and object-oriented design concepts, graphical notation and techniques. Topics include classes, objects, attributes, methods, encapsulation, abstraction, inheritance, polymorphism, interfaces, association, composite aggregation, ternary associations and design patterns. Oracle's object-relational extensions of user defined types, LOBS, REFs and collections will be covered. An emphasis is placed on explaining the design and software engineering benefits of object technology. A comparison of data and object models is also provided. An introduction to Oracle9i data warehousing and OLAP features will be included.

Topics

  • Oracle9i the Object-Relational OLAP database
  • relational database concepts
  • E/R diagramming fundamentals
  • the benefits of object technology
  • why object technology now
  • relational and object oriented concepts
  • classes, objects, attributes, methods, encapsulation, abstraction, inheritance, polymorphism
  • composite aggregation, ternary associations and design patterns
  • Oracle graphical notation of data models
  • the basics of UML graphical notation
  • a comparision of E/R and class diagrams
  • the JServer architecture in Oracle9i
  • user defined types, nested tables, varrays, refs, lobs and the new SQL and PL/SQL operators
  • UML diagrams

Prerequisites

  • A background in data processing and programming is required. Experience with Oracle or other RDBMS's is also required.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design