Learn The Fundamentals of Java Database Connectivity (JDBC)
What you will learn
Learn the fundamentals of JDBC
How to use it to read and manage data from relational databases
Learn JDBC terms
Basics of configuring a PostgreSQL database
Create, read, update, and delete data
Using stored procedures
Ordering and limiting results
Transactions in JDBC
Handling exceptions
much more!
Description
In this course, we will go over the fundamentals of Java Database Connectivity (JDBC). Learn the basics of the JDBC API. We’ll get started by setting up a basic database development environment.
You will learn how to use it to read and manage data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server in applications programmed with Java.
We’ll start with key JDBC terminology, the basics of configuring a PostgreSQL database, and how to create the course project. We’ll then get into how to select and update data, work with transactions, handle exceptions, and more.
JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE. JDBC API uses JDBC drivers to connect with the database. It provides the language with java database connectivity standards. It is used to write programs required to access databases. JDBC, along with the database driver, can access databases and spreadsheets. The enterprise data stored in a relational database(RDB) can be accessed with the help of JDBC APIs.
JDBC is an API(Application programming interface) used in java programming to interact with databases. The classes and interfaces of JDBC allow the application to send requests made by users to the specified database.
Content