Welcome to Complete Jdbc in Simple Way Course:
Course Content:
1. Introduction
2. Jdbc Drivers
3. Steps to prepare Jdbc Applications
4. Jdbc Applications
create table
insert records
update table
delete records
drop table
select data
5. Working with various types of Drivers
6. Database MetaData
7. ResultSetMetaData
8. execute() method
9. Different Approaches to Load and Register Driver
10.Student Management System Project
11.GUI-Jdbc Integration Applications
12.Scrollable ResultSets
13.Updatable ResultSets
14.Batch Updations With Statement
15.PreparedStatement
16.Batch Updations With PreparedStatement
17.SQLInjection Attack Problem
18.BLOB and CLOB
19.CallableStatement
20.Transaction Management
21.Connection Pooling
22.RowSets
Benefits of this course:
1. This Course will provide completeness on every topic.
2. This Course will make you to Strong on Theoritically and
Programmatically
3. This Course will provide Good Platform for the Advanced
Technologies and Frameworks like Hibernate, JPA, Spring,......
4. This Course includes almost all the interview Questions
and Answers as part of the Course internally.
5. This Course will provide Downloadable Material for all the
topics which are provided in Course Content.
6. In this course we have used Oracle and MySQL Databases.
7. In This course we have used the IDEs like Eclipse and Intellij IDEA
Introduction
Jdbc is a step by step procedure to interact with database from Java applications inorder to perform database operations from Java applications.
Jdbc is a technology , not programming language, it can be used to connect with database from java applications inorder to perform database operations from Java applications.
Jdbc is an API[Predefined classes and interfaces], it can be used to connect with database from java applications inorder to perform database operations from Java applications.
Jdbc is an abstraction provided by SUN Microsystems and implemented by all database vendors to connect with database from Java applications in order to perform database operations from Java applications.
Driver is an interface existed in between java application and database, it can be used to map java presentations to Database representations and from Database representations to Java representations.
To provide Drivers, SUN Microsystems has defined a predefined interface in the form of "java.sql.Driver" and SUN Microsystems has given an option to all the Database vendors to provide their own implementation for java.sql.Driver interface.
In JDBC, all databae vendords have provided their own Driver implementations in their database Softwares, but, all these Drivers are devided into five groups, that is "five types of Drivers.
