Java Survival Skills for DBAs

Recommended Duration:
2 Days
Version
Java SE 8
(suitable for earier versions)
Benefits
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, IBM RAD, JDeveloper, etc... may be added.
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.
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.
Major 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)
Exercises
There are six optional machine exercises (some optional) and several demonstrations. Exercises use text editor, Sun Java J2SE and Java EE JDKs. IDEs such as Eclipse, JDeveloper, etc... may be used upon request.