Using Java - for PL/SQL and Database Developers

Course details

Overview:

This course discusses Oracle Database programming using Java with examples and explanations of appropriate use. Students learn to access Oracle Database using JDBC , UCP, Java stored procedures, and SQLJ technologies. The course highlights the benefits of accessing and manipulating SQL data using JDBC and SQLJ technologies. The advantage of Oracle JVM is also discussed in the course.

Objectives:

• 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
• List the advantage of using Stored Procedures as Database Programming Model
• Explain the benefits of Oracle JVM (OJVM)