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.
CONTENT AND OBJECTIVES:
Database Access with Java
Examine the different types of JDBC drivers.
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.
Use two different techniques to write and develop code to run Dynamic SQL.
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.
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.
Embedding SQL statements in Java code.
Implement modifications to a SQLJ program to generate static SQL.
JDBC 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.
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.
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.
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.