CIW Enterprise Developer Series:

Enterprise Development with JDBC (CIWJDBC)

Enterprise Development with JDBC is a one-day course designed to teach developers how to build JDBC applications that connect interactive Web sites to relational databases. Students will learn how to interface Java applications with database systems and gain hands-on experience using Java Database Connectivity (JDBC) and Structured Query Language (SQL) concepts vital for Web database interface.

Target Audience

Database developers, Internet application developers, database architects, middleware programmers, database administrators, Java developers, and client/server developers.

Job Responsibilities

Develop n-tier database and legacy connectivity solutions for Web applications using Java, Java APIs, Java Database Connectivity solutions, middleware tools, and distributed object models such as CORBA/ORB and IIOP.

Prerequisites

Students must have CIW Foundations and CIW Application Developer certification or equivalent experience, and have completed Java Programming Fundamentals or have equivalent Java experience.

Topics

Introduction to JDBC

  • Why JDBC?
  • General Process for Database Programming
  • Client/Server Architecture
  • Drivers
  • JDBC API

Making a Connection

  • The Driver Interface
  • The DriverManager Class
  • The Connection Interface
  • InterServer

Executing a Query

  • Running a Select Query
  • Parsing the Results
  • Moving Through the ResultSet

Update Queries

  • Insert Queries
  • Compiled Queries

MetaData
  • What is MetaData?
  • ResultSetMetaData
  • Statement (PreparedStatement) Revisited