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
CollegeClass was just very unorganized and often ran by TAs instead of professor. The 2 projects were extremely long and difficult compared to the material of the class. The exams were pretty difficult as well with no study guide or cheat sheet. Homework was too easy in comparison. Professor also often gave rude and passive aggressive responses.
Great 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