Java Database Connection: JDBC and MySQL

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