Java Platform: Working with Databases Using JDBC
A course for all the Java Developers who want to work with JDBC Programming.
What you'll learn
This course provides complete information which is required for JDBC Programming from Beginner Level to Advanced level by describing how to read and manage data from relational databases, calling stored procedures, working with prepared statements, transaction management, reading and storing CLOB data, storing images within the databases and retrieving the image from the database, connection pooling, working with metadata etc.
Table of contents
- Overview 1m
- Setting up the Development Environment for Java 8 4m
- Setting up the Development Environment for Oracle Database 3m
- Demo: Connecting to Oracle Database using JDBC 5m
- Setting up the Development Environment for MYSQL Database 2m
- Demo: Connecting to MYSQL Database Using JDBC 5m
- Managing Database resources 4m
- Handling JDBC Exceptions 4m
- Summary 1m
- Introduction 1m
- Executing Static SQL Statements 7m
- Iterating Through ResultSets 7m
- Understanding Scrollable ResultSets 2m
- Demo: Working with Scrollable ResultSets 5m
- Understanding Updatable ResultSets 3m
- Demo: Managing Data Using Updatable ResultSets 6m
- Understanding PreparedStatement 3m
- Demo: Retrieving Data Using PreparedStatement 5m
- Demo: Inserting the Record 8m
- Demo: Updating the Record 5m
- Demo: Removing the Record 4m
- Summary 1m
About the author
Sekhar Srinivasan (Microsoft Certified Trainer) is well known for his good track record as one of the best I.T. faculty in imparting his unique techniques in training for the past 19 years. He's trained students on various Microsoft Technologies Platforms, including VB6.0, ASP, VB.NET, C#, ASP.NET, Silverlight, ASP.NET MVC, SharePoint 2013, Azure, Xamarin.Andriod, Xamarin.iOS, Xamarin Forms, and JavaScript Frameworks. Sekhar has rich experience in technology consulting, providing solutions for c... more