TheCoursewareShop.com

Need a sample?

To download free sample courseware, click here


Search for Courseware
We have hundreds of courses on offer, from individual courses to packages.
Click here to seach for courses.

Want to buy a selection of courses?
If you need a selection of courses, make us an offer we can't refuse! 80% of offers for multiple courses are accepted.
Click to make an offer.

JDBC & RMI Courseware

Our JDBC & RMI Courseware

The Courseware Shop offers Java Database Connectivity (JDBC) & Remote Method Invocation (RMI) courseware, as follows:

JDBC & RMI Courseware Two Day Course

Objectives

  • Database Concepts
  • Database Connectivity in Java Technology
  • Advanced Features of JDBC
  • Overview of Distributed Computing
  • Distributed Computing with Remote Method Invocation
  • Advanced features of Remote Method Invocation

Aimed at

Potential Java programmers intending to develop applications that communicate with a back-end and involve distributed computing.

Experience Needed

Prior knowledge of:

  • Core Java
  • Object Oriented Concepts

Courseware Content

Databases and Java

  •      Introduction
  •      Database overview
  •      Database Terminology
  •      Database Access Methods
  •      Database Client/Server Methodology
  •        Single-tier Database Design
  •        Two-tier Database Design
  •        Three-tier Database Design
  •     Databases and Java
  •     Role of JDBC
  •     JDBC Goals

JDBC Overview

  • What is JDBC?
  • Example to establish, send and process
    • the database statement
  • What Does JDBC do?
  • The JDBC API
  • JDBC Vs ODBC
  • The API Components
  • JDBC Drivers
    • JDBC Products

Getting Started

  • Steps to access a database using JDBC
  • Step – 1 Import java.sql. Package
  • Step –2 Registering the Drivers
  • Step –3 Connecting to the Database
  • Step – 4 Create a Statement
  • Step – 5 Execute the Statement
  • Step – 6 Retrieving the results
  • Step –7 Close the Statement & Connection
  • Exercise for connecting to the oracle
  • Exercise for connecting to the MS-Access
  •  Exercise of CallableStatement

Executing DML Commands

  • Inserting values into Tables
  • Exercise to insert a row into the table.
  • Retrieving values from Database
  • Exercise to retrieve values using select statement
  • Updating a table
  • Exercise to update the records
  • Deleting a row from the table
  • Exercise to delete a row from the table

PreparedStatement

  • Overview
  • The PreparedStatement Class
  • Creating a PreparedStatement
  • Supplying values to PreparedStatement
  • Exercise for Prepared Statement

Cursors and Batch Updates

  • Overview
  • Cursors
  • ResultSet Parameters
  • Creating a Scrollable ResultSet
  • Exercise for Scrollable ResultSet
  • Exercise to Retrive: 1
  • Exercise to Retrive: 2
  • Updatable ResultSets
  • Batch Updates
  • Example to Update
  • Exercise to Update
  • Exercise to Insert
  • Standard Extension Features

Structured Query Language SQL

  • Overview
  • Select Statements
  • Where Clause
  • Joins
  • Common SQL Commands
  • ResultSet and Cursors
  • Transaction
  • Stored Procedures
  • Example to create a Stored Procedure
  • MetaData


The java.sql Package

  • Interfaces in java.sql
  • Classes in java.sql
  • Exceptions in java.sql







Executing DDL Commands

  • Creating the Tables
  • Exercise for creating the tables
  • Altering a Table
  • Exercise for Altering a Table
  • Dropping a Column
  • Exercise for Dropping a Column






Joins and Transaction

  • Joins Overview
  • Example showing Equi-join
  • Exercise to show Equi-Join
  • Exercise to show Outer-Join
  • Transaction
  • Exercise for Transaction



CallableStatement

  • Stored Procedures
  • Creating Stored Procedures
  • Creating and Executing CallableStatement
  • Exercise for creating Stored Procedure
  • Exercise of CallableStatement

Exercise

  • Questions
  • Solutions

 

 

Download JDBC & RMI Specification

Only £35

Our Full Java Technologies Package

For our full Java Technologies courseware package, including JDBC & RMI, is available at a greatly reduced price. For more information about this courseware package, click here.

Restrictions on use of courseware

Courseware bought on this site is subject to certain terms and conditions. In particular, courseware bought on this site may not be resold, although you may edit, add contact details and branding and distribute to your own staff, students or deligates. For further information, please see our terms of sale.

'Java' and 'JDBC' are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries. Courseware and training material offered at The Courseware Shop is in no way approved by, endorsed by or connected to Sun Microsystems, Inc. or its subsidiaries.