Simple play icon Course
Skills

Database Applications with JDBC in Java SE Applications (Java SE 11 Developer Certification 1Z0-819)

by Kevin Jones

This course will teach you the basics of accessing databases from Java. You will learn the key interfaces for how to connect, perform queries, and process results.

What you'll learn

JDBC stands for Java Database Connectivity. In this course, Database Applications with JDBC in Java SE Applications (Java SE 11 Developer Certification 1Z0-819), you’ll learn to access databases using JDBC. First, you’ll explore creating a connection to a database using the DriverManager. Next, you’ll discover How to query and update databases with PreparedStatements Finally, you’ll learn how to execute stored procedures using CallableStatements. When you’re finished with this course, you’ll have the skills and knowledge of JDBC needed to be able to connect to a database and perform queries and updates against that database.

Course FAQ

What will you learn in this Java SE course?

In this course, you will learn about the structure of a JDBC URL, how to connect to a database, create and use a PreparedStatement, use CallableStatements, and how to iterate over result sets.

Are there any prerequisites for this course?

Before taking this course, you should be familiar with the Java Syntax and Intellij Idea.

Who is this course for?

This course is for anyone who wants to learn how to access databases using JDBC within Java SE Applications.

What are PreparedStatements?

A PreparedStatement is a feature that is used to compile SQL code and seperate it from data.

What are CallableStatements?

A CallableStatement interface allows the use of SQL statements to call stored procedures.

About the author

A long time ago in a university far, far away Kevin fell in love with programming. Initially on the university's DEC20 computer doing BASIC and Pascal and a little bit of Fortran. His first job had him writing batch PL/1 on an IBM mainframe where he also discovered the arcane delights of JCL. He soon realized the multiuser systems were not for him after discovering the delights of dBase IV on IBM PCs. From here it was all downhill as he became addicted to C and the Windows API. Just missing out ... more

Ready to upskill? Get started