CIW Database Specialist Part 2: Logical and Physical Design CBT Training CD

Rating:
Summary: CIW Database Specialist Part 2: Logical and Physical Design
Review: Course Overview
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.

Learn To

Identify features of normalization.
Identify features of functional dependency.
Identify features of first normal form (1NF).
Identify considerations for creating a logical database design.
Identify the types of relationships in a relational data model.
Identify methods of resolving complex relationships.
Identify characteristics of physical database design.
Identify guidelines for creating base relations.
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
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Normalization 2 - 3 hours

Identify features of normalization.
Identify features of functional dependency.
Identify features of 1NF.
Identify features of second normal form (2NF).
Identify features of third normal form (3NF).
Identify features of Boyce-Codd normal form (BCNF).
Identify features of advanced normal forms.

Unit 2: Logical Database Design 2 - 3 hours

Identify considerations for creating a logical database design.
Identify the types of relationships in a relational data model.
Identify methods of resolving complex relationships.
Identify guidelines for resolving relationships with attributes.
Identify guidelines for identifying redundant relationships.
Identify the syntax for organizing a relation by using the database definition language (DBDL).
Identify guidelines for validating a logical data model.
Identify features of domain integrity.
Identify features of entity integrity.
Identify features of referential integrity.
Identify features of enterprise integrity.
Sequence the steps for creating an enterprise data model.
Identify advantages of using Computer-Aided Software Engineering (CASE) tools.

Unit 3: Physical Database Design 2 hours

Identify characteristics of physical database design.
Identify guidelines for creating base relations.
Identify keywords used in DDL.
Access the Interactive Structured Query Language (SQL) Window.
Create an InterBase relation.
Identify guidelines for creating enterprise constraints.
Identify guidelines for determining referential constraints.
Identify features of secondary indexes.
Identify features of denormalization.
Identify guidelines for creating user views.
Identify characteristics of database access rules.