Java Programming with Database Training In Chennai

Programming Courses Training in Chennai

About Java Programming with Database

  • The JDBC ( Java Database Connectivity ) API developed by Sun Microsystems, which contains interfaces and classes for writing java application to establish database connection. Using JDBC you can execute all SQL (Structured Query Language), PL/SQL or T/SQL in the heterogonous databases. JDBC API is not even use to inserting, updating , deleting and retrieving records but you can also create database objects like; table, view, stored procedure, trigger etc. You will learn how to insert, update, delete and retrieve records from database. You will also learn to create batch and execute in java, implement transactions in java, scrollable result, fixed SQL statement, parameterized SQL statement, and execute stored procedure in java and information about database and resultset. We will guide you to develop JDBC applications using different type of drivers using JDBC API. The JDBC API and JDBC Driver both are different from each other. The JDBC driver is different for different database, like MySQL driver is different than Oracle and it is also different than MS-SQL server.

Course Contents - Java

Advance JDBC Programming:

  • Overview of Database Driver Architecture
  • Introduction to JDBC Standard Extension API (javax.sql)
  • Connection Pooling
  • JDBC Programming with ORACLE, MYSQL, etc.
  • Batch Processing
  • Connecting to non-conventional databases
  • Use of Excel API
  • Database cashing (case study with HSDB,CSQL)
  • Working with Multiple Databases
  • Handling SQL escape syntax
  • Calling SQL functions, Database stored procedures
  • Dealing with Database Metadata
  • Handling Binary Data (Operation on Image File)
  • Type mapping & SQL3 Data types

Introduction to J2EE

  • J2EE Overview
  • Why J2EE?
  • J2EE Architecture
  • J2EE APIs
  • J2EE Containers

Java Server Technologies

  • Web Application Basics.
  • Architecture and challenges of Web Application.
  • Introduction to servlet
  • Servlet life cycle
  • Developing and Deploying Servlets
  • Exploring Deployment Descriptor (web.xml).
  • Handling Request and Response
  • Initializing a Servlet
  • Accessing Database
  • Servlet Chaining
  • Session Tracking & Management
  • Dealing with cookies
  • Transferring Request
  • Accessing Web Context
  • Passing INIT and CONTEXT Parameter
  • Sharing information using scope object
  • Controlling concurrent access
  • User Authentication
  • Filtering Request and Response
  • Programming Filter
  • Filter Mapping
  • Servlet Listeners

Java Server Pages Technology:

  • Basic JSP Architecture
  • Life Cycle of JSP (Translation, compilation)
  • JSP Tags and Expressions
  • Role of JSP in MVC-2
  • JSP with Database
  • JSP Implicit Objects
  • Tag Libraries

Enterprise JAVA Beans

  • Enterprise Bean overview
  • Types of enterprise beans
  • Advantages of enterprise beans
  • The Life Cycles of Enterprise Beans
  • Working with Session Beans
  • Statefull vs. Stateless Session Beans
  • Working with Entity Beans
  • Message Driven Beans

JNDI (Java Naming and Directory Interface)

  • JNDI overview
  • Context operations
  • Using JNDI in J2EE applications