|
Provided by: Serebra Learning Corporation CIW Database Specialist Part 4: Advanced JDBCJDBC |
 |
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 updatable 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.
|
|
||||||||||
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 thru 87058.
Objective
- 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.
Topics Include
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.
Duration
8
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
