A 12-Step Guide to Mastering Java JDBC

Focused View

Mary Smith

45:14

8 View

1. Introduction

1. Introduction to Java JDBC.html

2. Download the Java connector

1. Download the mySQL driver.mp4

03:08

2. Create a database connection from Java using JDBC.mp4

04:46

3. Select Queries

1. SQL Select statement with JDBC.mp4

04:14

2. SQL Select with an empty resultset, no records are returned.mp4

00:57

3. SQL Select using parameters.mp4

07:14

4. Update, Insert and Delete Queries

1. SQL Update with JDBC.mp4

01:31

2. SQL Update with JDBC with a parameter.mp4

05:23

3. SQL Insert with JDBC.mp4

01:04

4. SQL Insert with JDBC with parameters.mp4

06:05

5. SQL Delete with JDBC.mp4

01:21

6. SQL Delete with JDBC with parameters.mp4

02:21

5. Create and Drop Table Queries

1. Create a table.mp4

04:11

2. Drop a table.mp4

02:59

Description

Database connectivity, access your database via Java

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

Who is this for?

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

What You Need to Know?

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

More details

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.
Who this course is for:
This course is for Java Developers who would like to develop database drive apps (desktop and mobile)

User Reviews

Rating

average 0

Total votes0

Focused display

Working in London in the UK, I have been coding as Java Specialist since 2006. I also get involved with data cleaning and restructuring, using mainly Python. Before 2006 I worked in a number of different using SQL, C++, Cobol and PL/1. With many years of experience I feel it is nice to diversify and also assist starters on their journey into this exciting career.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.