SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Business Analysis Training

It was excellent! A great instructor, knew the material and provided great feedback.
Comment from ESDC

1. Title

  • Focus on Business Analysis: Professional Data Modeling (SBDMD, 2 days)
    View PDF

2. Course Pre-requisites

  • Previous Experience in a Database role

3. Target Audience

  • IT Professionals who want to learn how to create professional data models for relational databases

4. Dates and Pricing

2 People for Guaranteed Live or Virtual Delivery $1,150.00 per person

5. Outline

Module 1: Object Oriented Analysis and Design

Topic 1: Understanding the Role of the Business Use Case

Topic 2: Performing Object Identification

Topic 3: Eliminating Objects: Identifying Antonyms and Antonyms

Topic 4: Creating a Candidate List with Definitions

Topic 5: Identifying Primary Object Associations

Topic 6: Drafting a Domain Model

Module 2: Exploring Relational Data

Topic 1: The Relationship between an Object and an Entity

Topic 2: The Relationship between a Property and a Field

Topic 3: When a Property becomes a Table

Topic 4: When an association becomes a Table

Topic 5: The Importance of Normal Form

Topic 6: What 1st Normal Form Provides

Topic 7: What 2nd Normal Form Provides

Topic 8: What 3rd Normal Form Provides

Topic 9: What Boyce-Codd Normal Form Provides

Topic 10: The Cost of Failing to Normalize

Topic 11: The Benefits of Denormalization

Module 3: Exploring Relational Database Constructs

Topic 1: About Tables, Fields, Keys and Indexes

Topic 2: Ensuring Entity Integrity with Primary Keys

Topic 3: Ensuring Referential Integrity with Foreign Keys

Topic 4: Ensuring Domain Integrity with Constraints

Topic 5: Exploring the Role of Indexes

Module 4: Moving from Analysis to Design

Topic 1: The Basics of ER Diagrams

Topic 2: Moving from an Object to an Entity

Topic 3: Adding Entity Relationships

Topic 4: Adding Entity Attributes

Topic 5: Adding Relationship Attributes

Topic 6: Specifying Data Types

Topic 7: Finalizing the Mode with Quality Checks

Topic 8: Generating the Model for a Specific RDBMS

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette