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 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

IN THIS COURSE

  • Playable
    1. 
    Database Developer
    36s
    UP 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 platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE