Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Data Warehousing > System Design Training

System Design Training

Course#: WA1830

The workshop divides design into Preliminary Design, External Design and Internal Design. Preliminary Design accomplishes the transition from analy-sis and determines the technical architec-ture of the system. It also decides what processes and data will reside on which processors. External Design is design from the viewpoint of the user. It defines dialogue flow and provides screen and report design. Internal Design is design from the viewpoint of the builder. It op-timizes the data, structures the logic and defines interfaces.

It uses the same case study as BAA. You complete the course with experi-ence in design.

The workshop provides a full dis-cussion of logical data base design. You will learn how to apply safe and aggres-sive trade-offs for optimizing the data. Safe trade-offs optimize the data without compromising integrity and redundancy. Aggressive trade-offs optimize the data while providing some compromise of integrity or redundancy.

What you will learn
Upon successful completion of this course, the student will be able to understand:

  • A step by step way to do design
  • The use of analysis results in design
  • How to do a design that meets business requirements
  • How to optimize (de-normalize) data
  • How to design code that conforms to the latest design principles
  • How to use task analysis to design screen flow
  • How to design screens and reports
  • How and when to prototype
  • The different forms of prototyping
  • What design must deliver to implementation

Audience

  • Designers
  • CASE specialists
  • Data Analysts
  • Systems Analysts
  • Programmers
  • Data/Database Administrators

Prerequisites
To get the most out of design, it is advis-able that you have an understanding of analysis. This can be achieved by attend-ing our BAA workshop or having equivalent experience.
 
Duration
4 days

Outline of WA1830 System Design Training

1. Introduction to Design

  • Overview of analysis
  • Deliverables from analysis
  • How to tell the data model is done
  • How to tell the process model is done
  • Role of analysis deliverables in design

2. Overview of Design

  • Characteristics of design
  • Stages of design
  • Tasks of design
  • Deliverables of design
  • The progression of deliverables from analysis to design
  • Transition from BAA deliverables

3. Preliminary Design

  • Transition to design
  • The technical architecture of a system
  • The application architecture
  • Types of systems
  • Host based
  • Distributed computing
  • Object-oriented
  • Determine scope of design
  • Determine automation boundary
  • Assign process to processors
  • Define batch, on-line, real time proc-esses
  • Assign data to processors

4. Presentation Design

  • Presentation design principles
  • Perform task analysis
  • Perform usability analysis
  • Types of dialogues
  • Data maintenance
  • Inquiry
  • Transactional
  • Designing the flow of screens/reports
  • Screen/report layout design

5. Prototyping

  • Definition of prototyping
  • Four kinds of prototyping
  • Application of kinds of prototyping
  • Tasks of prototyping
  • Prototyping the dialogue flow
  • Prototyping screen design

6. Data Design

  • Safe design trade-offs for optimization
  • Aggressive design trade-offs for optimi-zation
  • Integrity modules
  • Conversion to target DBMS

7. Function Design

  • Principles of good module design
  • Business level module design
  • Detailed level module design
  • Reusable modules
  • Module specification

8. Interface Design

  • Introduction to interfaces
  • Interface data design
  • Interface module design

9. Object Oriented Design

  • Definition of terms
  • Use of analysis models
  • Object design models

10. Client Server Design

  • Layered design:  data, presentation, function
  • Communication via message passing
  • Advantages of layered design

 

11. Managing Design


Appendices:
Access path analysis
Data usage mapping
Transaction load analysis
Performance analysis
Glossary

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.