Loading Course Schedule...
PT10428
Summary
This course provides participants with the skills necessary to design models for efficient and effective databases. Students learn to create Conceptual, Logical, Dimensional and Physical Models after gathering and defining the data requirements of an organization. Data element analysis, standardization, identifying candidate keys and recommended practices are included in this course. Normalization will be covered in detail as well as other major topics that include how to fully populate attributes to be implemented and define those attributes in terms of their domains or logical data types. ERWin modeling tool will be used for the labs and demos.The physical database can be DB2, Sybase, Oracle or SQL Server. (Note current outline is for Oracle).
Prerequisites
Prior to taking this course, students should have basic database knowledge.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for Business Analysts, Project Managers, DBAs and SQL Programmers who need to understand how to design models for efficient and effective databases.
Topics
- Data Modeling
- Business Requirements
- Conceptual Modeling
- Logical Modeling
- Relationships
- Normalization
- Dimensional Data
- Conceptual Dimensional Model
- Logical Dimensional Model
- Physical Modeling Oracle
- Baseline Tables
- Physical Dimensional Model
- Other Techniques
- reFactor / reDesign