Queries and processing, optimizer, cost models, execution plans, rewriting rules, access methods, spatial indexing; transactions, ACID properties, concurrency control, serializability, two-phase locking, timestamping, logging,checkpointing, transaction abort and commit, crash recovery; distributed databases.
4
UnitsLetter
Grading1, 2, 3
PasstimeNone
Level LimitEngineering
CollegeGreat lectures, very clear. Easy to approach and ask questions.
I decided to take this class to explore how databases are structured and the logic behind query languages such as SQL. After nearly finishing this class I can gladly say that Divy was THE professor to take when you have those questions. His lectures are recorded and his slides go in depth. There were 3 homework assignments. 2 Midterms and no final
Great at explaining and is very interesting class. Clearly cares about students and actively interacts with students in lectures
Not the best at teaching (lectures were pretty dry) but he's very lenient and accommodating, especially with the online format. Some of the homework/exam questions were poorly phrased, but they're not that hard to answer and he and his staff are very generous with helping to clarify the questions. Definitely could be a lot worse, not a bad choice
For some reason, I have always struggled extremely in classes taught by Divyakant Agarwal. Lectures are long, yet he's somehow always behind. Exams are often terribly worded and attempts at clarification serve to confuse rather than to help. Idk man I wish I could pinpoint what exactly makes him so terrible but ig I'll just say don't take him
Lectures were long and slow. Sometimes Agrawal did not have time to go over all material. Sometimes his explanations were unclear or confusing. This is an especially important class, and I suggest going with someone who is more organized and clear. Upside, I did learn what was expected in this class. Projects are worth a lot in his classes!