Course 118:
Data Modeling for Business Analysts

(2 days)

 

Course Description

Data Modeling is a classic method of designing systems that has been in use since the 1970s. The Data Model describes the static structural view of the system under development. The principles of data modeling have been carried forward into class and object modeling in the object-oriented world. Business analysts use data modeling to understand the interconnections of data in the applications and solutions they propose. While business analysts may not actually create data models, a job relegated to the data analysts or DBAs, the business analyst needs to be able to read and understand the basic data modeling diagrams to confirm and validate. This course introduces the concepts of data modeling that can be applied to any system under development regardless of the database system or development methodology.

Learning Objectives

At the end of this course, participants will be able to:

  • Apply the concepts of data: entities and relationships
  • Use data modeling to analyze the business problem to produce a data-based solution and analyze solutions for validity and feasibility
  • Relate the checks and balances of the data modeling metaphor to the problem solving process
  • Use basic Structured Query Language (SQL) and relational database operations

Who Should Attend

Business analysts, requirements analysts, project managers, designers, architects, and anyone involved with turning a business problem into an IT solution.

Prerequisites

Knowledge of basic computers and data storage.


Course Outline

Unit 1: The Concept of the Database

  • A Database System
  • Types of Database Systems
    • Hierarchical
    • Network (Codasyl)
    • Relational
    • Object-Oriented
  • Basic Data Design Approaches
    • OLTP
    • OLAP
  • The Corporate Data Model

Unit 2: Entity-Relationship Modeling

  • Data Modeling Using E-R Diagrams
    • Entities
    • Attributes
    • Relationships
    • Many:Many Relationships
    • Entity Subtypes
    • Participation
    • Recursive Relationships
    • Exclusivity

Unit 3: Creating and Applying the Data Model

  • Find the Noun Technique
  • Analytical Processes
  • Structure and Approach
  • Data Modeling in the Design
  • Data Models in Agile Approaches

Unit 4: Application of Design Principles

  • Dealing with Data Anomalies
  • Functional Dependency and Normalization
    • Functional Dependencies
    • Using Functional Dependencies
  • Functional Dependency and Normalization
    • First Normal Form
    • Second Normal Form
    • Third Normal Form
    • Other Forms
    • When and Where to Use Normalization
    • Denormalization

Unit 5: Relational Operations and SQL

  • The Fundamental Relational Operations
  • SQL Components
  • SQL Data Definition Commands
  • SQL Relational Queries
  • Advanced Concepts
  • Limitations of SQL

Unit 6: Analyze with the Data Model

  • Capturing Data at the User Interface
  • Information Architecture
  • Multiple Sources of Data
  • How the Data Model Fits in the Solution

Unit 7: The Bottom Line

  • Data Modeling in Retrospect
  • Where to Go to Find More Information
  • Course Summary

Please Contact Your ROI Representative to Discuss Course Tailoring!