Java II: Intermediate Java with JDBC

Course Number:  571-JK
Recommended Duration:  5 days

Intended Audience
Java developers/programmers who need to move beyond the Java basics.

Course Overview
Experienced programmers improve Java skills using collections, networking, JDBC, and SQLJ.  There are seventeen hands-on exercises, and two optional exercises.  Exercises use the IBM RAD tool (may be adjusted to Eclipse upon request).

Course appropriate for Java 5.0 (Java 1.5) and J2SE 1.4; IBM RAD Version 6.

Objectives
Participants will learn to improve upon basic Java skills to become more-complete Java developers developing, testing, and deploying Java database programs using JDBC, collections, internationalization, networking, and other more-advanced features.

Prerequisites
Java programming experience (six months or more) is assumed. Alternatively, participant must have completed Java I course or an equivalent course.

Topics

• OOP Review

• Packages and Classes

• Fully-qualified Names & Import

• Constructors and Method Overloading

• Get/Put (Accessor/Mutator) Methods

• Java Syntax Review

• Wrapper classes

• Objects and Garbage Collection

• Exception handling: Try/Catch/Finally

• Runtime vs Checked exception

• Debugging and Stack traces

• Inheritance Review

• Java Collections

• Nested classes and Inner classes

• Reflection and Introspection

• Multi-Threading and Thread Class

• Java Input and Output Streams

• Networking with Java

• URL and URL Connections

• Socket Connections

• Remote Method Invocation (RMI)

• Introduction to Patterns

• Classloading

• Introduction to JDBC

• Database connections/drivers

• Connection pools

• Connection property files

• Creating statement objects

• Queries and result sets

• Using PreparedStatement

• Update/Insert/Delete

• Using Stored procedures and CallableStatement

• SQL exception handling

• Servlets and JDBC

• Overview of SQLJ

• Best Practices and Common Mistakes