Database connectivity, access your database via Java
This brief yet comprehensive course covers everything you need to know about using JDBC to create and run SQL statements in your Java program.
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.
Course Content
- Introduction –> 1 lecture • 1min.
- Download the Java connector –> 2 lectures • 8min.
- Select Queries –> 3 lectures • 12min.
- Update, Insert and Delete Queries –> 6 lectures • 18min.
- Create and Drop Table Queries –> 2 lectures • 7min.
Requirements
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.