The Star in Tandem© NonStop Training & Professional Services since 1986
Polaris Learning Solutions Home PagePolaris Learning Solutions Home PageOn-Site CoursesProfessional ServicesPricing and Payment TermsContact UsAbout UsOur Clients
PLBP401 - Logical Database Design
DESCRIPTION
This advanced course teaches the student what the best (and worst) practices in Logical Database Design (covers both ENSCRIBE and NonStop SQL/MP) are.

Should the data be normalized? Is third normal form enough, or too much? What are Entity Relationships, and how do I diagram them?

This course is designed for senior Programmers, Analysts, Application Designers, DBAs, System Managers and those who want to fully understand the thoughts and methods behind proper entity relationships, logical database design, and how and when to get the User involved. It will cover Entity Design, Database Normalization, best/worst practices.

This courses is sold individually, or as a part of the three-course bundle. ( NonStop Database Best Practices Combined Course )

COURSE DURATION:

Online: Self-Paced, includes Instructor Support
On-Site: 1 day

WHO SHOULD ENROLL

Those senior Programmers, Application Designers, Analysts, DBAs and others who need to learn about Logical Database Design, Normalization, understanding using Entity Relationship diagrams, and mapping those diagrams to tables.

PROGRAM HIGHLIGHTS

  • Logical Database Design
  • Database Normalization
  • Entity Relationship Diagrams, and Relationship Cardinalities
  • The Relationships as Tables

PREREQUISITES

  • Minimum of 2 years experience on Tandem NonStop systems.
  • Minimum 2 years hands-on experience with NonStop Databases (ENSCRIBE and/or NonStop SQL/MP).

QUESTIONS/COMMENTS?
Web site:
E-mail:

Phone:
Fax:
Cell/Pager:

Mail:
http://www.polarislearning.com/
operations@polarislearning.com

+1 972-898-3206
+1 972-898-3206
+1 972-898-3206

1892 FM 2481
Bluff Dale, TX  76433
USA

COURSE DETAILS
  • Logical Database Design Module
    • Basic Components
    • Design Methodologies
    • Design Best Practices
    • Business Perspectives
    • User Involvement
    • Design Worst Practices
  • Database Normalization Module
    • Logical Relational Design
    • When to Normalize
    • When to De-Normalize
    • Steps and examples to Normalization forms
    • Normalization up to 5th Normal Form, when should you stop?
  • Entity Relationships Module
    • Methodologies
    • Relationship Cardinalities
    • ER Diagrams
    • Unary, Binary, Tenary and n-ary Relationships
    • Unary and Binary Relationships as tables
    • Key mapping
 
For Web site issues, contact Webmaster .   Copyright © 2003-2009 Polaris Learning Solutions   All rights reserved.