Overview

Databases are the backbone of modern applications, powering everything from large scale enterprise systems to web applications. This course gives you the comprehensive grounding you need to work with databases using Java programming. Whether you have a little or no knowledge of databases, if you’re keen to understand the different types of databases and how to work with these databases using Java, this course is for you! During the course, you’ll explore the fundamentals of databases and Java Database Connectivity (JDBC). You’ll get hands-on developing database applications using Spring Boot. Plus, you’ll work with Hibernate and explore other databases such as NoSQL, SQL Graph and time series databases. Throughout the course, you’ll complete hands-on labs and gain valuable practical experience applying your skills. Plus, you’ll complete a final project where you apply your knowledge to a real-world scenario; great for chatting about in interviews! If you’re looking to build the job-ready skills you need to develop Java applications with databases, enroll today.

Syllabus

Fundamentals of Databases and JDBC

Relational databases are the basis of data management, and they are commonly used in applications that require structured storage of data. When working with relational databases, Java provides the Java Database Connectivity (or JDBC) interface to interact with databases. In the world of Java software development, managing and interacting with data stored in relational databases is an essential skill. In this module, we introduce the foundational concepts of relational databases and their integration with Java using JDBC. You'll be able to understand how databases are structured, how to establish connections with them, and how to perform essential operations such as creating, reading, updating, and deleting data programmatically.

Spring Boot for Database Applications

One of the most critical components in modern web application development is the ability to interact with databases efficiently. The Spring Boot framework has changed the way we build database-driven applications. Spring Boot simplifies the development, deployment, and scaling of relational database-based applications by abstracting away the complexity of conventional Java setups and offering creative solutions. In this module we discuss the advantages of using Spring Boot, configure Spring Boot to integrate with relational databases such as MySQL, use Spring Data JPA to implement efficient CRUD operations, discuss the importance of using annotations and performing validation, and setup RESTful API integration for CRUD.

Hibernate and Other Databases

This module provides an in-depth understanding of Hibernate as an ORM framework. It also explains its role in handling complex database interactions. Learners will explore advanced entity relationships, caching, and query optimization. It also walks you through other modern data storage solutions such as NoSQL databases (document, graph databases, and time series databases). Finally it discusses how to implement Spring Boot applications to interact with NoSQL databases.

Final Project and Course Wrap-Up

In this module, you will apply the Java development skills for databases you practiced throughout this course in your final project. You will develop the backend for a retail management system using Java, Spring Boot, and Hibernate. Your system will use MySQL for structured data and a NoSQL database for unstructured data. At the end of this course, go through the course wrap-up video and course glossary to review what you’ve learned.