Overview

1. Introduction to advance java part-1JDBC AgendaWhat 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 JDBC2. Introduction to adv java part-2Understand JDBC in simple wayUnderstand role of JDBC Components3. Storage area , Query Processing SystemWhat is storage area?How many types of storage area?What is File system and disadvantagewhy 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 architectureWhat is JDBC ? JDBC features ?Evolution of JDBC ? how how it will come? Difference b/w JDBC and ODBCJDBC Architecture and how it will provide to us ? role of DriverManager5. JDBC API , Types of DriverHow 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 Driver6. Standard Steps to develop JDBC application , Programs , Types of SQL QueryEstablish the connectoin b/w java application and databaseCreate Statement ObjectSend and execute SQL queryClose the connection Types of SQL QueryexecuteQuery() executeUpdate()execute()App1--> Connection programApp2--> create table by using static queryApp3--> create table by taking table name as user input (dynamic query)App4--> insert records by using static queryApp5--> insert records by taking input user input (dynamic query)App6--> JDBC Applicaiton to Update records by new way of registering driverApp7--> JDBC Application to delete records by using static queryApp8--> 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 dataApp10--> JDBC Applicaiton to select all rows from the table based on Sorting ordersApp11--> JDBC Applicaiton to select particular coloum from table to print dataApp12--->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 data7. Working with MetaData1. MetaData Introduction2. How many types of MetaData are there ? DatabaseMetaData introductionApp16--> JDBC Application to work with DatabaseMeta data and print all Database detials3. ResultSetMeta Data introductionApp17--> 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 userApp19-->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 fileApp21--> Employee app9. Working with ResultSet types1. Understand previous working of ResultSet and Understand Types of ResultSet2. How to get required ResultSet objectApp22-->JDBC Application to check whether database support particular types of ResultSet or not3. 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 directionApp24--> JDBC Application to navigate records using SCROLLABLE_RESULTSETApp25--> without using insert sql query insert record into database using SCROLLBLE_RESULTSETApp26--> without using update sql query update record into database using SCROLLBLE_RESULTSET App27--> without using delete sql query delete record into database using SCROLLBLE_RESULTSET10. Working with properties file and ConnectionFactory1. Properties intro2. App28 fetch the records by using properties file3. Connection factory introApp29--> Jdbc Application to fetch the data App29 (a) --> Jdbc Application to update the data 11. Batch Updations and PreparedStatement1. 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 IMAGEApp30--> Jdbc Application to demonstrate the batch updations2. Need of PreparedStatement give ex.1 and ex.23. Advantage / Disadvantage of PreparedStatement4. Difference b/w Statement and PreparedStatementApp31--> Jdbc Application to insert records using PreparedStatementApp32--> Jdbc Application to update records using PreparedStatementApp33--> Jdbc Application to delete records using PreparedStatementApp34--> Jdbc Application to fetch records using PreparedStatementApp35--> Jdbc Application to perform batch updations using PreparedStatement12. BLOB and CLOB1. Intro to BLOB datatype and understanding architecture to insert BLOB data in DatabaseApp36--> Jdbc Application to insert BLOB data into Database2. Intro to BLOB datatype and understanding architecture to insert BLOB data in DatabaseApp37--> Jdbc Application to retrieve BLOB data into DatabaseApp38--> Jdbc Application to insert CLOB data into DatabaseApp39--> Jdbc Application to retireve CLOB data from Database13. Connection Pooling1. Connection Pooling IntroApp40--> 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. CallableStatement1. 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 Procedures5. Syntax of Stored functionApp43--> Demonstrate use of Store ProceduresApp44--> Demonstrate use of Store FunctionsApp45--> Demostrate use of SYS_REFCURSOR type variableApp46--> use of SYS_REFCURSOR type variable in FUNCTION15. Transaction Management and Savepoint1. Transaction Management intro Atomicity and Consistency principle2. Transaction Management Isolation and Durablity principle3. How to achieve atomicity in JDBCApp47--> Transaction Management achieve atomicity using commit() and rollback()App48---Savepoint and JDBC Application to demostrate use of Savepoint16. RowSets1. Introduction to RowSets ? Types of RowsetsDifference b/w ResultSet and RowSetApp49-->To create different RowSet objects2. Introduction to JDBCRowsetApp50--> To retrieve records from JDBCRowsetApp51--> To insert records using JDBCRowsetApp52--> To update records using JDBCRowsetApp53--> To delete records using JDBCRowset3. Introduction to CachedRowsetApp54--> To demonstrate Disconnected CachedRowsetApp55--> To retrieve records using CachedRowsetApp56--> To insert records using CachedRowsetApp57--> To update records using CachedRowset4. Introduction to WebRowsetApp58--> To retrieve records using WebRowsetApp59--> To insert records using WebRowsetApp60--> To delete records using WebRowset5. Introduction to JoinRowsetApp61--> To retrieve records using JoinRowset6. Introduction to FilteredRowsetApp62--> To retrieve records using JoinRowset

Skills

Reviews