Java Database Connection: JDBC and MySQL

Learn how to connect to a MySQL database with Java JDBC

4.46 (17317 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
Java Database Connection: JDBC and MySQL
203,148
students
1.5 hours
content
Feb 2024
last update
FREE
regular price

What you will learn

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

Description

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

Content

Introduction

Course Introduction

Getting Started with JDBC

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

Performing Basic JDBC Operations

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

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

Transactions and MetaData

Defining JDBC Transactions
Accessing Database MetaData
Reading ResultSet MetaData

Handling BLOBs and CLOBs

Reading and Writing BLOBs
Reading and Writing CLOBs

Database Configuration

Reading Database Connection Info from Properties File

Summary

Summary

Discount Coupon for More of My Java Training

Discount Coupon for More of My Java Training
Direct Links to My Java Courses

Reviews

Bexel
November 1, 2023
I was in a point not knowing how to connect MySQL with Eclipse and to run some SQL Queries in the database from a Java Application, this course really crafted me for an Initial grip.
Divey
September 9, 2023
Thanks for the course. It was really great and a must for every java beginner to understand what is coding.
Maja
August 20, 2023
The course was really informative and concise, while containing enough examples and repetition to stick in my memory. Thank you for making this course!
Koushick
August 10, 2023
This Course is recommended to anyone who want to learn and explore database with java from scratch! In this course we can get hands on knowledge very well..thanks for creating such a nice course!
Jaswanth
July 1, 2023
my first course taken was jsp ,well its on you tube channel and im working on my project now so im learning JDBC and im so glad that this course is a free course
Anonymized
June 8, 2023
I learned a lot from this course but one thing I dislike about this course is author's pace. He just skipped explaining helper functions and It would be a lot better if he could type the code while explaining rather than just explaining the code like a presentation
Fernando
May 22, 2023
Content is good and the level of difficulty is appropriate for beginners, however there are quite a few subjects for which you may need to research on beforehand.
Ed
February 2, 2023
Subtitles or not accurate. The version in the course is old, the interface and drivers are much newer. I use Visual Code and not Eclipse, so I had some difficulty to link the new MySQL jar to the Java-programs. When the connection is working, the programs and examples are clear. I enjoyed the course. Good luck.
Aathinarayanan
January 2, 2023
Yeah it is actually good, But my suggestion is, it is more easy to understand when they code during their lecture. It is somewhat theoretical.
Tarlan
December 31, 2022
Для новичков самый раз. Жаль, что нет русских субтитров. А то иногда не успевал за преподавателем, приходилось пересматривать.
Venkataramana
November 9, 2022
Frankly, preferred hands-on approach and live coding to demonstrate, instead of explaining the "before-hand existing set-up code". Nevertheless, the standard & quality of the course is excellent with simple explanations by Chad Darby. Must have collection and buy. Cheers!!!
Lucio
November 2, 2022
los pasos a seguir la instalación no fueron muy claro y no coincide con los que aparece en la instalación ya que no esta esa versión.
Michal
October 31, 2022
Very good and fast for basic understanding and using db connection with java. Not a lot of content which is good for this type of course. Straight on point.
Minh
September 11, 2022
Your lecture is excellent and easy to understand! I hope you will make more free lectures like it in the future as your hobby, like an open source project! Hu-huh!
Saikat
September 9, 2022
Understandable but if we get some quizzes and programs to write in between the course it would be beneficial to us, rest all the things were perfect and easy to understand.

Charts

Price

Java Database Connection: JDBC and MySQL - Price chart

Rating

Java Database Connection: JDBC and MySQL - Ratings chart

Enrollment distribution

Java Database Connection: JDBC and MySQL - Distribution chart
366280
udemy ID
12/9/2014
course created date
10/10/2019
course indexed date
Bot
course submited by