Description
In this course, you will learn:-
- Java allows you to connect to a MySQL database.
- Insert, update, and delete data using SQL commands.
- Prepared Statements are used to handle SQL arguments.
- Stored methods are called and various parameter types are handled (IN, INOUT, etc).
- BLOB and CLOB data files can be read and written.
- Use properties files to set up your database connection details.
Syllabus:-
-
Course Introduction
-
JDBC Overview
-
Database Setup Overview
-
Install the MySQL Database
-
Create New Database User in MySQL Workbench
-
Download JDBC Source Code
-
Setting up the Development Environment
-
Submitting SQL Queries
-
Getting rid of MySQL SSL Warning Message
-
Inserting Data into the Database
-
Updating Data in the Database
-
Deleting Data from the Database
-
Creating Prepared Statements
-
Calling Stored Procedures - Part 1 - IN Parameters
-
Calling Stored Procedures - Part 2 - INOUT Parameters
-
Calling Stored Procedures - Part 3 - OUT Parameters
-
Calling Stored Procedures - Part 4 - Result Set
-
Defining JDBC Transactions
-
Accessing Database MetaData
-
Reading ResultSet MetaData
-
Reading and Writing BLOBs
-
Reading and Writing CLOBs
-
Reading Database Connection Info from Properties File
-
Summar
-
Discount Coupon for More of My Java Training
-
Direct Links to My Java Courses