Final Exam: Database Developer

Intermediate
  • 1 video | 32s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
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 jdbc
    refresh the contents of a resultset
    describe the role of jdbc and jdbc drivers in enabling interactions between a java app and a database
    perform scrolling and navigation over the contents of a jdbcrowset
    identify the types of resultsets available in jdbc
    drop a table and database from a java app
    recognize the limitations of a type_forward_only resultset
    use a cachedrowset to work with data while disconnected from the database
    identify the different jdbc objects that enable a java app to work with a database, and recall the role played by each of them
    remove data from a sql table by performing deletes from a resultset
    refresh the contents of a resultset while iterating over its contents
    download and install mysql and the mysql workbench tool
    adopt a datasource object to create a connection with a database
    describe the role of batch updates and transactions when working with jdbc
    compare and contrast a jdbcrowset and resultset
    scroll through a resultset to access data in various locations
    add rows to a database table by running an insert query from a java app
    configure one-to-one mapping with a join table
    download image files from a sql table into your file system
    install mysql and mysql workbench on a windows machine
    use @generatedvalue to generate primary key values
    summarize the effects of cascade type merge
    recall the implications of cascade type none
    define collection mapping for primitive data types
    configure the table name using the @table annotation
    configure lazy and eager loading for collections
    summarize the basic structure of the criteria api
    hook into the entity lifecycle after load
    execute jpql queries
    hook into the entity lifecycle
  • hook into the entity lifecycle before and after entity load
    run basic criteria queries
    persist nested objects in collections
    summarize the effects of cascade type persist and remove
    execute stored procedures that return values and retrieve the outputs generated
    persist collections using the set interface
    use begin and commit transactions
    configure one-to-one-mapping with a shared primary key
    contrast the auto and identity generation types
    identify the implications of cascade type none
    use the identity generation type for multiple tables
    configure eager loading of entities on the many sides
    retrieve many entities in order of specific attributes
    identify why object-relational mapping is needed to work with databases
    recall how a webrowset records modifications to its contents
    specify entity attributes using xml
    execute native queries
    perform an update and delete operations on entities
    recognize the primary key as a required field
    perform read operations on database entities
    persist entities in a certain order
    configure lazy loading of entities on the many sides
    set up an apache maven project on a windows machine
    set up a one-to-one mapping between entities
    load large image files into a sql table using jdbc
    set up a bidirectional one-to-one mapping between entities
    identify the different ways to specify connection details when connecting to a database using jdbc
    describe the features offered by a webrowset
    outline the basic functionality that the jpa framework provides and how it differs to hibernate
    outline the basic functionality that the hibernate framework provides and how it differs to jpa

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.6 of 28 users Rating 4.6 of 28 users (28)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Rating 3.5 of 11 users Rating 3.5 of 11 users (11)