Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Oracle: Java and JDBC

Home

distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services



PCEC146

Oracle: Java and JDBC
DURATION: 2 days

FEE: $790

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional
 
   

DATES:

HANDS-ON TRAINING:
    1. Database Access with Java
      • Examine the different types of JDBC drivers.
    2. JDBC and SQL
      • Instructor to demonstrate and examine programs for: 1- Creating and populating a table 2- Data retrieval. 3- Generalizing connection information. 4- Using executeUpdate(). 5- Selecting data and presenting information. 6- Using prepared statements. 7- Handling SQLExceptions and SQLWarnings. 8- Using transactions. 9- Using batch updates. 10- Paging with scrollable ResultSets.
    3. JDBC Steps
      • Use two different techniques to write and develop code to run Dynamic SQL.
    4. JDBC Performance Extensions
      • Oracle performance extensions to the JDBC: Java Database Connectivity standard reduce the number of round trips to the database.
      • Improve application performance by grouping multiple UPDATE, DELETE, or INSERT statements into a single batch which is sent and processed to the database.
    5. JDBC Optional Package and JDBC in Web Applications
      • Create an instance of a connection cache class that has an associated group of pooled connection instances.
      • Use the connection cache to improve JDBC performance.
    6. Embedding SQL Statements in Java Code
      • Implement modifications to a SQLJ program to generate static SQL.
    7. SQLJ Advanced Topics
      • The Oracle JPublisher utility is used for creating custom object classes and Java classes.
      • Use Oracle JPublisher to generate a full definition for a custom Java class which can be instantiated to hold the data from an Oracle object.
      • Examine the JPublisher-generated classes and methods for: 1- Converting data from SQL to Java and from Java to SQL 2- Getter and setter methods for the object attributes.
    8. Developing and Deploying Stored Procedures in Java
      • Code stored procedures in both PL/SQL and Java.
      • Stored procedures are Java methods published to SQL and stored in the database for general use.
      • Write the call specifications required for publishing Java methods which can map Java method names, parameter types, and return types to their SQL counterparts.
      • Test and invoke the stored procedures.
      • Deploy the stored procedures which have multiple types of parameters.
 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
Value Added Service

Common Questions


Website

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.