CIW Database Specialist Part 1: Introduction to Database Design CBT Training CD

Rating:
Summary: CIW Database Specialist Part 1: Introduction to Database Des
Review: Course Overview
This is the first course in a four part series that teaches students about relational databases and database planning and design. It introduces relational databases, Codd's rules, relational data structure and the ER model. It also covers the various phases in the design life cycle and database design methodology, including the creation of ER models.

Learn To

Identify features of a database.
Identify disadvantages of a flat-file database.
Identify the problems that relational databases were developed to overcome.
Identify requirements and scope for the analysis phase.
Identify guidelines for processing information in the analysis phase.
Identify criteria for selecting a database management system (DBMS) during the design phase.

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.

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: Relational Databases 3 - 4 hours

Identify features of an Entity-Relationship (ER) model.
Identify the types of relationship cardinalities.
Match relational integrity rules with their features.
Identify features of a database.
Identify disadvantages of a flat-file database.
Identify the problems that relational databases were developed to overcome.
Identify features of a DBMS.
Identify advantages of a DBMS over flat-file databases.
Identify considerations for choosing a database type.
Identify stages in the evolution of relational databases.
Identify Codd's rules that relate to tables.
Identify Codd's rules that relate to a data dictionary.
Identify Codd's rules that relate to data updates.
Identify Codd's rules that relate to data independence.
Identify features of multitier database architecture.
Identify features of a relational data structure.
Identify characteristics of relations in a database.
Identify features of a primary key.
Identify features of a foreign key.
Match database languages with their features.
Identify features of a data model.

Unit 2: Database Planning and Design 3 - 4 hours

Identify requirements and scope for the analysis phase.
Identify guidelines for processing information in the analysis phase.
Identify criteria for selecting a DBMS during the design phase.
Identify considerations for DBMS interface.
Identify considerations for testing a database prototype during the design phase.
Identify considerations for building a database in the implementation phase.
Sequence the steps for designing a conceptual database.
Identify guidelines for establishing criteria for data representation.
Identify features of entity groups.
Identify the attributes of an entity.
Identify features of ER building blocks.
Match database anomalies with their definitions.
Identify the cardinality of ERs.
Match bottom-up transformation primitives with their functions.
Identify features of the mixed strategy.
Identify issues concerning data privacy and security.
Match top-down transformation primitives with their functions.