Database Modeling with Power Designer

PT0708
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. The physical data model specifies implementation details for Sybase ASE 15.7 as well as configuration choices for index creation, alternate key declarations, referential integrity, constraints, views, and physical storage objects such as segments, partitions and named caches. Sybase/SAP PowerDesigner v16 will be used extensively.
Prerequisites
Understand basic database concepts and basic SQL knowledge.
Duration
4 Days/Lecture & Lab
Audience
This course is designed for Business Analysts, Project Managers, DBAs, Designers and SQL Programmers who need to understand how to design models for efficient and effective databases.
Topics
Overview::Data Modeling::Business Requirements::Conceptual Modeling::Logical Modeling::Relationships::Primary and Foreign Keys::Normalization::Dimensional Data::Conceptual Dimensional Model::Logical Dimensional Model::Model Reports::Physical Modeling::Baseline Tables::Measurement Techniques::Assessing the Primary Key::Enforcing Data Integrity::Index Basics::Physical Dimensional Model::Other Objects::reFactor / reDesign

Related Scheduled Courses