Java Enterprise Edition (Java EE) for DBAs

SEE SCHEDULE

Duration: 4 Days

Method: Instructor led, Hands-on workshops

Price: $2250.00

Course Code: JA1019

View Related Video

Audience

Database Administrators and Systems Programmers.

Description

Are you a DBA who increasingly has to manage databases that interact with Java applications? Do you need to understand a bit more about object oriented development technologies and Java EE application servers? You will get a basic understanding of OO principles and Java EE architecture in this training. You will be provided with the details of how a Java program accesses a relational database using JDBC and/or SQLJ, how connection pooling works, how Enterprise Java Beans (EJBs) can be used to declare transactional requirements, and get a high level look at security concerns in a distributed environment. The course can be delivered using any development environment including RSA, RAD and Eclipse.

Objectives

Upon successful completion of this course, the student will be able to:

Explain concepts and beneﬁts of Object Oriented Programming
Describe basic JEE features, terms and components
Describe how Java programs access relational data
Explain how connection pooling works
Describe how EJBs can be configured to support transactions, connection pools, and isolation level
Describe the security requirements of a distributed application

Prerequisites

An understanding of Relational Database technology programming concepts.

Topics

I. Object Orientation: Concepts, Terminology and Features
- OO Overview
- Objects and Classes
- Behavior and Attributes
- Visibility
- Implementation Details
- Object Creation
- Object Relationships
  - Inheritance
  - Composition
- Polymorphism
- Abstract Classes
- Interfaces
- UML
II. Java: Basic Language Features
- What is Java?
- Why Java?
- Java and the Web
- JDK, JVM, and Bytecode
- Java Syntax Basics
  - Classes
  - Variables
  - Operators
  - Strings
  - Assignment
  - Packages
  - Branching
  - Looping
  - Arrays
- Mapping Java to OO Concepts
  - Constructors
  - Inheritance
  - Composition
  - Polymorphism
  - Interfaces
III. Java 2 Enterprise Edition (J2EE): Concepts, Terminology and Components
- Java EE Architecture
- Application Partitioning
- MVC Design Pattern
- Java EE Conceptual Architecture
- Java EE Containers
- Servlets
- Java Server Pages (JSP)
- Tag Libraries
- Enterprise JavaBeans (EJB)
- Java EE Deployment Units
- Deployment Descriptors
- Java Community Process
- Remote Objects IIOP (RMI)
- Remote Objects HTTPS (SOAP)
- JNDI – Java Naming and Directory Interface
- JDBC – Java Database Connectivity
- JMS – Java Messaging Service
- JTA – Java Transaction Architecture
  - Transaction Basics
  - Distributed Transactions
  - XA-Compliance
- JCA – J2EE Connector Architecture
- JAXP – Java API for XML Processing
  - SAX and DOM
- JAAS – Java Authentication and Authorization Service
  - Subjects and Principals
  - JAAS Authentication
  - Policy Files
- JCE – Java Cryptography Extensions
- JavaMail and Java Activation Framework (JAF)
IV. Java Database Connectivity (JDBC)
- Java Database Connectivity
- JDBC Architecture
- JDBC Drivers
- JDBC Runtime Interaction
- JDBC URLs
- JDBC Interfaces
- The Statement Object
- Select Statement Execution
- ResultSet Processing
- Retrieving Column Values
- Update Statement Execution
- Updatable ResultSets
- SQL Exceptions and Warnings
V. JDBC Additional Topics
- PreparedStatements
- Database Stored Procedures
- CallableStatement
- Execution Alternatives
- Scrollable ResultSets
- RowSets
- ResultSetMetaData
- DatabaseMetaData Example
- Escape Syntax
- Transaction Processing
- Setting Isolation Level
- Positioned Updates
- Batching Your SQL
- Large Objects
VI. SQLJ – An Alternative to JDBC
- SQLJ - What Is It?
- SQLJ Background
- SQLJ - Design Goals
- SQLJ Advantages over JDBC
- Security
- Performance
- SQLJ Syntax
- SQLJ and JDBC Interoperability
- Type and schema checking
- Handling Nulls
- Handling Exceptions
- Developing SQLJ Applications
- Execution Environment
- Executing SQLJ Applications
- Scrollable iterators
- Batch updates
VII. Using JDBC – Connection Pooling
- Connection Pooling: What and Why
- Programming Model
- Implementation Details
- Lifecycle of a pooled connection
- Connection States
- Shareable Connections
- Connection Pooling Exceptions
- Creating A DataSource in the Admin Console
- Applications - Using a DataSource
- Resource References: What, Why, and How
- Connection pools: Best Practices
- Connection Pool Tuning Parameters
VIII. EJBs and Transaction Management
- Fundamental Concepts
- Java EE Container Architecture
- Enterprise Java Beans (EJBs)
- EJB Container
- EJB Object
- EJB Object Services
- Deployment Descriptor
- Transactions
- EJB Transactions
- Programmatic vs. Declarative Transactions
- Global Transaction Context
- Local Transaction Containment
- Global Transaction Managers
- Distributed Transactions
- EJBContext and SessionContext
- Bean Managed Transactions (BMT)
- UserTransactions and BMTs
- Container Managed Transactions (CMT)
- Transaction Attributes for CMTs
- Transaction Propagation
- Configuring Container Transactions
- Exceptions: System vs. Application
  - CMTs and Exception Handling
  - BMTs and Exception Handling
- Handling Rollback
- Programmatic Transactions
- Obtaining UserTransaction
- UserTransaction Restrictions
- Transaction Isolation
- Controlling Isolation
- Indicating Isolation Level
  - Using Resource References
- Isolation Setting Options
IX. Security Concepts
- Security - the Big Picture
- Sample High-Level Architecture
- Border Protection: Reverse Proxy
- End-user Authentication and JEE
- Web Access Manager
- Declarative vs. Programmatic Security
- Layered Security Strategy
- User Identity vs. Process Identity
- Authorization and Data Access
- Secure Sockets Layer (SSL)
- SSL Handshake Sample Authentication Flow