|
Provided by: Serebra Learning Corporation CIW Database Specialist Part 1: Introduction to Database DesignCIW Database Specialist |
 |
Training
Provided by Serebra Learning Corporation
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.
|
|
||||||||||
CIW Database Specialist Part 1: Introduction to Database Design
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
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.
Objective
- Identify features of a database.
- Identify disadvantages of a flatfile 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.
Topics Include
Unit 1: Relational Databases
- 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
- 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.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
