|
Provided by: Serebra Learning Corporation CIW Database Specialist Part 3: Database Interaction and JDBCJDBC |
 |
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.
|
|
||||||||||
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
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
