Course: Javanista to Java Master - Part 4 Spring Data

Java Database Connectivity (JDBC) is a Java API that provides developers with a common interface for connecting to a database, issuing queries and commands, and handling responses from the database. Learn more about JDBC in Spring and JdbcTemplate class through this course. Start by exploring the Spring framework and its JDBC APIs to understand the features available in relation to database integration. You will then get hands-on experience using Spring Boot to set up an application that uses Spring JDBC to connect to a database and run queries against it. The course will also help you investigate the implementation of CRUD (i.e., create, read, update, and delete) operations using a JdbcTemplate class, mapping a database table to a Java class, and the role of Spring's RowMapper interface to translate rows from a query execution to Java objects. After completing this course, you'll have a solid grasp of how the Spring framework simplifies database integration from a Java app.

CrudRepository is a Spring Data interface that helps perform generic CRUD operations on specific types of repositories. Take this course to familiarize yourself with Spring Data's CrudRepository interface and modeling of relationships between entities in a Spring application. Delve into how CrudRepository is used to persist Java objects into a database table and examine Spring Data JDBC's Query annotations to map custom queries to CrudRepository methods. You'll then turn your attention to modeling relationships between entities in a Spring application and configure and implement many-to-one and many-to-many relationships. Having finished this course, you'll have a broader understanding of the features in the Spring Framework that make JDBC tasks easier.

Configuring derived query methods in Spring Data's CrudRepository enables the execution of complex queries and the processing of their results without the developer having to write any SQL. Use this course to explore CrudRepository and different query methods in greater detail. Learn more about the steps involved in enabling logging for your Spring application and configuring methods in your CrudRepository that retrieve specific entities from a database table based on the method's signature. You'll also examine different types of queries that can be implemented, such as exact match lookups, range searches, and ordering of results. After completing this course, you'll have acquired the skills to build robust and easy-to-maintain applications.

Spring Data JPA eases the development of applications that need to access Java Persistence API (JPA) by providing repository support. Use this course to get familiar with the basics of Spring Data JPA from a theoretical and practical standpoint. Through this course, you'll examine the concepts around Spring Data JPA and why this technology is a boon for developers, explore how to build a project that uses Spring Data JPA to connect to a database, and discover the use of the Spring Boot module. You'll also get a glimpse into the pieces which must come together to build an app that uses Spring Data JPA - data sources, a JPA implementation, and a CrudRepository. After finishing this course, you'll have the skills and knowledge to persist data using Spring Data JPA.

In this course, you'll learn more about configuring derived query methods in Spring Data JPA using the CrudRepository. Get hands-on experience using some of the methods of a CrudRepository, which are automatically implemented by the Spring Framework to retrieve entities from a database table and load them into Java objects. You will also examine how to configure new query methods, search for entities based on their properties, and implement create, read, update, and delete (CRUD) operations. After you are done with this course, you'll be able to efficiently work with persisted data in Spring Data JPA.

Through this course, explore how to map your own SQL queries to methods in a CrudRepository and leave the implementation of running the queries and processing the results to the Spring Framework. You'll investigate the use of @Query annotation to map simple select queries to methods in a CrudRepository and learn how the rest of the workaround connections, query executions, and processing of results is handled by Spring. This course will also help you discover named queries and how to add complexity to your query by substituting parameters that can be supplied when calling your methods. Once you are finished with this course, you'll have the skills to build efficient, robust, and easy-to-maintain applications by reducing the amount of boiler-plate code required.

For most organizations, processing large amounts of data is an essential task. However, it's often done using unoptimized and difficult-to-maintain solutions. Spring Batch rectifies these constraints, making batch processing a lot more efficient. Use this course as both a theoretical and practical introduction to Spring Batch. After a theoretical overview, learn how to build a batch process to transform CSV data to XML. In doing this, set up an ItemReader to read from a CSV file, an ItemProcessor to transform the data, and an ItemWriter to write the data to an XML file. When you've completed this course, you'll be able to identify how Spring Batch addresses the common limitations of batch processing and set up and run a Spring Batch application.

Processing vast amounts of data is an essential organizational task, which can become complicated with customized solutions. Luckily, Spring Batch makes batch processing easy to execute regardless of the types of data involved. Use this course to learn how to develop and configure a Spring Batch process for different data sources and destinations. You'll use Java annotation-based configurations to set up the beans for a Spring Batch process, read data from a relational database, write its contents to a JSON file, and perform the reverse transformation. While doing so, you'll apply various Spring and Spring Batch components, such as a RowMapper, an ItemPreparedStatementSetter, and customized data type adapters. Upon completion, you'll be able to use Spring Batch to build enterprise-grade solutions for various cases.

Final Exam: Spring Data will test your knowledge and application of the topics presented throughout the Spring Data track of the Skillsoft Aspire Javanista to Java Master Journey.