Dates Offered (click on the desired date to register):

This course is currently not scheduled for the near future.

Course Number:  DB1

Course Description:  This course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous ‘real-world’ problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented modeling principles are presented providing state-of-the-art modeling skills to attendees. This course may be presented using the modeling syntax of Oracle Designer or independent of any specific modeling tool.

Objectives:  - Work in a relational database environment confidently
- Develop a data model to describe an application's data
- Design a relational database using data modelling and normalisation
- Access data in a relational database using SQL (Structured Query Language)
- Transform the relational database system into an intelligent server
- Address the most important performance and quality issue first: database design

Benefits:  Relational databases often drive traditional company-critical applications as well as Web-enabled applications. The availability of robust, mature relational database management systems (RDBMSs) and the associated application development tools enable organisations of all sizes to manage data effectively, to deploy applications using that data, and to provide data warehousing capabilities.

This course provides a comprehensive foundation for designing, building and working with relational databases, enabling you to understand and use commercially available relational DBMS products effectively.

Target Audience:  This course is valuable for those involved in building and using relational databases and implementing database applications.

Prerequisites:  Computer lieterate

Course Length:  3 days

CourseTopics:

Data Modeling Principles
- What Is Data Modeling?
- Related Methodologies
- What You Can Do With A Data Model
- What Can Go Wrong Without A Data Model
- ERwin Model Notation
- SDesignor Model Notation
- Oracle Designer Model Notation
- Logical Database Design
Building A Data Model
- Building A Very Simple Model
- How To Start A Data Model
- Identifying Entities
- Identifying Attributes
- Identifying Relationships
- Certify the Model With Normalization
- Oracle Designer Notation
Transform Model To Logical Database
Semantic & Object Oriented Concepts
- Semantic Data Modeling
- OO Concepts
- Domains
- Flaws That Probably Exist In Your Entities!
- Flaws That May Exist In Your Attributes
- SuperTypes & SubTypes
- Generalization and Specialization
- Sample Specialization
- Subtype Constraints
- Arc
- Lattice
- Some Scary Stories!
What Is A Relational Database?
- Relational Database Terms
- Views
- Indexes
- Constraints
- Sequences
- Triggers
- A Logical Database Design
- Distributed Database & Data Partitioning
Classic Structures & PatternS
- Master-Detail (Generic)
- Master-Detail (Invoice specific)
- Bill-of-Materials (data model)
- Bill-of-Materials (relational schema)
- Organization Unit Hierarchy
Sample MODELS
- The Connection Trap (Solution)
- A Credit Card Company (Moderate)
- Refine Air Travel Model (Moderate)