Home   |   Instructor-led Training   |   Self-Paced Learning                Email Us   Phone :
Contact Us   -   About Us          
 
Courses
A+
ADA
Adobe
AJAX
AutoCAD
Business Skills and Technology
C++ programming
Cisco
Citrix
Cognos
ColdFusion
COM/COM+
CORBA
Corel
Crystal Reports
Data Mining
DB2
Desktop Application Software
Enterprise Architecture
ITIL
Java
JBoss
Legato
Lotus
Macintosh
Mainframe programming
Microsoft / MCT
MS Access
MultiMedia and design
.NET
Network+
Object oriented analysis and design
OpenVMS
Oracle
Perl
PHP
PowerBuilder
Professional Development
Professional Soft Skills Workshops
Project Management
Rational
SAS
Security
SharePoint
SOA
SQL Server
Telecommunications
Tivoli
Unix/Linux/Solaris/AIX/HP-UX
Visual Basic
Visual Foxpro
VMware
Web 2.0
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
JDBC Programming
Rev. 5.0
Java Training Overview

This one-day course covers the fundamentals of database programming in Java using JDBC (Java Database connectivity) in an incremental fashion, to get the programmer up to speed quickly and then to layer a deeper understanding of JDBC upon that foundation. This course has been designed to work with any of these relational database management systems:

  • Apache Derby, version 10.1
  • MySQL, version 4.1
  • PostgreSQL 8.0
  • Oracle, version 9i or 10g
Lab exercises use SQL99 constructs whenever possible in order to be relevant to databases from all vendors. The course software also includes an optional overlay of workspace and project files to support use of the Eclipse IDE in the classroom. (This requires that the instructor be experienced in use of Eclipse and able to walk students through basic tasks in the IDE.)

This revision of the course targets the 5.0 version of the Java language and Core API, though the impact of choosing a 1.4.x or 5.0 Java environment is minimal for this level of JDBC study.


Java Training Prerequisites

  • Experience in Java Programming is essential. The student must be comfortable with object-oriented Java, interfaces and abstract classes. Course “Java Programming,” is excellent preparation.
  • Understanding of basic SQL usage or other work with relational databases will be helpful, but is not required.
Java Training Learning Objectives

After successfully completing this course, you will be able to:

  • Briefly review relational database fundamentals with an awareness of the differences between SQL99 and SQL implementations by database vendors.
  • Connect to a database using JDBC and perform a simple query.
  • Update relational data using JDBC to execute updates, inserts and deletes.
  • Use prepared statements to produce reusable database queries and optimize execution time.
  • Use callable statements to access database procedures.
  • Use scrollable and updatable results sets for more robust solutions.
  • Use commit, rollback, and savepoint to build transactional systems.
  • Use batch processing for efficient handling of large datasets.
  • Understand the use of RowSets and the improved techniques and portability that they bring to JDBC.
Java Training Course duration

1 Day(s)

Java Training Course outline

Database and SQL Fundamentals
  • Relational Databases and SQL
  • SQL Versions and Code Portability
  • Database, Schema, Tables, Columns and Rows
  • DDL – Creating and Managing Database Objects
  • DML – Retrieving and Managing Data
  • Sequences
  • Stored Procedures
  • Result Sets and Cursors
  • Using SQL Terminals
JDBC Fundamentals
  • What is the JDBC API?
  • JDBC Drivers
  • Making a Connection
  • Creating and Executing a Statement
  • Retrieving Values from a ResultSet
  • SQL and Java Datatypes
  • SQL NULL Versus Java null
  • Creating and Updating Tables
  • Handling SQL Exceptions and Proper Cleanup
  • Handling SQLWarning
Advanced JDBC
  • SQL Escape Syntax
  • Using Prepared Statements
  • Using Callable Statements
  • Scrollable Result Sets
  • Updatable Result Sets
  • Transactions
  • Commits, Rollbacks, and Savepoints
  • Batch Processing
  • Alternatives to JDBC
Introduction to Row Sets
  • Row Sets in GUI and J2EE programming
  • Advantages of RowSets
  • RowSet Specializations
  • Using CachedRowSets
Appendix A. Learning Resources

Appendix B. Course Schema

Appendix C. Methods and Types


Hardware/Software Requirements

Hardware Requirements
  • 500 MHz, 256 MB RAM, 500 MB disk.
  • 1.5 GHz, 512 MB RAM, 1 GB disk.
Software Requirements

All free downloadable tools, with an option to use certain commercial products.

Operating system

  • Tested on Windows 2000 and XP Professional editions. The course software should be viable on all Windows or Linux systems that support J2SE 5.0 JDK.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.