Fundamentals of the SQL SELECT Statement
A
In groups and on the black board: Exercise 4.2 from the KSS book.
B
In groups and on the black board: write SQL select statements for the
following queries based on the database example used in the course.
- Find the first name, last name, and the course id of all teachers that
gives the course 'OOP' or 'OOA&D'
- Find the exercise id, exercise text, and answer text to lecture number 3
for the OOP course. The output should be ordered on the exercise id.
- Find the teachers that do not give any course.
- Find the course id and lecture number that do not have any slides
available via the course home page.
C
In pairs, construct use JDBC and preparedStatements to print the result of the
queries in Exercise B.