Home About Courses Schedule Services Webinars Contact Search

Java Enterprise Edition (Java EE) for DBAs

SEE SCHEDULE

Duration: 4 Days

Method: Instructor led, Hands-on workshops

Price: $2100.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 benefits 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

  1. 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
  2. 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
  3. 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)
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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