This Using Java – for PL/SQL and Database Developers training program will teach professionals about Oracle Database programming. Expert instructors use Java with examples and explanations of suitable use.

Radiant Teachlearning offers Using Java – for PL/SQL and Database Developers Training Program in Classroom and Virtual instructor Led/Online mode.


Duration: 2 days


Learning Objectives

  • Develop database Applications using Java.
  • Create, load, resolve and publish Java classes in the database.
  • Develop and Run Java directly in the database.
  • Access and Manipulate SQL and PL/SQL Data types using JDBC and SQLJ.
  • Utilize UCP for JDBC design-time and run-time requirements.
  • Convert Java in the database into Stored Procedure.
  • Explain the benefits of Oracle JVM (OJVM).
  • List the advantage of using Stored Procedures as Database Programming Model.
  • Map SQL and PL/SQL Types to and from Java Types
  • Invoke Java in the Database
  • Manage Java in the Database
  • Use key metadata in JDBC
  • Manipulate Oracle SQL data types in JDBC
  • Use Result Sets and RowSet
  • Understand JDBC Quality of Services and Best Practices
  • Access and Manipulate Oracle SQL data using SQLJ
  • Develop and Run Java directly in the database
  • Access and Manipulate SQL and PL/SQL Data types using JDBC and SQLJ


Benefits to You

Ensure reliable, fast, secure and easy to manage and maintain performance. Optimize database workloads, minimize IT costs and deliver a higher quality of service by allowing consolidation onto database clouds.


Access & Manipulate SQL Data

Upon enrolling in this training program, professionals will also learn to access Oracle Database using UCP, JDBC, Java stored procedures and SQLJ technologies. Instructors will highlight the advantages of accessing and manipulating SQL data using SQLJ and JDBC technologies. The benefit of Oracle JVM is also discussed to ensure understanding.


Required Prerequisite

  • Knowledge of Oracle Database

Audience Profile

  • Developer

Course Content


  • Describe the training program objectives
  • Describe the training program prerequisites and suggested prerequisites
  • Describe lesson contents and agenda
  • List the schemas and appendices used in this training program
  • Identify the relevant documentation and other resources
  • Describe the Training program Technical Environment and data

Introduction to Java

  • Java and OOP Technology
  • Key features of Java

Introduction to JDBC

  • JDBC Architecture
  • JDBC Drivers: Overview
  • JDBC Specification
  • Essential of JDBC Programming

Accessing and Manipulating SQL Data using JDBC

  • Key Metadata in JDBC
  • Manipulating Oracle Data Types with JDBC
  • Accessing and Manipulating LOBs using JDBC
  • Result Set support in JDBC
  • Rowset

JDBC Quality of Services and Best Practices

  • Introduction to Transaction Services
  • Introduction to Security Services
  • Best Practices and tips

Introduction to SQLJ Technology

  • Overview of SQLJ
  • SQLJ Database Access

Universal Connection Pool

  • Introduction to Universal Connection Pool (UCP)
  • Universal Connection Pool for JDBC Overview
  • UCP for JDBC design-time and run-time requirements
  • Basic Connection Steps
  • Packages of the UCP for JDBC API
  • Database Connections

Stored Procedures as Database Programming Model

  • Overview of Stored Procedures
  • Introduction to Java Stored Procedures
  • Advantages of Java Stored Procedures

Oracle JVM

  • Define Oracle JVM and its architecture
  • Using Java in Oracle Database
  • Difference between OracleJVM Architecture and JDK VM Architecture
  • Automated Storage Management with Garbage Collection
  • Dynamic Class Loading
  • Performance Enhancement of Oracle JVM

Developing and Running Java in the Database

  • Creating or Loading Java in the Database
  • Removing Java Sources, Classes and Resources from the Database
  • Setting/Querying Environment Variable and System Properties
  • Java Compiler within the Database
  • Converting Java in the Database into Stored Procedure
  • Invoking Java in the Database
  • Error and Exception Handling
  • Managing Java in the Database


Q: What a database development needs to be done using Java?


A: As per Oracle database is concerned, Java Database Connectivity is used for manipulation and development of data in relational database. JDBC let’s you embed SQL code in Java for the development of database.


Q: Do I need to have any knowledge as a prerequisite for this training?


A: One need to have essential knowledge about Oracle database as a prerequisite for this training.


Q: What is the difference between result set and row set?


A: Row set can be serialized, connected and disconnected from the database whereas result set cannot be serialized or disconnected from the database. There are many more differences between the two sets but these two are the essential differences between both.


Q: What are the benefits of SQLJ technology?


A: SQLJ reduces the number of written code lines and also checks the types and schema objects to enhance the quality and productivity.


Q: Is there any difference between SQLJ and JDBC?


A: JDBC provides an entire dynamic SQL interface from Java to in relational databases or vice versa, whereas SQLJ fills a complementary role for static SQL. The additional difference is that SQLJ source programs are smaller than JDBC programs because SQLJ is scripted in a shorter syntax. SQLJ uses database connections to type and check static SQL code.


Q: What are the benefits of SQL Technology?


A:  Listed below are some of the benefits of SQL technology?

  • High speed service
  • High availability
  • Well defined services
  • Multiple data view


Q: Why one should prefer Radiant Techlearning ?


A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the e-mail to answer your technical queries even after the training program.


Q: Does this training program include any project?


A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.


Q: If I face technical difficulty during the session then is there any remedy for that?


A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.


Q: What is schedule of training program?


A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Unble To Find a Batch..?

Request a Batch