Complete JDBC Programming Part-2
Master advanced Java database programming with classroom videos. Learn left and right joins and more!
Course Content
Complete JDBC Programming Part-2 is an all-levels Udemy course taught by DURGASOFT DURGA. It runs 31h 19m, is taught in English, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 601 reviews, with 4,735 students enrolled. It is a paid course, last updated August 2019.
JDBC (Java Database Connectivity): Master Java Database Programming
This course provides a comprehensive understanding of JDBC, the foundational technology for Java database programming. You'll build a strong foundation in advanced database concepts and learn to effectively interact with various database systems.
Here's a detailed breakdown of the topics covered:
- SQL Query Execution Lifecycle: Understand the complete process of how SQL queries are executed within a Java application.
- PreparedStatement: Learn to use PreparedStatement for secure and efficient database interactions, preventing SQL injection vulnerabilities.
- Statement vs. PreparedStatement: Explore the key differences between Statement and PreparedStatement and when to use each for optimal performance and security.
- SQL Injection Attacks: Gain insights into SQL injection attacks and how to prevent them using PreparedStatement.
- Stored Procedures: Discover how to leverage Stored Procedures to enhance code reusability and improve database performance.
- Callable Statement: Learn to execute Callable Statements to invoke stored procedures and functions.
- Cursors: Understand the use of Cursors for iterating through result sets, particularly useful for large datasets.
- Functions: Explore the use of functions within your Java database applications.
- Statement vs. PreparedStatement vs. CallableStatement: A detailed comparison of these three key JDBC statement types.
- Batch Updates: Implement batch updates for significantly improved database write performance.
- executeQuery vs. executeUpdate() vs. execute() vs. executeBatch(): Master the different
executemethods and their appropriate use cases for various database operations. - Insert & Retrieve Date Values: Learn best practices for handling date values during database insertion and retrieval.
- BLOB & CLOB Introduction: Understand the concepts of BLOB (Binary Large Object) and CLOB (Character Large Object) data types.
- Insert & Retrieve BLOB Type: Learn how to efficiently insert and retrieve BLOB data from the database.
- Insert & Retrieve CLOB Type: Master the techniques for inserting and retrieving CLOB data.
- Connection with Properties: Configure database connections using properties files for easy management.
- Working with Properties: Learn how to effectively read and utilize properties files for connection parameters.
- Different Ways to Get Connection Object: Explore various methods for obtaining a connection object in your Java application.
- Transaction Management: Implement robust transaction management to ensure data consistency and integrity.
- Savepoint: Utilize savepoints within transactions for finer-grained control over transaction boundaries.
- Transaction Concurrency Problems & Isolation Levels: Understand transaction concurrency problems and how to manage them using different isolation levels.
- Metadata: Explore database metadata, including ResultSetMetaData and ParameterMetaData, for dynamic query generation and data validation.
- JDBC with Non-Traditional Databases like Excel: Learn how to connect and interact with non-traditional databases, such as Excel spreadsheets.
- ResultSet Types: Understand different ResultSet types, including Forward only, Scrollable, Scroll sensitive, and Scroll insensitive.
- ResultSet Holdability: Learn about ResultSet holdability and its impact on performance.
- RowSets vs. ResultSets: Understand the differences between RowSets and ResultSets and when to use each.
- Working with all RowSets: Learn how to efficiently process all RowSets returned by your queries.
- Miscellaneous Types like RowId etc.: Explore other useful JDBC data types like RowId.
- Topmost Important JDBC FAQs: Get answers to frequently asked questions about JDBC to solidify your understanding.
This course equips you with the skills to build robust, secure, and efficient Java applications that interact with databases.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.