First Midterm Exam

The first midterm exam will be held in class on Friday, April 24th.

The exam will cover the basics of SQL databases and Spring Boot with JDBC.

The questions on the exam will all be short answer questions that will ask you to write short snippets of SQL code and Java code.

Below is a list of the categories of questions I will ask.

Basic SQL

Be prepared to write some basic SQL code:

• Simple select statements
• Select statements with joins
• Insert statements
• Delete statements

Working with the JdbcTemplate class

Be prepared to write short snippets of Java code involving the use of one or more of these JdbcTemplate methods:

• query
• queryForObject
• queryForList
• update

Writing controller methods

Be prepared to write the code for some controller methods. You should familiarize yourself with the following annotations that are commonly used in controller methods:

• @PostMapping
• @GetMapping
• @RequestBody
• @PathVariable
• @RequestParam