Question Regarding Final about cmc-csci143 HOT 2 CLOSED

Will the final be over writing SQL queries or like the questions in the practice final pdf on github?

I believe the grading section immediately below what you quoted answers this questrion. In particular, 4/20 points are for writing the SQL queries, and 16/20 points are for discussing how to make those queries fast.

I noticed that the practice problems do not have JOIN commands.

Each of the 5 practice problem sheets has SQL queries that use JOIN. For example, the 2023 final exam includes JOINs in problem 4 and 5.

Other than reading the articles, how else do you recommend studying for the final?

Because 16/20 of the points come from the answering problems similar to the practice problems, I recommend being able to solve the practice problems. If you can't solve the practice problems, you won't do well on the final.

I will also be available Monday during the normal office hours timeslot from 9:30-11am for final related questions.

from cmc-csci143.

Thank you for the clarification!

from cmc-csci143.