Also available in eLearning at firstplacelearning.com.
At this seminar you will learn the secrets of successful
logical and physical data modeling. You will gain valuable insights into
the job and responsibilities of the data modeler as well as the responsibilities
of other project contributors. This seminar helps to bridge the gap between
data modelers and database administrators (DBAs).
This seminar includes an effective mix of exercises and
presentations. Each step of the way the student learns through doing. Three
levels of data modeling are included: conceptual, logical, and physical.
The focus is on logical and physical data modeling. Students will learn
about data element analysis, standardization, naming, and normalization.
They will learn how to create a single model that supports multiple user
views. In addition, they will learn how to select and use modeling tools.
Conceptual Data Modeling also known as Entity/Relationship
(E-R) Modeling is a key method for getting a handle on the data requirements
of an organization. Effective E-R modeling results in maximum benefits
from information assets by increasing shared use and avoiding redundancy.
Data that is relevant, timely, consistent, and accessible has increased
value to the organization.
There are proven approaches, methodologies, templates,
and checklists which you will learn about that can dramatically increase
the data modeling success rate. You will learn through many effective hands
on workshops and case studies. Our trainers know how to create effective
data models and transition those models into effective database designs.
- HOW TO use data modeling to meet business and performance
- HOW TO apply data modeling to client/server projects and
data warehouse projects
- HOW TO develop logical and physical data models
- HOW TO manage and coordinate large data models
- HOW TO lead your team through the data modeling process
- HOW TO effectively translate data models into into databases
- HOW TO avoid data modeling traps, problems, and time wasters
- HOW TO improve database performance through data modeling
- HOW TO make databases easier to use through data modeling
- HOW TO select data modeling software
- HOW TO effectively communicate data models and database designs
You will receive a comprehensive manual and data modeling
toolkit that provides useful checklists, examples and reference material
that will help you in your data modeling efforts. The usefulness of the course
continues long after the class sessions.
You will receive a Certificate of Completion upon
successful completion of the course.
Data Modeling Team Members
Information Technology Managers
I. Data Modeling Concepts
II. Conceptual Data Modeling Review
- What is Data Modeling?
- Where does Data Modeling fit into Information Technology Management?
- Information Architecture
- Benefits and Objectives of Data Modeling
- Three Schema Architecture
III. Defining The Data
- Preparing for Logical and Physical Modeling
- Supertypes and Subtypes
- Derived Data
IV. Normalizing The Data
- Discovering and Identifying Entities
- Naming Data Elements
- Standardizing Data Elements
- Re-using and Sharing Data Elements
- Business Definitions
- Using The Data Dictionary
- Normalizing Data
- Handling Derived Data
- Identifying Keys
- Relating the Entities
- Reviewing and Validating the Model
- Data Warehousing vs Transaction Processing Requirements
V. Physical Data Modeling and Database Administration Tools
VI. Developing the First Cut Physical Design
- Physical Data Modeling Tools
- DBA Tools
- Data Re-engineering Tools
- Evaluating Tools
- Managing Tools and Metadata
Normalization and De-Normalization
Defining Primary and Foreign Keys
VII. Tuning the Physical Design
- Physical Data Modeling Steps
VIII. Database Advanced Considerations
- Improving Ease of Use
- Ad Hoc Queries
- Transaction Modeling
- Relational Views
- Stored Procedures
- Distribution of Data
- Client/Server Considerations
- Two Tier and Three Tier Architectures
- Replication of Data
- Design Tradeoffs
- Standards and Controls