Complete JDBC Programming With Advanced Concepts

Complete JDBC Programming With Advanced Concepts free download

Covers all the advanced topic according to industrial point of view with crystal clear explanation

1. Introduction to advance java part-1

• JDBC Agenda

• What is adv java ? and what is the need of learning adv-java?

• How many types of application are in java?

• How many editions are available in java?

• Version of JDBC

2. Introduction to adv java part-2

• Understand JDBC in simple way

• Understand role of JDBC Components

3. Storage area , Query Processing System

• What is storage area?How many types of storage area?

• What is File system and disadvantage

• why we use database ? limitation is comparison with data warehouses?

• Query Processing System ?

     step 1: Query tokenization

     step 2: Query processing

     step 3: Query optimization

     step 4: Query Execution

4. Introduction to JDBC , Evolution of JDBC , JDBC architecture

• What is JDBC ? JDBC features ?

• Evolution of JDBC ? how how it will come?

• Difference b/w JDBC and ODBC

• JDBC Architecture and how it will provide to us ? role of DriverManager

5. JDBC API , Types of Driver

• How many packages is JDBC API ?

• Difference b/w Driver interface  , Driver class ,  Driver software

• Types-1 Driver ? advantages ? Disadvantages ? 

• Types-2 Driver ? advantages ? Disadvantages ?

• Types-3 Driver ? advantages ? Disadvantages ? 

• Types-4 Driver ? advantages ? Disadvantages ?

• Summary of all the Driver.

• comparison table of all JDBC Driver

  
  

6. Standard Steps to develop JDBC application , Programs , Types of SQL Query

• Establish the connectoin b/w java application and database

• Create Statement Object

• Send and execute SQL query

• Close the connection

• Types of SQL Query

• executeQuery() 

• executeUpdate()

• execute()

• App1---> Connection program

• App2---> create table by using static query

• App3---> create table by taking table name as user input (dynamic query)

• App4---> insert records by using static query

• App5---> insert records by taking input user input (dynamic query)

• App6---> JDBC Applicaiton to Update records by new way of registering driver

• App7---> JDBC Application to delete  records by using static query

• 
  

• App8---> JDBC Applicaiton to delete  records by taking input user input (dynamic query)

• App9---> JDBC Applicaiton to select all rows from the table to print all data

• App10---> JDBC Applicaiton to select all rows from the table based on Sorting orders

• App11---> JDBC Applicaiton to select particular coloum from table to print data

• App12----->JDBC Applicaiton to select range of records based on address(take address as user input)

• App13---> JDBC Applicaiton to  to select range of records based on salary(take salary as user input)

• App14---> JDBC Applicaiton for try with resources

• App15---> JDBC Applicaiton to fetch all the data

7. Working with MetaData

• 1. MetaData Introduction

• 2. How many types of MetaData are there ? DatabaseMetaData introduction

• App16----> JDBC Application to work with DatabaseMeta data and print all Database detials

• 3. ResultSetMeta Data introduction

• App17----> JDBC Application which shows that how to know the coloum name and type of unknown database by using ResultSetMetaData rmd = rs.getMetaData;

• App18---->  JDBC Application that take table name as a dynamic input and print table coloum and table data of that particular table which was entered by user

• App19---->Java application that take dynamic SQL Query it may be non-select or select SQl Query

•                     >>> if it is select SQL Query then it return true so simply print records of the table

•                     >>> if it is non-select SQL Query then it return false so we have to update the Database....

• App20----> Java Application that takes table name as a dynamic input and then fetch the data and tranfered to the desired  location in the form of html file

• App21----> Employee app

9. Working with ResultSet types

• 1. Understand previous working of ResultSet and Understand Types of ResultSet

• 2. How to get required ResultSet object

• App22--->JDBC Application to check whether database support particular types of ResultSet or not

• 3. List of allowed methods on (Forward only ResultSet) Non-Scrollable ResultSet

•     |- rs.next()

•     |- rs.getXxx()

•     |- rs.getRow()

• 4. List of allowed methods on Scrollable ResultSets

•     |- rs.previous()

•     |- rs.beforeFirst()

•     |- rs.afterLast()

•     |- rs.first()

•     |- rs.last()

•     |- rs.absolute(int record_position)

•     |- rs.relative (int no_of_Records)

•     |- refreshRow()

•     |- rs.setFetchSize(int no_of_Records)

