Final Exam: Database Developer
- 1 Video | 35s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
add rows to a database table by running an INSERT query from a Java appadopt a DataSource object to create a Connection with a databasecompare and contrast a JdbcRowSet and ResultSetconfigure eager loading of entities on the many sidesconfigure lazy and eager loading for collectionsconfigure lazy loading of entities on the many sidesconfigure one-to-one mapping with a join tableconfigure one-to-one-mapping with a shared primary keyconfigure the table name using the @Table annotationcontrast the AUTO and IDENTITY generation typesdefine collection mapping for primitive data typesdescribe the features offered by a WebRowSetdescribe the role of batch updates and transactions when working with JDBCdescribe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a databasedownload and install MySQL and the MySQL Workbench tooldownload image files from a SQL table into your file systemdrop a table and database from a Java appexecute JPQL queriesexecute native queriesexecute stored procedures that return values and retrieve the outputs generatedhook into the entity lifecyclehook into the entity lifecycle after loadhook into the entity lifecycle before and after entity loadidentify the different JDBC objects that enable a Java app to work with a database, and recall the role played by each of themidentify the different ways to specify connection details when connecting to a database using JDBCidentify the implications of cascade type NONEidentify the types of ResultSets available in JDBCidentify why object-relational mapping is needed to work with databasesinstall MySQL and MySQL Workbench on a Windows machineload large image files into a SQL table using JDBC
outline the basic functionality that the Hibernate framework provides and how it differs to JPAoutline the basic functionality that the JPA framework provides and how it differs to Hibernateperform an update and delete operations on entitiesperform read operations on database entitiesperform scrolling and navigation over the contents of a JdbcRowSetpersist collections using the Set interfacepersist entities in a certain orderpersist nested objects in collectionsrecall how a WebRowSet records modifications to its contentsrecall the implications of cascade type NONErecognize the limitations of a TYPE_FORWARD_ONLY ResultSetrecognize the primary key as a required fieldrefresh the contents of a ResultSetrefresh the contents of a ResultSet while iterating over its contentsremove data from a SQL table by performing deletes from a ResultSetretrieve many entities in order of specific attributesrun basic criteria queriesscroll through a ResultSet to access data in various locationsset up a bidirectional one-to-one mapping between entitiesset up an Apache Maven project on a Windows machineset up a one-to-one mapping between entitiesspecify entity attributes using XMLsummarize the basic structure of the Criteria APIsummarize the effects of cascade type MERGEsummarize the effects of cascade type PERSIST and REMOVEuse a CachedRowSet to work with data while disconnected from the databaseuse begin and commit transactionsuse database connection details in a properties file to set up a connection to a database using JDBCuse @GeneratedValue to generate primary key valuesuse the IDENTITY generation type for multiple tables
IN THIS COURSE
1.Database Developer36sUP NEXT
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platformDigital badges are yours to keep, forever.