CIW Database Specialist
 Return to CIW Home Page
CIW Database Specialist Curriculum Exam 1D0-441
|
CIW Database Specialist Curriculum
|
$516.00
|
n87056d
|
|
CIW Certified Internet WebMaster Training Course on CD
CIW Database Specialist - Exam 1D0-441
Part 1: Introduction to Database Design
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.
Objectives
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.
top
Part 2: Logical and Physical Design
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.
Objectives
Unit 1: Normalization
• 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
• 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.
top
Part 3: Database Interaction and JDBC
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.
Objectives
Unit 1: SQL
• 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
• 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
• 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
• 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
top
Part 4: Advanced JDBC
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.
Objectives
Unit 1: Metadata
• 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
• 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
• 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.
top
|
CIW Database Specialist Curriculum
|
$516.00
|
n87056d
|
|
|
