Analysis & Design - Introduction
Course Description
This is a 2-day course which provides a complete view of database design from initial analysis of a business process to ensuring the database will be efficient in live use. Practical exercises reinforce the theory and the course instructor will use real-life examples to illustrate the points made during the course.
Course Duration
2 days
Course Objectives
On completion of this course delegates will be have learned:
· Entity-Relationship Modelling of business processes
· Third Normal Form analysis to remove redundancy
· Conversion of logical to physical data model
· Testing and tuning the physical design
· Entity-Relationship Modelling of business processes
· Third Normal Form analysis to remove redundancy
· Conversion of logical to physical data model
· Testing and tuning the physical design
Course Content
BACKGROUND
Introduction; Databases and data; The need for Data Modelling; Systems development lifecycles.
ENTITY-RELATIONSHIP MODELING
Logical data modeling; Bachman Diagrams; Relationships, attributes and entities; Mandatory, optional and special relationships.
NORMALISATION
Key Selection; Steps to Third Normal Form; Conversion to data model.
REFERENTIAL INTEGRITY
Primary and Foreign keys; Entity, domain and referential integrity; Constraints.
CONVERSION TO PHYSICAL
Usage profiles; Indexing; Security; Concurrency; Transaction design; SQL Data Definition Language; CASE tools; Backup strategy.
DATABASE TESTING
Profile and trace; SQL and Stored Procedure Testing; Access plans; Performance testing; Testing tools.
OTHER TECHNQIUES
Object-oriented data design; Entity Life Histories; CRUD matrix; Relationship Cardinality.
DISTRIBUTING DATA
Benefits and drawbacks; Latency; Replication; Two phase commit; Transaction logs.
SUMMARY & CONCLUSION
Key learning points; Personal Action Planning
Introduction; Databases and data; The need for Data Modelling; Systems development lifecycles.
ENTITY-RELATIONSHIP MODELING
Logical data modeling; Bachman Diagrams; Relationships, attributes and entities; Mandatory, optional and special relationships.
NORMALISATION
Key Selection; Steps to Third Normal Form; Conversion to data model.
REFERENTIAL INTEGRITY
Primary and Foreign keys; Entity, domain and referential integrity; Constraints.
CONVERSION TO PHYSICAL
Usage profiles; Indexing; Security; Concurrency; Transaction design; SQL Data Definition Language; CASE tools; Backup strategy.
DATABASE TESTING
Profile and trace; SQL and Stored Procedure Testing; Access plans; Performance testing; Testing tools.
OTHER TECHNQIUES
Object-oriented data design; Entity Life Histories; CRUD matrix; Relationship Cardinality.
DISTRIBUTING DATA
Benefits and drawbacks; Latency; Replication; Two phase commit; Transaction logs.
SUMMARY & CONCLUSION
Key learning points; Personal Action Planning
Who should attend?
This course is designed for developers and/or system & business analysts who need to understand the principles behind database design.
Pre-requisites
Whilst no prior experience of data analysis is needed, some knowledge and experience of IT systems or their use is assumed.