JDBC: JAVA DATABASE CONNECTIVITY

2 Days course

Language: English

This course is only available on request!!

DESCRIPTION
Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort - largely because Java deals in objects, while most databases do not.
This course describes the standard Java interfaces that make portable object-oriented access to relational databases possible, and offers a robust model for writing applications that are easy to maintain.

WHAT YOU WILL LEARN
You will be introduced to JDBC and RMI packages and will use them to develop three-tier client server applications (applications divided into a user interface, an object-oriented logic component, and an information store).
Additional course topics include blobs and multimedia content, database cursors, stored procedures, dynamic SQL and database metadata.
You will also solve operational problems such as high availability, load balancing and failover as well as security, transaction management for OLTP environments and design concepts for large-scale applications.

ASSUMED KNOWLEDGE
Java Programming

OUTLINES

CHAPTER 1: JDBC: DATABASES THE JAVA WAY!
1) What is the JDBC?
2) The JDBC Structure
3) ODBC's Part in the JDBC

CHAPTER 2: SQL
1) The Relational Model and SQL
2) Data Definition Language
3) Data Maintenance Language
4) Data Query Language
5) Coming up Next

CHAPTER 3: USING JDBC DRIVERS
1) Quick Start Guide
2) Installing java.sql*
3) Registering and calling JDBC Drivers
4) Using ODBC Drivers

CHAPTER 4: THE INTERACTIVE SQL APPLET
1) Your First JDBC Applet
2) Getting a Handle on the JDBC Essentials
3) The HTML File that Calls the Applet
4) The Final Product

CHAPTER 5: ACCESSING ODBC SERVICES USING JDBC
1) Bridge Requirements
2) The ODBC URL
3) JDBC to ODBC Calls

CHAPTER 6: SQL DATATYPES IN JAVA AND ORM
1) Mapping SQL Data to Java
2) ResultSetMetaData
3) Understanding the Object Relation Model

CHAPTER 7: WORKING WITH QUERY RESULTS
1) A Basic Java Object for Storing Results
2) Charting Your Data
3) URL Rewriting
4) Persistent Cookies
5) The Session Tracking API

CHAPTER 8: THE ICONSTORE MULTIMEDIA JDBC APPLICATION
1) IconStore Requirements
2) Building the Database
3) Application Essentials

CHAPTER 9: JAVA AND DATABASE SECURITY
1) Database Server Security
2) Finding a Solution
3) Reusing Database Objects
4) Applet Security

CHAPTER 10: WRITING DATABASE DRIVERS
1) The JDBC Driver Project
2) The DriverManager
3) JDBC DataDypes
4) New Data Classes
5) Native Drivers
6) Implementing Interfaces
7) Tracing
8) Data Coercion
9) Escape Clauses
10) JDBC Interfaces

CHAPTER 11: INTERNET DATABASE ISSUES
1) Connectivity Issues Involved with Database Access
2) Application Server
3) The Client

CHAPTER 12: THE JDBC API
1) Classes
2) Interfaces

[HOME] [dates] [reserve] [seminars]
FDDI Institute
De Regenboog 11 - 2800 Mechelen - Belgium - Europe
Tel 32 15 24 50 58 - Fax 32 15 25 10 50