Java Database Connection: JDBC and MySQL

This course assumes you have some knowledge of databases.

———-

Join 15,000+ highly engaged students

All source code is available for download

A responsive instructor is available to answer your questions.

———-

Excellent 5-Star Reviews!

Very well-designed course. I like the clarity and delivery of content. I wish there were more courses from Chad !!!!

– Satish Jain

I have to say that I was extremely pleased to note that his lecture material was straightforward and to the point. I was also impressed with how well he structured the contents! His presence was felt as he periodically showed interest in my progress. I would recommend his material to anyone interested in expanding their programming knowledge with additional tools.

– Marc-Alexandru

If you want to learn everything about JDBC – this is the course for you! Excellent content. Brilliant explanation.

– Vishal Kumar

———-

In this course, you



learn how to connect to a MySQL database using Java JDBC



.

The course starts with an overview of the JDBC API. Then you learn how to



set up your development environment



with the appropriate MySQL database drivers. Next, the course shows you how to



submit a SQL query and process the result set



. Also, you learn how to perform



SQL insert, updates, and deletes



.

The course moves on to



advanced topics



such as



Prepared Statements



to handle SQL parameters. You also learn how to call



stored procedures



using various parameter types (IN, INOUT, OUT, and ResultSet). Next, the course shows you how to process large data types such as



BLOBs and CLOBs



. Finally, the course wraps up with a section on reading database connection information from a configuration file.

Who Is This Course Suitable For?

• Java developers: beginner, intermediate or advanced

Note: This course assumes you have some knowledge of databases.

You, Will, Learn How To

• Connect to a MySQL Database with Java
• Submit SQL statements to insert, update and delete data
• Handle SQL parameters with Prepared Statements
• Calls stored procedures and handle various parameter types (IN, INOUT, etc..)
• Read and write BLOB and CLOB data files
• Configure your database connection information with properties files

Source Code

• All source code is available for download
• All database scripts are available for download

Course Requirements

You should have the following software already installed.

• MySQL Database
• Java Development Kit