Advance Java (J2EE) Training

Course Code: GLOXINIA/JT-AJT/02

Overview: Three Tires for J2EE, Three Tiers for J2SE, The case Study, Design Patterns, Domain and Service Models

Database and SQL Fundamentals: Relational Databases and SQL, Database, Schema, Tables, Columns and Rows, DDL-Creating and Managing Database Objects, Sequences, Stored Procedures, Using SQL Terminals

JDBC Fundamentals: What is the JDBC API?, JDBC Drivers, Making a Connection, Creating and Executing a Statement, Retrieving Values from a Result Sets, SQL and Java Datatypes, Creating and Updating Tables, Handling SQL Exceptions and Proper Cleanup, Handling SQL Warning

Advance JDBC: SQL Escape Syntax, Conditional (IF) Statements, Using Prepared Statements, Using Callable Statements, Scrollable Result Sets, Updatable Result Sets, Transactions, Commits, Rollbacks and Save points, Batch Processing

Introduction to Row Sets: Row Sets in GUI and J2EE Programming, Advantages of Rowsets, Rowset Specializations, Usie of Cachedrowsets

JDBC Classes and the Java.SWL: Driver manager and data source connection, Statement, Prepared Statement and Callable Statement, Resultset, SQL Package, Rowsets

Connecting to Databases: Selecting and Installing a Database Driver, Connecting to the Database Via a Network Address, Connecting to the Database Based on information supplied by JNDI (The Java Naming and Directory Interface), Using the JAVA.SQL Data source Class, Increasing Performance with connection Pooling, Opening and Closing the Connection, Handling Class not Found Exception and SQL Exception

JDBC Design Patterns: Overview of Client tier, Presentation Tier, Business Tier and Resource Tier Patterns, The Data Access Object Pattern, The Value Object Pattern, The Model-View-Controller Pattern

Servlet: HTML Forms, Servlets Overview, Servlet Life Cycle: Init(), Service(), Destroy(), Generic Servlet, Request and Servlet Response, Request-Response, Headers, GET, POST, Accessing Parameters

Additional Servlet Capabilities: HTTP Headers and Mime Types, Requestdispatcher: Including and For Warding, Sharing data with the Request object attributes, Sharing Data with Servlet Context Attributes, Error Handling

Java Server Pages: Basics and Overview, JSP Architecture, JSP Tags and JSP Expressions, Fixed Template Data, Lifecycle of a JSP, Model view controller (MVC), Model 1/Model 2 Architecture, Data Sharing among Servlets and JSP, Request, Application, Session and Page Scope, JSP Implicit Objects

Session Management: HTTP as a Stateless Protocol, Hidden form Fields, Cookies, Session Tracking, HTTP Session, Exception Handling and Error Pages, Directives, Single Thread Model Interface

Project