Java JDBC

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

DBC is a Java-based data access technology (Java Standard Edition platform) from Oracle Corporation. This technology is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the JVM host environment.

At the end of the training, participants will be able to:

Pre-requisite

Java Programming and some Java development experience are required.

Duarion

5 days

Course Outline

  1. What is JDBC?
  2. JDBC versus Open Data Base Connectivity (ODBC)
  3. JDBC Driver Types
  4. How Does JDBC Work?
  5. Using SQL Statements with JDBC
  1. The Driver Manager Class
  2. Connecting to Data Bases Using JDBC
  3. Data Base Connection Failures
  4. Read-Only Connections
  5. Closing the Connection
  1. What Are Static SQL Statements?
  2. Creating a Statement
  3. Executing a Statement
  4. Closing a Statement
  1. Mapping Data Types Between Java and the Data Base
  2. Special SQL Data Types
  3. Reading and Updating SQL Data
  1. What Are Result Sets?
  2. When the Data Base Returns a Result Set
  3. Positioning Within the Result Set
  4. Reading Data from the Result Set
  5. Returning Data Values from the Current Result Set Row
  6. How to Check for Nulls
  7. Closing a Result Set
  1. Result Set Values
  2. Fetching Data from Result Sets
  3. Updating Data within Result Sets
  1. Catching SQL Errors
  2. The SQL Exception
  3. Handling SQL Warnings
  4. Data Truncation when Reading, Writing, and Updating Data
  1. What Are Prepared Statements?
  2. Preparing a SQL Statement
  3. Setting Input Parameters
  4. Executing a Prepared Statement
  5. Putting It All Together
  6. What is Meta Data?
  7. Reading Meta Data
  8. Result Set Meta Data
  9. Data Base Meta Data
  10. JDBC Driver Meta Data
  1. What are Escape Clauses?
  2. JDBC Escape Clauses
  3. Processing Escape Clauses
  1. Calling Stored Procedures Using JDBC
  2. Using Callable Statements
  3. Stored Procedure Meta Data
  1. Data Management Issues
  2. Maintaining Data Consistency
  3. Handling Concurrent Threads
  1. What is Dynamic SQL?
  2. Using Dynamic SQL
  3. JDBC SQL Batch Processing
  1. Types of JDBC Drivers
  2. Calling JDBC Drivers
  3. Getting JDBC Driver Meta Data
  4. Connection Timeouts
  5. JDBC Trace Log
  1. How JDBC Works with Enterprise Java
  2. Defining Data Sources
  3. Processing Row Sets
  4. Connection Pooling
  5. JDBC Events

Reviews