|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-advance-jdbc-programming-by-kool-nigam/
课程评论：没有评论
课程名称：完成JDBC编程与高级概念 课程概述： 本课程涵盖完整的JDBC编程，旨在深入介绍JDBC的高级概念。课程内容包括： 1. **高级Java简介**： - 什么是高级Java，学习的必要性。 - Java应用类型和版本谈论JDBC的演变。 2. **JDBC基础**： - 解释JDBC及其组件的角色，如何简化数据库操作。 3. **存储区域与查询处理系统**： - 探讨存储区域的类型及其与文件系统和数据仓库的比较。 - 介绍查询处理的步骤：分词、处理、优化和执行。 4. **JDBC架构与API**： - JDBC的特性及其架构，JDBC与ODBC的区别。 - 各类型驱动及其优缺点的比较。 5. **JDBC应用开发标准步骤**： - 连接数据库，创建语句对象及执行SQL查询的步骤。 - 多种SQL查询的应用实例，如创建表、插入、更新和排序数据。 6. **元数据的使用**： - 介绍数据库元数据及结果集元数据的使用实例。 7. **结果集的工作原理**： - 理解不同类型的结果集，并提供相关的操作示例。 8. **属性文件与连接工厂**： - 使用属性文件访问数据，介绍连接工厂的概念。 9. **批量更新与准备语句**： - 讲解批量更新的优缺点，准备语句的使用优劣比较。 10. **BLOB与CLOB**： - 介绍BLOB和CLOB数据类型的操作，包括数据插入和检索的实例。 11. **连接池**： - 连接池机制的概述及几种实现方法的例子。 12. **调用语句与存储过程**： - 调用语句的使用和存储过程的语法与示例。 13. **事务管理与保存点**： - 事务管理的基本原理，包括原子性、一致性及如何在JDBC中实现它们。 14. **RowSets的介绍**： - 讲解RowSets类型及其与ResultSets的区别，通过实例演示其操作。 本课程通过理论讲解与实际编程练习相结合，帮助学习者深入理解JDBC及其在Java应用程序中的重要性。
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
