Diploma in Java Programming with Database Training Module

Diploma in 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.

Duration

180 Hours

Diploma in Java Programmig with Database
    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
    • JNDI API
    • Context operations
    • Using JNDI in J2EE applications

You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

Best - SAP training center in London.