|
Provided by: 123-CBT Computer Based Training CIW Database Specialist Part 2 Logical Physical Design |
 |
Training
Provided by 123-CBT Computer Based Training
This is the second course in a four part series that teaches students about normalization, and logical and physical database design. This course will cover the normalization about the first, second, and third normal forms, and also about Boyce-Codd Normal Form, logical database design resolving relationships, creating a logical data model, and the various integrity constraints, physical database design which introduces physical design, creating enterprise constraints, and database performance and access.
o Identify features of functional dependency.
o Identify features of first normal form (1NF).
o Identify considerations for creating a logical database design.
o Identify the types of relationships in a relational data model.
o Identify methods of resolving complex relationships.
o Identify characteristics of physical database design.
o Identify guidelines for creating base relations.
o Identify keywords used in data definition language (DDL).
CEU credits: 0.70 CEUs
o Identify features of normalization.
o Identify features of functional dependency.
o Identify features of 1NF.
o Identify features of second normal form (2NF).
o Identify features of third normal form (3NF).
o Identify features of Boyce-Codd normal form (BCNF).
o Identify features of advanced normal forms.
Unit 2: Logical Database Design 2 - 3 hours
o Identify considerations for creating a logical database design.
o Identify the types of relationships in a relational data model.
o Identify methods of resolving complex relationships.
o Identify guidelines for resolving relationships with attri
Learn To:
o Identify features of normalization.o Identify features of functional dependency.
o Identify features of first normal form (1NF).
o Identify considerations for creating a logical database design.
o Identify the types of relationships in a relational data model.
o Identify methods of resolving complex relationships.
o Identify characteristics of physical database design.
o Identify guidelines for creating base relations.
o Identify keywords used in data definition language (DDL).
Audience
The intended audiences for this course include individuals who design, implement, and maintain database schemas; design and develop database client applications and components; and perform database administration and maintenance, database developers, enterprise developers, application developers, software engineers, and Web developers. Recommend competency in object-oriented theory and Java programming. This course is mapped to the Master CIW Enterprise Developer certification program and exam 1D0-441. In addition, students should have taken the first part of this series (87056).Deployment Options
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsCEU credits: 0.70 CEUs
Language Options
American EnglishTotal Learning Time
6 to 8 hours87057 Objectives
Unit 1: Normalization 2 - 3 hourso Identify features of normalization.
o Identify features of functional dependency.
o Identify features of 1NF.
o Identify features of second normal form (2NF).
o Identify features of third normal form (3NF).
o Identify features of Boyce-Codd normal form (BCNF).
o Identify features of advanced normal forms.
Unit 2: Logical Database Design 2 - 3 hours
o Identify considerations for creating a logical database design.
o Identify the types of relationships in a relational data model.
o Identify methods of resolving complex relationships.
o Identify guidelines for resolving relationships with attri
|
|
||||||||||
CIW Database Specialist Part 2 Logical Physical Design
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
