Language: English (US)

Java Database Connectivity | JDBC | Advance Java Concepts

https://www.udemy.com/course/java-database-connectivity-jdbc-advance-java-concepts/

Course Topics:

Java Database Connectivity (JDBC) is an API in Java that enables applications to interact with databases. It provides methods for querying and updating data in relational databases. JDBC supports various operations, including connecting to a database, executing SQL statements, and retrieving results. Advanced JDBC concepts include managing transactions, using batch processing for executing multiple queries efficiently, and implementing connection pooling to optimize resource usage. JDBC also supports using Prepared Statements to prevent SQL injection and improve performance. These capabilities make JDBC a critical tool for developing robust and efficient database-driven applications in Java.

We are going to learn below topics in this series apart from theory we will understand everything by doing practical example

1. What is JDBC API | Introduction to JDBC API 

2. What are the types of JDBC Driver

3. Software and libraries required for JDBC Program

4. How to connect JDBC program with MySQL database | JDBC Connection Program

5. JDBC Program to create database from Java Program

6. JDBC Program to create table in MySQL Database

7. JDBC Program to insert data in MySQL Database

8. JDBC Program to update data in MySQL Database

9. JDBC Program to delete data in MySQL Database

10. What is ResultSet interface ?

11. JDBC Program to get data from MySQL Database ?

12. What is PreparedStatement ? How it's easy to use from Statement ?

13. What is ResultSetMetaData ?

14. What is DatabaseMetaData ?

15. What is Batch Processing ?

16. What is JDBC RowSet ?

17. Difference B/W executeUpdate() VS executeQuery() VS execute() ?

18. PROJECT - 1 : Student Management Application

19. PROJECT - 2 : ATM Application