| |
- This course provides intensive exposure to designing for relational database systems. It emphasizes the integration of two complementary data analysis methods for converting business requirements to efficient and flexible relational structures: top-down analysis using the entity-attribute method, and bottom-up verification using normalization. Students learn a methodology for capturing and recording database access requirements in preparation for physical design. The class explores various general design issue trade-offs such as when to denormalize, data clustering, index selection, splitting tables, and derived data, as well as implementation decisions for widely used Relational DBMS's such as SQL Server, ORACLE and DB2. Frequent exercises reinforce the presentations, and participants gain experience by developing an extensive business case to parallel the class content.
- Audience
- This class is designed for data processing managers, business analysts, project leaders, and database and data administrators who need to understand database design issues as they apply to relational systems. Anyone who designs databases for implementation will also benefit.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Ask for a course outline.
|
|
