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.
Course Overview Hi everyone. This is Sekhar Srinivasan and welcome to my course, Java Platform: Working with Databases Using JDBC. I'm a corporate trainer and a senior architect at LS Solutions Private Limited. Java Database Connectivity, JDBC, is a API for connecting programs written in Java to any database. This course is a quick introduction to develop Java applications for interacting with a database such as Oracle and MySQL using JDBC. Some of the major topics that will be covered includes performing basic CRUD operations using JDBC statements and prepared statements, working with stored procedures using callable statements, managing transactions, working with BLOB and CLOB, working with metadata and pooling database connections. By the end of this course you will have a solid foundation to get started developing Java applications for interacting with any database. Before learning this course you should be familiar with core Java. I hope you will join on this journey to learn JDBC with the Java platform, working with databases using JDBC course at Pluralsight.
Introduction Hi, this is Sekhar Srinivasan for Pluralsight. This course especially designed for Java programmers who would like to understands the JDBC framework in detail along with its architecture and actual usage. This course consists of eight modules where the first and second module provides a complete knowledge, which is required for working with databases using JDBC and also helps in understanding the remaining modules efficiently. The third module explains how to perform the basic CRUD operations using JDBC and then we will understand how to work with stored procedures, what transaction management is and how to achieve transaction management using JDBC. This course also explains how to store and retrieve images and files from the database. We will also understand the importance of working with metadata and connection pooling. This course assumes that the attendees have a basic understanding of Java programming language and also have a prior exposure to any database. Now let us understand what is JDBC.
Getting Started with JDBC Hi, this is Sekhar Srinivasan for Pluralsight. In this module we shall understand everything which is required to get started with the JDBC. We will understand how to set up the development environment to support Java 8. We shall understand how to set up the environment for Oracle database and MySQL database. And also, we shall understand the essentials which are required to connect Oracle and MySQL database, and along with that we shall also understand how to use the database resources efficiently and handle the JDBC exceptions. Now let's get started.
Performing Basic CRUD Operations Using JDBC Hi, this is Sekhar Srinivasan for Pluralsight. In the last module we have understood how to get started with the JDBC. Now in this module we will understand how to execute static SQL statements, what is ResultSet, and we will understand the types of ResultSet such as scrollable ResultSet, updatable ResultSet, and we will also understand what is prepared statement and how to retrieve insert, update or remove the records using prepared statement. By the end of this module we will be able to perform basic operations using JDBC. Now let us get started.
Working with BLOB and CLOB Hi this is Sekhar Srinivasan for Pluralsight. In this module we shall understand how to store and retrieve CLOB data, that is large text contents of file within the database and also we shall understand how to store BLOB data, that is binary data such as an image within the database, and retrieve the image from the database. Now let's get started.
Working with Metadata Hi, this is Sekhar Srinivasan for Pluralsight. In simple terms, data about data is called as metadata, that is gathering much information about given information. In JDBC metadata programming is useful to know the capabilities, limitations, and facilities of underlying database software and its resources. JDBC supports the following metadata programming concepts. Database Metadata, ResultSet Metadata, Parameter Metadata where maximum vendors of JDBC drivers have not provided proper implementation for parameter metadata interface. In this module we shall understand what is database metadata and how to access the database related information, the tables, and the column details using the database metadata. And also we shall understand the ResultSet metadata with proper demos. Now let's get started.