|
|
Logical Database Design for
Sybase Adaptive Server
| Duration: 3 days |
| Participants: Developers, DBAs, Designers, and others who design logical database models, and implement them using Microsoft SQL Server. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Describe relational design. - Use a Data Dictionary. - Describe and use: Relational Database Design, Conceptual Design, Logical Design, and Physical Design. - Create logical database models. - Implement a logical design into a physical database, using Microsoft SQL Server. - Normalize and denormalize a database and describe the impact of denormalization. |
|
Overview:
- This course teaches the basics of designing a relational database from requirements gathering to implementation. The instructors are hands-on Database Modelers and share their experiences while teaching the course material. Participants will design for Microsoft SQL Server databases. |
| Prerequisites: Ability to use Windows. |
| Format: Lecture and discussion with hands-on exercises. In workshops, participants practice creating logical and physical design models and normalizing these models. |
|
Topic Outline:
- Introduction To Databases Databases Concepts Hierarchical Databases Network Databases Flat File Databasess Relational Databases Object Databases Object Relational Databases - Data Dictionary RDBMS Specific - Introduction to Relational Database Design Design Review of System Design Different Methodologies The Steps Design Bias RDB Design Methodologies 3-Levels CASE Tools - Denormalization Performance Implications of a Physical Database - Conceptual Design Inputs Outputs When it is Done Steps in Performing - Distributed Database Design for a Multi-site Database - Logical Design Inputs Outputs When it is Done Entities Attributes Relations Keys Reviewing the Design - Converting an OO Design to a Relational Database How it differs from a Standard Database Design - Normalization Mathematical Meaning Plain English Description Six Standard (Normal) Forms 1NF 2NF 3NF Boyce-Code 4NF 5NF - Introduction to Informational Modeling Understand Flow of Information at Your Site - Physical Design Inputs Outputs Tables When it is Done Columns Nulls Constraints Indexes Object Placement - Appendixes Symbols for Different Methodologies Step by Step Design a Database Database Design Templates Glossary |