• 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.

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.

• 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

• 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

• 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

• Row Sets in GUI and J2EE programming
• Advantages of RowSets
• RowSet Specializations
• Using CachedRowSets