CIW Database Specialist Part 3: Database Interaction and JDBC CBT Training CD

Rating:
Summary: CIW Database Specialist Part 3: Database Interaction and JDB
Review: 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.