Java Survival Skills for DBAs

Course Number:  543-JK
Recommended Duration:  2 days

Intended Audience
Data Base Administrators (DBAs), System Administrators, and other Information Technology personnel who need to support Java programs but not write Java programs.  Course is designed specifically for DB2 and Oracle DBAs but can be adapted to other SQL databases.

Course Overview
DBAs learn how Java works and how it interacts with databases.  Oracle and DB2 are featured, other products can be included upon request.  Java installation, performance, and debugging issues of importance to DBAs are covered.  There are six optional machine exercises (some optional) and several demonstrations.  Exercises use text editor, Sun Java J2SE and J2EE JDKs. IDEs such as Eclipse, WSAD, JDeveloper, JBuilder, etc... may be used upon request.

Course appropriate for Java 5.0 (Java 1.5) and J2EE 1.4.  Course covers Java 2 (aka. Java 1.4) with some new Java 5.0 features being introduced.  Most topics and examples also apply to Java 1.1, Java 1.2, Java 1.3, Java 1.4., and J2EE 1.3.

Objectives
Participants will be exposed to object oriented basics, and how to create, test, and deploy programs using the Java language.  Students examine and execute applications, Servlets, and JSPs as part of the hands-on exercises. Upon request coverage of the locally available IDE (e.g. Eclipse, WebSphere Studio Application Developer, JDeveloper, JBuilder, etc...) may be added.

Prerequisites
Students must have some programming experience.  Experience with text editor, manipulating files and directories, and using a browser are required to accomplish optional exercises.

Topics

• DBA role in Java development

• Java Virtual Machine (JVM)

• Java Security

• Applications, Applets, Servlets, JSPs

• Classes, Methods, and Variables

• Compilation and testing

• Packages, naming, Import, .jar, .war, .ear, and CLASSPATH

• Language syntax: Data types, variables, Strings, reference types,Arrays, Vectors, Collections, Operators, Conditions, and looping

• Exceptions: try, throw, catch, finally

• Inheritance: Subclass/Superclass

• Multi-threading (concurrency)

• Java Beans

• Servlet and JSP basics

• Introduction to Java SQL access using JDBC

• Understanding performance and control issues of JDBC

• Overview of SQLJ (if applicable)

• Database Connection Pooling

• Deployment of Java applications

• Java performance issues

• DB2 and/or Oracle specific issues

• Java interaction with mainframe

• What is an IDE (Integrated Development Environment)