•     |- rs.isFirst()

• 
  

• App23---> use of next() and previous() to fetch data in both backward and forward direction

• App24---> JDBC Application to navigate records using SCROLLABLE_RESULTSET

• App25---> without using insert sql query insert record into database using SCROLLBLE_RESULTSET

• App26---> without using update sql query update record into database using SCROLLBLE_RESULTSET

• App27---> without using delete sql query delete record into database using SCROLLBLE_RESULTSET

10. Working with properties file and ConnectionFactory

• 1. Properties intro

• 2. App28 fetch the records by using properties file

• 3. Connection factory intro

• App29---> Jdbc Application to fetch the data

• App29 (a) ----> Jdbc Application to update the data

11. Batch Updations and PreparedStatement

• 1. Need of batch updations ? Intro to batch updations ? Advantage of batch updations ? Disadvantage of batch updations ? how we can implement batch updations how many methods are there ? UNDERSTAND BY IMAGE

• App30----> Jdbc Application to demonstrate the batch updations

• 2. Need of PreparedStatement

•      give ex.1  and ex.2

• 3. Advantage / Disadvantage of PreparedStatement

• 4. Difference b/w Statement and PreparedStatement

• App31---> Jdbc Application to insert records using PreparedStatement

• App32---> Jdbc Application to update records using PreparedStatement

• App33---> Jdbc Application to delete records using PreparedStatement

• App34---> Jdbc Application to fetch records using PreparedStatement

• App35---> Jdbc Application to perform batch updations using PreparedStatement

12. BLOB and CLOB

• 1. Intro to BLOB datatype and understanding architecture to insert BLOB data in Database

• App36---> Jdbc Application to insert BLOB data into Database

• 2. Intro to BLOB datatype and understanding architecture to insert BLOB data in Database

• App37---> Jdbc Application to retrieve BLOB data into Database

• App38---> Jdbc Application to insert CLOB data into Database

• App39---> Jdbc Application to retireve CLOB data from Database

13. Connection Pooling

• 1. Connection Pooling Intro

• App40---> JDBC Application to demonstrate Connection Pooling Mechanism by using Default DataSource Object[Approach -1]

• App41---> JDBC Application to demonstrate Connection Pooling Mechanism by using DataSource Object Provided By Database software Vendor [Approach -2]

• App42---> JDBC Application to demonstrate Connection Pooling Mechanism by Third party provided Connection Pooling Mechanism[DBCP Connection Pooling]

14. CallableStatement

• 1. Callable Statement intro

• 2. Difference b/w Statement , PreparedStatement and CallableStatement ?

• 3. What is the difference b/w stored procedures and stored function ?

• 4. Syntax of Stored Procedures

• 5. Syntax of Stored function

• App43---> Demonstrate use of Store Procedures

• App44---> Demonstrate use of Store Functions

• App45---> Demostrate use of SYS_REFCURSOR type variable

• App46---> use of SYS_REFCURSOR type variable in FUNCTION

15. Transaction Management and Savepoint

• 1. Transaction Management intro Atomicity and Consistency principle

• 2. Transaction Management Isolation and Durablity principle

• 3. How to achieve atomicity in JDBC

• App47---->  Transaction Management achieve atomicity using commit() and rollback()

• App48-----Savepoint and  JDBC Application to demostrate use of Savepoint

16. RowSets

• 1. Introduction to RowSets ? Types of Rowsets

• Difference b/w ResultSet and RowSet

• App49--->To create different RowSet objects

• 
  

• 2. Introduction to JDBCRowset

• App50---> To retrieve records from JDBCRowset

• App51---> To insert records using JDBCRowset

• App52---> To update records using JDBCRowset

• App53---> To delete records using JDBCRowset

• 
  

• 3. Introduction to CachedRowset

• App54---> To demonstrate Disconnected CachedRowset

• App55---> To retrieve records using CachedRowset

• App56---> To insert records using CachedRowset

• App57---> To update records using CachedRowset

• 
  

• 4. Introduction to WebRowset

• App58---> To retrieve records using WebRowset

• App59---> To insert records using WebRowset

• App60---> To delete records using WebRowset

• 
  

• 5. Introduction to JoinRowset

• App61---> To retrieve records using JoinRowset

• 
  

• 6. Introduction to FilteredRowset

• App62---> To retrieve records using JoinRowset

•