Final Exam: Database Developer
- 1 Video | 32s
- 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
use database connection details in a properties file to set up a connection to a database using JDBCrefresh the contents of a ResultSetdescribe the role of JDBC and JDBC drivers in enabling interactions between a Java app and a databaseperform scrolling and navigation over the contents of a JdbcRowSetidentify the types of ResultSets available in JDBCdrop a table and database from a Java apprecognize the limitations of a TYPE_FORWARD_ONLY ResultSetuse a CachedRowSet to work with data while disconnected from the databaseidentify the different JDBC objects that enable a Java app to work with a database, and recall the role played by each of themremove data from a SQL table by performing deletes from a ResultSetrefresh the contents of a ResultSet while iterating over its contentsdownload and install MySQL and the MySQL Workbench tooladopt a DataSource object to create a Connection with a databasedescribe the role of batch updates and transactions when working with JDBCcompare and contrast a JdbcRowSet and ResultSetscroll through a ResultSet to access data in various locationsadd rows to a database table by running an INSERT query from a Java appconfigure one-to-one mapping with a join tabledownload image files from a SQL table into your file systeminstall MySQL and MySQL Workbench on a Windows machineuse @GeneratedValue to generate primary key valuessummarize the effects of cascade type MERGErecall the implications of cascade type NONEdefine collection mapping for primitive data typesconfigure the table name using the @Table annotationconfigure lazy and eager loading for collectionssummarize the basic structure of the Criteria APIhook into the entity lifecycle after loadexecute JPQL querieshook into the entity lifecycle
hook into the entity lifecycle before and after entity loadrun basic criteria queriespersist nested objects in collectionssummarize the effects of cascade type PERSIST and REMOVEexecute stored procedures that return values and retrieve the outputs generatedpersist collections using the Set interfaceuse begin and commit transactionsconfigure one-to-one-mapping with a shared primary keycontrast the AUTO and IDENTITY generation typesidentify the implications of cascade type NONEuse the IDENTITY generation type for multiple tablesconfigure eager loading of entities on the many sidesretrieve many entities in order of specific attributesidentify why object-relational mapping is needed to work with databasesrecall how a WebRowSet records modifications to its contentsspecify entity attributes using XMLexecute native queriesperform an update and delete operations on entitiesrecognize the primary key as a required fieldperform read operations on database entitiespersist entities in a certain orderconfigure lazy loading of entities on the many sidesset up an Apache Maven project on a Windows machineset up a one-to-one mapping between entitiesload large image files into a SQL table using JDBCset up a bidirectional one-to-one mapping between entitiesidentify the different ways to specify connection details when connecting to a database using JDBCdescribe the features offered by a WebRowSetoutline the basic functionality that the JPA framework provides and how it differs to Hibernateoutline the basic functionality that the Hibernate framework provides and how it differs to JPA
IN THIS COURSE
1.Database Developer33sUP 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.