Java Database Connection: JDBC and MySQL
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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 JainI 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.
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?
Note: This course assumes you have some knowledge of databases.
You Will Learn How To
You should have the following software already installed.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: Getting Started with JDBC|
In this video tutorial, we will present an overview of Java JDBC. We discuss the following topics:
Database Setup Overview
Install the MySQL Database
Create New Database User in MySQL Workbench
Extract the zip file.
The zip file contains all of the source code used in the course.
In this video, you will learn how to set up your development environment. This includes downloading the JDBC driver, configuring the driver in Eclipse. Finally, we'll run aprogram to test the database connection.
|Section 3: Performing Basic JDBC Operations|
In this video, you will learn how to submit a SQL query to the database and process the result set.
Getting rid of MySQL SSL Warning Message
In this video, you will learn how to insert new data into the database.
In this video, you will learn how to update data in the database.
In this video, you will learn how to delete data from the database.
In this video, you will learn how to use prepared statements with JDBC.
|Section 4: Calling Stored Procedures|
In this video, you will learn how to call stored procedures with Java. This video focuses on using IN parameters.
In this video, you will learn how to call stored procedures with Java. This video focuses on using INIOUT parameters.
In this video, you will learn how to call stored procedures with Java. This video focuses on using OUT parameters.
In this video, you will learn how to call stored procedures with Java. This video focuses on handling result sets returned from the stored procedure.
|Section 5: Transactions and MetaData|
In this video you will learn how to use transactions with JDBC. This includes how to disable the auto-commit property on a database connection. Also, you will learn how to call the methods to perform a commit or rollback.
In this video, you will learn how to access database metadata with JDBC.
In this video, you will learn how to read ResultSet metadata with JDBC.
|Section 6: Handling BLOBs and CLOBs|
In this video, you will learn how to read and write BLOBs with JDBC.
In this video, you will learn how to read and write CLOBs with JDBC.
|Section 7: Database Configuration|
In this video, you will learn how to read database connection information from a properties file.
|Section 8: Summary|
|Section 9: Discount Coupon for More of My Java Training|
Discount Coupon for More of My Java Training
Direct Links to My Java Courses
Chád (shod) Darby is an author, instructor and speaker in the Java development world.
Chád is a contributing author to several Java books, including Professional Java E-Commerce (Wrox Press), Beginning Java Networking (Wrox Press), and XML and Web Services Unleashed (Sams Publishing).
Chád has Java certifications from Oracle and IBM. He holds a B.S. in Computer Science from Carnegie Mellon University.