Home : Directions : Hotels : Contact Us : About : e-mail : Login
Data Modeling
     
     This course introduces the principles of relational databases and relational database design. Business requirements will be incorporated into a logical data model. The components of a logical data model are defined and represented as an entity relationship diagram and table diagrams. Table construction rules and data normalization rules will be discussed as well as supertypes, subtypes and recursive relationships.
Covered Topics:
  • Relational database terminology
  • What is a data model?
  • Benefits of data modeling
  • Gather and document business requirements
  • Data model input
  • Identifying entities, attributes and relationships
  • Handling complex relationships such as many-to-many, recursion, supertypes, subtypes and exclusive arcs
  • Determine entity unique identifiers (primary keys)
  • Implementing relationships with foreign keys
  • Domains and derived attributes
  • Producing an entity relationship diagram
  • Producing table diagrams
  • Normalizing to 5th normal form
  • Denormalization
  • What is a physical data model?
Prerequisites:
  • None
Audience:
     This course is designed for all database professionals and non-technical professionals including:

  • Developers
  • Database Administrators
  • Application Designers
  • Business Analysts
  • Others concerned with logical database design
Course Benefits:
     Students will understand the principles and tasks of relational data modeling and be able to communicate using relational database terminology. Students will also be able to translate business requirements into logical data models.
Materials Furnished:
  • Student Manual
  • Lecture and discussion followed by team-based workshops for each major topic to reinforce the material.
  • Each participant will receive an extensive lecture guide with several examples and workshop solutions.
Recommended Follow-On Course:
  • Oracle 9i Fundamentals
  • Oracle 9i PL/SQL Fundamentals
Course Length: Two Days
Public Course Price: $990.00
On-Site Price:
Please contact Euler Solutions for details
Home : Directions : Hotels : Contact Us : About : e-mail : Login
Copyright © 2008 Euler Solutions, Inc. Minneapolis, MN