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.

Prerequisites: Computer Science 130B.

4

Units

Letter

Grading

1, 2, 3

Passtime

None

Level Limit

Engineering

College
These majors only cmpsc cptcs
Divyakant Agrawal
2.9
38 reviews
PHELP1425
F
13:00 PM - 13:50 PM
38 / 38 Full

387 1015
F
14:00 PM - 14:50 PM
35 / 37

GIRV 2128
F
15:00 PM - 15:50 PM
0 / 38 Closed

387 1015
F
16:00 PM - 16:50 PM
0 / 37 Closed

Spring 2024 . Su J
CHEM 1171
M W
14:00 PM - 15:15 PM
See All
CMPSC 174B Agrawal D Winter 2023 Total: 38
CMPSC 174B Agrawal D Winter 2022 Total: 10
See All
38
2.9
CMPSC174B . 2 Years Ago

Great lectures, very clear. Easy to approach and ask questions.

0 helpful 0 unhelpful
CMPSC174B . 2 Years Ago

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

0 helpful 0 unhelpful
CMPSC174B . 2 Years Ago

Great at explaining and is very interesting class. Clearly cares about students and actively interacts with students in lectures

0 helpful 0 unhelpful
CS130A . 4 Years Ago

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

0 helpful 0 unhelpful
CS130A . 4 Years Ago

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

0 helpful 0 unhelpful
CS130A . 4 Years Ago

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!

0 helpful 0 unhelpful
See all 38 reviews
CMPSC 165A
150 / 150 Full
Artificial Intelligence
Preiss J A
T R
11:00 AM - 12:15 PM
53.6% A
CMPSC 165B
150 / 150 Full
Machine Learning
Guo W
T R
15:30 PM - 16:45 PM
59.7% A
CMPSC 170
100 / 100 Full
Operating Systems
Tao Yang 3.0
T R
09:30 AM - 10:45 AM
39.5% A
CMPSC 174A
150 / 150 Full
Fundamentals of Database Systems
Jianwen Su 2.0
M W
14:00 PM - 15:15 PM
48.8% A
CMPSC 176C
47 / 150 Enrolled
Advanced Topics in Internet Computing
Gupta A
M W
12:30 PM - 13:45 PM
61.3% A
CMPSC 177
75 / 150 Enrolled
Computer Security
Kevin Burk 3.0
M W
11:00 AM - 12:15 PM
42.9% A