Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
JDBC Programming
Rev. 6.0.1
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 10.6
  • Oracle, version 9i, 10g, or 11g
Lab exercises use SQL99 constructs whenever possible in order to be relevant to databases from all vendors.

This revision of the course targets Java 6. For training targeted to earlier Java environments, please see version 4.5.1 and version 5.0 of this course


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

Chapter 1. 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
Chapter 2. 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
  • The JDBC 4.0 Cause Facility
Chapter 3. 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
Chapter 4. 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 minimal Core 2 Duo 1.5 MHz or equivalent, 1 gig RAM, 1 gig disk space.

Hardware recommended Core 2 Duo 1.5 MHz or equivalent, 2 gig RAM, 1 gig disk space.

Operating system Tested on Windows XP and Windows 7. Course software should be viable on all systems which support a Java 6 Developer's Kit.

Network and Security Limited privileges required

Software All free downloadable tools


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy