Database Design

Building an Application Framework

Database Fundamentals

Information System Design

Effective Business Analysis

Building Business Objects

Project Management

Database Design (5 Days)

Businesses continually change to become more effective and competitive in the global market. One area that is not addressed or given enough attention in regard to change is database design. This can be a hindrance as a business moves forward, since one of the key assets of any business is their data. However, if the data structures are designed properly they will usually meet the changes in business process for many years with very little change themselves.  This course is designed to fine-tune your staff’s skills and present concepts that can be used to better utilize your data assets.

Course Content

• Where to look for possible data sources.
• Approach to developing a data model.
• Enterprise aware design techniques.
• Various modeling techniques such as UML and Entity Modeling.
• Description of logical and physical design techniques.
• Techniques to apply to models to check for completeness and consistency.
• Physical database design techniques to deal with performance and design implementation issues.
• Discussions on the various databases on the market currently, such as MySQL, SQLAnywhere, Microsoft SQL Server and others.
• How to design a robust transactional model.

For course information or registration, contact us