Java Development with Databases聽

This course is part of IBM Java Developer Professional Certificate

Instructor: Skill-Up EdTech Team

Access provided by New York State Department of Labor

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

20 hours to complete

3 weeks at 6 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

20 hours to complete

3 weeks at 6 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

The job-ready skills you need to develop Java applications with databases in just 4 weeks
Apply the fundamentals of databases in a Java program using Java Database Connectivity and develop database-driven applications using Spring Boot
Handle entity relationships with Object Relational Mapping (ORM) using Hibernate for efficient data management
Explore other modern data storage solutions such as NoSQL, document, time series and graph databases

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

11 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about 糖心vlog官网观看 for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Software Development expertise

This course is part of the IBM Java Developer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from SkillUp EdTech

There are 4 modules in this course

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鈥檙e 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鈥檒l explore the fundamentals of databases and Java Database Connectivity (JDBC). You鈥檒l get hands-on developing database applications using Spring Boot. Plus, you鈥檒l work with Hibernate and explore other databases such as NoSQL, SQL Graph and time series databases. Throughout the course, you鈥檒l complete hands-on labs and gain valuable practical experience applying your skills. Plus, you鈥檒l complete a final project where you apply your knowledge to a real-world scenario; great for chatting about in interviews! If you鈥檙e looking to build the job-ready skills you need to develop Java applications with databases, enroll today.

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.

What's included

8 videos2 readings4 assignments5 app items4 plugins

8 videosTotal 53 minutes

Course Introduction4 minutesPreview module
Introduction to Databases 7 minutes
Understanding RDBMS with Examples 6 minutes
SQL : DDL, DML, and Procedures 6 minutes
Understanding JDBC, Connections, and Connection Pools 8 minutes
JDBC Statements in Java 6 minutes
Prepared and Callable Statements in JDBC 5 minutes
CRUD Operations Using JDBC 8 minutes

2 readingsTotal 7 minutes

Course Overview5 minutes
Summary and Highlights: Fundamentals of Databases and JDBC 2 minutes

4 assignmentsTotal 61 minutes

Practice Quiz: Introduction to Databases 20 minutes
Practice Quiz: Understanding JDBC10 minutes
Practice Quiz: CRUD with JDBC 10 minutes
Graded Quiz: Fundamentals of Databases and JDBC21 minutes

5 app itemsTotal 255 minutes

Lab: Creating and Accessing MySQL Databases45 minutes
Lab: Working with Procedures in MySQL60 minutes
Lab: Using JDBC for Simple Queries60 minutes
Lab: Using Prepared and Callable Statements45 minutes
Lab: CRUD in MySQL using JDBC45 minutes

4 pluginsTotal 30 minutes

Reading: How to Make the Most of this Course5 minutes
Reading: More SQL10 minutes
Reading: RDBMS Tools10 minutes
Cheatsheet: Fundamentals of Databases and JDBC 5 minutes

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.

What's included

4 videos1 reading3 assignments4 app items3 plugins

4 videosTotal 34 minutes

Configuring a MySQL Database in Spring Boot6 minutesPreview module
Using JPA for Database Operations 9 minutes
Annotations for Validations 10 minutes
Setting up a RESTful API for CRUD 9 minutes

1 readingTotal 2 minutes

Summary and Highlights: Spring Boot for Database Applications 2 minutes

3 assignmentsTotal 51 minutes

Practice Quiz: Integrating Spring Boot with Databases 10 minutes
Practice Quiz: Databases in Spring Boot with JPA 20 minutes
Graded Quiz: Spring Boot for Database Applications 21 minutes

4 app itemsTotal 180 minutes

Lab: Configuring a MySQL Database in Spring Boot45 minutes
Lab: Create a Simple Spring Boot App for Data Retrieval45 minutes
Lab: Create Spring Boot App with Data Validation45 minutes
Lab: Create a RESTful CRUD App45 minutes

3 pluginsTotal 40 minutes

Reading: Introduction to Lifecycle Annotations in JPA15 minutes
Lab: Testing the API using POSTman 15 minutes
Cheat Sheet: Spring Boot for Database Applications10 minutes

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.

What's included

6 videos1 reading3 assignments4 app items1 plugin

6 videosTotal 46 minutes

Introduction to Hibernate and ORM 7 minutesPreview module
Advance Entity Relationships in Hibernate 7 minutes
HQL and SQL in Hibernate 6 minutes
Video: Introduction to Document-based NoSQL Databases7 minutes
Introduction to Time Series and Graph NoSQL Databases9 minutes
Video: Developing Java Applications with NoSQL Databases9 minutes

1 readingTotal 2 minutes

Summary and Highlights: Hibernate and Other Databases 2 minutes

3 assignmentsTotal 41 minutes

Practice Quiz: Hibernate and ORM 10 minutes
Practice Quiz: NoSQL, MongoDB, SQL Graph, and Time Series Databases10 minutes
Graded Quiz: Hibernate and Other Databases 21 minutes

4 app itemsTotal 225 minutes

Lab: Configuring Hibernate in Spring Boot45 minutes
Lab: Advanced CRUD using Hibernate60 minutes
Lab: Using MongoDB with Java60 minutes
Lab 4: (Optional) Working with SQL Graph Databases and Time Series Databases60 minutes

1 pluginTotal 15 minutes

Cheat Sheet: Hibernate and Other Databases 15 minutes

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鈥檝e learned.