Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


This 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


 
Course Outline
Description

This 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
Objectives

At the end of this course, students 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.
Topics
  • Database and SQL Fundamentals
  • JDBC Fundamentals
  • Advanced JDBC
  • Introduction to Row Sets
Course Outline

I. Database and SQL Fundamentals

A. Relational Databases and SQL
B. SQL Versions and Code Portability
C. Database, Schema, Tables, Columns and Rows
D. DDL -- Creating and Managing Database Objects
E. DML -- Retrieving and Managing Data
F. Sequences
G. Stored Procedures
H. Result Sets and Cursors
I. Using SQL Terminals

II. JDBC Fundamentals
A. What is the JDBC API?
B. JDBC Drivers
C. Making a Connection
D. Creating and Executing a Statement
E. Retrieving Values from a ResultSet
F. SQL and Java Datatypes
G. SQL NULL Versus Java null
H. Creating and Updating Tables
I. Handling SQL Exceptions and Proper Cleanup
J. Handling SQLWarning

III. Advanced JDBC
A. SQL Escape Syntax
B. Using Prepared Statements
C. Using Callable Statements
D. Scrollable Result Sets
E. Updatable Result Sets
F. Transactions
G. Commits, Rollbacks, and Savepoints
H. Batch Processing
I. Alternatives to JDBC

IV. Introduction to Row Sets
A. Row Sets in GUI and J2EE programming
B. Advantages of RowSets
C. RowSet Specializations
D. Using CachedRowSets



Prerequisites & Certificates
Pre-Requisites

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

Certificates offered

Certificate of Completion


Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 157 times.