Developer to Software Architect - Part 2 Database Developer

• Before getting your hands dirty with Java Database Connectivity

• (JDBC), it is important to recognize its purporse and the options
• it has to offer - and this is exactly what this course provides. It
• first lays a theoretical foundation in terms of the need for JDBC,
• the various pieces which come together to let your app connect to a
• database, as well as their features and use cases. You will cover
• topics such as JDBC drivers, JDBC objects such as Statement ,
• ResultSet, and RowSet, and then connect a Java app to a
• database.

• Java Database Connectivity (JDBC) offers a number of ways in

• which SQL queries can be executed using a number of built-in
• objects. This demo-based course covers the use of the fundamental
• JDBC objects required to set up and manage database connections
• from a Java app and to execute queries. You will cover the use of
• Properties objects to load connection details, and then the use of
• the Statement and PreparedStatement instances to run SELECT,
• INSERT, DELETE and UPDATE queries against a database from a Java
• app.

• ResultSets allow SELECT query results to be processed

• systematically in a Java app while executing INSERT and UPDATE
• queries can be handled efficiently with query batches. This is very
• much a hands-on course and gets into the nitty-gritty of processing
• large volumes of data using JDBC. You will cover a lot of features
• of the ResultSet object - from its navigability to its ability to
• update data. You will also optimize updates by running them in a
• batch, and cover the implementations of atomic transactions when
• using JDBC.

• The JDBC RowSet offers the same functionality as a ResultSet

• with several useful additional features. This course involves a
• number of demos covering different RowSet types. You will explore
• the features of the JdbcRowSet which is a type of connected RowSet
• and is similar to a ResultSet. You will then cover different
• flavors of disconnected RowSets - from the CachedRowSet and the
• WebRowSet to performing offline joins using the JoinRowSet and
• filtering rows using the FilteredRowSet.

• When building Java apps which interact with a database, you may

• need to work with stored procedures and also large binary objects.
• The goal of this course is to give you hands-on experience with the
• handling of binary and text data and working with stored
• procedures. You will load image and text files from your file
• system to a database using JDBC, and will then do the reverse
• operations. You will also create and execute a variety of stored
• procedures from a Java app.

JPA, or the Java Persistence API, is focused on persistence. Persistence can refer to any mechanism by which Java objects outlive the applications that created them. JPA is not a tool, or a framework, or an actual implementation.

In this course, you'll explore the basic ideas behind object-relational mapping, where entities and relationships expressed in an object-oriented framework are mapped to records and tables in a relational database.

You'll examine the basic features of the JPA and Hibernate frameworks. You'll then practice how to get set up with the MySQL database, the MySQL Workbench, and Apache Maven to manage dependencies in your Java application.

In this course, you'll explore how primary keys can be set up for the tables underlying your entities and how you can manage the configuration of individual columns in your database columns using JPA annotations. You'll learn how to perform create, read, update, and delete operations using the JPA entity manager.

Once you're done with this course, you'll be able to structure your entities and their attributes based exactly on your specifications and perform basic storage and retrieval operations using JPA and Hibernate.

In this course, you'll explore the various kinds of relationships that you might want to express using JPA annotations and how these relationships map to relational table design. You'll examine unidirectional as well as bidirectional one-to-one, one-to-many, many-to-one, and many-to-many relationships.

Once you're done with this course, you'll be able to model and express real-world relationships between your entities using JPA annotations. Finally, you'll learn how to finely manipulate how you want these relationships configured using underlying database tables.

In this course, you'll explore how nested collections within an outer entity can be mapped using JPA. You'll implement mappings for collections of primitive types, embeddable objects, and collections of entities. You'll examine how JPA and Hibernate handle list, set, and map collections.

Next, you'll relate how specific operations such as entity persistence, update, and removal can be cascaded from parent entities to child entities and illustrate how inheritance relationships in your code can be mapped to database tables.

Once you're done with this course, you'll be able to use nested collections within your entities and also map inheritance relationships in your code to meaningful representations using tables.

In this course, you'll explore a variety of ways to execute queries using JPA. You'll run native queries, queries using JPQL, and queries using the Criteria API, which helps avoid syntax errors in your query specification.

Next, you'll examine how you can have entity-specific callback methods that can be invoked at different stages in the entity's lifecycle. When you are done with this course, you'll be able to perform complex queries on your database tables and manage your entity's lifecycle in a very granular manner.

• Perform Database Developer tasks such as inserting records to a table, formating records for display and adding the JDBC's RowSet class. Then, configure Eclipse to build with Maven, examine update modes, build tables with Entity class and combine JDBC functionality to build collections.
• This lab provides access to tools typically used by Database Developers, including:
• - MySQL 5.7
• - MySQL 8.0.23
• - Mysql-connector-java-8.0.22
• - MySQl Workbench 6.3
• - MySQL Workbench 8
• This lab is part of the Database Developer track of the Skillsoft Aspire Developer to Softwart Architect journey.

Final Exam: Database Developer will test your knowledge and application of the topics presented throughout the Database Developer track of the Skillsoft Aspire Developer to App Architect Journey.