CIW Database Specialist Curriculum CBT Training CDs

Customer Reviews:

CIW Database Specialist Curriculum CBT Training CDs [Posted on 2004-10-15]
Course Overview
The CIW Database Specialist Curriculum 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. It also teaches students about normalization, and logical and physical database design. This curriculum 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. SQL, relational algebra, transactions and database security, and an introduction to the JDBC is also covered along with SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. Metadata, improving JDBC programs, and building applications using JDBC is covered. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and Application Development in JDBC are also covered.

# This curriculum consists of four courses: Course 87056 CIW Database Specialist Part 1: Introduction to Database Design
# Course 87057 CIW Database Specialist Part 2: Logical and Physical Design
# Course 87058 CIW Database Specialist Part 3: Database Interaction and JDBC
# Course 87059 CIW Database Specialist Part 4: Advanced JDBC Certification: This course is mapped to the Master CIW Enterprise Developer certification program and exam 1D0-441.

Learn To
See individual course descriptions for specific course objectives and scope.


Audience
The intended audiences for this curriculum 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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits Per Course

Language Options
US English

Total Learning Time
24 to 32 hours

CIW Database Specialist Part 1: Introduction to Database Design Training CD
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.


CIW Database Specialist Part 2: Logical and Physical Design Training CD
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.


CIW Database Specialist Part 3: Database Interaction and JDBC Training CD
Course Overview
This is the third course in a four part series that teaches students about SQL, relational algebra, transactions and database security, and an introduction to the JDBC. This course covers SQL DDL commands, inserting, updating, and querying with DML statements, granting and revoking privileges with DCL statements. The course also teaches about relational algebra concepts, to include joins, transactions and database security, and using JDBC drivers and executing SQL statements.

Learn To
# Identify features of Structured Query Language (SQL).
# Match the SQL data types with their characteristics.
# Match data definition language (DDL) commands with their functions.
# Identify the fundamental operations in relational algebra.
# Identify characteristics of the selection operation.
# Identify characteristics of the projection operation.
# Identify features of a transaction.
# Identify features of concurrency control.
# Identify features of concurrency control methods.
# Identify features of a Java system architecture.
# Identify features of JDBC.
# Match JDBC driver types with their functions.


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 two parts of this series (87056 and 87057).

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: SQL 2 hours
# Identify features of SQL.
# Match the SQL data types with their characteristics.
# Match DDL commands with their functions.
# Identify features of inserting a value into a relation.
# Identify features of updating a value in a relation.
# Match simple SQL keywords with their functions.
# Match basic queries for filtering with their functions.
# Match special predicates with their functions.
# Identify features of the ORDER BY clause.
# Identify functions of the GRANT statement.
# Identify functions of the REVOKE statement.


Unit 2: Relational Algebra 2 hours
# Identify the fundamental operations in relational algebra.
# Identify characteristics of the selection operation.
# Identify characteristics of the projection operation.
# Identify characteristics of the Cartesian product operation.
# Identify characteristics of the union operation.
# Identify characteristics of the difference operation.
# Identify characteristics of the intersection operation.
# Identify characteristics of the theta-join and the equi-join operations.
# Identify characteristics of in the natural join operation.
# Identify characteristics of the outer join operation.


Unit 3: Transactions and Database Security 1 - 2 hours
# Identify features of a transaction.
# Identify features of concurrency control.
# Identify features of concurrency control methods.
# Identify features of database security.
# Match database security protection techniques with their features.


Unit 4: Introduction to JDBC 1 - 2 hours
# Identify features of a Java system architecture.
# Identify features of JDBC.
# Match JDBC driver types with their functions.
# Identify methods of loading a JDBC driver.
# Identify methods of establishing a database connection.
# Identify syntax of the Statement interface methods.
# Identify features of the ResultSet object.
# Identify features of a transaction with a SQL statement.


CIW Database Specialist Part 4: Advanced JDBC Training CD
Course Overview
This is the final course in a four part series that teaches metadata, improving JDBC programs, and building applications using JDBC. Topics covered include introduction to metadata and to ResultSetMetaData, SQL exceptions, scrollable and updateable result sets, batch updates, and prepared statements. Finally, the Building Applications Using JDBC teaches about Swing, the Layout Manager, UML and Application Development in JDBC are also covered.

Learn To
# Identify functions of DatabaseMetaData methods.
# Identify methods for determining database schema.
# Match the ResultSetMetaData methods with their descriptions.
# Identify characteristics of try and catch blocks.
# Match the SQLException methods with their descriptions.
# Identify the syntax for creating a scrollable result set.
# Identify features of Swing.
# Match basic Swing components with their functions.
# Identify commonly used features of layout managers.


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 three parts of this series 87056 through 87058.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Metadata 2 - 3 hours
# Identify functions of DatabaseMetaData methods.
# Identify methods for determining database schema.
# Match the ResultSetMetaData methods with their descriptions.
# Identify methods for extracting metadata from a result set.


Unit 2: Improving JDBC Programs 2 - 3 hours
# Identify features of the BatchUpdateException class.
# Identify characteristics of try and catch blocks.
# Match the SQLException methods with their descriptions.
# Identify the syntax for creating a scrollable result set.
# Identify features of scrollable result set methods.
# Identify methods for moving a cursor to a designated row.
# Identify features of ResultSet update methods.
# Sequence the steps for modifying the number of rows in a relation.
# Identify characteristics of a prepared statement.
# Identify features of prepared statement parameters.
# Match the methods for executing prepared statements with their functions.
# Identify features of stored procedures in JDBC.


Unit 3: Building Applications Using JDBC 2 hours
# Identify features of Swing.
# Match basic Swing components with their functions.
# Identify commonly used features of layout managers.
# Identify features of events.
# Sequence the steps in the event handling process.
# Identify features of a JTable.
# Identify features of Unified Modeling Language (UML).
# Match Unified Modeling Language (UML) diagrams with their descriptions.
# Identify features of a sequence diagram.
# Identify factors involved in selecting Computer-Aided Software Engineering (CASE) tools.
# Identify the tasks that need to be performed to create a graphical database client.
# Identify database interaction methods for connecting a graphical client to a database.
# Identify the stages in connecting a tabular client to a database.

Click here for more details and discount information...