Oracle Database Programming using JDBC, Java and Web Services: Kuassi Mensah

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

The Oracle database 11g stores and manages all types of data i.e., Relational and unstructured data (XML, Object-Relational, Multi-media, Spatial, Text, etc). This seminar will furnish a condensed but intensive coverage of all aspects of Java persistence and Java access to these data.

JDBC is the most used Java API; the first part of the seminar will cover JDBC, the Universal Connection Pool (UCP), Oracle extensions, and the related quality of services i.e., transaction, concurrency, scalability, high-availability, and security.

When significant data manipulation is involved, running Java directly in the database is often the most efficient choice. The Oracle database is also a robust and s…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Service Oriented Architecture (SOA), Java, Programming (general), Web Accessibility, and Web Analytics.

The Oracle database 11g stores and manages all types of data i.e., Relational and unstructured data (XML, Object-Relational, Multi-media, Spatial, Text, etc). This seminar will furnish a condensed but intensive coverage of all aspects of Java persistence and Java access to these data.

JDBC is the most used Java API; the first part of the seminar will cover JDBC, the Universal Connection Pool (UCP), Oracle extensions, and the related quality of services i.e., transaction, concurrency, scalability, high-availability, and security.

When significant data manipulation is involved, running Java directly in the database is often the most efficient choice. The Oracle database is also a robust and scalable server for database applications (i.e., PL/SQL, and Java). The second part of the seminar will cover all aspects of developing and running Java in the Oracle database and the various applications enabled by such integration.

The third part of the seminar will describe Web services and SOA technologies, their integration with the the Oracle database and how to leverage SQL, PL/SQL, XML, and Streams AQ using WSDL, SOAP, HTTP and the SOA quality of services (Web Services Security, Web Services Management, Web Services Reliable Messaging, and so on), without the need to get into the details of these technologies.


Audience
  • Developer
  • Database Administrators
  • Java Developer

Course Topics Day 1: Oracle JDBC - Crash Course
  • Overview of JDBC Specifications: from JDBC 1.22 to JDBC 4.0
  • JDBC URL, DataSource
  • Oracle Net Services summary for JDBC
  • Statement, PreparedStatement, CallableStatement, Statement Caching, DML batching
  • Manipulating SQL Data types using JDBC: Ref type, VARRAY, NESTED TABLE, SQLData, ORAData, etc
  • Manipulating LOBs, LOB Prefetch, SecureFiles LOB
  • Result Set: Scrollable, Updatable, Prefethcing, Changes and Visibility
  • Result Set Caching in Oracle Database 11g: Server Result cache, Client Result cache
Day 1: Oracle JDBC - Crash Course....contd
  • RowSet (JSR-114): connected and disconnected RowSets (Cached/Web/Joined)
  • Scalability: Query Change Notification
  • What’s New for JDBC in 11gR2
  • SQLXML Support
  • Timestamp and Time Zone improvement
  • LOB Prefetching Support
  • Zero-copy I/O for Oracle SecureFiles
  • Setting Session Edition for a Connection
Day 1: Oracle JDBC - Crash Course....contd
  • Internet Protocol Version 6 Support (IPv6)
  • PreparedStatement.getMetaData() Method
  • Oracle RAC Fast Application Notification
  • Universal Connection Pool
  • OCI Client Result Cache Enhancement
  • Online Upgrade of Java Applications using Edition Based Redefinition
  • Manageability: programmatic database startup and shutdown
  • JDBC Best Practices and Troubleshooting
Day 1: Oracle JDBC - Crash Course....contd
  • Interface Change
  • Concrete Classes desupport
Day 1 - Universal Connection Pool (UCP) – Crash Course
  • Universal Connection Pool (UCP)
  • Optimizing Connection Pool
  • Timeouts
  • Connection Labeling
  • Conn Pool Manager
  • Proxy Authentication.
  • Advanced UCP Services:
  • Fast Connection Failover (FCF)
Day 1 - Universal Connection Pool (UCP) – Crash Course .... contd
  • FCF versus TAF
  • Runtime Connection Load Balancing
  • Web Session Affinity
  • Transaction Affinity
  • UCP Best Practices and Troubleshooting
Day 2: Java in the Database - Crash Course
  • Stored Procedures as Database Programming Model: Why, What for, PL/SQL or Java?
  • OracleJVM Life Cycle: Install/Uninstall,
  • OracleJVM Internals: Memory management, Threading, Security,
  • What’s New for Java in the database in 11gR1
  • Oracle JVM Compatibility with JDK 1.5
  • Oracle JVM Utilities Enhancements
  • Ease-of-Use Interface
  • Oracle JVM Just-in-Time Compiler (JIT)
Day 2: Java in the Database - Crash Course....contd
  • Java Execution in the database: JIT Compiler
  • Developing and Running Java in the Database: loadjava, Call Spec, Type Mapping, Invoking Java in the database
  • Pragmatic and advanced applications: RMI Callout, HTTP Callout, SAP Callout, Web Services Callout, JDBC Callout
Day 2: Database Web Services and SOA – Crash Course
  • Web Services and SOA for DBA, Data Architects, and Others
  • Database as Web Services Provider: PL/SQL Web Service, JDeveloper Wizard, Web Services Assembler, Data Types, SOA Quality of Services
  • Database as Web Services Consumer: WSDL, JPublisher, Web Services Callout Utility
Wrap Up – Q & A
Course Objectives
  • Empower Java developers
  • Database developers
  • DBAs
  • Data architects
  • SOA and Web Services assemblers
  • To fully leverage the Oracle Database

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.