Data Modeling Training Course Highlights
- Strong knowledge of Data Modeling concepts
- Hands-on experience use logical data modeling and physical database design
- Working with data model components including attributes, entities and relationships
- Gain knowledge about Data integrity through normalization
- Real time experience to handling the complex relationships involves Many-to-many, recursive, subtypes and supertypes
- Documenting the data model with validation
Course Features
- Duration60 hours
- Skill levelAll level
- Batch Strength15
- AssessmentsYes
- Mock InterviewsYes
- Resume BuildingYes
- PlacementsYes
- Flexible TimingYes
- Fee InstallmentsYes
- LanguageTamil/English
Section 1: Introduction to Logical Data Modeling
- Importance of logical data modeling in requirements
- When to use logical data models
- Relationship between logical and physical data model
- Elements of a logical data modelRead a high-level data model
- Read a high-level data model
- Data model prerequisites
- Data model sources of information
- Developing a logical data model
Section 2: Project Context and Drivers
- Importance of well-defined solution scope
- Functional decomposition
- Context-level data flow diagram
- Sources of requirements
- Data interpretation Mechanism
- Class diagrams
- Other documentation
- Transactional business systems
- Business intelligence and data warehousing systems
- Integration and consolidation of existing systems
- Maintenance of existing systems
- Enterprise analysis
- Commercial off-the-shelf application
Section 3: Conceptual Data Modeling
- Discovering entities
- Defining entities
- Documenting an entity
- Identifying attributes
- Distinguishing between entities and attributes
Section 4: Conceptual Data Modeling-Identifying Relationships and Business Rules
- Model fundamental relationships
- Cardinality of relationships
- One-to-one
- One-to-many
- Many-to-many
- Is the relationship mandatory or optional?
- Naming the relationships
Section 5: Identifying Attributes
- Discover attributes for the subject area
- Assign attributes to the appropriate entity
- Name attributes using established naming conventions
- Documenting attributes
Section 6: Advanced Relationships
- Modeling many-to-many relationships
- Model multiple relationships between the same two entities
- Model self-referencing relationships
- Model ternary relationships
- Identify redundant relationships
Section 7: Completing the Logical Data Model
- Use supertypes and subtypes to manage complexity
- Use supertypes and subtypes to represent rules and constraints
Section 8: Data Integrity Through Normalization
- Normalize a logical data model
- First normal form
- Second normal form
- Third normal form
- Reasons for denormalization
- Transactional vs. business intelligence applications
Section 9: Verification and Validation
- Verify the technical accuracy of a logical data model
- Verify the logical data model using other models
- Data flow diagram
You will be going through detailed 2 to 3 months of Data Modeling Hands-on training
- Detailed instructor led sessions to help you become a proficient Expert in Data Modeling.
- Build a Data Modeling professional portfolio by working on hands on assignments and projects.
- Personalised mentorship from professionals working in leading companies.
- Lifetime access to downloadable Data Modeling course materials, interview questions and project resources.
Credo Systemz - Velachery, Chennai
Call Us +91 9884412301
