Final Exam: Database Developer
Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
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.
Expected Duration (hours)
0.0
Lesson Objectives Final Exam: Database Developer
add rows to a database table by running an INSERT query from a Java app
adopt a DataSource object to create a Connection with a database
compare and contrast a JdbcRowSet and ResultSet
configure eager loading of entities on the many sides
configure lazy and eager loading for collections
configure lazy loading of entities on the many sides
configure one-to-one mapping with a join table
configure one-to-one-mapping with a shared primary key
configure the table name using the @Table annotation
contrast the AUTO and IDENTITY generation types
define collection mapping for primitive data types
describe the features offered by a WebRowSet
describe the role of batch updates and transactions when working with JDBC
describe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a database
download and install MySQL and the MySQL Workbench tool
download image files from a SQL table into your file system
drop a table and database from a Java app
execute JPQL queries
execute native queries
execute stored procedures that return values and retrieve the outputs generated
hook into the entity lifecycle
hook into the entity lifecycle after load
hook into the entity lifecycle before and after entity load
identify the different JDBC objects that enable a Java app to work with a database, and recall the role played by each of them
identify the different ways to specify connection details when connecting to a database using JDBC
identify the implications of cascade type NONE
identify the types of ResultSets available in JDBC
identify why object-relational mapping is needed to work with databases
install MySQL and MySQL Workbench on a Windows machine
load large image files into a SQL table using JDBC
outline the basic functionality that the Hibernate framework provides and how it differs to JPA
outline the basic functionality that the JPA framework provides and how it differs to Hibernate
perform an update and delete operations on entities
perform read operations on database entities
perform scrolling and navigation over the contents of a JdbcRowSet
persist collections using the Set interface
persist entities in a certain order
persist nested objects in collections
recall how a WebRowSet records modifications to its contents
recall the implications of cascade type NONE
recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
recognize the primary key as a required field
refresh the contents of a ResultSet
refresh the contents of a ResultSet while iterating over its contents
remove data from a SQL table by performing deletes from a ResultSet
retrieve many entities in order of specific attributes
run basic criteria queries
scroll through a ResultSet to access data in various locations
set up a bidirectional one-to-one mapping between entities
set up an Apache Maven project on a Windows machine
set up a one-to-one mapping between entities
specify entity attributes using XML
summarize the basic structure of the Criteria API
summarize the effects of cascade type MERGE
summarize the effects of cascade type PERSIST and REMOVE
use a CachedRowSet to work with data while disconnected from the database
use begin and commit transactions
use database connection details in a properties file to set up a connection to a database using JDBC
use @GeneratedValue to generate primary key values
use the IDENTITY generation type for multiple tables
Course Number: it_fedaa_02_enus
Expertise Level
Intermediate