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:-

• 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