Java Database Connection: JDBC and MySQL

Visit Tutorial Page ( Report)
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 Who is the target audience? The course is appropriate for all Java developers: beginners to advanced
  • Introduction
    00:01:28
    • Course Introduction
      00:01:28
  • Getting Started with JDBC
    00:20:42
    • JDBC Overview
      00:06:00
    • Database Setup Overview
      00:00:26
    • Install the MySQL Database
      00:04:49
    • Create New Database User in MySQL Workbench
      00:03:05
    • Download JDBC Source Code
      00:00:01
    • Setting up the Development Environment
      00:06:21
  • Performing Basic JDBC Operations
    00:16:56
    • Submitting SQL Queries
      00:00:21
    • Getting rid of MySQL SSL Warning Message
      00:03:56
    • Inserting Data into the Database
      00:02:33
    • Updating Data in the Database
      00:03:01
    • Deleting Data from the Database
      00:02:26
    • Creating Prepared Statements
      00:04:34
  • Calling Stored Procedures
    00:16:04
    • Calling Stored Procedures - Part 1 - IN Parameters
      00:06:16
    • Calling Stored Procedures - Part 2 - INOUT Parameters
      00:03:07
    • Calling Stored Procedures - Part 3 - OUT Parameter
      00:03:57
    • Calling Stored Procedures - Part 4 - Result Set
      00:02:44
  • Transactions and MetaData
    00:14:51
    • Defining JDBC Transactions
      00:05:49
    • Accessing Database MetaData
      00:05:12
    • Reading ResultSet MetaData
      00:03:50
  • Handling BLOBs and CLOBs
    00:13:12
    • Reading and Writing BLOBs
      00:07:29
    • Reading and Writing CLOBs
      00:05:52
  • Database Configuration
    00:03:07
    • Reading Database Connection Info from Properties File
      00:03:07
  • Summary
    00:01:11
  • Discount Coupon for More of My Java Training
    00:00:51
    • Discount Coupon for More of My Java Training
      00:00:41
    • Direct Links to My Java Courses
      00:00:10
Write Your Review

Reviews