Data Modeling Online Training

Data Modeling Online Training

Data Modeling Online Training
Data Modeling Online Training

Data Modeling Online Training Course Content :

Introduction to Logical Data Modeling

  • Definitions
  • Benefits of logical data modeling
  • Data modeling vs. physical database design
  • Roles involved in data modeling
  • Steps in the data modeling process
  • Example data model

Entities

  • Identifying entities
  • Validating entities
  • Documenting “instances” of entities
  • Distinguishing entities from attributes
  • Naming entities
  • Starting an Entity/ Relationship (E/R) diagram
  • Workshop

Relationships

  • Identifying significant relationships
  • Determining the “cardinality” or “degree” of a relationship
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • Determining whether a relationship is optional or mandatory
  • Giving a relationship a name
  • Documenting the relationships in the E/R diagram
  • Walking people through an E/R diagram
  • Workshop
  • Resolving Many-to-Many Relationships
  • Real-world examples of many-to-many relationships
  • Why many-to-many relationships are broken down into simpler relationships
  • Identifying “association” or “intersection” entities
  • Documenting the new relationships in the E/R diagram
  • Workshop

Attributes and Normalization

  • Defining and categorizing attributes
  • Domains and integrity rules
  • Unique identifiers/ primary keys
  • Foreign keys
  • Occurrence population
  • Normalization: validating the placement of each attribute
  • Attribute does not repeat (first normal form)
  • Attribute is dependent on its entire UID (second normal form)
  • Attribute is dependent only on its UID (third normal form)
  • Workshop

Subtypes and Supertypes

  • Identifying subtypes: real-world examples of subtypes and supertypes
  • Determining when entities are similar
  • UIDs
  • Attributes
  • One-to-one relationships
  • Creating subtypes and supertypes
  • “Type” entities
  • Using subtypes to apply fourth normal form
  • Establishing the relationships of the sub- and super-entities to other entities
  • Mutually exclusive vs. non-mutually exclusive subtypes
  • “Role” entities to handle complex subtypes
  • Workshop

Recursive Relationships

  • Real-world examples of recursive relationships
  • Discovering recursive relationships
  • Determining whether the relationships are optional or mandatory
  • Documenting the new relationships in the E/R diagram
  • Hierarchical vs. Network recursive relationships
  • “Structure” or “Bill of Materials” entities: fifth normal form
  • Workshop

Appendix: Implementing a Relational Database

  • Relational database objects: tables, views, indexes, etc.
  • Mapping logical objects to physical objects
  • De-normalization
  • Why
  • How
  • Pros/Cons
  • Distributing databases
  • Referential integrity

Drop your query

What my Client's Say?

 

  • Prabhu is an excellent instructor, very patient and thorough. I have tried another training class and EXPLORE IT far exceeds other trainers and their methods ~ Hassan Malik

  • An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn from.~ Bhavani Sudarshnam

  • The training was clear and detailed. I like Parker's style of teaching as the recurrent training is a thorough review of the HR. Every opportunity for the student to ask questions was provided. ~ Yiting Chen

  • Jane Anderson conducted the class in a very professional manner. Examples were very relevant and I feel that I gained a lot from the updated materials this year.~ Somesh Taneja

  • Prem was a great instructor. Thanks Prem for making the training easy to understand. A lot of information was covered. He made the approach easy to follow.~ Komali Sambakula

  • She wants to make sure that her students walk away from her course with a good working knowledge. She is an excellent trainer and cares that all of her students learn the material.~ Kiran Jain

  • Krishna is very thorough and professional. He made the code very understandable. I was very impressed with his teaching methods and presentation of the regulations. EXPLORE IT is the best! ~ Rajesh Isukapalli

  • Mr. Chris Brown was very affirmative with the course, on time and fluent. This is my second recourse with him. I hope to take his course as long as I am shipping at my current job. ~ Awais Rahim