Training Course:Logical Database DesignSchool/Trainer:Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Learn to apply consistent methodology in creating a logical database design that is based on the relational data model and confirms to formal standards of normalization. Examine techniques for gathering and analyzing business rules, using entity-relationship diagrams to capture conceptual data designs, and modeling business processes with data flow diagrams. Study the theoretical foundations of the relational data model and how to apply its principles to produce a fully normalized logical data model and design.
Course Objectives :
Upon completion of this course, you will be able to:
Describe the goals of the database design process
Describe the five phases of the design process
Gather information about a business using interviews and other techniques
Read a data flow diagram
Understand the relationship between data flow and business function
Define the key terms of data modeling
Distinguish among dependent, recursive, and subordinate relationships
Read an entity-relationship diagram
Complete a conceptual model of a database
Define primary keys, foreign keys and artificial keys
Learn the rules of data normalization and the five normal forms
Course Topics :
Distinguishing logical database design from physical database design, using PowerDesigner to examine data models, entities, attributes, and relationships, derived and subtype entities, dependent entities, diagramming a conceptual model, converting the conceptual model to a logical model, converting many-to-many, n-ary, and recursive relationships, normalization and the relational data model, normal forms (first, second, third, Boyce-Codd, higher), when to de-normalize, and the next step ¨C where the logical design goes from here.
Who Should Attend : Database Designers, Application Developers, Database Administrators
...''
Please go to the school's official website for training price and schedule:
http://www.sybase.com
Phone:1-800-8-SYBASE (800-879-2273)
School Address:
14800 Quorum
Suite 505
Dallas, Texas 75240
United States
8755 West Higgins Road
Suite 1100
Chicago, IL 60631
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036
Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland
561 Virginia Rd.
Concord, MA 01742
(978) 287-1500
3820 Mansell Road
Suite 100
Alpharetta , GA 30022
19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612
Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Other training courses offered by Sybase, Inc.:
Behind the Scenes with DBCC Commands
Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server
Troubleshooting Adaptive Server Data Structures
Performance and Tuning: Adaptive Server Enterprise Query Optimizer
Physical Database Design
XML Certification Boot Camp
Introduction to Cascading Style Sheets
Introduction to JavaScript
Introduction to Java 2 Programming
Intermediate Java 2 Programming
Advanced Java 2 Programming
Adaptive Server Anywhere 9.0 Fundamentals
Manage Anywhere Studio 5.0 Administration
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later. |
|
|
