Udemy

Java Database Connection: JDBC and MySQL

Name: Java Database Connection: JDBC and MySQL
Availability: InStock
Rating: 4.5 (20564 reviews)

4.5(20,564)228k students

Korshub's take

Overview

This course walks through connecting Java applications to a MySQL database using JDBC, starting with an overview of the JDBC API and environment setup with the correct MySQL drivers. From there it covers submitting SQL queries and processing result sets, followed by inserts, updates, and deletes.

Who It's For

Java developers at any level, from beginner to advanced, who already have some familiarity with databases and want to add JDBC to their toolkit for real database-driven applications.

Key Takeaways

Connect to and query a MySQL database from Java
Perform SQL insert, update, and delete operations
Use Prepared Statements to handle SQL parameters safely
Call stored procedures with IN, OUT, INOUT, and ResultSet parameters
Read and write BLOB and CLOB data, and manage connection settings via properties files

About this course

This course assumes you have some knowledge of databases.

----------

Join 15,000+ highly engaged students

All source code is available for download

Responsive instructor available to answer your questions.

----------

Excellent 5-Star Reviews!

Very well designed course. I like clarity and delivery of contents. 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 definitely 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 paramaters. 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

Java Database Connection: JDBC and MySQL

Java Database Connection: JDBC and MySQL

Korshub's take

Overview

Who It's For

Key Takeaways

About this course

Related deals

Working with FileMaker Starter Solutions

Mobile Application Development using Android

React.js - Let's build a Tic Tac Toe game.

JourneyApps Training - Foundations