About Advanced Java Training

 The course builds a strong understanding of JDBC Technology. It gives in to demonstrate why Servlets are the cornerstone of Java’s Web platform. It then shows how JSP is built on the Servlet architecture. Additionally, the class shows students how to use JSTL, custom tags and expression language to reduce Java code in Web pages while adding tremendous power and capability to those pages. The class culminates in an exploration of Java MVC frameworks like Struts at a high level.

Advanced Java Training Course Prerequisite

Basic Knowledge of Core Java is required. An understanding of Web technologies like HTML and HTTP is helpful.

Advanced Java Training Course Objective

Learn the fundamentals of JDBC and using the different interfaces in the JDBC API. Learn how to use Java servlets in the role of Web application control. Identify the options to state management in a Java Web application and understand the pros/cons of each. Understand how JSPs can help to separate Web logic and functionality from page layout. Explore how to make JSPs smaller and more powerful with JSTL, custom tags and expression language. Explore strategies in the exchange of data between Web pages (views) and business processing (model). Learn the meaning and importance of MVC

Advanced Java Training Course Content Overview

Introduction

• About Java Platforms
• Applications of Java
• About API (Application Programming Interface)
• Static Blocks
• Introduction to interfaces
• Runtime Polymorphism

Persistence

• What is Persistence?
• File management system
• Disadvantages of File management system
• Database management system
• Advantages of Database management system

JDBC

• Introduction to JDBC
• Why JDBC? & ODBC Vs JDBC
• Approch-1 Vendor specific library
• Disadvantages
• Approch-2 X/Open standards
• Disadvantages
• Approch-3 ODBC standards
• Disadvantages
• Approch-4 JDBC standards
• Advantages

JDBC API and JDBC Drivers

• About JDBC API
• What is a JDBC Driver?
• JDBC architecture
• Types of JDBC Drivers
• JDBC-ODBC bridge driver
• Advantages & Disadvantages
• Native API Partly Java Driver
• Advantages & Disadvantages
• Net-Protocol all/pure java driver
• Advantages & Disadvantages
• Native-Protocol pure java driver
• Advantages

JDBC API

• JDBC Packages
• sql, Javax.sql
• Interfaces and classes in above packages
• Versions of JDBC API
• Steps for developing JDBC application

SQL

• Introduction to SQL
• Types of SQL queries

Establishing Connection to Database

• About Driver Manager class
• Methods of Driver Manager
• What is registering driver with Driver Manager
• Different methods of registering driver with Driver Manager
• About get Connection method of Driver Manager
• Syntax of URL to communicate with database
• Autoloading of class driver in JDBC 4.0

Statement interface

What is Statement? & Need of Statement

• Characteristics of Statement
• How to get Statement object?
• Methods of Statement
• Passing SQL statements to Database
• About execute, executeUpdate, executeQuery, largeExecute Updates methods

Prepared Statement interface

• What is PreparedStatement?
• Need of PreparedStatement
• Difference between Statement and PreparedStatement
• How to get PreparedStaement object
• Defining parameters
• How to pass values to PerparedStatement object

What is SQL Injection attack & how to overcome?

• Resultset Interface
• What is ResultSet?,
• Need of ResultSet
• How to get resultset object
• Methods of ResultSet
• Reading data, Various types of ResultSet
• Resultset types
• TYPE_SCROLL_SENSITIVE
• TYPE_SCROLL_INSENSITIVE
• TYPE_FORWARD_ONLY
• Resultset modes
• CONCUR_READ_ONLY, CONCUR_UPDATABLE

SQL 99 Datatypes

• BLOB
• Inserting blob type, Reading blob type
• CLOB
• Inserting clob type, Reading clob type
• Array, Inserting array type
• Reading array type
• Object, Inserting object
• Reading object

Metadata

• Resultset Metadata
• Need of ResultsetMetaData
• How to get metadata
• DatabaseMetadata
• How to get database metadata
• Parameterizedmetadata
• How to get parameterizedmetadata
• Example with Application

CallableStatement

• About CallableStatement
• Advantage of CallableStatement
• Creating CallableStatement object
• Calling Procedure using CallableStatement
• Calling functions using Callable Statement
• About PL/SQL Programming vs Manual on Batch Queries

Batch updates

• What is batch processing
• Batch updates using Statement object
• Batch updates using Prepared Statement object

Transaction Management

• Transaction Definition
• ACID Properties
• Atomicity, Consistency,Isolation, Durability
• Methods in Transaction Management
• setAutoCommit(), setSavePoint()
• commit(), rollback()
• Example with All Application

Connection Pooling

• What is connection pooling?
• Advantages of connection pooling
• Disadvantage of DriverManager
• About DataSource
• JDBC connection pooling
• Isolation Levels

RowSet

• What is RowSet?
• What is difference between ResultSet and RowSet
• Types of RowSets
• JdbcRowSet
• CachedRowSet
• WebRowSet

Communicating with difference databases

• Communicating with MYSQL
• Working with CSV files
• Communicating with MS-EXCEL
• Communicating with PostgreSql
• Example with Application 

JDBC 4.0 Features

• Auto-loading of JDBC driver class
• Connection management enhancements
• Support for RowIdSQL type
• DataSet implementation of SQL using Annotations
• SQL exception handling enhancements
• SQL XML support

Working with Properties File

• Working with Date Values
• Procedure to Create Desktop icon (jar file execution)

SERVLET

JEE

• JEE technology
• Components of JEE technology
• What is Enterprises Application
• What is Web Application
• Types of Web Application
• Presentation Oriented Web Application
• Service Oriented Web Application
• About Web Client, About Web Server
• About Application Server
• Diff Between Web Server And Application Server

Introduction

• Server side technologies
• Need of server side technologies
• Client side technologies
• What is Servlet? & Advantages of Servlet
• Difference between CGI and Servlet

Servlet API

• Versions of Servlet API
• Packages of Servlet API
• About Servlet Container
• Responsibilities of Servlet Container 

HTTP Protocol

• What is HTTP?
• What is HTTP Request format & Response Format?

Developing Servlet

• Servlet interface
• Methods of Servlet interface
• Developing servlet by implementing Servlet interface
• Life cycle methods of Servlet
• Webapplication directory structure
• Deployment descriptor file (web.xml)
• What is deployment?
• Types of deployments
• Deployment, Console deployment
• Tool deployment
• Deployment webapplication in tomcat server
• URL patterns