|
Description
This is a high-level, practical overview of the concepts, notation,
and techniques of logical data modeling and relational database
design. The course also includes a discussion of scalability and
how to achieve scalability in design.
Audience
IT professionals interested in relational database development including
project managers, team or group leaders, analysts, designers, programmers,
and support personnel. This course may also be valuable for business
users participating in the design process.
Prerequisites
Familiarity with computing systems and programming concepts is strongly
recommended. Prior knowledge of the relational database model is
helpful.
Classroom Requirements
Overhead projector, whiteboard, flipcharts.
|
Format
- Presentation
- Written Exercises
Objectives
After completing this course, participants should be able to:
- Understand modeling techniques used
in relational database design
- Describe the differences between
conceptual, logical, and physical models and their place in the
phases of relational database design
- Describe logical data modeling techniques
- Create, interpret and apply entity-relationship
diagrams
- Describe relational database design
concepts
- Recognize the implications of scalability
for modeling during the design phase
|
