Logical Database Design (Certificate)

Sybase, Inc.
Ottawa, Toronto, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms to formal standards of normalization. Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams. Study the theoretical foundations of the relational data model and how to apply its principles to produce a fully normalized logical data model and design.
Course Objectives:
Upon completion of this course, you will be able to:
Describe the goals of the database design process
Describe the five phases of the design process
Gather information about a business using interviews and other techniques
Read a data flow diagram
Understand the relationship between data flow and business function
Define the key terms of data modeling
Distinguish among dependent, recursive, and subordinate relationships
Read an entity-relationship diagram
Complete a conceptual model of a database
Define primary keys, foreign keys and artificial keys
Learn the rules of data normalization and the five normal forms
Course Topics:
Distinguishing logical database design from physical database design, using PowerDesigner to examine data models, entities, attributes, and relationships, derived and subtype entities, dependent entities, diagramming a conceptual model, converting the conceptual model to a logical model, converting many-to-many, n-ary, and recursive relationships, normalization and the relational data model, normal forms (first, second, third, Boyce-Codd, higher), when to de-normalize, and the next step �where the logical design goes from here. ...''

Elements of this syllabus are subject to change.

Phone:(978) 287-1626

School Address:

Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8

Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto

Search other schools for Logical Database Design training resources.

Performance and Tuning: Adaptive Server Enterprise 15.0 Query Optimization
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Implementing ASE Cluster Edition
M-Business Anywhere Fundamentals
SQL Anywhere 10.0 Fundamentals
Adaptive Server Anywhere 9.0 Fundamentals
Manage Anywhere Studio 5.0 Administration
Replicating Data using SQL Remote 9.0
MobiLink Synchronization with Adaptive Server Anywhere 9.0
MobiLink Synchronization with SQL Anywhere 10.0
Physical Database Design
Data Modeling with PowerDesigner 12
Business Process Modeling with PowerDesigner 12
Business Process Modeling Using PowerDesigner 11
Data Modeling with PowerDesigner 11
Essential Techniques for Object-Oriented Modeling using PowerDesigner 12
Object-Oriented Modeling with PowerDesigner 11.0
Object-Oriented Modeling with PowerDesigner 12
Data Modeling with PowerDesigner 15

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.