What you'll learn

Explain in simple terms how to access a SQL database using Java JDBC

Establish a connection with a SQL Database

Which libraries are needed in Java to use JDBC

Installing and configuring for JDBC

Requirements

Basics of Java: Variables, Loops, If-else, Arrays, OOP Basics

Description

This brief yet comprehensive course covers everything you need to know about using JDBC to create and run SQL statements in your Java program.This is a very important aspect of your Java Programming. All programs need data, and mostly this will be stored in a database. So this knowledge is really crucial for all Java programmers. This course is easy and I provide a little template that is usable for most of your JDBC code.You'll discover how to download Java connector .jar files for your database, set up Java for JDBC, and execute SQL queries. For every database, the downloads are available on different sites, e.g. Microsoft SQL Server, MySQL, PostgreSQL, MariaDB, etc. However, once you have the .jar file, the configuration process is the same for all.The course includes lessons on creating and dropping tables, selecting records, displaying result sets, inserting records, deleting records, and updating records.While I plan to add cool demos of real-life examples later, for now, I want to keep the content concise.If you're already familiar with Java and SQL, this course should be all you need.I really hope that you will enjoy the videos that I have uploaded and that the course will be the easiest way to learn the techniques covered.

Overview

Section 1: Introduction

Lecture 1 Introduction to Java JDBC

Section 2: Download the Java connector

Lecture 2 Download the mySQL driver

Lecture 3 Create a database connection from Java using JDBC

Section 3: Select Queries

Lecture 4 SQL Select statement with JDBC

Lecture 5 SQL Select with an empty resultset, no records are returned

Lecture 6 SQL Select using parameters

Section 4: Update, Insert and Delete Queries

Lecture 7 SQL Update with JDBC

Lecture 8 SQL Update with JDBC with a parameter

Lecture 9 SQL Insert with JDBC

Lecture 10 SQL Insert with JDBC with parameters

Lecture 11 SQL Delete with JDBC

Lecture 12 SQL Delete with JDBC with parameters

Section 5: Create and Drop Table Queries

Lecture 13 Create a table

Lecture 14 Drop a table

This course is for Java Developers who would like to develop database drive apps (desktop and mobile)