Data Modeling course helps to convert the business requirements to the Data Model which includes the life cycle of data modeling.

Topics Covered

Data Modeling Course Outline Database design and data modeling overview Database design Data modeling and methodologies Conceptual, logical, and physical modeling Logical Modeling Building blocks, components, standards Entities, attributes Unique identifiers and access concepts Keys – Primary, Foreign, Alternate, Surrogate Relationships Cardinality Normalizing the model Object documentation Model notation, definitions and descriptions Extended data typing Metadata creation Standards Audit and Validation Syntactical validation Conceptual validation Practical approach to model auditing Model Presentation Enterprise Security Model Subject Areas – business dimensions within a model Stored Displays - organizing views in a model Model Object Reporting Report Template Builder deliverables Model printing Advanced Data Modeling Understand complex relations Modeling for history Referential integrity Resolve many to many relationships Build entity type hierarchies Build recursive relationships Independent attributes Physical Modeling Logical/Physical model implementation considerations Defining physical properties Referential integrity constraints Maintaining referential integrity Building and maintaining a database Business Views Physical model forward engineering Database reverse engineering Comparing a model to a database Modifying an existing database through the model Forward Engineering Templates DIMENSION MODELING Dimension Types of Dimensions Fact Types of Facts Schemas and Types of Schemas Identifying Dimensions and Facts for Modeling Implementation of Dimension Modeling

Who should attend

Database Developers and who are interested to be a DataModeler

Pre-requisites

SQL

What you need to bring

I will provide all the required knowledge, please get your notepad's to make key points.

Key Takeaways

Very good Knowledge on DataModeling and Handson exp on DataModeling with more than 3 case studies which includes realtime project requirement documents.