Course Description:
Course is divided into two sections, externals and internals.
Externals mainly deals with SQL which is used to query the information present in the database.
Internals part of the course describes how data is stored in the disks and how a query is processed and optimized which is used to fetch data from the disks.
Course Pattern and Logistics:
Externals is taught in the first half of semester and internals in the latter half with one quiz (7.5% weightage) in each half of the semester. 10% weightage is given to a reading assignment which requires us to read about newly developed database systems. Prof allows us to take printed slides into the examination hall but the exams are generally lengthier and hence, slides are barely useful (you’ll have to study). Attendance isn’t mandatory and chill grading (In our batch, n(AA) > n(x) for all x != AA)
Comments on the Instructor:
Prof. Sarda taught us. He is a very sensible person who teaches very patiently even if a single person in the complete class listens to him.
Who will find it interesting:
Students who are interested in developing different apps must (and should) find the first half of the course interesting as SQL is widely used in applications. Students who are interested in the following questions will find the 2nd half of the course interesting.
- How is data stored in the disks ensuring reliability and speed?
- How can two tables joined while answering a query which contains JOIN?
- How can we optimize complex queries to reduce the number of seeks and block transfers from the disk?
- How can we deal with simultaneous bank transactions ensuring consistency?
- What is the backup mechanism to store all the updates made in the database?
No comments:
Post a Comment