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

Business Analysis Training


The ambience, food and camaraderie excellent. The arrangements made to compensate for my disability has been much appreciated. THANKS The place felt like home.
Comment from Shared Services

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