Soaring Eagle Consulting - Training

Length: 3 Days

Prerequisites: None

Overview:

Learn the basics of designing a database from requirements gathering to implementation. Our instructors are hands-on Database Modelers. They will share their experiences while teaching the course material.

Key Benefits: Learn Database Design for Microsoft SQL Server

Topics Covered:

Introduction To Databases
Databases in General, Hierarchical Database, Network Database, Flat File Databases, Relational Database, 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, 6 Standard 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

Appendix
A. Symbols for Different Methodologies
B. Step by Step Design a Database
C. Database Design Templates
D. Glossary

Join us at These Events

When: Oct 25, 2008
Where: Orlando FL

Tuning Guide (for Peoplesoft)

Dynamic Scripting

Search for Talent.

©Soaring Eagle 2006