Principles of Data Design, Modeling and Management

PT4389
Training Summary
This course introduces the student to the principles and process of data modeling through the modeling cycle from modeling business object, through logical modeling and into the specific features of relational data modeling. The course presents topics such as the techniques of logical and business data modeling, how to incorporate business requirements into a logical data model, how to diagram the data models using ER diagrams and UML, how to normalize data and handle complex relationships within a relational model and some considerations for transforming the logical design into a physical design.
Prerequisites
Students must have a general understanding of information technology and database concepts.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for Business Analysts, Application Developers/Analysts, Business Analysts, Project Leaders and Data/Database Administrators.
Course Topics
  • Introduction to logical data modeling
  • Business requirements
  • Entities
  • Relationships
  • Attributes and normalization
  • Resolving many-to-many relationships
  • Subtypes and supertypes
  • Recursive relationships
  • Appendix implementing a relational database
  • Putting it all together

Related Scheduled Courses