Complete JDBC Programming Part-1

Introduction To JDBC
1 JDBC Agenda
2 Introduction to Advanced Java Part – 1
3 Introduction to Advanced Java Part – 2
4 JDBC in Simple Way Part- 1
5 JDBC in Simple Way Part- 2

Evolution of JDBC & JDBC API
6 Storage Areas
7 JDBC Versions
8 Evolution of JDBC Part – 1
9 Evolution of JDBC Part – 2
10 JDBC Architecture
11 How JAVA is Platform Independent & Database Independent
12 JDBC API Part -1
13 JDBC API Part – 2

JDBC Drivers
14 Types of Drivers Introduction
15 Comparison Table of All JDBC Drivers
16 Types of Drivers Type – 1
17 Types of Drivers Type – 2
18 Types of Drivers Type – 3
19 Types of Drivers Type – 4
20 Architecture Diagram of all JDBC Drivers
21 Which JDBC Driver should be used
22 Difference between thick & thin Drivers
23 Difference between 2 – Tier & 3 – Tier Drivers

Steps to Develop JDBC Application
24 Step – 1 Load and Register Driver class
25 Step-2Establish Connection between Java Application and DataBase
26 Step-3 Creation of Statement object
27 Prepare, send & Execute SQL Query Part- 1
28 Prepare, send & Execute SQL Query Part- 2
29 Prepare, send & Execute SQL Query Part- 3
30 Prepare, send & Execute SQL Query Part- 4
31 Step-5Process Result from ResultSet
32 Step-6 Close the Connection

Working with All JDBC Drivers
33 Working with Type -1 Driver
34 Working with Type – 2 Driver
35 Working with Type – 4 Driver
36 Working with Type – 3 Driver
37 Working with Type – 5 Driver
38 Summary of all JDBC Drivers
39 How to identify the class of a method
40 AutoLoading of JDBC Driver class (New Feature from JDBC 4.0V)

JDBC Programs for CRUD Operations
41 JDBC App – 1 Program to Create Table
42 JDBC App – 11 Program to Delete Multiple Rows
43 JDBC App – 12 Program to Select All Rows of Employeee Table
44 JDBC App – 13 Program to Select All Rows Based on Sorting order of Salaries
45 JDBC App – 14 Program to Select Range of Records based on Address
46 JDBC App – 15 Program to Select Range of Records based on Salary Range
47 JDBC App-16 Select Range of Records Based on initial characters of given Employ
48 Selecting Particular Columns From the Table
49 JDBC App – 17 How to Select Particular Columns From the Table
50 JDBC App – 2 Program to Drop Table
51 JDBC App – 3 Program to Insert a Single Record into Employees Table
52 JDBC App – 4 How to Read Dynamic input from Keyboard
53 JDBC – App -5 & 6 Formatting Sql Queries with Dynamic Input
54 JDBC App – 7 Program to insert Multiple Rows
55 JDBC App – 8 Program to Update Single Row
56 JDBC App – 9 Program to Update Multiple Rows
57 JDBC App – 10 Program to Delete Single Record

JDBC Programs for Aggregate Functions
58 Aggregate Functions
59 App -18To display Number of Rows by SQL Aggregate Function Count()
60 App -19Select HighestMin Salaried Employee information by Using SQL Aggregate
61 JDBC App – 20 Select Nth Highest Salaried Employee information
62 App – 21 How to display retrived data from the database through HTML

JDBC Execute method Loop Holes
63 App-22 How to execute Select and Non – Select Queries by using execute() method
64 App – 23 Execute method Loop Holes executeQuery() Vs Non -Select Query
65 App – 24 Execute method Loop Holes executeUpdate() Vs Select Query
66 App – 25 Execute method Loop Holes executeUpdate() Vs DDL

JDBC Real Time Standards
67 Importance of Java IDEs Eclipse, Netbeans, IntelliJ IDEA, BlueJ, JGrasp
68 How to download Eclipse and Run Hello World Program
69 How to develop and run JDBC Application on Eclipse
70 Working with Mysql Database
71 Working with Mysql Database – JDBC Information
72 To Copy Data from Oracle database to Mysql Database
73 JDBC Coding Standards
74 Program To Demonstrate JDBC Coding Standards