|
Provided by: 123-CBT Computer Based Training CIW Database Specialist Part 1 Introduction to Database Design |
 |
Training
Provided by 123-CBT Computer Based Training
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.
o Identify disadvantages of a flat-file database.
o Identify the problems that relational databases were developed to overcome.
o Identify requirements and scope for the analysis phase.
o Identify guidelines for processing information in the analysis phase.
o Identify criteria for selecting a database management system (DBMS) during the design phase.
CEU credits: 0.70 CEUs
o Identify features of an Entity-Relationship (ER) model.
o Identify the types of relationship cardinalities.
o Match relational integrity rules with their features.
o Identify features of a database.
o Identify disadvantages of a flat-file database.
o Identify the problems that relational databases were developed to overcome.
o Identify features of a DBMS.
o Identify advantages of a DBMS over flat-file databases.
o Identify considerations for choosing a database type.
o Identify stages in the evolution of relational databases.
o Identify Codd's rules that relate to tables.
o Identify Codd's rules that relate to a data dictionary.
o Identify Codd's rules that relate to data updates.
o Identify Codd's rules that relate to data independence.
o Identify features of multitier database architecture.
o Identify features of a relational data structure.
o Identify characteristics of relations in a database.
Learn To:
o Identify features of a database.o Identify disadvantages of a flat-file database.
o Identify the problems that relational databases were developed to overcome.
o Identify requirements and scope for the analysis phase.
o Identify guidelines for processing information in the analysis phase.
o 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
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsCEU credits: 0.70 CEUs
Language Options
American EnglishTotal Learning Time
6 to 8 hours87056 Objectives
Unit 1: Relational Databases 3 - 4 hourso Identify features of an Entity-Relationship (ER) model.
o Identify the types of relationship cardinalities.
o Match relational integrity rules with their features.
o Identify features of a database.
o Identify disadvantages of a flat-file database.
o Identify the problems that relational databases were developed to overcome.
o Identify features of a DBMS.
o Identify advantages of a DBMS over flat-file databases.
o Identify considerations for choosing a database type.
o Identify stages in the evolution of relational databases.
o Identify Codd's rules that relate to tables.
o Identify Codd's rules that relate to a data dictionary.
o Identify Codd's rules that relate to data updates.
o Identify Codd's rules that relate to data independence.
o Identify features of multitier database architecture.
o Identify features of a relational data structure.
o Identify characteristics of relations in a database.
|
|
||||||||||
CIW Database Specialist Part 1 Introduction to Database 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
- Dreamweaver MX
-...
