CIW Database Specialist Part 3: Database Interaction and JDBC

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).

Objective

• 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.

Topics Include

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.

Duration

7

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